Accounting setup

Accounting setup

This article guides you through setting up your organization so you are ready for exporting itinerary data to an accounting system. In the Accounting setup you can add your tax information, chart of accounts  and also map your incoming and supplier payments to your chart of accounts for the purpose of sending Tourwriter data to your accounting system for easy reconciliations.

More information on the Xero integration is here.

General settings

  • Tax number – This is your company tax number and it will display on the PDF invoices you send to travelers
  • Payment instructions – These are the payment instructions that will appear in your PDF invoices

Supplier payment settings

The information you add here will be used when using the Xero integration or exporting to CSV for accounting import.
    • The "Reference" field in Supplier Payments, whether exporting to CSV or sending payment information to Xero, can be customized using a combination of fields defined in the Supplier Payment settings.
    • When multiple fields are selected, then each field will be separated by a -
    • You can select Itinerary name, Itinerary ID, Booking ID, Itinerary internal reference, Supplier payment ID or Supplier payment reference number.

    Tax rates

    For customers who export itinerary supplier payments for the purpose of uploading to an accounting system, you can assign a tax rate to assist with your tax compliance requirements. The first tax rate added will be the default rate applied to all supplier payments. If you have more than one tax rate configured you can override the default for any item in an itinerary.

    How to override the default tax rate in an itinerary

    1. Navigate to the Pricing tab in an itinerary.
    2. Click Edit pricing for the Item you wish to override.
    3. Select an alternative tax rate from the Change tax rate dropdown.
    4. Click Save to save your changes

    Note: To view the tax rates assigned to an item, click the gear icon on the Markup column and select tax %

    Note: When using the Xero integration Xero does not recognize the tax rate assigned in Tourwriter but instead uses the tax rate assigned to the Account code in Xero. 

    Note: When exporting to Xero the Accounting export name should exactly match the Tax rate name in Xero to ensure the upload is successful.

    Chart of accounts

    For customers who export itinerary supplier payments to upload to an accounting system you can add your account codes to Tourwriter and then map these to your product types to ensure your payments are automatically mapped to the correct account in your accounting platform. First add all your accounts to match your accounting system then map them as detailed below.

    To add accounts already setup in your accounting platforms Chart of accounts, you can either add manually or import directly from Xero if you have Xero integration enabled.

    Add accounts manually
    1. Click Add account ( and select Add accounts from Xero if Xero integration is enabled)
    2. Type a code (usually 3 or 4 digits. This is a mandatory field)
    3. Type the Account name (This is a mandatory field)
    4. Click Save 
    Add accounts from Xero (Only available if you have active Xero integration)
    1. Click Add account
    2. Select Add accounts from Xero
    3. All the Charts of Accounts from Xero will be listed
    4. Select the  ones you would like to Import
    5. Click Add accounts
    6. The selected accounts from Xero will be imported in Tourwriter

    Note: You should only add accounts from the Revenue (Incoming payments) and Expense (Product types) side of the ledger.

    Note: You can edit a line if you make a mistake or delete the code if necessary.

    Account code mapping

    After setting up your chart of accounts you can map your Tourwriter payment types to your preferred account. Each account created above is available in the mapping dropdown. Doing this ensures fast and easy reconciliation and bank payment processing using the Xero integration.  

    Incoming payments​ mapping
    Select an Accounting code from Chart of accounts to be used as the Account code when exporting Incoming payments with Xero integration.

    Agency payments mapping
    Select an Accounting code from Chart of accounts.
    Note: Agency payments are not currently included in the Xero integration and require a manual adjustment.

    Product type mapping
    Select the appropriate account code from the drop down. You can also select an alternative manually in Xero so leaving a type as unmapped is OK.



      • Related Articles

      • Setup your terms and conditions

        How to set up default terms and conditions Overview Your terms and conditions are an important company document that you can send attached to your itineraries and have travellers accept them through Tourwriter. 1. Log into Tourwriter ...
      • Itinerary Setup

        How to create an itinerary Overview It's time to get down to business and get started on the itinerary build process! In this article we're going to cover through the intiial setup of an itinerary and how to add collaborators - travellers, agencies ...
      • Setup your default currency in Tourwriter

        Overview Tourwriter supports over 170 currencies. The default currency is the currency you will quote and sell itineraries in. Click here to view an interactive tour of how to setup your default currency. Step-by-step 1. Login to ...
      • Exporting supplier payments to CSV for accounting reconciliation

        The Export payments function means you can export supplier payment data from an Itinerary into a CSV file ready for uploading to accounting software such as Xero. You can then either reconcile payments already made or create bank payments via your ...
      • Setup your booking email settings and templates

        How to set up your default booking email settings and templates Overview The booking email settings is where you will setup the settings and templates that you will send to your suppliers with regards to bookings. Along with your general email ...