The accounting export streamlines your month-end closing process with Xero, ensuring efficiency and ease. Kinnovis enhances this experience by optimising data transfer to Xero, significantly reducing the time required. This export feature allows you to conveniently select and align data fields with accounting codes, minimising manual effort. Your customised export is delivered directly to your email, ensuring seamless integration and convenience.
How to Customise Your Export
Step 1: Set up your export
1. Navigate to the "Invoices" tab within your Kinnovis Manager.
2. Click on "Actions" and select "Xero Accounting Export."
3. Select one or multiple locations for which you wish to export the accounting data.
4. Choose the date range for the export. By default, the system displays the current month, but you may select a custom date range if required.
5. Select the same date format that you have set up in your Xero Invoice Settings for a smooth upload and matching invoice dates.
6. Each account is assigned a specific account type, which Xero uses to determine where it will appear in your financial reports. Please enter the corresponding "Xero account codes" that align with the following revenue types from Kinnovis:
Rental revenues
Protection plan revenues
Deposit revenues
Product revenues
If there are separate codes for credit notes, please include them as well. If the credit note codes are the same as the invoice codes, indicate that as well.
7. Each account has a default tax rate. The tax rate name, which determines how Xero treats the transactions for sales tax purposes, can be added to the export. Ensure that the correct values are entered corresponding to the setup in Xero.
Note: In addition to the specified fields, the Xero export will include the following columns: *ContactName, EmailAddress, POAddressLine1, POAddressLine2, POAddressLine3, POAddressLine4, POCity, POPostalCode, POCountry, *InvoiceNumber, Reference, *InvoiceDate, *DueDate, Total, InventoryItemCode, Description, *Quantity, *UnitAmount, Discount, AccountCode, TaxRateName, TaxAmount, TrackingName1, TrackingOption1, TrackingName2, TrackingOption2, Currency, BrandingTheme
Step 2: Define recipients
The mandatory "email address" field will be automatically pre-filled with the email address of the currently logged-in user. You can easily add additional email addresses to distribute the report to multiple recipients, including your accountants.
Your customised export will be delivered via email. By clicking "Download", the document will be saved to the location specified in the browser.
Export Format & Import to Xero
Your export will be delivered in a CSV format. The CSV document contains values that are provided during Step 1 and matched with booking data from your operations. You can open this file with any conventional table calculation program to check the data, or upload it directly to Xero.
🏁 Congratulations! 🏁
Your export is now ready to be uploaded to Xero.