Opening Balance Checklist When Shifting to GST Software
- Choose one cutover date and prepare all reports as of that date.
- Reconcile the old books before importing balances.
- Carry customer and supplier balances bill by bill.
- Move stock item-wise and location-wise.
- Reconcile book ITC with GST portal records instead of forcing the figures to match.
- Test the migrated data before starting live billing.
This guide is for accountants, SME owners and finance teams shifting from Excel, Tally or another accounting system to new GST accounting software. The objective is to ensure that every balance in the new system can be traced to the old books, supporting records or GST portal as of the same cutover date.
Shift Your Accounts to BUSY with Confidence
Import opening balances, masters and vouchers, then verify your accounts before starting work in the new software.
What is an opening balance entry?
An opening balance entry records the amount carried into the new accounting system on the migration date. It normally comes from the closing balance in the old system.
For example, if the old books are closed on 31 July 2026, the verified balances as of that date become the starting balances in the new software from 1 August 2026. The treatment of income and expense accounts depends on when the migration takes place:
- At the beginning of a financial year: Income and expense accounts normally start from zero. The previous year’s result is carried through capital, reserves or retained earnings.
- During the financial year: The business must either migrate current-year transactions or carry the required year-to-date balances so that full-year reports remain complete.
Changing accounting software does not change the GSTIN, previously filed returns or balances maintained on the GST portal.
Decide what will move to the new software
Before preparing the opening balance in GST software, decide whether you will migrate:
- Complete historical transactions
- Current financial-year transactions
- Masters and opening balances only
- A combination of transactions, masters and opening balances
The right approach depends on reporting requirements, audit needs, available data and the import features of the new software. Also decide who will prepare, review and approve the migration. Once the old data is frozen, backdated entries should be restricted or recorded through an approved cutover process.
Records and balances to prepare
Prepare all reports as of the same cutover date. Only applicable and properly supported balances should be migrated.
| Balance or record | Main source | What to verify |
|---|---|---|
| Trial balance | Old accounting system | Total debits equal total credits |
| Customer balances | Open invoices and receipts | Party total, invoice reference and due date |
| Supplier balances | Open bills and payments | Party total, invoice reference and due date |
| Customer and supplier advances | Advance schedules | Original reference and unadjusted amount |
| Inventory | Stock register and physical count | Item, quantity, value, unit and location |
| Cash | Cash book and physical verification | No unexplained negative or unusual balance |
| Bank accounts | Reconciled bank book | Pending cheques, deposits and bank entries |
| Fixed assets | Fixed-asset register | Cost, depreciation and carrying amount |
| Loans and deposits | Lender or party statements | Principal, interest and classification |
| Input GST accounts | Books and purchase records | Claimed, pending, reversed and ineligible ITC |
| Electronic Credit Ledger | GST portal | IGST, CGST, SGST or UTGST and Cess |
| Electronic Cash Ledger | GST portal | Major and minor head balances |
| GST liabilities | Books and portal records | Paid, unpaid and disputed amounts |
| RCM balances | Books, returns and portal statement | Liability paid and related ITC claimed |
| Pending documents | Internal cutover list | Unrecorded invoices, returns and goods in transit |
| Old-system backup | Existing software | Complete audit and recovery copy |
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Balance or record
Main source
What to verify
Step 1: Freeze and reconcile the old books
Before importing any data, ensure the following:
- Post all approved vouchers up to the cutover date.
- Reconcile bank accounts and party control accounts.
- Review suspense, difference, and temporary ledgers.
- Check debit and credit signs.
- Separate records GSTIN-wise where the business has multiple registrations.
- Take a final backup and restrict further changes.
The approved trial balance should become the master reference for the opening balance entry in the new system. If the old trial balance does not agree, resolve the difference before migration. Otherwise, the same error will move into the new software.
Step 2: Carry party balances bill by bill
Avoid entering only one total against each customer or supplier. For each open invoice or bill, carry the document number, date, due date, outstanding amount and related advance, credit note or debit note . Bill-wise migration preserves ageing and allows later receipts and payments to be adjusted against the correct document.
For example, a customer may owe ₹1,20,000 against three invoices. Entering one balance of ₹1,20,000 will make the ledger total correct, but the software will not know which invoice is overdue or which invoice a later receipt should settle.
Keep advances separate
Do not merge customer or supplier advances with normal invoice balances. Carry the original date, amount, party reference, adjusted amount and remaining balance. This prevents an old advance from being adjusted twice after migration.
Step 3: Move stock item-wise and location-wise
For each stock item, carry the following:
- Item name and code
- Unit of measurement
- Quantity
- Rate or cost
- Total value
- Godown or location
- Batch, serial number or expiry details, where applicable
- HSN and GST rate for future transactions
Rule 56 of the CGST Rules requires regular taxpayers, other than composition taxpayers , to maintain commodity-wise stock records containing opening balances and stock movements.
Continue the approved stock valuation method unless a properly authorised accounting-policy change is being made. Accounting Standard 2 recognises cost formulas such as FIFO and weighted average for applicable inventories.
If the item-wise stock total does not match the trial balance, review negative stock, goods in transit, unposted receipts, damaged stock, job-work stock and manual valuation adjustments. Do not overwrite the value only to make the accounts agree.
Start with Accurate Opening Balances
Keep party dues, stock, bank balances and GST records organised from the first day after migration.
Step 4: Reconcile GST balances separately
Do not transfer one combined GST figure. Review each tax head and GST ledger separately.
Input tax credit
Download the Electronic Credit Ledger as of the cutover date and compare the balances under IGST, CGST, SGST or UTGST, and Cess with the corresponding book balances. The book ITC may not exactly equal the credit available on the portal. Common reasons include:
- Eligible ITC booked but not yet claimed
- Supplier invoices not yet reflected in GSTR-2B
- ITC visible in GSTR-2B but not yet recorded in the books
- Blocked or ineligible credit
- Temporary ITC reversals
- Credit already used against GST liability
- RCM credit awaiting payment or accounting entry
Prepare a reconciliation schedule for these differences. Do not delete or alter a supported accounting entry only to make the portal and books show the same amount.
Review IMS and GSTR-2B before finalising the reconciliation. IMS is a facilitation tool, and action on every record is not mandatory. Records with no action are generally treated as deemed accepted when GSTR-2B is generated. Incorrect or disputed invoices should still be reviewed and acted upon where required.
Cash, liability and RCM balances
Match the Electronic Cash Ledger by GST major and minor heads. Check challans, PMT-09 transfers, TDS or TCS credits and deposits made under the wrong head. A cash deposit does not settle a GST liability until the Electronic Cash Ledger is debited against that liability.
Also compare the Electronic Liability Register with the GST liability accounts in the books. Identify whether each amount is paid, unpaid, disputed, or already adjusted.
For reverse-charge transactions, match the liability recorded in the books, the liability reported in GSTR-3B , the tax paid in cash, and the related ITC claimed. Do not add the RCM liability again if it is already included in the trial balance.
Step 5: Carry Bank, Cash, Assets and Loans Correctly
Bank and Cash
Carry the reconciled book balance for each bank account, not only the closing balance shown in the bank statement. Pending entries such as unpresented cheques, deposits awaiting credit, direct customer deposits and unrecorded bank charges should remain identifiable in the bank reconciliation after migration.
Match the cash balance with the physical cash available on the cutover date. Investigate negative cash, old imprest balances and unadjusted employee advances before entering the opening balance.
Fixed Assets and Loans
Carry each fixed asset with the details needed for future depreciation and reporting. These normally include the acquisition date, original cost, accumulated depreciation, net carrying amount, useful life, depreciation method and asset location or identification number.
Do not enter all fixed assets as one combined written-down value when the new software will calculate depreciation or track assets separately.
For loans and deposits, separate the principal from accrued interest. Also identify current and long-term instalments, security deposits and any other amounts that should not be included in the main loan balance.
Step 6: Control Pending Transactions
Prepare a cutover list for transactions that are incomplete on the migration date. Common examples include invoices received after cutover but dated earlier, goods received but not invoiced, goods in transit, pending returns, unrecorded credit or debit notes, post-dated cheques, job-work stock, e-invoices not yet posted and unsettled payment gateway collections.
Assign each transaction to either the old system or the new system. Record the decision in the cutover sheet so that the same document is not missed or entered twice.
Step 7: Test the Import Before Going Live
Where possible, begin with a sample import covering account masters, party balances, stock items and different voucher types. Verify that fields, dates, document numbers, debit and credit signs, GST categories, party mapping and item mapping appear correctly.
Compare the number of imported records with the source data. Correct any mapping or formatting issue before importing the complete dataset.
Common mistakes to avoid
| Mistake | Why it creates a problem |
|---|---|
| Using reports from different dates | The trial balance, stock and GST records will not reconcile |
| Importing both transactions and their opening balances | Receivables, payables, bank, GST or stock may be duplicated |
| Combining all input GST in one ledger | Tax-head reconciliation becomes difficult |
| Migrating stock as one total value | Item quantities, locations and valuation details are lost |
| Ignoring customer and supplier advances | Old advances may be adjusted twice |
| Writing off a difference immediately | The actual migration error remains unresolved |
| Allowing entries in both systems | Transactions may be duplicated or missed |
| Deleting old records too early | Historical invoices and ledgers may become unavailable |
Mistake
Why it creates a problem
Mistake
Why it creates a problem
Mistake
Why it creates a problem
Mistake
Why it creates a problem
Mistake
Why it creates a problem
Mistake
Why it creates a problem
Mistake
Why it creates a problem
Mistake
Why it creates a problem
Final GST Migration Checklist Before Go-Live
| Area | What to confirm |
|---|---|
| Accounts | The new trial balance matches the approved old trial balance, total debits equal total credits, and no unexplained suspense or opening-balance difference remains. |
| Parties and stock | Party totals match bill-wise schedules, while stock quantity and value match item-wise and location-wise records. |
| Bank and GST | Bank balances include pending reconciliation entries, and GST ledgers have been checked separately for each tax head. |
| Transactions and import | Sample sales and purchase invoices post to the correct ledgers, and imported master and voucher counts match the source data. |
| Backup and access | A final backup has been taken, and the old system remains available in read-only form for reference. |
Area
What to confirm
Area
What to confirm
Area
What to confirm
Area
What to confirm
Area
What to confirm
An import marked as successful only confirms that the file was processed. It does not prove that every balance, tax head, stock record or document was migrated correctly.
Move opening balances to BUSY
BUSY accounting software supports the entry or import of account and item opening balances, masters and vouchers from Excel. It also provides a Tally-to-BUSY migration utility.
Trusted by more than 6,00,000 businesses, BUSY combines accounting, GST, billing and inventory management in one system.
A typical BUSY migration workflow includes backing up the old data, importing masters and balances, checking field mapping, comparing record counts, and reconciling party, stock, bank, and GST balances before approval.
Conclusion
A reliable opening balance in GST software begins with one cutover date, verified supporting records, and a controlled import process.
Reconcile the old books first, carry party balances bill by bill, move stock item-wise, and review GST records separately . Most importantly, document valid differences instead of forcing the books and GST portal to match.
A properly managed migration gives the business a clean starting point for accounting, inventory reporting and GST compliance.
