Xero, opening balances
- ✓ Trial Balance at your start date (Accounting, Reports, Trial Balance), exported to Excel.
- ✓ Aged Receivables Detail at the same date.
- ✓ Aged Payables Detail at the same date.
- ✓ Chart of accounts (Accounting, Chart of accounts, Export) and your contacts (Contacts, Export).
Send each report exactly as Xero exports it. Please don't tidy them up first.
Xero, detail
- ✓ Journal Report for the period (Accounting, Reports, Journal Report), exported to Excel.
- ✓ Trial Balance at the day before the period starts.
- ✓ Aged Receivables Detail and Aged Payables Detail at the last day of the period.
- ✓ Chart of accounts (Accounting, Chart of accounts, Export) and your contacts (Contacts, Export).
Don't filter the Journal Report by account: a transaction split across two files can't be rebuilt.
Pastel, opening balances
- ✓ A backup of the company (File, Backup), as the zip file Pastel makes. Don't unzip it.
The backup already holds your chart, customers, suppliers, open items and ledger, and we check every figure against Pastel's own balances. Pick a start date at the end of one of Pastel's periods.
Pastel, detail
- ✓ A backup of the company (File, Backup), as the zip file Pastel makes. Don't unzip it.
The backup already holds your chart, customers, suppliers, open items and ledger, and we check every figure against Pastel's own balances. Pick a start date at the end of one of Pastel's periods.
Sage Business Cloud, opening balances
- ✓ Trial balance at your start date.
- ✓ Aged debtors at the same date, one row per unpaid invoice rather than one total per customer.
- ✓ Aged creditors at the same date, one row per unpaid bill.
- ✓ Your chart of accounts and your customer and supplier lists, with their account codes.
Excel or CSV, straight out of the package. You don't need to rearrange anything: we map the columns.
Sage Business Cloud, detail
- ✓ General ledger for every account across the period, each line with its transaction number, date, account code, debit and credit.
- ✓ Trial balance at the day before the period starts.
- ✓ Aged debtors and aged creditors at the last day of the period, one row per invoice or bill.
- ✓ Your chart of accounts and your customer and supplier lists, with their account codes.
Excel or CSV, straight out of the package. You don't need to rearrange anything: we map the columns.
QuickBooks Online, opening balances
- ✓ Trial balance at your start date.
- ✓ Aged debtors at the same date, one row per unpaid invoice rather than one total per customer.
- ✓ Aged creditors at the same date, one row per unpaid bill.
- ✓ Your chart of accounts and your customer and supplier lists, with their account codes.
Excel or CSV, straight out of the package. You don't need to rearrange anything: we map the columns.
QuickBooks Online, detail
- ✓ General ledger for every account across the period, each line with its transaction number, date, account code, debit and credit.
- ✓ Trial balance at the day before the period starts.
- ✓ Aged debtors and aged creditors at the last day of the period, one row per invoice or bill.
- ✓ Your chart of accounts and your customer and supplier lists, with their account codes.
Excel or CSV, straight out of the package. You don't need to rearrange anything: we map the columns.
Something else, opening balances
- ✓ Trial balance at your start date.
- ✓ Aged debtors at the same date, one row per unpaid invoice rather than one total per customer.
- ✓ Aged creditors at the same date, one row per unpaid bill.
- ✓ Your chart of accounts and your customer and supplier lists, with their account codes.
Excel or CSV, straight out of the package. You don't need to rearrange anything: we map the columns.
Something else, detail
- ✓ General ledger for every account across the period, each line with its transaction number, date, account code, debit and credit.
- ✓ Trial balance at the day before the period starts.
- ✓ Aged debtors and aged creditors at the last day of the period, one row per invoice or bill.
- ✓ Your chart of accounts and your customer and supplier lists, with their account codes.
Excel or CSV, straight out of the package. You don't need to rearrange anything: we map the columns.