Skip to main content
All CollectionsFront Desk Setup
Accounting Integration: setup
Accounting Integration: setup
Updated over 2 months ago

Important to know:

  • To map your accounting package codes in Little Hotelier, in Front Desk, go to Setup > Accounting Integration

  • This feature is not available to Little Hotelier customers in Germany or Spain

Introduction to Accounting Integration

You can integrate your accounting package with Little Hotelier to help manage your property’s accounting and bookkeeping, perform bank reconciliations, as well as to make tax declarations to government authorities. Little Hotelier enables you to export your finalised invoice data to a .csv file, which you can then import into your accounting software package, eliminating the need to manually input data into your accounting software package and reducing potential errors.

The .csv file that can be exported from Little Hotelier is designed with Xero and QuickBooks' invoice import functionality in mind. However the exported file can also be used for general purposes such as for data analysis.

Map your accounting package codes in Little Hotelier

You must set up your chart of accounts and taxes directly in your software accounting package, prior to mapping your accounting package codes in Little Hotelier.

To configure your Accounting Integration in Little Hotelier, you must map your accounting package account and tax codes, which will ensure your software accounting package recognises your Little Hotelier reservation data.

Follow these steps to map your accounting package codes in Little Hotelier:

  1. In Front Desk, go to Setup > Accounting Integration > Accounting Integration

  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

map accounting package codes

Add custom mapping

To map a certain Room Type (Room Revenue), Extras, Fixed Taxes and Non Sales Taxes to a specific account and tax code that is not the Default Account Mapping and Default Tax Mapping code, you can Add custom mapping.

To do so, click the Add custom mapping button in the appropriate section, then enter the relevant Account Mapping and Tax Mapping codes.

After initial set up, if required, you can add new custom mappings, however to avoid potential errors in your accounting package, it is recommended the default mapping codes do not change.

add custom mapping

Define how dates appear on your accounting exports

To configure how dates appear in the .csv accounting exports from Little Hotelier you can select the appropriate format from the dropdown menu under “ General Settings ” in the Setup Accounting Exports page.

This is a property level setting and will be applicable for all property users, using the Accounting Export functionality.

By default all dates on .csv accounting exports would be in DD/MM/YYYY format.

Advanced settings for Accounting Exports

To configure if tax codes and tax exemptions are mapped in your .csv accounting exports from Little Hotelier, you can look for their corresponding toggles under the Advanced Settings ribbon in General Settings in the Setup Accounting Exports page.

By default, Little Hotelier has tax code mappings toggled on and tax exemptions toggled off. Having the tax code toggle turned off, removes tax codes from the Setup Accounting Exports page altogether and the ‘TaxType’ column will be removed from the .csv accounting exports prepared.

By default, the tax exemptions mapping toggled is turned off by Little Hotelier. Having this toggled turned on, will present a check box adjacent to all the mappings you make in the Setup Accounting Exports page and add a ‘TaxExempt’ column into the .csv accounting exports prepared.

If the “Make tax exempt” check box is checked for a mapping in the Setup Accounting Exports page, then the ‘TaxExempt’ column will be populated with a ‘True’ (and vice versa) in the .csv accounting export file.

To have your accounting exports generated exclusive of sales tax use the sales tax exclusive toggle turned on. Accounting exports are generated inclusive of sales tax by default.

English
Did this answer your question?