Export receipts for Xero, QuickBooks, FreeAgent, DATEV and FEC

Many small businesses keep their books in an online bookkeeping app, while the receipts pile up somewhere else. ReceiptBook reads and files receipts on your iPhone, and at the end of a period it can write the same documents in a layout your bookkeeping app or tax adviser can import. You keep the originals and the full accountant package; the bookkeeping file is the bridge to the software.

Which formats you see, by country

The standard four formats (accountant package, CSV, Excel and period PDF) are there for everyone. Below them, the For bookkeeping software section depends on the country set in Settings > Your business:

If you run a business in a second country, a separate business profile gets its own country and its own formats. See income and several businesses.

What each file contains

Xero, QuickBooks and FreeAgent

These three are bank-statement style files: one line per document, with money out as a negative amount. Xero gets a date, amount, payee, description and reference; QuickBooks gets a date, a description and an amount; FreeAgent gets a date, an amount and a description with no header row. US profiles get month-first dates, UK profiles day-first. You upload the file where the app accepts a bank statement, then match or explain the lines there.

DATEV, lexoffice and sevDesk

The DATEV booking batch (EXTF) is meant for your tax adviser. It has the EXTF header and one booking per VAT rate or split part, with SKR03 accounts and tax keys. Before you export it, enter your DATEV consultant number and DATEV client number in Settings > Your business. The lexoffice and sevDesk files are one line per document with date, amount and purpose; you map the columns once on the first import.

FEC for France

The FEC accounting entries (TXT) file has balanced entries with PCG accounts in the FEC layout, for tools such as Pennylane or Tiime or for your accountant. Its name is fixed by the format and starts with your SIREN, so fill in SIREN in Settings first.

Vietnam household business book

Vietnamese profiles get a household business book of revenue and costs as PDF and CSV. The app itself notes that this layout is not yet verified against the rules, so have it checked before you rely on it.

Separators, currencies and the accountant package

ReceiptBook writes CSV files as UTF-8 with dates as YYYY-MM-DD in its own spreadsheets. Germany, France, Austria and Vietnam use a semicolon with a decimal comma, Switzerland a semicolon with a decimal point, and the UK and US a comma with a decimal point. The bookkeeping files follow the layout of their target app, which is why the lexoffice and sevDesk files use semicolons and German dates.

Documents in another currency need an exchange rate before they can go into a bookkeeping file. Without one, the file leaves them out and the app tells you how many were skipped. The foreign currency post shows how to add the rate your bank charged.

You don't have to choose between a bookkeeping file and the full record. The accountant package ZIP carries the country's bookkeeping files in its accounting/ folder next to the CSV, the period PDF, the originals and the manifest. The accountant package post lists everything inside.

FAQ

Download ReceiptBook and hand your next period to your bookkeeping app in one file.