Moving your HOA's books off QuickBooks

October 7, 2026

QuickBooks is built for businesses, and many associations make it work for years. But an HOA isn’t a business: it bills the same dues to every unit, tracks what each owner owes, keeps reserves apart from operating money, and hands its books to a new volunteer every few years. Treasurers end up with workarounds, like a customer record per unit, classes for reserves, and a spreadsheet beside it all for who has paid. When those workarounds start costing more time than they save, it’s time to move. Intuit’s decision to stop selling new subscriptions to most US desktop editions in September 2024 pushed many associations to decide sooner.

Switching is mostly careful bookkeeping on a single date. This guide walks through it, with a worked example.

Pick a cutover date

The cutover date is the day the new books start. Everything before it stays in QuickBooks; everything from it on goes in the new system.

• The start of your fiscal year is best. The new system then holds the whole year, and the annual report, budget comparison, and tax return come from one place.
• The start of a month is the next best. Choose one right after a month you’ve reconciled.
• Mid-year works, with one extra step. Also bring over the year-to-date total for each income and expense account, so the year’s reports still cover the whole year.

Avoid a busy month. The month dues are billed for the year, or the month of the annual meeting, is a bad time to learn new software.

Step 1: Finish the books in QuickBooks

Before exporting anything, make QuickBooks right as of the day before the cutover:

• Record every payment received through that day, and every bill the association owes.
• Reconcile every bank account through the last statement before the cutover. See how to reconcile an HOA bank account.
• Clear up the odd items: unapplied payments, duplicate customers, and old uncleared checks that should be voided.

Whatever is wrong on the cutover date gets copied into the new books, so fix it here, where you already know the history.

Step 2: Export what you’ll need

Run these reports as of the day before the cutover, and save each one as both PDF and Excel:

In QuickBooks Online, the Export data tool can pull reports and lists in one step. In the desktop editions, run each report and export it to Excel.

Step 3: Map your accounts

List the QuickBooks accounts beside the new system’s chart of accounts and decide where each balance goes. Keep it simple: the new books don’t need every account QuickBooks had, only the ones the association still uses. Two things matter most:

• Keep reserves separate. Reserve cash and the reserve fund balance must stay apart from operating money.
• Keep owners separate. Each owner’s balance comes over on its own, not as one lump of accounts receivable.

Step 4: Enter the opening balances

Now enter the balances as of the cutover date. A worked example makes the rules clear.

Maple Court HOA has 24 units and moves on January 1. Its trial balance on December 31:

Three rules come out of it:

• Use the book balance, not the bank’s. The December statement shows $18,850.00 in operating, but check #1187 for $450.00 hadn’t cleared. The books say $18,400.00, and that’s the opening balance. Note the outstanding check, so the first reconciliation in the new system can match it when it clears.
• Enter each owner’s balance separately. The $2,350.00 is three owners who owe $1,200.00, $650.00, and $500.00, and each goes on their own account and unit. The two owners who paid ahead get their $300.00 each as a credit, so it pays their next bills.
• The totals must match. When you’re done, the new system’s trial balance should equal the QuickBooks one to the cent. If it doesn’t, find the difference before going further: it’s almost always a missed owner balance or an outstanding item.

Step 5: Run both for a month

For the first month, keep QuickBooks available while you record everything in the new system. At the end of the month:

• Reconcile the bank accounts in the new system. The outstanding check from December should clear and match.
• Compare each owner’s balance with what they’d owe if you’d kept QuickBooks going.
• Run the reports the board sees and check they read the way the board expects.

If the first month reconciles and the owner balances agree, the move is done. Stop entering anything in QuickBooks.

Step 6: Tell the owners

Owners notice a change in statements before anything else. Send a short note:

• What’s changing, and the date.
• How to pay from now on, if that’s changing too.
• Their balance as of the cutover, so they can check it against what they expect.

Questions about a balance are easier to answer in the first week, with both systems still open, than in six months.

Keep the old records

Don’t delete anything. Keep the exported reports, and keep the QuickBooks data itself, in a backup file for the desktop editions or exported from QuickBooks Online. Intuit has let cancelled QuickBooks Online accounts stay read-only for a year, but check the current terms before you cancel, and export everything first anyway. How long the association must keep financial records depends on your governing documents, state law, and what your CPA advises; seven years is a common rule of thumb.

Common mistakes

• Starting from the bank statement balance instead of the reconciled book balance.
• Bringing over accounts receivable as one total, which leaves no way to tell owners what they owe.
• Forgetting owners who paid ahead. Their credit disappears, and they get billed twice.
• Skipping the last reconciliation in QuickBooks, so old mistakes move into the new books.
• Losing the year-to-date totals on a mid-year move, which leaves the annual report half empty.
• Cancelling QuickBooks before exporting, then needing a report for the audit or the tax return.

Moving the books is one afternoon of careful work, and a month of checking. For the rest of the treasurer’s year, see the HOA treasurer duties checklist.