File export
The file export hands over reviewed invoices as an Excel or CSV file to any accounting program that can read such a file. You decide which columns appear in which order. It is part of the base package and needs no add-on module.
Setting up
Section titled “Setting up”- Open Settings, Further systems and choose Add File export. This applies per company.
- Choose the Format:
- Excel (.xlsx): Amounts as numbers, dates as dates. The character set does not matter.
- CSV: Delimited text. Set character set, delimiter, decimal separator and date format as in the target program.
- Define the Columns. Insert template gives you a starting point, Add column adds more.
- Set from when an invoice is ready (Ready from: Approved or Reviewed) and whether the file has one line per invoice line or per account assignment (Posting lines). Enter the first document number and, if you wish, a date for Invoices from. Empty means: from the month the export was created.
Without columns no file is created.
The columns
Section titled “The columns”Every column has a heading and a source:
- Invoice: for example document number, invoice number, date, vendor, IBAN, net total
- Line: for example description, quantity, net, tax rate
- Coding: your coding fields, such as G/L account and cost center
- Fixed text: always the same value
times -1 reverses the sign. Credit note amounts negative applies to the whole file, and so does First row with the column headings. The letters A, B, C match the columns in Excel, which you then use to map them in the target program.
The everyday way
Section titled “The everyday way”- Open Handover in the navigation. You see which invoices are ready and what is missing for the others. An invoice is blocked if the vendor, the invoice date, the line items or an amount or tax rate is missing. Empty coding fields stay empty in the file. There is no feedback as with BMD.
- Select the ready invoices and create the batch.
- Download the file. The ZIP contains the document images, named after the document number.
- Read the file into your program.
Characters that the chosen character set does not know are replaced by fineelik and counted on the batch.
Without downloading
Section titled “Without downloading”With the local agent, the file lands by itself in a folder on your network, with the document images if you wish. If one agent serves several companies, each gets its own subfolder.
Once a month on its own: the monthly handover creates the batch for the previous month and provides it with documents, payment receipts and expenses as a ZIP, with folders and file names for accounting.
If you remove the file export, only its settings and columns are lost. The invoices and their coding are kept.