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
- Choose the cutover date. Month-end or fiscal year-end is usually easier to validate than a date in the middle of a billing and payment cycle.
- Confirm the accounting basis. Record whether the association reports on cash, accrual, or another basis and configure the new system consistently before entering balances.
- Assign one conversion owner. One person should control versions, questions, corrections, and final approval even when several people prepare files.
- Define the archive rule. Decide who will keep QuickBooks access, exported files, attachments, bank statements, invoices, reconciliations, tax records, and governing retention schedules.
- Set the posting freeze. Identify the last person allowed to post in QuickBooks and the first person allowed to post routine activity in PayHOA.
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:
- Owner balances and prepayments to accounts receivable or deferred-credit control accounts.
- Open vendor bills and credits to accounts payable.
- Reserve bank cash to reserve-designated accounts and board restrictions.
- Prepaid expenses, deposits, fixed assets, loans, and other liabilities to schedules or source documents.
- Retained earnings or fund balances to the final accepted financial statements.
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:
- Balance sheet, profit and loss or income statement, trial balance, general ledger, journal report, and chart of accounts.
- All bank and credit-card reconciliation reports, statements, outstanding-item lists, and reconciliation discrepancy explanations.
- Owner or customer balance detail, aging, statements, charges, payments, credits, prepayments, write-offs, payment plans, and collection status.
- Vendor list, open bills, bill-payment detail, vendor credits, W-9 files, contracts, invoices, approvals, and 1099 history.
- Budgets, budget-versus-actual reports, reserve schedules, loan schedules, fixed-asset schedules, and special-assessment tracking.
- Audit-log evidence, recurring templates, attachments, custom report definitions, and the exact export date and administrator.
- Federal and state returns, information returns, CPA or tax-preparer adjustments, audit or review reports, and management letters.
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:
- Cutover controls and approvals.
- Old-to-new chart-of-accounts mapping.
- Units, owners, addresses, emails, ownership dates, and status.
- Unit receivables and prepayments as of the day before the PayHOA start date.
- Balance-sheet opening balances.
- Midyear income and expense balances when applicable.
- Open checks, deposits in transit, vendor bills, credits, and other reconciling items.
- Exceptions, decisions, preparer, reviewer, and resolution evidence.
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
- Trial balance tie: PayHOA opening debits equal credits and match the approved conversion trial balance.
- Cash tie: each PayHOA bank balance plus or minus documented outstanding items reconciles to the bank statement and final QuickBooks reconciliation.
- Owner tie: the total of all unit receivables and prepayments agrees with the mapped general-ledger control accounts.
- 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:
- Approved QuickBooks closing balances.
- Each conversion adjustment and its support.
- PayHOA opening balances.
- First-month activity and ending balances.
- Unresolved exceptions, owner communications, and responsible party.
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
- The board approved the cutover date, basis, account map, and responsible people.
- Every bank and credit-card account has a final supported reconciliation.
- Owner balances, prepayments, payables, reserves, and other schedules tie to the general ledger.
- The immutable archive includes reports, lists, attachments, statements, tax records, and conversion evidence.
- The PayHOA opening passes the four independent ties.
- Every conversion adjustment has a reason, preparer, reviewer, date, and source.
- Homeowner billing and portal access were tested before general release.
- The first month-end includes a migration bridge and exception report.
Primary reference links
- PayHOA Accounting V2: starting balances for a new association
- PayHOA product, import, export, role, and security features
- Intuit: export QuickBooks Online reports, lists, attachments, and other data
- Intuit: reconciliation reports and Audit Log review
- Common Ledger: PayHOA vs QuickBooks for HOA accounting
- Common Ledger: PayHOA month-end close checklist