Skip to main content

Reconcile a bank account

Reconciling checks your PayHOA ledger against your bank statement, so you know every transaction is recorded once and your balances are…

M
Written by Michael Bollinger

Reconciling checks your PayHOA ledger against your bank statement, so you know every transaction is recorded once and your balances are right. Most associations reconcile each account monthly, when the bank statement arrives. A bank reconciliation isn't automatic: you start it and finish it, unless an administrator has turned on Autopilot's Bank reconciliation area. See How often should I reconcile, and does PayHOA do it for me?

You can reconcile linked and unlinked bank accounts. The PayHOA financial account can't be reconciled, so it isn't in the account list.

Your first reconciliation

  1. Start with the first full statement after the account's Balance as of date, and check the account's Starting Balance against the bank's balance on that date. The two should be equal, unless checks written before that date hadn't cleared the bank yet (see the note below). See Transactions: common questions.

  2. Enter that statement's beginning balance as the starting balance. Later periods follow on from it: PayHOA fills in the starting balance and locks it so the periods chain together.

  3. If some transactions pre-date your PayHOA start, reconcile from your start date and leave the older items unticked. They'll show as uncleared on the report until you delete them.

Checks written before your start date that clear after it. A new association's Starting Balance on a bank account usually comes from the previous system's balance sheet. That is the books' balance: it already leaves out checks that were written but hadn't cleared, so it's lower than the bank statement's balance on the same date by the amount of those checks (and higher by any deposits the bank hadn't credited yet). A reconciliation works from the bank statement, not from the books: PayHOA fills in the first reconciliation's starting balance from the account's Starting Balance, and you change it there to the statement's beginning balance. Whether to also change the account's Starting Balance, and how to record those checks when they clear, depends on how your books were set up, so contact PayHOA's accounting support team before you do either. See Enter starting balances for a new association.

If the Cleared balance already shows an amount before you've ticked anything, transactions in the period were marked reconciled earlier, by a reconciliation you deleted or by Gable. Untick them, or ask PayHOA support to clear the flags.

Start a reconciliation

  1. On Transactions, click Actions → Bank reconciliation, then Start reconciliation. You can also open the same page from Reports → Bank Reconciliation.

  2. Select an account. The list holds every bank account that has a card on Transactions, except the PayHOA financial account. If your bank account isn't in the list, see My bank account isn't on Transactions, or isn't offered in Bank reconciliation.

  3. Choose how to start:

    • Reconcile with Gable (recommended): drop your bank statement PDF in the box (PDF, up to 15 MB). Gable reads the dates and balances, matches transactions and flags anything missing for your review.

    • Enter details manually (the link under the statement box): enter the Starting date, Ending date and Ending balance from your statement, then click Start reconciliation. If you don't see Reconcile with Gable, it's switched off for your association; enter the details manually.

The dates and starting balance follow on from your last reconciliation for that account, so you usually only need the ending balance.

Can't start? Statement periods can't overlap an earlier reconciliation, and the starting balance must match the previous period's ending balance (PayHOA fills it in and locks it when the periods join up). If the dates clash, the dialog tells you which reconciliation they overlap; adjust the period, or delete the earlier reconciliation if it was wrong. See Reconciliation reports, fixes and deleting a reconciliation.

For Alliance Bank accounts, pick the statement date from your Alliance statements instead.

Note: Each account can have one reconciliation in progress. If one is open, you'll see Continue reconciliation or Abandon (which discards the work in progress).

When Reconcile with Gable doesn't work

  • Western Alliance Bank accounts: there's nothing to upload. PayHOA already has your statements; pick the statement period and Gable reads it. See Bank with Alliance Association Bank.

  • PayHOA says it can't load or read the statement: use a text-based PDF from your bank's website. A scan or a photo of a statement won't read. If the error repeats, contact PayHOA support; it's usually something they or the development team fix for you.

  • Gable's starting balance or matches are wrong: don't finish. Untick the wrong matches, click Edit on the Statement details card to correct the balances, or click Abandon and start again with Enter details manually.

  • The AI bank reconciliation got the month wrong. Reconcile with Gable is PayHOA's AI bank reconciliation. If it gave a wrong beginning or ending balance, matched the wrong transactions, missed checks, or listed a deposit that isn't on your statement, nothing is final until you click Finish reconciliation: correct it as in the line above, or abandon it and reconcile by hand. The one exception is when an administrator has set Autopilot's Bank reconciliation area to Auto: Gable then finishes statements that balance at $0.00 itself, so if a reconciliation it finished is wrong, delete it and reconcile the period again; see Delete a reconciliation. A line under Missing from ledger that isn't really on your statement can be removed with Dismiss. To report a wrong AI result so that PayHOA looks at it, contact PayHOA support with the bank account, the statement period, what was wrong (for example the balance Gable read and the balance printed on the statement) and a screenshot. Upload the statement to Documents first so the team can see it.

  • The statement's account number doesn't match the account in PayHOA: Gable compares the last four digits of the account number printed on the statement with the account number saved on the bank account in PayHOA. If they differ, it stops with a message such as "This statement looks like account ending 1234, not 5678." Check that you picked the right account and uploaded the right statement. If you did, click Use this account anyway to carry on. To stop the message coming back, save the account number from the statement on the bank account: in Settings → Bank Accounts, click Update on the account and fill in Bank account number. See Change, unlink or delete an account. If that field isn't offered for the account, contact PayHOA support with the account's name and the last four digits printed on the statement. You can always choose the account yourself and start with Enter details manually, which doesn't check the number.

  • One bank deposit, several lines in PayHOA: Gable can't match a single statement line to several split lines. Link or merge them first.

  • You'd rather not use Gable at all: an administrator can turn Gable off for the whole association at Other Tools → AI Settings → Gable settings → Turn Gable off. That removes Gable's chat, Help me finish with AI and the Ask Gable boxes from the reconciliation pages. It doesn't remove Reconcile with Gable from the start dialog. To remove that too, or to reconcile an Alliance account by hand, ask PayHOA support to turn off AI reconciliation for your association; the dialog then opens straight on the manual form. See Turn Gable on or off.

Match your statement

The reconciliation page has three main parts:

  • Statement details — the account, period, balances and Source (Reconciled with Gable or Manual entry). Click Edit on the card to fix them in Edit reconciliation information, then Update reconciliation.

  • Does it balance? — the Statement ending balance, your Cleared balance, and the Difference between them, with a Balanced or Not balanced badge.

  • Ledger transactions — every transaction in the period.

Tick each transaction that appears on your statement, using the check button in its Reconciled column. A row you haven't ticked shows an Unmatched badge. On this page, matching a transaction just means ticking it: an Unmatched row isn't an error, it's a row you haven't ticked yet. As you tick, the Difference goes down. Untick anything that isn't on the statement yet, such as a check that hasn't cleared. To clear several at once, select their checkboxes. A bar appears at the bottom of the list with Reconcile selected, Merge transactions and Delete transactions; click Reconcile selected → Yes, reconcile.

Use the drop-down above the list to show All ledger transactions, only Payments, only Deposits, or Unreconciled only. A Check no. column is available but hidden by default.

Ticking a transaction on the reconciliation page only marks it as cleared. It takes the transaction off the list of outstanding items and doesn't change any financial report. Deleting a transaction is different: it removes the transaction from your books, so the balance sheet and general ledger change, including for months you've already reported. To take the tick off a transaction (unmatch it), click its check button again before you finish.

Transactions still on For review are listed on the reconciliation page too, and you can tick them. They don't count in the account's Ledger balance or on your reports until they're approved, so if your ledger balance and your statement disagree, check the For review tab for transactions waiting to be approved.

Can't see the check buttons or some of the columns? Reconcile on a desktop or laptop computer, set your browser's zoom to 100%, and scroll the list sideways to reach the Reconciled column.

Transactions from earlier months

The list shows transactions dated inside the statement period. A check you wrote last month that cleared this month, or a deposit you recorded on the 30th that the bank posted on the 1st, is dated outside the period. Turn on Show all transactions (the switch at the top of Ledger transactions) to see every transaction in the account, including unreconciled ones from earlier months, and tick the ones that are on this statement.

Anything you leave unticked stays unreconciled: it appears on the report under Checks and payments not reconciled or Deposits and other credits not reconciled, and it's offered again next month. If an old item is never going to clear (a duplicate, a check you entered by hand that was never cashed, a stray $0.00 line), delete it or merge it rather than leaving it unreconciled: on Transactions, open Filters, set Status to Unreconciled, and work through the list. A check you paid from Payables and then voided is different: it can't be deleted, and it's cleared by ticking it together with its void entry. See Outstanding checks, voided payments and PayHOA's mailed-check fee.

A transfer or deposit is on the Transactions page but missing from the reconciliation list. If Show all transactions is already on and it still isn't in Ledger transactions, check these:

  • The view. The drop-down above the list may be set to Payments, Deposits or Unreconciled only, or the list's search box may have text in it. Choose All ledger transactions and clear the search. The list shows 100 rows to a page, so look on the next pages too.

  • The bank account. A reconciliation lists one bank account. On Transactions, check which account the transaction is under: a deposit recorded on a different account, or the bank's line for the other side of a transfer that was never converted to a transfer, belongs to that other account's reconciliation. A transfer between two of your accounts is listed in both accounts' reconciliations.

  • It's already reconciled. A transaction ticked in an earlier reconciliation of this account isn't offered again. On Transactions, click Filters, set Status to Reconciled and search for it. If it was ticked in the wrong month, delete that reconciliation and redo it; see Delete a reconciliation.

  • It was deleted. A deleted transaction isn't listed anywhere on Transactions either.

If none of these explains it, contact PayHOA's accounting support team with the bank account, the statement period, and the date and amount of each missing transaction.

Journal entries don't appear on a bank statement, but a journal entry that moves money in this bank account is listed here, marked Journal. Tick it if the statement shows the same movement.

If you reconciled with Gable, matches are already ticked. Check them, and look at Missing from ledger: transactions on your statement that aren't in PayHOA. Click Add to ledger or Dismiss for each. See Missing from ledger: Add to ledger or Dismiss for what each button does.

Missing from ledger: Add to ledger or Dismiss

When you reconcile with Gable, the card that lists what Gable found can show Missing from ledger: lines Gable read on your bank statement and couldn't match to any transaction in PayHOA. Each line has two buttons.

Button

What it does

Add to ledger

Adds the statement line to PayHOA as a new transaction on this bank account, with the statement's date, description and amount, and takes it off the list. You see "Item has been added to your ledger." The new transaction has no category and isn't approved or ticked. Tick it in Ledger transactions, and give it a category on Transactions → For review so that it counts in your books.

Dismiss

Takes the line off the Missing from ledger list and does nothing else. You see "Item removed from the list." Nothing is added to your ledger, no transaction is ticked or unticked, and the Cleared balance and the Difference stay exactly as they were.

When to dismiss a statement transaction. Dismiss a line that is already in PayHOA and that Gable simply failed to match, for example a deposit recorded under a different description, a split, or a transaction dated outside the statement period. Then tick the transaction that's already there (turn on Show all transactions if it's dated outside the period). Don't dismiss a line that really is missing from PayHOA: the money is still on your statement, so the Difference won't reach $0.00 until the transaction is in the ledger and ticked.

