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.
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
- A trial balance on the start date — from LedgerLite or Tally as Excel or PDF, or totals copied from the register.
- A list of parties with their balances, and, if you can, the open invoices and bills behind each balance.
- The bank statement for the start date, with the cheques not yet presented and deposits not yet credited.
- Stock on hand by lot, in kilos and value.
- 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 Sep | Dr | Cr |
|---|---|---|
| Cash | 412,500 | |
| Bank current account | 1,284,060 | |
| Haji Rafiq & Sons | 2,750,000 | |
| 1121 sella, lot 18 | 6,930,000 | |
| Bhatti Paddy Co. | 3,410,000 | |
| Usman Brokerage | 118,500 | |
| Partners' capital | 7,848,060 | |
| Total | 11,376,560 | 11,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
- The opening entry balances and each account equals the old trial balance, line by line.
- Every party agrees. Each customer's and supplier's opening balance equals their statement in the old books.
- 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.
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.
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