Your accountant needs the same things every month: what you invoiced, what you credited, and what was paid. Dentz puts all of it in one download.
Making the export
- Open Invoices and press Export for your accountant. It is on Reports → Money in too.
- Pick the period: This month, Last month, This tax year (1 March to the end of February), Last tax year, or Custom dates.
- Pick the format your accountant uses: Xero, Sage, or Summary only.
- Check the counts ("42 invoices, 3 credit notes, 51 payments") and press Download. Email the file to your accountant.
Which file goes where
| File | What it is | Where it goes |
|---|---|---|
| summary | Totals for the period: sales excl. VAT, VAT, credit notes, net sales, and payments by method. | Your accountant checks this first, against your VAT return. |
| xero-invoices | Every invoice line in Xero's import template. | Xero: Business → Invoices → Import. Choose Tax exclusive when Xero asks. |
| xero-credit-notes | Credit notes, with negative amounts, in the same template. | The same Xero import. Negative amounts come in as credit notes. |
| sage-sales-journal | One row per invoice and credit note: date, number, customer, excl. VAT, VAT, total. | Sage Business Cloud Accounting: your bookkeeper maps the columns when importing, or posts the totals. |
| payments | Money received: date, invoice, method, amount and bank reference. | For matching against the bank statement. Not an import file. |
| customers | The customers in this period, with VAT numbers and addresses. | For setting up customers in the accounting package. |
Deposits
A deposit invoice is a sale on the day it is issued. In the export the final invoice carries Less deposit as a negative line (your customer sees it under the total, as Less deposit paid), so the job is counted once across both invoices even when they fall in different months.
Accounting codes
Under Accounting codes you can change the sales account and the VAT type the file uses. Xero starts at account 200 with OUTPUT (or NONE if you are not VAT registered); Sage starts at Sales with Standard Rate (or No VAT). Dentz remembers what you used for next time.
More than one branch
The export follows the branch you have picked at the top. Choose All branches for the whole business, or one branch for just its invoices and payments. With more than one branch, the Sage and payments files get a Branch column, and every Xero line is tagged with a Branch tracking category.
Still stuck?
Press Get help in the portal or under More in the Dentz app, or email hello@dentz.co.za. A person answers, usually within the working day.
Updated 2026-10-20