Skip to main content

Accounting exports setup guide

Updated over 5 months ago

Overview

The accounting integration feature allows you to connect your accounting software with Little Hotelier, streamlining your property's accounting and bookkeeping, bank reconciliations and tax declarations. Export finalised invoice data to CSV format for easy import into your accounting system, eliminating manual data entry and reducing potential errors.

Note: This feature is not available for properties in Germany or Spain.

While the CSV export is designed for Xero and QuickBooks import functionality, you can use it with other accounting systems or for general data analysis.

Initial setup

Before configuring the integration in Little Hotelier, ensure you have:

  • Set up your chart of accounts in your accounting software

  • Map your tax codes in your accounting software

Map accounting codes

  1. Navigate to Setup > Accounting exports

  2. Enter the Default Account Mapping and Default Tax Mapping codes for:

    1. Room Revenue

    2. Extras

    3. Fixed Taxes

    4. Non Sales Taxes

    5. Credit Card Surcharges

    6. Service Charges


Custom mapping

To create mappings for individual items (Room Type, Extras, Fixed Taxes and Non Sales Taxes):

  1. Navigate to Setup > Accounting exports

  2. Click Add custom mapping in the relevant section

  3. Enter Account Mapping and Tax Mapping Codes

  4. Save changes

While you can add new custom mappings after initial setup, avoid changing default mapping codes to prevent errors.

Settings

Date format

  • Select your preferred date format from the dropdown menu in General Settings

  • Default date format is DD/MM/YYYY

  • This setting applies to all property users

Advanced settings

Tax code mapping

  • Enabled by default

  • When disabled:

    • Removes tax codes from Setup accounting exports page

    • Removes TaxType column from CSV exports

Tax exemptions

  • Disabled by default

  • When enabled:

    • Adds checkbox for tax-exempt items

    • Includes 'TaxExempt' column in exports

    • Marks exempt items as 'True' in export file

Sales tax display

  • Default: Tax-inclusive exports

  • Toggle available for tax-exclusive exports

Did this answer your question?