What Excel file should you upload for reconciliation?

Upload your accountant's monthly ledger extract in Excel (.xlsx or .xls): column A account code, B name, C–D debit and credit turnover, E–F debit and credit balance. Header rows are skipped automatically.

Upload the monthly ledger extract your accountant sends you. If your accountant needs a sample, download one with Download Excel template (for accountant) on the Accountant Reconciliation page.

Expected columns

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

The reconciliation compares the monthly turnover (columns C–D) with your own figures.

Good to know

• The first rows can contain a title, company name, period or headers – the system starts reading at the first row with an account code in column A.
• If a worksheet name contains the word "Főkönyvi", that sheet is used; otherwise all worksheets are checked.
• If the file has several worksheets (e.g. one per month), a dialog lets you assign them to months when uploading.
• If no data is found, check that column A contains account codes.