Bring your books across
Moving from another ledger takes one file: your trial balance at a cut-off date. This guide covers where to find it and what happens next.
Checked against the product on 2026-11-04
Step 1: Pick a cut-off date
Usually the last day of your most recently closed month. Balances up to that date come across; everything from the next day is recorded in Nexus Ledger.
Step 2: Export a trial balance
From your current ledger, run a trial balance as of the cut-off date and export it as CSV or Excel. Each account needs a code, because Nexus matches rows to your chart by code.
QuickBooks Online
Open Reports, run Trial Balance, set the report date to your cut-off date and export it. If the export has no account numbers, turn on account numbers in QuickBooks, or add a code column in a spreadsheet first.
Xero
Open Reporting, then All reports, and run Trial Balance for your cut-off date. Export it as CSV or Excel and keep the Account Code column. If your export has none, add one.
A spreadsheet
Use four columns: account_code, account_name, debit and credit. Put each balance in the debit column or the credit column, not both.
Step 3: Check the file
Amounts are in your base currency, and total debits must equal total credits. Total rows and zero-balance rows are skipped.
Step 4: Upload it as opening balances
In setup this is the Opening balances step. The same page is available later.
- Press Download CSV template for a file built from your own chart of accounts, or use your own export.
- Drop the file on the page. The preview lists each row, the debit and credit totals, and whether they balance.
- Accounts that are not in your chart are listed. Press Create accounts and import to add them as part of the import.
- Import. Nexus creates one balanced opening-balance entry as a draft. Review it and post it like any other entry.
No earlier books? Choose Starting fresh and this step is done.
Sample data
Start from an opening trial balance. Step 5: Opening stock is counted once
If you entered quantities under Products and costs, your opening stock is already booked on your items' inventory accounts. Leave that inventory out of the file and put the same amount on the debit side of Opening Balance Equity. Goods in transit on their own account stay in the file.
Step 6: Connect Amazon and approve recent settlements
Once balances are in, connect Amazon. Settlements arrive as drafts; review each one and post it. Older history can be brought in as a settlement CSV.
What comes across, and what does not
Comes across
- Account balances at your cut-off date, as one opening-balance entry
- Accounts from your file that are missing from your chart
- SKUs, unit costs and opening quantities from the item template
- Amazon settlements, as drafts you review
Not part of this import
- Transaction-level history from before the cut-off date
- Supplier and customer lists, and open invoice lists
- Attachments and other supporting files
- Bank reconciliations from your old ledger
Keep your old ledger export as your record of earlier years.
About the template
There is no fixed file to download here, because opening balances are matched to the account codes in your own chart. Inside setup, Download CSV template gives you one built from your chart. Its columns are account_code, account_name, debit and credit.