Common LedgerGet a quote

Accounting migration

Move HOA books from QuickBooks to PayHOA without losing the story.

A clean migration is not a data dump. It is a controlled close in QuickBooks, a documented opening in PayHOA, and a reconciliation that lets the board explain every balance.

One cutoverdate and accounting basis
Four tiescash, receivables, liabilities, and equity
Two systemsone preserved audit trail
Board sign-offbefore routine posting begins

Common Ledger is independent and is not affiliated with, sponsored by, or endorsed by PayHOA, QuickBooks, or Intuit. Platform capabilities change; verify current instructions with each provider. This article is general operational education, not accounting, tax, audit, legal, CPA, or data-retention advice.

The migration principle

Do not try to make PayHOA look as though it processed years of transactions that actually occurred in QuickBooks. Preserve QuickBooks as the historical system through a defined date. Open PayHOA on the next date with supportable beginning balances, unit-level receivables and prepayments, and enough documentation to trace the opening back to the old books.

PayHOA's current Accounting V2 instructions use the same basic model: choose a PayHOA start date, use the immediately preceding date for opening balances, prepare a balance sheet, include a profit-and-loss statement when starting midyear, and provide accounts receivable and prepayments by unit. That is the spine of the project. The board still needs a fuller archive, reconciliation, approval, and exception process around it.

1. Freeze the scope before anyone imports

A fuzzy cutover creates duplicate payments, missing invoices, unexplained opening entries, and owners whose balances differ between systems. Put the date, roles, and freeze in a short board-approved migration memo.

2. Clean QuickBooks before exporting it

Migration does not cure old accounting errors. Complete the final QuickBooks close first. Reconcile every operating, reserve, money-market, savings, and credit-card account to a third-party statement. Resolve old outstanding checks, deposits in transit, uncategorized bank-feed items, duplicate transactions, negative receivables, unapplied payments, stale vendor credits, and balance-sheet suspense accounts.

Review the QuickBooks audit log and reconciliation history for changes to previously reconciled periods. Intuit notes that QuickBooks Online can show who changed reconciliation reports or reconciled transactions in the Audit Log. Preserve the final reconciliation reports and the statements they reconcile to. A later board or accountant should be able to distinguish the final accepted close from an earlier draft.

Then reconcile subsidiary detail to the general ledger:

3. Build the evidence archive, not just an export file

QuickBooks Online provides an export process for reports and lists and separate export options for attachments and certain non-posting information. Intuit's article also points to third-party apps for backing up QuickBooks Online data, so the export alone should not be treated as the complete backup. Treat the export as one part of a controlled archive.

At minimum, preserve the following as of the cutover date:

Use read-only storage with a clear folder index. Keep the original exports unchanged and place working transformations in a separate folder. Record file hashes or other integrity controls when the association's risk profile warrants them.

4. Design the PayHOA opening before entering numbers

Map the old chart of accounts to the new chart before importing units or posting opening entries. Do not carry forward every duplicate, inactive, or poorly named QuickBooks account simply because it exists. Each old account should map to one active PayHOA account, a documented consolidated account, or an archive-only item with no opening balance.

Prepare a conversion workbook with separate tabs for:

PayHOA's current guidance says units, people, and unit starting balances can be imported together and that the starting-balance date should be the day immediately before the PayHOA start date. Follow the current sample file and support instructions rather than reusing an old template.

5. Separate owner balances from general-ledger balances

The owner subledger is usually the hardest part of an HOA conversion. For every unit, identify the owner of record, total amount due or prepaid, charge categories, dispute status, payment plan, collection status, legal referral, returned payment, unapplied cash, and any transaction still moving between processors or banks.

The total owner receivables less prepayments must tie to the corresponding opening balance-sheet accounts. If it does not, stop. Do not plug the difference into income, bad debt, retained earnings, or a generic conversion account without a written explanation and qualified review.

Keep prior-owner history in the archive. Load only the balances and ownership information needed for the new operating period under the current platform's rules. Verify how the platform separates former and current owner history before homeowners receive access.

6. Validate the opening with four independent ties

  1. Trial balance tie: PayHOA opening debits equal credits and match the approved conversion trial balance.
  2. Cash tie: each PayHOA bank balance plus or minus documented outstanding items reconciles to the bank statement and final QuickBooks reconciliation.
  3. Owner tie: the total of all unit receivables and prepayments agrees with the mapped general-ledger control accounts.
  4. Financial-statement tie: the PayHOA opening balance sheet agrees with the final QuickBooks balance sheet after documented conversion adjustments.

When the move occurs midyear, also tie year-to-date income and expenses to the final QuickBooks profit-and-loss statement. Run cash- and accrual-basis comparisons when the association uses one basis for management reporting and another for tax or CPA work.

7. Run a controlled first month

For the first billing cycle, compare assessment charges to the approved budget, declaration allocations, unit roster, and prior schedule. For the first payment cycle, watch for payments initiated before cutover but settled after it. For the first accounts-payable cycle, check that open QuickBooks bills are not paid twice and that new PayHOA bills do not omit prior approvals.

At the first month-end, prepare a normal board packet plus a migration bridge showing:

Do not shut down historical access until the board, bookkeeper, and tax or accounting professional have confirmed that the archive is usable and the new opening can be reconstructed.

Board approval checklist

Planning a conversion?

Close the old books before opening the new ones.

Common Ledger can help clean the QuickBooks close, map balances, establish PayHOA, validate owner ledgers, and deliver the first board-ready financial packet.