How are the monthly earnings reports calculated?

[Eric8077]

My city has started charging a 12% TOT tax.  I tried putting together my own Excel file with all the information for my earnings from each month, only to find out that the all the money I'm paid in a month on the date I get paid (24 hours after reservation starts) does not align with Airbnb's earning reports.  The taxes I paid in the past have always been based on that report.  I tried it from the date of the reservation and that number also doesn't align.

The exporting of their CSV file tells me the payment amounts, which are combined from two different reservations.  Since I'm trying to calculate exemptions based on individual reservations, I need a clear way to determine how each month's earnings report is calculated.

[Rebecca]

Hello @Eric8077 👋

Thank you so much for coming to the community to ask this question.  Whilst I'm not exactly sure on why they don't align, I'd like to invite some of the experienced hosts who know a thing or two about the financial side of things and hopefully they'll be able to jump in: 

@Chippy3, @Jon5060 and @Thomas3789 - I wondered if you'd be able to share some advice or information here that might help @Eric8077? 

Thanks so much in advance. 😊

[Pat271]

For what purpose are you calculating monthly taxes?

If it’s to make monthly payments to your government, you can add the taxes directly as a line item in Airbnb using their Professional Tools, and just pay the monthly total of those taxes.

If it’s to report the gross earnings to the government, you can calculate that in your spreadsheet by adding a Gross Earnings column and reverse-calculating that figure from the total of the taxes collected from each guest.

I wouldn’t use payout information to derive anything, as if you did, you would have to add back in the Airbnb host fee and massage other potential figures such as refunds you gave guests outside of your cancellation policy. Instead, use a formula consisting of the base rent + fees (cleaning, extra person, etc.) as your gross income and multiply that times your tax rate to cross check the amount of taxes you have collected from the guest using Professional Tools.