Transaction history

[Letitia0]

Hi Hosts,

In the Transaction History it has an option to "Export to CSV", when I do this though it opens in my Excel looking untidy and not having all data under the titles it has.  Very hard to explain without showing all my transactions.

Can anyone help?

Cheers,

Letitia

[Marzena4]

Hello @Letitia0. There is a glitch with those exports to CSV, you must report it to Airbnb directly, maybe if more hosts have complained, Airbnb will improve this option.

[Letitia0]

Oh ok thanks Marzena, I'll do that.

[Robin4]

@Letitia0  CSV stands for 'Comma Separated Values' and is an Excel file that does away with a lot of unrequired information. 

If you transactions are not showing in their correct cells it is probably that your Excel has been corrupted as this is not a general complaint we come across Letitia.

You are never going to have all the information displayed without hovering over the 'hash' fields. 

This is the file as you should see it....

You can reveal more information by expanding some of the cells to the right, including payment details and accounts to which payouts have been sent.

If you are not seeing your information displayed in this way let me know and I will try to advise you further.

Cheers.....Rob

[Letitia0]

Thanks for your reply Rob.  I've used Excel alot so I'm aware of the expanding of cells to view the info but it appears to have put it all into one cell.  I'm not sure how to screenshot my excel page but here's my copy and paste:

Date,Type,Confirmation Code,Start Date,Nights,Guest,Listing,Details,Reference,Currency,Amount,Paid Out,Host Fee,Cleaning Fee
05-01-2018,Payout,,,,,,Transfer to Account *****0106,,NZD,,325.37,,
05-01-2018,Reservation,[Reservation number hidden],04-01-2018,1,[Personal information hidden],Cozy room in my home on Shalimar,,,NZD,36.69,,0.00,4.81
05-01-2018,Reservation,[Reservation number hidden]04-01-2018,3,[Personal information hidden],Cozy Apartment on Shalimar,,,NZD,288.68,,7.00,14.00
04-01-2018,Payout,,,,,,Transfer to Account *****0106,,NZD,,99.45,,
04-01-2018,Reservation,[Reservation number hidden],03-01-2018,1,[Personal information hidden],Cozy Apartment on Shalimar,,,NZD,99.45,,2.00,14.00
02-01-2018,Payout,,,,,,Transfer to Account *****0106,,NZD,,37.65,,
02-01-2018,Reservation,[Reservation number hidden],01-01-2018,1,[Personal information hidden],Cozy room in my home on Shalimar,,,NZD,37.65,,0.00,4.81
01-01-2018,Payout,,,,,,Transfer to Account *****0106,,NZD,,247.16,,
01-01-2018,Reservation,[Reservation number hidden],31-12-2017,1,[Personal information hidden],Cozy room in my home on Shalimar,,,NZD,37.65,,0.00,4.81
01-01-2018,Reservation,[Reservation number hidden],31-12-2017,2,[Personal information hidden],Cozy Apartment on Shalimar,,,NZD,209.51,,5.00,14.00

 [Personal information has been hidden due to safety reasons] 

[Nathan111]

I am having the exact same issue, my solution was to upload this using Google Sheets. Worked perfectly there.

[Barry-S-And-Jennifer0]

Hi,

were trying to download the csv from airbnb and when we click on the download csv file it shows us that it is downloading but not sure where. First question, does this only work on a laptop or computer and can you actually do this on a smart phone or an iPad etc. 

i see google sheets is best for opening the .csv file but frankly I’m trying from a non pc with excel and google sheets (my apple ipad) and not getting anywhere!

thank you

Barry 

[Branka-and-Silvia0]

@Letitia0 it showes different on windows 7 and windows 10. If you have another laptop/computer try there

[Patty45]

I don't know if anybody else is aware, but host service fees are tax deductible.  I didn't realize this until this year after hosting for 5 years.  Problem is, apparently you cannot go back to previous years to recover the fees you paid, or the totals in the past.  I would like to see if I can adjust my previous tax returns with those deductions.  The design of the website has the most unfriendly user format I have ever seen!  Everytime I need to access anything except the reservation process, it's a major wild goose chase.  I don't know who sets up the accounting or the website design, but it is the worst.  I've whined about this forever... When is someone going to do something about it!?!?!?!?!?  GRRRR

[Matthew285]

@Patty45, wouldn't host fees not even have been declared as part of your income?

AirBnB doesn't even send you the host fees; they deduct them before transmitting your share of the funds. So if you use the actual amount received as your income, the host fees were never part of it (and therefore do not need to be deducted.)

However, yes, if you were reporting the gross amount as your income, you certainly should deduct your host fees. Especially since you never received the money they represented in the first place.

[Roisin1]

I"m totally with Matthew in San Fan. Just delcare the income you receive. You are not delcaring the booking fees your guests get charged why declare the money that Airbnb are making off you and you never receive.

[Letti0]

@Roisin1   In the US you would be falsifying tax information reported. You must report the gross earning for the IRS. State, City and County hotel taxes you must also use the gross amount with no deductions allowed. You can deduct the service fee's from the total on the IRS annual return. Texas has no State Income tax, so no deduct here, but the other 44 States that do have State Income tax returns you can also deduct them on that. 

[Barry-S-And-Jennifer0]

Can anyone give me more clear directions on downloading the .csv? We’re trying to download the csv file for our taxes our there in Oz and I’m using my apple Ipad and apple smart phone to try and download the csv file. Do you need to do this on a laptop or computer in order for this download/upload to work?

thank you in advance

Barry

[JoseLuis74]

Hello everyone,

Maybe this excel template can help you with your problems!

I have it under my account in Fivver:

Stay healthy!

**[Advertisement removed in line with - Community Center Guidelines]