Switching from Excel to Accounting Software: A Philippine SME Migration Guide

Excel is a remarkable tool. Millions of Philippine businesses have managed their books in spreadsheets for years — income and expense lists, simple P&L summaries, maybe a bank reconciliation worksheet. It works until it doesn't. The point at which Excel stops being enough is predictable, and if you're reading this guide, you're probably there.

This guide walks through the complete migration from Excel bookkeeping to proper accounting software — cleaning your data, setting up opening balances, importing what can be imported, and verifying that your new system is telling the same story your spreadsheets were (or a corrected version of it).

Signs It's Time to Switch

Not every Excel-based business needs to migrate. But these patterns reliably indicate the spreadsheet system is breaking down:

You've missed a BIR deadline because pulling the numbers together took longer than expected. If your books aren't organized, filing quarterly returns becomes a two-day project instead of a two-hour one.

Bank reconciliation takes more than 90 minutes because you're manually matching hundreds of transactions. Accounting software automates bank feeds and matching.

You have multiple versions of the same spreadsheet. "Books Q2 2024 FINAL v3.xlsx" is a red flag. There's no single source of truth.

A staff member left and took the institutional knowledge of how the spreadsheets work. No one else can explain why there's a column labeled "adjustment 2" or what "misc income B" refers to.

Your accountant or CPA asks for your trial balance and you don't know how to generate one from your spreadsheets.

You're preparing for an audit and your Excel records don't have a clear audit trail (who changed what, when).

You want bank financing and the bank requires audited financial statements. An auditor needs proper books, not spreadsheets.

Before You Start: Clean Up Your Excel

The quality of your migration is limited by the quality of your starting data. Before importing anything, clean your Excel:

Standardize Date Formats

Pick one date format and apply it consistently: DD/MM/YYYY or MM/DD/YYYY — just one, throughout. Mixed date formats cause sorting errors and import failures.

In Excel: Select the date column → Format Cells → Number → Date → pick one consistent format.

Remove Formula Errors

Press Ctrl+End in each sheet to identify the actual extent of your data. Clear cells that contain #REF!, #VALUE!, or #DIV/0! errors. Accounting software cannot import error cells.

Standardize Account Names

If you have "Shopee Fees" in some rows and "Platform Fees-Shopee" in others, decide on one name and find-replace the inconsistencies. Inconsistent category names in your import will create duplicate accounts in the new system.

Eliminate Blank Rows

Blank rows in the middle of data sheets confuse import tools. Filter for blank rows and delete them.

Verify Running Totals

Manually verify that your income totals and expense totals in the spreadsheet match your filed tax returns. If they don't, you have a discrepancy that needs to be resolved before migration — not papered over by starting fresh.

Step 1: Export Your Chart of Accounts

Your first task is to identify every income and expense category you've been using in Excel and map them to proper account codes in the standard Philippine COA.

Create a mapping table:

This mapping table is your guide when setting up the chart of accounts in your new software. Take time to get it right — cleaning it up after import is tedious.

Step 2: Establish Your Opening Balances

Opening balances are the starting point of your new system — the financial position of your business at the moment you switch. This is the most critical and most error-prone step.

What you need:

Cash and Bank Balances

From your bank statements, get the closing balance of every bank account and e-wallet on the last day before your migration date. Example: migrating as of January 1, 2025 — get December 31, 2024 balances.

Accounts Receivable (AR)

Which customers owe you money as of the migration date? You need:

• Customer name
• Invoice date and number
• Amount outstanding
• Due date

Pull this from your Excel invoice tracker or manually list outstanding invoices.

Accounts Payable (AP)

Which supplier bills are unpaid as of the migration date? Same format:

• Supplier name
• Bill date and reference number
• Amount owed
• Due date

Inventory (if you carry stock)

The value of inventory on hand as of the migration date, at cost. If you don't have a perpetual inventory system, do a physical count and value it using your average purchase cost.

Fixed Assets

List each asset (computer, equipment, vehicle, furniture) with:

• Purchase date and original cost
• Accumulated depreciation to the migration date
• Net book value (cost minus accumulated depreciation)

Loans Payable

Outstanding loan balances as of migration date, per lender.

Opening Equity

This is typically computed as: Total Assets − Total Liabilities = Owner's Equity (for sole proprietors) or Stockholders' Equity (for corporations). Most accounting software calculates this automatically when you enter the other opening balances.

