How to enter opening balances in new accounting software in Pakistan

How to Enter Opening Balances in New Accounting Software (Pakistan Guide)

In short: Opening balances are the cash, bank, customer, supplier, stock, asset, tax, loan and capital figures your business carries into new software on its first day. Choose a clean start date, take a trial balance on that date, enter each group in detail (customers and suppliers bill by bill, stock from a fresh count), and check that the new trial balance matches the old one before you go live.

What are opening balances?

Opening balances are the amounts your business already has on the day you start using new software: cash in hand, money in each bank account, what customers owe you, what you owe suppliers, stock in the godown, fixed assets, loans, tax payable and your capital. Every report you run later is built on top of these numbers, so a wrong opening balance keeps showing up in ledgers, stock reports and the balance sheet for months.

This guide is for businesses moving from Excel, a manual register, Tally, Peachtree or an older desktop program. The steps are the same whichever accounting software you choose.

Step 1: Choose a clean start date

Pick the first day of a month, so that all earlier transactions stay in the old system and everything from that date is entered in the new one. The cleanest point is the start of a tax year. Under section 74 of the Income Tax Ordinance 2001, the normal tax year in Pakistan is the twelve months ending on 30 June, so a 1 July start keeps the whole year’s reports in one system. A business that uses a special tax year needs the Commissioner’s permission for it, and should start on the first day of that year instead.

If you cannot wait for 1 July, the first day of any month works. Just make sure the old books are closed up to the last day of the previous month before you take the figures.

Step 2: Set up the chart of accounts first

Create your account heads before entering any balance: each bank account separately, cash in hand, debtors and creditors control accounts, stock, fixed asset groups, tax accounts, loans and capital. If you need a starting structure, use our chart of accounts guide for small businesses.

Step 3: Take a trial balance on the cut-off date

Ask your accountant, or export from the old system, a trial balance as on the last day before your start date. Total debits must equal total credits. This one sheet is your master list: every opening entry you make in the new software comes from it, and you will compare the new software’s trial balance against it at the end.

Step 4: Enter the balances, one group at a time

  1. Bank accounts. Enter each bank’s balance as per your books, then list any cheques issued or deposited that the bank has not yet cleared. Our bank reconciliation guide shows how to prepare that list.
  2. Cash in hand. Count the cash on the cut-off date and enter the counted figure, not the figure the old register says.
  3. Customers. Enter each customer’s balance bill by bill, with the invoice number, date and due date, not as one lump sum. Only then will the new software give you a correct receivable ageing report from day one.
  4. Suppliers. Do the same for each supplier: unpaid bills with their dates, plus any advances you have paid.
  5. Stock. Enter quantity and cost for every item from a physical count on the cut-off date, plus batch and expiry where you track them. Follow our physical stock count procedure so the count is reliable.
  6. Fixed assets. Enter each asset group at cost and its accumulated depreciation separately, so depreciation continues correctly.
  7. Tax balances. Enter sales tax payable or refundable, withholding tax deducted but not yet deposited, and advance tax paid, agreed with your filed returns and payment challans.
  8. Loans and capital. Enter bank loans, director or partner loans and capital. Retained profit is the last figure, and it should make the trial balance agree.

Never force a difference: if debits and credits do not match, do not post the difference to a “suspense” or “opening difference” account and move on. Find it first. A forced difference usually hides a missing supplier bill, a double-entered customer or stock valued at the wrong rate.

Step 5: Check everything before you go live

  1. Trial balance match. The new software’s opening trial balance equals the old trial balance line by line.
  2. Customer and supplier totals. The total of all customer balances equals the debtors control account, and the same for suppliers.
  3. Stock value. The stock report value equals the stock figure in the trial balance.
  4. Bank. Each bank ledger plus or minus uncleared cheques equals the bank statement on the cut-off date.
  5. Sign-off. The owner or accountant signs the opening trial balance, and the old system is locked for that period.

Common mistakes to avoid

  • Starting in the middle of a month, so some sales are in both systems and some in neither.
  • Entering customer balances as one total, which makes ageing and recovery follow-up impossible.
  • Taking stock quantities from the old software instead of a fresh count.
  • Forgetting advances: money received from customers before delivery, or paid to suppliers before receiving goods.
  • Letting staff keep using the old system “just for a few days”, which creates two versions of the truth.

Moving to new accounting software?

Message us on WhatsApp and our team will help you plan the start date and load your opening balances correctly.

Frequently asked questions

What are opening balances in accounting software?

They are the amounts your business already holds on the day you start the new software: cash, bank, customer and supplier balances, stock, fixed assets, tax balances, loans and capital. All later reports are built on them.

What is the best date to start new accounting software in Pakistan?

The first day of a month, and ideally 1 July, because the normal tax year under section 74 of the Income Tax Ordinance 2001 ends on 30 June. Starting then keeps a full tax year in one system.

Should customer balances be entered as one total?

No. Enter them bill by bill with invoice number, date and due date. Otherwise the software cannot show which bills are overdue or produce a correct receivable ageing report.

How do I enter opening stock?

Do a physical count on the cut-off date and enter quantity and cost for each item, with batch and expiry where you track them. Do not copy quantities from the old system without counting.

What if my opening trial balance does not match?

Find the difference before going live instead of posting it to a suspense account. Common causes are a missing supplier bill, a customer entered twice, an advance left out or stock valued at the wrong rate.

Can I keep using Excel alongside the new software for a while?

It is better not to. Lock the old records for the period before your start date and enter every new transaction only in the new software, so there is one version of the numbers.

This guide is general information checked on 15 November 2026 and is not tax or accounting advice. Ask your accountant or tax adviser to review your opening trial balance, especially tax balances and the choice of start date.