Skip to content
On this page

Get started

Migrating to Ringbook

Move your books from Xero, QuickBooks, MYOB, Sage, Wave, FreshBooks, a local package or a spreadsheet, and check that the numbers agree before you rely on them.

You do not re-key years of history. You bring across your chart of accounts and one opening position, and Ringbook takes over from your cutover date.

Migration at a glance

The plan has five stages. The examples on this page follow Studio North, a design studio in Hong Kong that books in HKD and cuts over on 1 January 2026.

The old system keeps the history; Ringbook starts from one opening position.
StageWhat you doWhere
ChoosePick the cutover date. Opening balances are taken as of the day before.Your decision
ExportGet the chart of accounts and the closing trial balance from the old system.Old system
ImportBring in the accounts, then review what will be created.Book → Import journals
OpenPost one opening journal that reproduces the old trial balance.Book
VerifyRun the Trial Balance and Balance Sheet and compare them with the old system.Reports

Before you start

Create your Ringbook organization first, with its name, base currency and fiscal year-end. The base currency cannot be changed once it is set, so choose the currency you report in. The Getting Started guide covers this in a few minutes.

You need two exports from your old system:

  • A chart of accounts, or any export that lists account names and codes.
  • A trial balance (a list of every account with its closing debit or credit balance) as of the day before your cutover date.

Both are standard reports in every accounting package. If you only have a spreadsheet, that works too.

Step 1 — Pick your cutover date

The cutover date is the day Ringbook becomes your system of record. Choose the first day of a fiscal period: a month, a quarter or, best of all, your fiscal year. Everything before it stays in the old system as history. Everything on or after it lives in Ringbook.

Your opening balances are taken as of the day before the cutover. If Studio North cuts over on 2026-01-01, the opening trial balance is the one dated 2025-12-31.

Step 2 — Export from your old system

Export two reports as of the day before cutover:

  • Chart of accounts: account names and codes.
  • Trial balance: every account with its closing debit or credit balance.

The importer reads .xlsx, .xls and .csv. You do not have to reformat columns by hand, because you map them in the wizard. One file that holds both the account list and the closing balances is ideal, since you can do everything in one pass.

Step 3 — Run the import (Book → Import journals)

Open Book and choose Import journals…. The wizard reads your file, proposes the accounts it needs, and creates them only when you confirm.

Accepted files

FileNotes
.xlsx, .xlsMulti-sheet workbooks are fine. You pick the sheet in the wizard.
.csvOne header row, then data rows.
Image (.jpg, .jpeg, .png, .gif, .webp)A screenshot of a voucher or balance sheet is read by AI and costs 50 credits. Check every line afterwards.

The wizard, step by step

Wizard stepWhat it asks of you
Upload FileDrop in one file.
Select SheetPick the sheet, if the workbook has several.
Map ColumnsMatch your columns to Ringbook fields. Date and Account Name are required. Use Debit and Credit, or a single Amount column. Ringbook guesses from your headers. You can move the header row up or down.
Review AccountsDecide which accounts are matched, suggested or new. See the next section.
Review SegmentsConfirm any segments (cost centers, departments, projects) that will be created. Shown when your file has them.
Review SubledgerConfirm customers or vendors attached to lines. Shown when your file has them.
Review VouchersCheck every journal (Ringbook calls each one a voucher in this step) before it is posted.
Import SummarySee totals and choose the journal number order, top to bottom or bottom to top.
Import CompleteConfirm what was created.

If your file has no dates, the wizard asks for an Import date and applies it to all rows. Enter the date shown on the source statement. Ringbook does not guess one for you. Blank date cells inherit the date above them.

How accounts are matched

Before it creates anything, the importer tries to match each account in your file to one you already have.

Each account in your file is matched to your chart, offered as a suggestion, or listed for creation. Nothing is created until you confirm.
MatchWhat happens
Same account code, or same name (ignoring upper and lower case and extra spaces)Bound automatically. The line posts to your existing account.
Code found inside the name, similar name, same category, or an AI matchShown as a suggestion. Nothing changes until you accept it, one by one or with Accept suggested matches.
No matchListed under Accounts to create, with a type and category you can review.

