Latest Activity...
I updated the booking so the $300 factored in, so that is correct now.
We're looking into the issue to make sure it doesn't happen again.
I have a guest who just checked out and wanted to book again for next year. he wants me to keep his deposit from this year towards next year. I created the quote, he accepted, and I went on to "record" a payment of $300 (his carry over deposit) as 'credit card collected elsewhere". But it appears although the system sent him receipt for payment of $300, it did not subtract the $300 that i have "recorded' from the outstanding balance which still shows a full total. is there a step I am missing? Booking ORB1109741
Yep, that makes sense. We've got plans to add a feature for refundable secdeps so they are treated like the auths and don't factor into the total. Once that's in place, the travel insurance would automatically take that into account.
Cleaning fees are a little more case by case, as some may not refund those on cancellations, or depending on timing, but at least it would be good to get the secdep factored out.
I do not use credit card hold as sec dep - instead I have a sec dep surcharge and I later refund ( i just feel safer having money in hand rather than a cc auth). But with that, when trip insurance is calculated, it is applied to the amount of sec dep as well.
Ideally I would think that trip insurance should not be applied to sec dep or the cleaning fee amount, as if guest does not show up, there is nothing to clean. I had a couple of cancellations with insurance on VRBO in the past, and how it works is you refund sec dep and cleaning fee, and the insurance takes care of the rest ( rent plus tax balance).
The reason I am asking is the amount due of trip insurance is overstated when sec dep and cleaning fee is figured in.
tried every which way - still comes out wrong.
I have 2 scenarios:
1. person inquires, I send "special offer" add-on for tax, in that case tax is included in the amount when they pay
2. person instant-books, in that case I have to send "alteration" to add the tax, and then there are 2 transactions - one for instant book, one for additional amount for tax.
When importing I have received several messages about rows skipped... maybe that is the issue. Sending the CSV and print screen.. See reservation for Saleh as a good example of 2 transcations. no matter what options I use to import it still seems to come out wrong
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.
Chris Hynes said:
We just pushed out an update that should handle the multiple reservation rows and non USD currency and date formats.
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.
Thank you, it took multiple people flagging and reporting to CL to get it gone
Don't you hate that.
BTW - the listing is gone
Got my photos and description lifted from VRBO and posted on CL by " Butler Stanley" posing as property manager.
Please help flag listing as fraud : https://knoxville.craigslist.org/vac/6310275564.html
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.
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.
Did you ever receive my excel?
Is it possible to receive a text notification from OwnerRez when someone inquires about my property? Right now I'm only receiving an email.
Just sent
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
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.
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 :-/
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....
Heh! Guess we need a button for that eh?
Easiest way is to email help@ownerreservations.com
Ok. Heh, how do I create a support ticket?
Can you send over the file you're using in a support ticket? We'll have a look and see what's what.
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.
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!!
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://app.ownerrez.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!
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 :)
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.
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?
Looks correct now!
