⚠️ This feature is not available for Little Hotelier customers in Germany or Spain.
How to export invoices
⚠️ Only Finalised invoices can be exported.
To export invoices:
Go to My Apps > Front Desk.
Navigate to Reports > Accounting.
Use the View for search toggle and select Yesterday, Last 7 days or Select custom dates. The results will show Finalised reservations with an invoice creation date that falls within your selected date range.
Click Export.
A .csv file will be downloaded (or a .zip file for larger data sets) that you can import into your accounting software.
Invoice status tabs
View invoices based on their status within your selected date range:
Status | Description |
Finalised | Invoices marked as final with creation dates within the search range. These are included in the export. |
Not finalised | Invoices generated but not marked as final, with creation dates within the search range. |
Not invoiced | Reservations past check-out without generated invoices, where checkout dates fall within the search range. |
Out of sync | Out of Sync invoices are invoices have been cancelled with a new invoice generated and marked as final |
All | Combined view of all invoice statuses. |
Note: A (!) symbol appears next to the Finalised status when reservation changes were made after finalising the invoice
CSV export fields
.csv file column name | Data included in the column |
ContactName | Primary guest's first and last name |
EmailAddress | Primary guest email address |
POAddressLine1 | Primary guest address |
POCity | Primary guest city |
PORegion | Primary guest state |
POPostalCode | Primary guest post code |
POCountry | Primary guest country |
InvoiceNumber | Invoice number of the invoice marked final |
InvoiceDate | Invoice date of the invoice marked final |
DueDate | As above, the due date of the invoice marked final |
Description | Invoice line item's description |
Quantity | Invoice line item's quantity |
UnitAmount | Invoice line item's unit price (including sales taxes and discounts) |
ItemAmount | Invoice line item's unit price (including sales taxes and discounts) multiplied by its quantity |
AccountCode | Account code mapped for invoice line items of this nature by you in Little Hotelier Setup |
TaxType | Tax code mapped for invoice line items of this nature by you in Little Hotelier Setup. This column can be omitted from the export based on your configuration in Little Hotelier Setup. |
Taxable | Tax exemptions mapped for invoice line items of this nature by you in Little Hotelier Setup. This column can be omitted from the export based on your configuration in Little Hotelier Setup. |
Currency | Invoice line item's currency |
Note: UnitAmount and ItemAmount values are inclusive of sales tax by default. Ensure your accounting package import settings are configured for tax inclusive amounts.