Read the steps · Use the app

Convert old Excel financials to the new format

Select the financial-statement sheets, review the recognised figures and generate Excel/PDF through Convert Old Format to New.

Convert Old Format to NewCreate FinancialsBrowse written guides

Product instructions · Team assureOffice · For the current assureFinancials workflow

Prepare the workbook

Keep the original Excel intact. Include the Balance Sheet, P&L, notes and available workings; retain source formulas and linked values wherever possible. CY and PY can be in a single workbook or supplied as separate files. Password-protected or unusual layouts may need preparation or support.

Convert and review

  1. Open Convert Old Format to New and select Old Financials Excel.
  2. Upload the current-year/both-years workbook. Add the separate PY file only when comparatives are in another workbook.
  3. Select Read files. Review the detected financial-statement sheets and select the relevant statements, notes and workings.
  4. Confirm entity type, name, address and financial-year dates. Check recognised capital, PPE, stock and accounting data.
  5. Review auditor/signing details and output controls. Select Generate Financials, then inspect PDF/Excel.
  6. Use Save to assureFinancials or Save & Edit in assureFinancials to retain the conversion in your account. If saving into an existing client, review the selected year and replacement preview.
assureFinancials Convert and review screen using demonstration data
App screen using demonstration data. Open the image to read it at full size.

What requires your review

Review points
  • Sheet selection matters when a workbook contains multiple years, drafts or working sheets. Select the relevant version.
  • Check note references, units, share counts, disclosures and totals against the original workbook. Recognition can be incomplete for unusual formats.
  • Do not overwrite an existing year until you have reviewed the import preview and made a backup. Financials imports into a saved client use Import Centre → Financial Statements.

Continue with a related guide