MillMargin / Guides / Moving your books

Moving your books from LedgerLite, Tally or a register

Changing software sounds like months of re-entering. It isn’t: you move balances, not history. Pick a start date, carry over what each account stands at, and check it three ways before the first new entry.

By the MillMargin team · Updated 19 Nov 2026 · 3 min read

The short answer

Close the old books on a date — ideally a month end or your year end. Take every account's balance on that date, enter them as one opening entry in the new books, and check that it balances, that every party agrees and that the bank matches. From the next day, all new entries go into the new books only.

Opening entry: every Dr balance on the Dr side, every Cr balance on the Cr side — both sides equalIf they don't, the old trial balance didn't agree either. Find out why before you move.

Pick the start date

  • Start of your financial year — cleanest. Only balance sheet accounts come over; income and expenses start at zero.
  • A month end mid-year — fine too. Bring the year-to-date totals of sales, purchases and expenses as well, so this year's P&L is complete.
  • Not mid-month. A month split across two systems makes the bank reconciliation and party statements harder for no gain.

What to bring from the old books

  1. A trial balance on the start date — from LedgerLite or Tally as Excel or PDF, or totals copied from the register.
  2. A list of parties with their balances, and, if you can, the open invoices and bills behind each balance.
  3. The bank statement for the start date, with the cheques not yet presented and deposits not yet credited.
  4. Stock on hand by lot, in kilos and value.
  5. Any dollar balances, in dollars and in your own currency.

The opening entry, worked

Al Noor Rice Traders moves on 30 September. Its old trial balance gives:

JV-0001 · balances brought forward, 30 SepDrCr
Cash412,500
Bank current account1,284,060
Haji Rafiq & Sons2,750,000
1121 sella, lot 186,930,000
Bhatti Paddy Co.3,410,000
Usman Brokerage118,500
Partners' capital7,848,060
Total11,376,56011,376,560

Invented business and figures. Capital is the balancing figure only because this business starts at its year start; otherwise bring capital as the old books show it.

Three checks before you start

  1. The opening entry balances and each account equals the old trial balance, line by line.
  2. Every party agrees. Each customer's and supplier's opening balance equals their statement in the old books.
  3. The bank matches. The bank balance in the new books, adjusted for cheques not presented and deposits in transit, equals the bank statement on the start date.
Keep the old software or register as it was on the start date, read-only. Nobody should post into it again — two live sets of books is how balances drift.

Questions traders ask

Do I have to re-enter last year's entries?

No. The opening balances carry everything forward. Keep the old books for looking things up; bring past entries across only if you need old ledgers in the new system.

What about invoices that are still unpaid?

The party's balance carries them. If you bring the open invoices one by one, later receipts can be matched against each of them.

Our register doesn't balance.

Find out why before you move: count the cash, get the bank statement, agree the big parties. Put any small difference you cannot trace in a suspense account and clear it in the first month.

How long does a move take?

For a trader with a few hundred parties, a day or two to collect the balances and an afternoon to check them. The work is in the checking, not the typing.

Upload your trial balance and you’re in

Export the trial balance from LedgerLite, Tally or Excel and upload it when you create your books in MillMargin Ledger. Every account is sorted for you and you check the opening balances before anything is saved. Keeping a paper register? Our team moves you in instead — free for founding members.

Start your Ledger books free