Xero

​

Overview

This page describes the import from Xero: you export the General Ledger Detail report as an Excel file and upload it to Fyvel. An overview of every import path is on Uploads.

​

Open the report

1. In Xero, open Reporting.
2. Under Taxes and balances, choose General Ledger Detail.

​

Select all accounts

Under Accounts, click Select all. Every account must be in the export. If an account is missing, the bookings do not balance and Fyvel rejects the file.

​

Set the date range

Under Date range, choose the start and the end. Take the first month you want to report in Fyvel through the current month. After the change, click Update so the report shows the new range.

​

Columns

Under Columns, tick every column shown in the screenshot:

• Account, Account Code, Account Type
• Credit, Debit, Gross, Net
• Date, Description, Reference, Source
• Department
• Invoice Number, Journal ID, Related account
• Running Balance
• Tax, Tax Rate, Tax Rate Name

If one of these columns is missing, Fyvel cannot read the file. You need Department if you want to bring cost centers over from Xero.

​

Do not group

Under Grouping/Summarizing, Group by must be None. Not Account or Account Code & Name, and not Summarize by. Otherwise the file contains total rows instead of the individual bookings.

​

Save as a custom report

At the bottom right, click Save as custom. Next time you open this report, set only the date range again. You do not have to configure accounts, columns, and grouping once more.

​

Download as Excel

1. Check that Update shows the correct date range on the report.
2. Export → Excel. Not PDF, and not Google Sheets.

The file extension is .xlsx. It is always exactly one file per upload.

​

Upload in Fyvel

1. In Fyvel, open the Uploads page.
2. Drag the Excel file into the upload area.
3. Fyvel processes the file in the background. You see the status in the upload table.

The new upload replaces all previous Xero bookings of this company. Anything that is no longer in the file is gone from Fyvel afterwards.

​

Cost centers

If the export contains a column with departments or tracking categories (in the screenshot, Department):

1. Upload the file once. Fyvel remembers the labels from that column.
2. Open Company settings → Xero integration.
3. Enter the column name as the source column, for example Department.
4. Map each label to a Fyvel cost center and save.
5. Upload the same file again. Only this second upload writes the cost centers onto the bookings.

Labels without a mapping come in without a cost center. The column must stay in the Excel export, otherwise the upload fails.

​

If the upload fails

---