The Export payments feature lets you export supplier payment data as a CSV file formatted for either Xero or QuickBooks, so you can reconcile payments directly in your accounting software.Before you export
Make sure the payment lines you want to export are visible. If any are hidden, check that the relevant booking statuses are active in your filter settings on the Supplier payments tab.
How to export supplier payments
- Go to the Supplier payments tab.
- Select the payment lines you want to export. To export all, use the select-all option.
- Open the Actions dropdown and choose Export CSV.
- In the dialog, select either Xero or QuickBooks as your export format.
- Review the selection and click Export.
- Open the downloaded CSV file to verify the data.
Once exported, each payment line displays a download icon to confirm it has been included in an export.
Grouping payments by supplier
If you want to consolidate multiple payments to the same supplier into a single line, tick Export items grouped by supplier in the export dialog before clicking Export.
How the CSV maps to your accounting software
The export maps Tourwriter fields to the corresponding fields in Xero or QuickBooks as follows.
| Exported from Tourwriter | CSV column label | Xero field label | QuickBooks field label |
| Supplier Name | ContactName | Contact | Supplier |
| Organisation-> Accounting-> Supplier payment settings | InvoiceNumber | Reference number – Using global search in Tourwriter will direct you straight to the related Supplier payment | Bill number |
| Date of export | InvoiceDate | Date – This can be edited in Xero | Bill date |
| Payment Due Date | DueDate | Due Date – This can be edited in Xero | Due date |
| Quantity = 1 | Quantity | Quantity – Hard coded to 1 to ensure the correct Total due is reflected in Xero | Quantity |
| Amount Due | UnitAmount | Unit Amount – Multiplying the Unit Amount by the Quantity of 1 = Total due in Xero | Line amount |
| Account code | AccountCode | Account – The account code in Tourwriter needs to match the Account code in Xero. | Account |
| Accounting export name | TaxType | Tax rate – the tax rate label in Tourwriter needs match the tax rate in Xero. | Line tax code |
| Supplier email address | EmailAddress | Email address of the Supplier/Contact | |
| Quantity x ItemName (ItemOption – number of nights or days) | Description | Description | Line description |
| Currency | Currency | Currency – this is the currency the product will be paid in. This currency needs to be listed in Xero before exporting | NA |