A dismissed line can't be brought back to the list. If you dismissed one you need, click Add transaction on the reconciliation page and enter it yourself. Dismissing doesn't carry over to other months: each Missing from ledger list comes from that reconciliation's own statement, so a dismissed line isn't offered again in next month's reconciliation, and dismissing doesn't change your bank statement or any report.

Outstanding checks, voided payments and PayHOA's mailed-check fee

These three leave rows unticked, or lines on the statement with nothing to tick, and none of them means the reconciliation is wrong.

  • A check I sent hasn't cleared yet, or cleared the next month. A check that's still outstanding at the end of the statement period is normal. Leave it unticked this month. In the month it clears, turn on Show all transactions and tick it there. PayHOA's payment statuses don't tell you whether a mailed check was cashed; look for it on your bank statement. See Track a payment and payment statuses.

  • A payment I voided in Payables shows twice, once as the payment and once as Void/Cancel:. Voiding doesn't remove the payment. It adds a reversing entry dated the Void Date, so the two rows add up to zero. When the check was never cashed, neither is on your bank statement. Tick both in the same reconciliation; the Difference doesn't change. Don't delete either row. If the money had left the bank and was refunded, tick each against its own line on the statement; see If the money had already left the bank and was refunded. See A voided bill payment and its Void/Cancel entry.

  • Small debits from PayHOA on the statement, such as $2.00, $4.00 or $6.00. PayHOA charges $2.00 for each check it mails for you, billed once a day for that day's checks. If your association pays PayHOA from this bank account, each charge is a debit on the statement. It's a bank transaction, not a bill: there's no payable to create or match. If the debit is in Ledger transactions, tick it, and give it an expense category on Transactions so it's approved. If it's on the statement but not in the list, click Add transaction, choose Payment, enter it, then tick it. See Mail a check for how the fee is billed.

