Export to Exact Online

Introduction

Fuga can generate export files for import into Exact Online (EOL). For a correct import, 3 separate files are required, which must be created and uploaded in a specific order.

The 3 export files

The following files must be created and uploaded in this order:

OrderFileContent
1ClientsClient data (including VAT numbers)
2InvoiceCreditNoteInvoices and credit notes
3PaymentsPayments

⚠️ Important: The order is essential! If clients are not imported first, VAT numbers will not be correctly linked to invoices in Exact Online.

Creating the files in Fuga

1. Clients (client data)

  1. Go to the Consultations tab
  2. Click on All reports
  3. Choose the report "Clients with invoice/credit note in selected period"
  4. Select the desired period
  5. Click on the export button "exactonline_file" in the top right corner
  6. Save the XML file

2. InvoiceCreditNote (invoices and credit notes)

  1. Go to the Accounting tab
  2. Click on All reports
  3. Choose the report "Invoices and credit notes"
  4. Select the desired period
  5. Click on the export button "exactonline_file" in the top right corner
  6. Save the XML file

3. Payments

  1. Go to the Accounting tab
  2. Click on All reports
  3. In the Debtor management column, choose the report "Payments"
  4. Select the desired period
  5. Click on the export button "exactonline_file" in the top right corner
  6. Save the XML file

Send the 3 XML files to your accountant.

Tip: Shortcuts on your dashboard

You can place shortcuts on your dashboard for quick access to these exports:

  1. Click on the Dashboard tab 
  2. Click on the gear icon with clipboard in the top right corner of the coloured bar
  3. Select the reports you want to add:
    • Clients with invoice/credit note in selected period
    • Invoices and credit notes
    • Payments
  4. Save

Uploading files to Exact Online

Upload the files to Exact Online in the following order:

  1. First upload the Clients file
  2. Wait for the import to complete
  3. Then upload the InvoiceCreditNote file
  4. Wait for the import to complete
  5. Finally upload the Payments file

Common issues

VAT numbers do not appear in Exact Online:

This happens when files have not been uploaded in the correct order. Client data (with VAT numbers) must be imported before invoices. Recreate the 3 files and upload them in the correct order.