SparkReceipt Help

Export files for Sage 50, DATEV, Wave and Sage 200/300

Download your expenses and income as a file already formatted for Sage 50, DATEV, Wave or Sage 200/300, then import it into your accounting software.

JO
Written by Joel OjalaUpdated Oct 14, 2026

SparkReceipt can export your documents as a file that's already formatted for a specific accounting package, so you can import it directly instead of reshaping a plain spreadsheet by hand. The format is called Accounting import file in the export dialog and Accounting Software on the Create report page. The templates cover:

  • Sage 50 — CSV for Sage 50 Accounts (UK / Ireland)
  • Sage 200/300
  • DATEV — the EXTF Buchungsstapel format used in Germany
  • Wave

These are file exports: SparkReceipt builds the file, you download it, and you import it into your accounting software yourself. That's different from the direct QuickBooks Online and Xero connections, where documents are published straight into the platform — see What accounting software integrations do you have? for that side. Use these templates when your software isn't one of the direct integrations but can import a formatted file.

Two places to create a template export

You can produce a template file from either of two spots in the web app, and from the export sheet in the mobile app. The templates are part of the Elite plan, so the format is only listed when your plan includes them.

From the Documents view

  1. Open the Documents view in the SparkReceipt web app
  2. Filter the documents you want and click Export in the page header, or tick the rows you want and click Export selected
  3. In the export dialog, check the first line. It shows how many documents are included, the period and the active filters
  4. Under Format, choose Accounting import file
  5. Pick the template you need (Sage 50, Sage 200/300, DATEV or Wave)
  6. Fill in the template's settings (see below), then click Export

In the mobile app

  1. Open the Documents tab, set the filters you want and tap Export at the top, or select documents and tap Export in the selection bar
  2. In the export sheet, choose Accounting import file under Format
  3. Pick the template you need and fill in its settings, then tap Export

From Reports

  1. Click Reports in the left-hand menu
  2. Click Create report
  3. On the Create report page, choose the date range and any filters you want
  4. Choose the Accounting Software format and pick your template
  5. Fill in the template's settings, then click Export

Either way, the file is generated the same way as any other export. SparkReceipt prepares it while you wait or after you click Continue working, downloads it or shows a notification with a Download button when it's ready, and keeps it in Reports with the kind Accounting import file. If email notifications for finished reports are on in your notification preferences, you get an email too.

Template settings are remembered per account

Each template has its own settings — the account codes and identifiers your accounting software expects. SparkReceipt saves these per account, so once you've set them up they're pre-filled the next time you export, and everyone on the account uses the same configuration.

Sage 50

  • Account Reference — the customer/supplier reference to write on each row
  • Nominal Code — the nominal account to post to
  • Default Tax Code — the Sage tax code (T0, T1, T2, T5 or T9) used when a line has no more specific mapping

DATEV

  • Consultant Number (Beraternummer) — required
  • Client Number (Mandantennummer) — required
  • Account Chart — your chart of accounts (SKR 03 or SKR 04)
  • Account Length — the account number length (4 or 5 digits)

If a required setting is missing, the export will tell you which field to fill in before it can build the file.

Which documents are included

The export includes whatever is in scope when you start it. From the Documents view that is everything matching your filters when you click Export, or exactly the rows you ticked when you click Export selected. From Create report it is everything matching the date range and filters you set on that page. Both expenses and income are included, mapped to the debit/credit side each format expects.

Tip

If you're not sure which template or codes your accountant needs, ask them for the chart-of-accounts codes and tax codes before your first export — those are the settings SparkReceipt asks for, and getting them right once means every later export imports cleanly.