Quickbooks Airbnb sales tax input I think I have it......mostly

[Brenda Logan]

So I needed a few things.  I need my invoice to match what Airbnb sends me for payout and I need the sales tax to be what is actually taxed so that QB can keep up with it for me.  I worked on this with my accountant so I feel it's correct but I'm wondering about how the sales tax will work out.  

Airbnb pays my state taxes but I am responsible for the city of Galveston taxes.

I use class tracking to keep up with each rental property. I have 4 long term rentals and this one brand new to the game short term rental.  That meant I had to change my  preferences to charge sales tax.  So when I did that QB wants a tax entity for the ltr's that I don't charge so I made one up at 0% tax called Non-tax agency. Item List Type:  Sales Tax Item, Account:  Sales Tax Payable.  

So to the invoice, the first line is for the actual money ABNB collected for the nights rent.  I made a service item call Rent for Casa #177 (our class name for the str), left the description blank setting it up as I will fill that in with the info for each invoice (see image below).  I made an income account called Rental Income from Airbnb for when I do my payments/deposits. I made the cleaning fee Item to go to a separate income account called Cleaning Fee Income.  The 3rd item on the list is the Remove Tax item.  This is to remove the tax so that the invoice will match what Airbnb is sending.  This is an income non taxable account called Remove Tax, Type:  Other charge, Account:  To Remove Tax on Invoice. Enter it as a negative number.

And last I need to enter the fee Airbnb takes out. Name it Airbnb Fee,make Income account called Airbnb, Type: Other charge, non taxable. Also enter it as a negative number.

Pictures below to help illustrate it.  This is what the invoice for 1 guest's stay works out to be. 

Here is the P& L showing how this worked out.  I am concerned that the tax expense will happen twice. Once here and again when I actually pay my sales tax.  

But when I do my Sales tax liability report, it looks correct:

Here is the breakdown of the non-taxable sales of $56.40. It's the 2 line items I set up:

So this is where I am, I don't feel it's 100% correct but I'm at a loss as to how to fix it.  I had read some other threads on here but wasn't sure about those so I decided to try this out and see what you guys think.

Brenda