Names come from the file and cannot be edited in the wizard: if one is wrong, correct the file and upload it again. Each new account needs its own unused code, and reserved codes (including the one for system Retained Earnings) are rejected with a message. Two new accounts with the same name are created separately, and the wizard warns you because their journal lines will not combine.

Import only a chart of accounts

If you have no journals to bring in, skip the wizard. On the Chart of Accounts page, on the Accounts tab, choose Import and upload the account list. Existing accounts are never modified.

ModeWhat it does
Append new accountsCreates accounts that are not in your chart yet. Deletes nothing.
Replace (delete all unused)Deletes every unused account first, then imports the file. Accounts that are in use, budgeted or reserved are kept. You must tick a box to confirm the deletion.

Choose Preview import first. The preview marks each row as Will create, already existing, merged with an earlier row of the same name, or invalid. Replace mode needs every row to be valid, so fix skipped rows or use Append.

Step 4 — Clean up unused accounts

If your organization already had default accounts, some may sit unused beside the chart you imported.

  1. Open Chart of Accounts and the Accounts tab.
  2. Find the button Clean up N unused, where N is the count of accounts with no journal entries.
  3. Select it and confirm.

The cleanup only removes accounts with no journal entries. Accounts with activity and reserved system accounts such as Retained Earnings are kept. An account you imported but have not used yet also counts as unused, so if you post the opening journal by hand, run the cleanup after it.

Step 5 — Bring across your opening trial balance

Mirror the old trial balance as one opening journal dated the day before cutover. Debit every account that has a debit balance and credit every account that has a credit balance. A trial balance already balances, so the journal will too.

The old trial balance is copied line for line into one balanced journal; retained earnings land in an opening Equity account.

You can enter this journal by hand with Single journal on the Input tab of Book, or import it as a file: one voucher number, the date, and one line per account with its debit or credit. Ringbook shows a running Difference while you build the journal and will not post it until debits equal credits.

After it posts, Ringbook starts from the same position your old system ended with.

Retained earnings, the right way

Retained earnings is the profit a business has kept over the years. In Ringbook the system account Retained Earnings is protected and maintained by the year-end close, so you cannot post to it directly.

When the importer recognizes a retained-earnings line, it books it to an ordinary Equity account named Retained earnings - opening. It recognizes the system code, names such as retained earnings, retained profits, accumulated earnings or losses, and their Chinese and Japanese equivalents. If a suitable opening account already exists, including one named Opening retained earnings, it is reused. Otherwise a new one is proposed in Review Accounts, and it is created only when you confirm.

An accumulated profit is normally a credit and an accumulated loss a debit. Check the sign and date against your source statement. The opening account appears on the Balance Sheet and does not change the Profit & Loss.

Example. Studio North's trial balance shows a retained-earnings credit of HKD 63,000.00 at 2025-12-31. It becomes a credit of HKD 63,000.00 to Retained earnings - opening, next to the other lines of the opening journal. You do not pick Sales or any other Profit & Loss account.

Open items (invoices and bills)

Your opening trial balance already holds the totals for Accounts Receivable and Accounts Payable, so the Balance Sheet is right from day one.

To see individual unpaid invoices and bills in aging, enter each open item as its own line against the receivable or payable account, not as one lump sum. The importer can map Due Date and Subledger columns, so a line can carry a due date and a customer or vendor. Most teams do this only for items still open at cutover. Settled items stay in the old system.

Multi-currency opening balances

The journal importer works in your base currency. If a file carries another currency in the Currency column, the import stops and asks you to convert those amounts to the base currency first. Remove the mapping only when the amounts are already in the base currency.

For a foreign-currency balance, such as a USD bank account on HKD books, use the rate that gives the base-currency balance shown on your old trial balance. That keeps the opening position equal to what you are migrating from. See Multi-Currency and FX for ongoing gains, losses and revaluation.

When the import does not balance

The importer checks balance at three points, and you cannot post past the first.