Step 3: Import into Accounting Software

What can typically be imported via CSV:

• Chart of accounts
• Customer list (name, address, TIN, payment terms)
• Supplier/vendor list
• Opening balances (as a single journal entry)
• Historical transactions (if your software supports transaction import)

What is usually manual:

• Bank account setup and connection to bank feeds
• Tax configuration (VAT rate, percentage tax rate)
• Recurring transactions setup

For Akauntants:

1. Go to Settings → Chart of Accounts → Import CSV
2. Upload your account list using the provided template
3. Go to Settings → Opening Balances
4. Enter each asset, liability, and equity opening balance
5. The system will show you a real-time summary; ensure debits = credits before saving

Step 4: Verify — The Trial Balance Test

After entering opening balances, generate a Trial Balance report in your new accounting software.

Compare it line by line to:

• Your last Excel balance sheet (if you maintained one)
• Your most recently filed 1701Q (income tax return) for income figures
• Your last bank reconciliation for cash balances

Variances to investigate:

• Cash difference → check your opening bank balance entry
• AR difference → check if all outstanding invoices were entered
• AP difference → check if all outstanding supplier bills were entered
• Net equity difference → usually a symptom of one of the above

Don't proceed to recording new transactions until the trial balance matches your known starting position.

Step 5: The Cut-Off Date and Parallel Period

Choose a cut-off date — the first day your new system is the book of record. All transactions from this date forward go in the new system. All transactions before this date are historical (read-only in Excel).

Best cut-off dates:

• First day of the financial year (January 1 for calendar-year businesses) — cleanest
• First day of a quarter — second choice
• Mid-year — possible but creates more complexity for annual comparisons

Run parallel for one month: For the first month after switching, continue maintaining your Excel alongside the new software. At month-end, compare the two. This parallel period:

• Catches data entry errors in the new system
• Builds confidence that the new system is working correctly
• Gives you a fallback if something goes wrong

After one clean parallel month where the two systems agree, you can safely stop maintaining Excel.

Common Migration Mistakes

Importing historical transactions and accidentally creating duplicates. If you import 2024's transactions into the new system but also enter opening balances as of January 1, 2024, you'll have both the individual historical transactions AND their net effect in the opening balance — double-counted. Choose: either import all historical transactions, or enter a single opening balance. For most SMEs, opening balance is simpler.

Forgetting outstanding checks from the prior period. If you wrote a check in December 2024 that wasn't cashed by December 31, that check is an outstanding item in your bank reconciliation. Include it in your opening accounts payable or as a reduction in your opening bank balance, otherwise your reconciliation will be off from day one.

Bringing over already-reconciled items as unreconciled. When you import bank transactions from the pre-migration period, mark them as already reconciled. Some import tools default to "unreconciled," which will make your first reconciliation impossibly messy.

Not cleaning up Excel first, then discovering the mess midway through import. Do Step 1 (clean up Excel) completely before attempting any import. Finding formula errors during import is much harder to fix than finding them beforehand.

What to Tell Your Accountant or CPA

If you work with an accountant, loop them in before migration. They need to:

• Agree on the migration date and opening balance methodology
• Review the opening trial balance before you go live
• Understand the new system so they can access reports for quarterly filing

Most CPAs who work with Philippine SMEs are comfortable with any major accounting software. Your job is to ensure the opening balances are correct; their job is to review the system and confirm it's ready to use for tax purposes.

After Migration: New Habits to Build

Once you're in accounting software, some habits that were optional in Excel become non-negotiable:

Record every transaction promptly. The power of accounting software comes from having complete, real-time data. If you batch-enter transactions monthly, you lose visibility the rest of the time.

Use the bank feed / bank reconciliation feature. Connect your bank account (if your software supports Philippine bank feeds) or import statements monthly. Reconcile every month.

Run reports, don't just look at numbers. Your accounting software generates P&L, balance sheet, cash flow, AR aging, and tax summaries. Use them. A monthly look at these reports is how you catch problems before they become serious.

Back up regularly. Cloud software backs up automatically, but if you're using desktop software, set an automatic daily backup to an external drive or cloud storage.

The migration effort — typically two to three days for a small business — pays dividends for years. Accurate, organized books reduce the stress of every BIR deadline, every loan application, and every business decision that depends on knowing your actual financial position.