I was just looking at some of my bookings and noticed that a few of my AirBnB bookings have the total fee charged and shows payments. Not all of them are this way. Curious why they don't all have the fees shown?
Can you send a couple examples and booking IDs? I'll have a look.
We don't import fees and payments in the calendar import as Air doesn't include them in their iCal. Is it possible you added them yourself at some point?
We just added an import that will populate charges and payments from the Airbnb Transaction History CSV, but you have to upload that to apply them. Look at the bottom of the Tools menu for that one.
It looks like my bookkeeper must have updated the booking, I didn't realize she did that :). Bummer, I was hoping you'd figured it out :)
Ahh, OK! Just wanted to make sure you didn't have unexpected data showing up :-)
Have a look at the new airbnb transaction import: https://secure.ownerreservations.com/bookings/import/airbnbtransactioncsv. We haven't announced it yet -- released earlier this week.
It's not automatic yet, but it lets you update in bulk from the Transaction History export in your Airbnb account -- will make your bookkeeper's job easier at least!
I just tried this. Pretty darn slick...I had to adjust a few of the parameters and import a few times but I think I figured it out!!
Whoa... I knew there was a reason that I occasionally look at these forms. This is awesome and will help my workflow a lot!! Unfortunately being in Canada, I cannot import anything yet. I get two errors per transacation
- Couldn't parse Date value '18-09-2017' in row 1 column 0 as Date
- Only USD supported currently. Contact us for other currencies
I hope you can solve those two because this would be great for me. I do this manually so I can produce a report for my maintenance guy who gets a percentage of my rental revenue.
Can you send over the file you're using in a support ticket? We'll have a look and see what's what.
Ok. Heh, how do I create a support ticket?
Heh! Guess we need a button for that eh?
Easiest way is to email email@example.com
Chris, I have tried the import and when it works, it is sleek! but in about half of my reservations it did not work, I think I know hy.
My rates on AirBNB do not include tax; AirBNB does not collect tax in my area; so for all instant book requests, i have to do this: accept, then send 'alteration' to increase the subtotal by the amount to account for 12.75% tax. So that results in 2 rows, for example:
3/5/2017 Payout Transfer to *****4083 USD 116
2/17/2017 Reservation B9PPRJ 4/18/2017 5 Brittany SXXXXX Appalachian Escape Cabin - Gatlinburg-Pigeon Forge USD 116 6.12 0
3/5/2017 Payout Transfer to *****4083 USD 907
2/17/2017 Reservation B9PPRJ 4/18/2017 5 Brittany SXXXXX Appalachian Escape Cabin - Gatlinburg-Pigeon Forge USD 907 47.88 0
the amount of $116 is a tax that was collected separately via "alteration".
I think that makes import choke and not import. I don't know maybe I need to manipulate the CSV before importing to sum the charges and fees by reservation....
Does it give you an error or unexpected results? It's designed for that mode with the taxes Added to Airbnb amount -- that's exactly how I do my properties as well.
As far as I've been able to determine, Airbnb doesn't give any info in the export on the taxes. They also don't have any way of mapping the resolution payout to the reservation -- no matching confirmation code, dates, or even property. So we import what we can -- a payment for the reservation amount in the Airbnb file, taxes based on your tax rates, any surcharges you set to be added. If you have separate resolution payouts, you still have to add those payments manually :-/
It gives and error something about 2 rows for reservation. Just to be clear, AirBNB doe not have taxes in my area, so how I handle it, is that after initial acceptance of the request, I send "price alteration" for additional amount" that is for tax. So what it does that it creates to 2 payouts for same reservation, for ex: $1000 is one amount (rent plus cleaning fee) and $100 for tax. each of those has its own "host fee". Which, in spreadsheet, results in 4 rows per one reservation. I can send you sample downloaded excel.
Yep, send it over to firstname.lastname@example.org and I'll have a look. Very interesting because the ones I have only show the reservation once, then a separate "resolution payout", like this:
09/05/2017,Payout,,,,,,Transfer to *****1234,,USD,,801.00,,
09/05/2017,Resolution Payout,,,,,,Resolution payout for resolution 3428667,,USD,74.00,,,
09/05/2017,Reservation,SOMEJUNKCODE,09/04/2017,3,Jane Doe,Cabin in the woods,,,USD,727.00,,23.00,0.00
Did you ever receive my excel?
Yep, I got it. Still putting that together with Glenn's to get all the different variations researched.
Seems like Airbnb exports one thing if you have the 30 days before arrival payment and a different format if it is day after arrival payment.
Yes mine is super strict 60 so I get paid at 60 days before arrival mark (or as soon as they pay, if check in is in less than 60 days) , not after check in.
We just pushed out an update that should handle the multiple reservation rows and non USD currency and date formats.
Give it a whirl and let me know how it works now.
Chris Hynes said:We just pushed out an update that should handle the multiple reservation rows and non USD currency and date formats.
Looks like you did taxes included in Airbnb fee, which subtracts the tax % you have set up from the total payout to get the rent. That's for folks who quote inclusive rates and then back out the taxes.
Try using the taxes added to Airbnb fee mode, which takes the Airbnb amount and tacks tax on top -- which calculates the tax added in the additional resolution request.
The host fee isn't factored into the charges/rent/tax calcs at all, but tracked separately as a listing site fee.