WhereWhat you seeWhat to do
Review VouchersEach journal shows Total: Dr … / Cr …. Unbalanced journals block the import with "Balance N vouchers before importing".Edit the amounts, move an amount to the other side, or use the balance button on a line. Fix invalid amounts and lines that have both a debit and a credit.
Review VouchersA Dup badge on a journal that already exists.Duplicates are skipped. Use Force import only if you really mean to repeat a voucher.
Import historyA Debit and credit control panel with Total debits, Total credits and Difference, plus the statement impact on Assets, Liabilities, Equity, Revenue and Expenses.A non-zero difference or an Unclassified amount is flagged here. Compare it with your source records.

Verify the migration

When the import and the opening journal are in, compare Ringbook with the old system as of the cutover date.

The check is simple: every line agrees, both totals agree, and the difference is zero.
CheckWherePass when
Trial BalanceTrial Balance report, as of the opening dateIt balances, and each account matches the old trial balance line for line.
Balance SheetBalance Sheet report, same dateTotal assets equal total liabilities plus equity, and the figures match the old balance sheet.
CashOpen the bank accountsThe opening figure equals the last bank statement balance.
Receivables and payablesOpen Accounts Receivable and Accounts PayableThe totals equal the old aged reports.
Retained earningsOpen Retained earnings - openingOne credit (or debit) for the prior-year result, with the right date.

Ringbook's entry rules make debits equal credits, so a difference in a report points at the data you entered. It is almost always one transposed or mistyped line in the opening journal.

Migration checklist

  • Organization created with the correct base currency and fiscal year-end.
  • Import journals access right available.
  • Cutover date chosen; opening balances taken as of the day before.
  • Chart of accounts and closing trial balance exported.
  • File imported through Book → Import journals; accounts and segments reviewed.
  • Clean up N unused run on the Chart of Accounts.
  • Opening journal posted, with retained earnings in Retained earnings - opening.
  • Open receivables and payables entered individually, if you need aging.
  • Trial Balance and Balance Sheet match the old system.

FAQ

Do I have to import all my historical transactions?

No. You bring the chart of accounts and an opening balance as of the cutover date. History stays in your old system, which you can keep read-only. See retained earnings for how prior-year profit is carried.

Where exactly is the importer?

In Book, under Import journals…. If the button is missing, you do not have the Import journals right yet. An admin can grant it under Settings → Access Rights.

What file types can I import?

Excel (.xlsx, .xls) and .csv, plus images (.jpg, .jpeg, .png, .gif, .webp) that are read by AI. Multi-sheet workbooks are supported.

What are "segments"?

Segments are tags such as cost centers, departments, projects or locations. They let you slice reports below the account level. If your file carries them, the importer offers to create them in Review Segments.

Is the "Clean up unused" delete safe?

Yes, with one caution. It removes only accounts with no journal entries, and keeps accounts with activity and reserved system accounts. A newly imported account that no journal uses yet counts as unused, so run the cleanup after the opening journal is posted.

Can I just run Ringbook alongside Xero or QuickBooks instead of replacing it?

Yes. Many teams keep the old system as the system of record and use Ringbook to capture and draft entries, exporting them at month-end. See Using Ringbook Alongside Xero or QuickBooks.

Something doesn't tie out — who can help?

Email samyip@ringbook.io with your organization ID (from your profile) and your old closing trial balance, and we will help you reconcile the opening position.

Import review, history and recovery

Before you confirm, check dates and debit and credit signs, map existing accounts before creating new ones, and review account levels, segments and subledgers. Standalone account, segment and subledger imports are available from their own management areas.

Import history keeps the summary and completion details of every run. Delete this import removes the journals the run created, and is offered only when the run passes the safety checks shown in its history. Later edits or linked activity can block it, so review the reasons shown. Accounts, segments and subledgers created by the import are kept. Starting another import does not undo an earlier one.

For outbound files, Book has dedicated Xero, QuickBooks Online and MYOB formats. They export base-currency journal lines with no-tax defaults. See accounting exports.