Fill in DIANO's templates
If you keep your books in Excel, download DIANO's templates, copy your lists and balances into them, and upload them.
1. What it must include
- Your customers and suppliers, one per line
- Your items (optional)
- Each account's balance on the day before your start date
- Each unpaid invoice, one per line
- Do not change the templates' column names
- Do not add totals at the bottom
- Do not save them as PDF
2. Step by step in Excel
Download DIANO's Excel templates. Click DIANO › Move to DIANO › Templates. Keep them as Excel (.xlsx).
A picture of the real screen comes here.Fill in your trial balance on the day before your start date. Click Templates › Trial balance. Save as Excel (.xlsx).
A picture of the real screen comes here.Fill in your unpaid customer invoices. Click Templates › Unpaid customer invoices. Save as Excel (.xlsx).
A picture of the real screen comes here.Fill in your unpaid supplier invoices. Click Templates › Unpaid supplier invoices. Save as Excel (.xlsx).
A picture of the real screen comes here.Fill in your customers, suppliers and items. Click Templates › Customers / Suppliers / Items. Save as Excel (.xlsx).
A picture of the real screen comes here.
3. The files you get
- Trial balance (Excel)
- Unpaid customer invoices (Excel)
- Unpaid supplier invoices (Excel)
- Customers (Excel)
- Suppliers (Excel)
- Items (Excel)
- Chart of accounts (if you want your own account names and types) (Excel)
Keep DIANO's file names and column names: they help you, though DIANO reads the columns.
4. Where it lands
On a laptop: Wherever you saved them. Documents is easiest.
On a phone: Templates are easier on a computer.
5. Check before you upload
- The column names are unchanged
- The trial balance's debits and credits add up to the same
- Every file ends in .csv or .xlsx
6. Common problems
Excel changed my dates or numbers
Type dates as 2026-09-30 and amounts without the R, e.g. 1250.50.
I keep my books in more than one spreadsheet
Copy each list into its own template. The trial balance template needs only each account's balance on one day.
7. The best time to move
The best time to move is just after you finish a month: your VAT return (and payroll, if you pay staff) for last month is done, and your start date is the 1st of this month.
On the day:
- Make the backup or the reports on the day you move, not earlier.
- From your start date, capture new invoices and payments in DIANO only. Stop capturing in the old program.
- Keep the old program for a few months so you can look things up. Do not delete it.