Accounting exports
Your sales, payments and expenses as a journal for your accountant, in CSV, Tally, Xero or QuickBooks.
Finance → For your accountant turns the hotel's money into journal entries for your accountant or accounting software.
What's in it
For each day there are up to three entries. Each one balances: debits equal credits.
| Entry | Debit | Credit |
|---|---|---|
| Sales | Guest ledger | Room revenue, extras, fees, cancellation fees and tax |
| Payments | Cash, card, bank or Stripe | Guest ledger |
| Expenses | The expense category | Cash, card or bank, as it was paid |
Voided lines, payments and expenses are left out. A refund goes the other way.
Downloading the file
- Choose the dates at the top of the Finance page (this month, last month, or your own).
- Under The accounts for..., click the format you need:
| Format | Use it for |
|---|---|
| CSV | Any spreadsheet, or to send to your accountant |
| Tally (XML) | Tally: Gateway of Tally → Import Data → Vouchers |
| Xero (manual journal) | Xero: Accounting → Manual journals → Import |
| QuickBooks Online (journal) | QuickBooks: Settings → Import data → Journal entries |
Your account codes
Click Change the account codes to use your own chart of accounts. For each line (room revenue, each payment method, each expense category...) set the code and the account's name. Tally matches by name, Xero by code and QuickBooks by account name.
Emailed every month
Fill in Email last month's file to and choose the format. On the 1st of each month, last month's file is emailed there.
Still need help?