What Excel file should you upload for the opening balance?

Upload your accountant's annual closing ledger extract in Excel (.xlsx or .xls) – in the same format as for reconciliation. The system reads columns E–F (debit and credit balance) as the opening balance.

Upload the annual closing ledger extract your accountant sends you. The format is the same as for the accountant reconciliation.

Expected columns

• Column A – account code (e.g. 311, 9111)
• Column B – account name
• Column C – debit turnover
• Column D – credit turnover
• Column E – debit balance
• Column F – credit balance

For the opening balance the system uses the E–F (balance) columns; the turnover columns (C–D) are not used for this.

Skipped rows

• account codes that are not in your chart of accounts,
• rows with a zero balance,
• account 491, the opening balance sheet account (the system handles it itself).

After the upload the system tells you how many accounts were imported and how many were skipped.