Experience the difference of "Elite".

Interesting-AirBnB iCal import sometimes has fees and payments?
(page 1 )

Marina's Edge
Sep 19, 2017 10:28 PM
Joined Oct, 2012 206 posts

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?

Chris Hynes
Sep 19, 2017 10:39 PM
OR Team Member Joined Oct, 2012 1375 posts

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.

Marina's Edge
Sep 19, 2017 11:30 PM
Joined Oct, 2012 206 posts

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 :)

Chris Hynes
Sep 19, 2017 11:34 PM
OR Team Member Joined Oct, 2012 1375 posts

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!

Marina's Edge
Sep 20, 2017 12:50 AM
Joined Oct, 2012 206 posts

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!!

Glenn Moore
Sep 20, 2017 5:07 PM
Joined Nov, 2012 76 posts

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.

Chris Hynes
Sep 20, 2017 5:50 PM
OR Team Member Joined Oct, 2012 1375 posts

Can you send over the file you're using in a support ticket? We'll have a look and see what's what.

Glenn Moore
Sep 20, 2017 9:05 PM
Joined Nov, 2012 76 posts

Ok. Heh, how do I create a support ticket?

Chris Hynes
Sep 20, 2017 10:25 PM
OR Team Member Joined Oct, 2012 1375 posts

Heh! Guess we need a button for that eh?

Easiest way is to email help@ownerreservations.com

BlueMtnCabins
Sep 21, 2017 7:42 AM
Joined Jun, 2016 1052 posts

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....

Chris Hynes
Sep 21, 2017 10:33 AM
OR Team Member Joined Oct, 2012 1375 posts

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 :-/

BlueMtnCabins
Sep 21, 2017 10:37 AM
Joined Jun, 2016 1052 posts

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.

Chris Hynes
Sep 21, 2017 10:43 AM
OR Team Member Joined Oct, 2012 1375 posts

Yep, send it over to help@ownerreservations.com 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


BlueMtnCabins
Sep 21, 2017 10:44 AM
Joined Jun, 2016 1052 posts

Just sent

BlueMtnCabins
Sep 23, 2017 8:08 PM
Joined Jun, 2016 1052 posts

Did you ever receive my excel?

Chris Hynes
Sep 23, 2017 8:20 PM
OR Team Member Joined Oct, 2012 1375 posts

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.

BlueMtnCabins
Sep 23, 2017 8:23 PM
Joined Jun, 2016 1052 posts

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.

Chris Hynes
Sep 29, 2017 5:03 PM
OR Team Member Joined Oct, 2012 1375 posts

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.

BlueMtnCabins
Sep 29, 2017 10:40 PM
Joined Jun, 2016 1052 posts

Chris Hynes said:

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.

Is the host fee subtracted from rent?

Ex:

$401.67 x 3 nights $1205.00
Airbnb Service Fee ($60.25)
Total Payout $1144.75

I see in OR:
Rent Airbnb rent 1,015.75 $1,015.75
Tax TN Sales / Sevier County Lodging Tax 12.75% $129.00
Total: $1,144.75

Listing site fee: $60.25

Is that expected? Tx

Chris Hynes
Sep 29, 2017 10:56 PM
OR Team Member Joined Oct, 2012 1375 posts

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.