Export to Accounting Software

Frihet exports billing data in 5 formats that major accounting programs can import directly. This allows managers and tax advisors to work with their usual tools without manual data entry.

Available Formats

Format	Target Software	Delimiter	Encoding	Date Format
ContaPlus xDiario.txt	Sage 50, ContaSol, A3	Fixed-width (129 characters)	latin-1	YYYYMMDD
DATEV EXTF	German accounting firms (~90% of the market)	; (semicolon)	latin-1 / CP1252	DDMM
Xero CSV	Xero (global)	, (comma)	UTF-8	DD/MM/YYYY
QuickBooks CSV	QuickBooks (global)	, (comma)	UTF-8	MM/DD/YYYY
Generic CSV	Universal	, (comma)	UTF-8 with BOM	ISO 8601

ContaPlus (xDiario.txt)

The ContaPlus xDiario format is the historical accounting standard in Spain. It generates a text file with fixed-width records of 129 characters per line.

Record Structure

Each invoice generates between 2 and 3 lines of accounting entry:

Position	Length	Field	Example
1-2	2	Entry Type	A1
3-10	8	Date	20260215
11-22	12	Accounting Account	430001000000
23-34	12	Contra Account	700000000000
35-49	15	Amount	000000121000.00
50	1	D/H (Debit/Credit)	D
51-90	40	Concept	Inv. FRI-2026-0001

Default Accounting Accounts

Account	Concept
430XXX	Clients (XXX = client code)
477000	Public Treasury, Output VAT
700000	Sales of goods / provision of services
472000	Public Treasury, Input VAT
600000	Purchases / expenses

Import into Sage 50

1. Open Sage 50 and go to Accounting > Journal > Import
2. Select the xDiario ContaPlus format
3. Load the .txt file exported from Frihet
4. Review the entries and confirm the import

DATEV EXTF

The DATEV EXTF format is the de facto standard in German accounting firms and is also used in Austria and Switzerland. Frihet generates files compatible with DATEV Unternehmen Online and similar.

EXTF Header

The first line of the file contains the batch metadata:

EXTF;700;21;Buchungsstapel;12;...

Main Fields

Field	Description
Umsatz (Soll/Haben)	Debit or Credit Amount
Gegenkonto	Contra Account
BU-Schlüssel	Tax code (8 = 19%, 9 = 7%)
Belegdatum	Document date (DDMM)
Buchungstext	Entry text
Belegfeld 1	Invoice number

Encoding

DATEV requires latin-1 (CP1252) encoding. Frihet automatically converts special characters (accents, ñ) when exporting.

Xero CSV

Xero is the most used accounting software in Anglo-Saxon markets. The Xero CSV contains 43 columns that cover all fields of a sales invoice.

Main Fields

Field	Description
*ContactName	Client name (required)
*InvoiceNumber	Invoice number
*InvoiceDate	Issue date (DD/MM/YYYY)
*DueDate	Due date
*UnitAmount	Unit price
*Quantity	Quantity
*AccountCode	Accounting account code
TaxType	Tax type (OUTPUT, INPUT, NONE)
Description	Description of the item
Currency	ISO currency code (EUR, USD, GBP...)

Import into Xero

1. In Xero, go to Business > Invoices > Import
2. Select CSV as the format
3. Load the file exported from Frihet
4. Map the columns (Frihet's CSV uses the exact Xero names)
5. Confirm the import

QuickBooks CSV

The QuickBooks CSV format is compatible with QuickBooks Online and QuickBooks Desktop.

CSV Fields

Field	Description
InvoiceNo	Invoice number
Customer	Client name
InvoiceDate	Issue date (MM/DD/YYYY)
DueDate	Due date
Item	Description of the item
Quantity	Quantity
Rate	Unit price
Amount	Line total amount
TaxCode	Tax code
TaxAmount	Tax amount
Memo	Additional notes

Date Format

QuickBooks uses the MM/DD/YYYY (month/day/year) format. Frihet automatically converts dates when exporting.

Generic CSV

The generic CSV format is the universal option when no other format fits the target software. It includes all available fields with the broadest possible compatibility.

Features

• Encoding: UTF-8 with BOM (compatible with Excel in all languages)
• Delimiter: comma
• Dates: ISO 8601 format (YYYY-MM-DD)
• Amounts: decimal notation with a dot (1234.56)

Included Fields

The generic CSV exports all invoice fields: number, date, client (name, tax ID, address), items (description, quantity, price, tax), totals, payment status, and VeriFactu metadata.

How to Export

Individual Export

1. Go to Billing > Invoices
2. Open the invoice you want to export
3. In the actions menu, select Export > desired format
4. The file is downloaded

Export by Period (Accounting Firm Dashboard)

If you have access to the Accounting Firm Dashboard:

1. Go to Accounting Firm Dashboard > Export tab
2. Select the export format
3. Select the period (month, quarter, or custom range)
4. If you manage multiple clients, select the client
5. Click Download

The file contains all invoices for the selected period in the chosen format.

Batch Modelo 303

The Accounting Firm Dashboard allows generating the draft Modelo 303 for multiple clients simultaneously:

1. Go to Accounting Firm Dashboard > Batch tab
2. Select the quarter and year
3. Select the clients for whom you want to generate the model
4. Click Generate Batch
5. A ZIP file containing a draft Modelo 303 for each selected client is downloaded

tip

Batch export saves significant time at quarterly closing when managing multiple clients from the same accounting firm workspace.

Notes on Encoding

ContaPlus and DATEV formats require latin-1 (ISO 8859-1 / CP1252) encoding. Frihet performs the conversion automatically upon export:

• Compatible characters are converted directly
• Characters without a latin-1 equivalent are transliterated (e.g., Asian characters are replaced by their closest ASCII representation)

Xero, QuickBooks, and generic CSV formats use UTF-8 and have no character restrictions.

---

Related: Ledger Book | Tax Forms | All Integrations