An Excel workbook (XLSX) for short-term rental hosts, B&B and guesthouse owners: log your income and expenses by property and category, and the workbook totals them by category, by property and by month, compares income with expenses, flags missing receipts, possible duplicates and entries outside your 12-month period, tracks a checklist of documents to collect, and prints a clear Accountant sheet to hand over. It is a record-keeping tool: it applies no tax rules and gives no tax advice. A BLANK workbook and a DEMO workbook with fictional data are included in English, Italian, Spanish, French and German.

The problem it solves

At year end, receipts, payout statements and bank lines are scattered. Nobody knows which expenses belong to which property, what is still missing, or how to present it all in a way an accountant can use.

Who it is for

Short-term rental hosts, B&B and guesthouse owners and small property managers who want their year-end records in order and one tidy summary to give to their accountant, in desktop Excel.

What you get

• Expense log with property, category, supplier, amount, payment method and whether you kept the receipt; refunds go in with a minus sign
• Income log with gross amounts and the platform fees withheld, so payouts and fees do not get mixed up
• Totals by category, by property and by month, plus income minus costs for the period; a category-by-property table shows where the money went
• Automatic checks: missing receipts, possible duplicates, entries outside your period and incomplete lines
• Document checklist with 24 typical records to collect (platform statements, bills, insurance, loan statements and more), with progress and an outstanding list
• A printable Accountant sheet (3 A4 pages) with your details, totals, records check and a notes area; print it or save it as PDF
• Complements Rental Property Tracker (profitability tracking) and Rental Performance; all files in English, Italian, Spanish, French and German

How you use it

1. Download and unzip, open the folder of your language and look at the DEMO workbook first.
2. Open the BLANK workbook in desktop Microsoft Excel and save a working copy. In Setup, set the period start date (12 months are counted), your properties and the names for the Accountant sheet; rename categories if you like.
3. Log each payment in Expenses and each payout or booking payment in Income. Tick off documents in the Documents sheet.
4. Read the Summary for totals and the entries to check, and fix anything flagged.
5. Print the Accountant sheet or save it as PDF, add your notes in the yellow cells, and hand it over.

Questions