More you can do on the reconciliation page

If you use Gable, Help me finish with AI (at the top of the page, and on the card that lists what Gable found) opens a Gable chat about this reconciliation. Gable reviews it and offers the fixes it needs in the chat, such as matching a line, correcting a wrong amount, adding a missing statement line or deleting a duplicate, and can finish the reconciliation once it balances. When the difference isn't zero, the Does it balance? card has the same shortcut as Have Gable help me finish.

From the page you can also:

  • Add transaction — add one that's on the statement but missing. Choose the Type (Payment or Deposit) and enter the amount as a positive number.

  • Reconcile selected — mark the rows you've selected as cleared. This and the next two are in the bar that appears when you select rows.

  • Merge transactions — combine two or more selected duplicates with the same amount.

  • Delete transactions — removes the selected rows from your whole ledger, not just this reconciliation.

  • On a single row, ⋯ → Edit (or clicking the row) changes its date, amount, description or memo, and Delete removes it from the ledger.

Catching up several months

To catch up on bank reconciliations for a long period, reconcile one month at a time. Start with the earliest month that isn't reconciled, use that month's bank statement, finish it, then move to the next month. Each period has to start on the previous period's ending balance and can't overlap it, so the months join up in order. Reconciling a whole year as one period makes a difference much harder to find.

If transactions from an earlier year were never reconciled, they keep showing as not reconciled on later reports. Clear them with a catch-up reconciliation: start a reconciliation for the earlier period, tick the transactions that cleared the bank, check the balances against that period's statement and finish it. Its ending balance must equal the starting balance of the reconciliation that comes after it.

PayHOA support can guide you through a reconciliation and look into one that won't balance, but doesn't reconcile your accounts for you. If you'd rather have it done for you, see PayHOA's bookkeeping service, a paid service in which a PayHOA bookkeeper reconciles your accounts each month.

Finish

When the Difference is $0.00 you'll see "You're all set. Perfectly balanced." Click Finish reconciliation, then Yes, finish. The button stays greyed out until the difference is zero, so if you can't click Finish reconciliation, the Difference isn't $0.00 yet.

Finishing approves any cleared transactions that already have a category but were still waiting for review. Uncategorized ones stay on For review.

Can't get to zero? See When the difference won't reach zero, which also covers a bill payment that won't delete and what to send PayHOA support if you're still stuck. You can also click Help me finish with AI, or ask Gable Why doesn't this reconcile?

Did this answer your question?