Skip to main content

Reconciliation reports, fixes and deleting a reconciliation

See past reconciliations, download their reports, find why one won't balance, and redo one if you need to.

M
Written by Michael Bollinger

See past reconciliations, download their reports, find why one won't balance, and redo one if you need to.

Past reconciliations

On Transactions, click Actions → Bank reconciliation, or go to Reports → Bank Reconciliation; both open the same page. Previous reconciliations lists each one with its period, balances, payments, deposits and the date it was finished. Filter by account or year. To see the reconciliations of a bank account you've deleted, open the account filter and turn on Show deleted accounts. The list has no search box and its columns are fixed.

From the ⋯ menu:

  • Resume — continue one that's In progress.

  • View report — open a finished one. A reconciliation that's still In progress has no report yet; finish it to download one.

  • Delete — remove it (see below).

Two reconciliations for the same month. PayHOA doesn't let a new reconciliation overlap one that's already there, but if the list shows two reconciliations for the same account and month, for example one finished and one In progress, delete both and reconcile that month again. Leaving a duplicate in place throws off the balances of the months after it.

The reconciliation report

The report shows the period, ending balance, the transactions you reconciled, and the checks, payments and deposits that hadn't cleared. Click Download report for a PDF, or Export CSV. On older reconciliations the uncleared lists are worked out from today's data, not from the day you finished.

Printing a year-to-date (YTD) bank reconciliation report. Each finished reconciliation has its own report, for its own statement period. There's no single report that combines a year of reconciliations and no print button: to print a reconciliation report, click Download report and print the PDF. To get the year's reports, filter Previous reconciliations by the account and the year, then open each one with ⋯ → View report and download it. You can also put them in one PDF with a report packet: add Bank Reconciliation once for each period, then, when you run the packet, click each copy in Run report packet and pick its period under Reconciled between (when you create the packet, only Most recent reconciliation is offered); see Report packets. Don't reconcile a whole year as one period to get a single report: a difference is much harder to find that way. See Catching up several months.

Statements you drop into Reconcile with Gable are kept with the reconciliation, not in Documents. Keep your own copy if you want it in your files. There's no button on a reconciliation or on its report that opens or downloads the uploaded statement again, so to keep statements where your board can read them, upload them to Documents yourself. (Alliance Association Bank statements are different: they can be downloaded from the bank account's ⋯ menu in Settings.)

A reconciliation I finished isn't in the list

If a bank reconciliation you completed and saved for an earlier month isn't listed under Previous reconciliations with the others, check these in order before you redo it:

  1. The filters. Set the account filter to All accounts and the year filter to All years. A reconciliation is filed under the year of its End date, so a statement that ends in early January is under the new year. The list shows 25 rows to a page, and the year filter may offer only the years on the page you're looking at, so if the year you want isn't offered, leave it on All years, sort by End date and look on the next pages.

  2. A deleted bank account. If the account was deleted and added again, its old reconciliations belong to the removed account: open the account filter and turn on Show deleted accounts.

  3. It was started but not finished. A reconciliation that was never finished shows In progress in the Reconciled column and has no report; click ⋯ → Resume. One that was abandoned is gone.

  4. A reconciled transaction's amount was edited. Changing the amount of a transaction in a finished reconciliation deletes that reconciliation, after a warning ("Edit a reconciled transaction?"). Another person with access may also have deleted it.

  5. Try to start it again. Click Start reconciliation and enter the same account and statement dates. If the reconciliation still exists, PayHOA won't let the dates overlap and names the one they clash with. If it lets you start, the old one is no longer there, and reconciling the month again is the fix.

If the dates clash with a reconciliation you can't find in the list, contact PayHOA support with the bank account, the statement period, who reconciled it and roughly when, and a screenshot of the message.

If the reconciliation balanced but the Balance Sheet shows a different figure for that bank account, compare the two on the statement's end date: the balance sheet should match the report's Register Balance as of {date}, not the statement's ending balance. See My reconciliation balanced. Why is the bank balance on the balance sheet different?

Changes detected means transactions in that period were added, split or deleted after you finished, or an amount in it was changed by editing a journal entry or by importing a file (listed as Amount changed). Open it to see which. Editing the Amount of a reconciled transaction on Transactions is different: it deletes the reconciliation, as the note below says, so there is nothing left to show Changes detected. Changing only a transaction's category, vendor, memo or description doesn't change what cleared the bank, so the transaction stays reconciled and the period doesn't need redoing.

Important: Changing the amount of a transaction in a finished reconciliation, by editing the transaction on Transactions, deletes that reconciliation. It doesn't just show Changes detected. PayHOA warns you first with "Edit a reconciled transaction?", and nothing is deleted unless you click Change amount. You'll need to reconcile that period again.

An opening balance or old item that shows as not reconciled on every report

The report lists every transaction on the bank account that has never been ticked in a reconciliation, however old it is, under Checks and payments not reconciled or Deposits and other credits not reconciled. So an amount that sits there month after month is a ledger item nobody has ticked. A common one is the opening (beginning) balance: if the balance you started with was entered as a deposit or a journal entry on the bank account, instead of as the account's Starting Balance, it's a transaction like any other and stays on the report as unreconciled until it's ticked.

The year end doesn't clear it. Nothing in PayHOA closes or rolls forward reconciliation items; a transaction leaves the list only when it's ticked in a reconciliation or deleted.

To clear an opening balance entry without changing your books, tick it in a catch-up reconciliation that ends the day before your first reconciliation starts:

  1. On Transactions, click Actions → Bank reconciliation → Start reconciliation, pick the account and choose Enter details manually.

  2. Set the Ending date to the day before your first reconciliation's starting date, and the Starting date on or before the date of the opening balance entry.

  3. Enter a starting balance of 0.00, because the account held nothing in PayHOA before the opening balance entry. As the Ending balance, enter the starting balance of your first reconciliation.

  4. Tick the opening balance entry (and anything else from before your first statement that really was in the bank by then). When the Difference is $0.00, click Finish reconciliation.

The same steps clear old items from an earlier year that were never reconciled. See Catching up several months.

If the account has a Starting Balance and the same opening balance was also entered as a transaction or journal entry, the money is counted twice and the Ledger balance is too high by that amount. In that case delete the extra entry instead of ticking it. If you aren't sure which applies, contact PayHOA's accounting support team and send the bank account's name, the amount and date of the entry, and the reconciliation report it appears on.

Old unreconciled items from a closed bank account still show. Can I hide them?

No. Nothing in PayHOA hides unreconciled transactions, on a report or anywhere else. Excluding them doesn't do it either: an excluded transaction is still listed when you reconcile and still counts in the bank account's balance on the balance sheet; excluding only takes it out of income and expenses. A transaction leaves the not-reconciled lists only when it's ticked in a reconciliation or deleted. To clear the leftover items of a bank account that has been closed at the bank:

  1. If the account was deleted in PayHOA, restore it first. Its transactions show the account's name followed by (Removed), and a removed account can't be reconciled. See Restore a deleted account.

  2. Run one catch-up reconciliation up to the day the account closed. On Transactions, click Actions → Bank reconciliation → Start reconciliation, pick the account and choose Enter details manually. Use the bank's final statement for the Ending date and Ending balance (0.00 if the account was emptied). Tick everything that really cleared the bank.

  3. Delete what never happened. A check you entered by hand that was never cashed, a duplicate or a stray entry is deleted, not ticked. A payment made from Payables that never went through is voided in Payables instead; see A voided bill payment and its Void/Cancel entry.

  4. Finish, then delete the account again. When the Difference is $0.00, click Finish reconciliation. Then delete the account in Settings → Bank Accounts (⋯ → Delete); its history stays in PayHOA.

If the closing balance was moved to another of your accounts and that movement was never recorded, record it as a transfer first, or the closed account won't reach zero; see Record transfers between accounts. These items are listed on that bank account's reconciliation report (and in a report packet that includes it) and under Filters → Status → Unreconciled on Transactions. If they've started to appear on a different report, contact PayHOA support with the report's name, its dates and a screenshot.

Can a reconciled month be locked?

No. PayHOA has no period lock, close date or "close the books" setting. A transaction dated in a month you've already reconciled or reported on can still be added, changed or deleted by anyone with write access to Transactions. Two things show you when that has happened: the reconciliation for that month shows Changes detected, or is deleted (after a warning) if a reconciled transaction's amount was edited on Transactions (see above), and the General Ledger report has Recorded Date and Recorded By columns, which show when each entry was written and by whom, so an entry dated in March but recorded in June stands out. Save the reconciliation report and your month-end reports as PDFs when you finish each month, so you have the figures as they were.

Monthly report packets

A monthly report packet pulls in the reconciliation for that month. If the packet says a reconciliation is missing but the account shows as reconciled, run the packet again after the reconciliation is finished. If it still says so, contact PayHOA support with the account and month.

When the difference won't reach zero

Work through these in order. If you use Gable, you can also click Help me finish with AI on the reconciliation page: Gable looks for the difference and offers the fixes in a chat.

First, rule out a deleted bank transaction. If you deleted a transaction that came from your bank, it never imports again, so the ledger is short by that amount. You can't restore it yourself: contact PayHOA support with the date and amount and they'll restore it from the deleted list. Then:

  1. Starting balance. It should match your statement's beginning balance. If this is your first reconciliation, check the account's starting balance on Transactions: click the small refresh-arrow icon next to Ledger balance on the account card (Update Starting Balance) and check Starting Balance and Balance as of.

  2. Dates. Make sure the statement period matches your statement exactly.

  3. Missing transactions. Compare the statement line by line, or reconcile with Gable to have it flag what's missing. Add them with Add transaction.

  4. Duplicates. Look for the same amount twice. Merge or delete one.

  5. Deposits that combine several payments. The bank shows one deposit; make sure you're not ticking the individual payments as well.

  6. Transfers recorded on only one side. See Record transfers between accounts.

  7. Pending items that aren't on the statement yet. Leave them unticked.

  8. Transactions waiting on For review. They're listed on the reconciliation page, but they aren't in the account's Ledger balance until they're approved. Approve the ones that are right.

  9. The difference is exactly the amount of one check or payment from an earlier month. A check you wrote or processed late last month that cleared the bank this month is on this statement, but it's dated before the statement period, so it isn't in the list. Turn on Show all transactions (the switch at the top of Ledger transactions), find the check and tick it. See Transactions from earlier months.

A deposit of owners' checks or cash is on the statement but isn't in the list to tick, although the payments show on the owners' accounts. On a bank account that isn't linked, recording the payments doesn't add a deposit to Transactions unless Create deposit on transaction ledger was turned on in the Record payment form, and that switch starts off. The payments are on the owners' accounts, but the deposit was never created in your books, so there's nothing to tick and the difference is the deposit total. Add the deposit by hand: on Transactions, click Add transaction, choose Income, pick the bank account and enter the deposit total and date, then click ⋯ → Link payments on it and tick the payments that were in it. Then tick the deposit in the reconciliation. See Add a deposit to your books.

A bill payment that won't delete during a reconciliation

A bill payment you made from Payables can't be deleted as a transaction, during a bank reconciliation or anywhere else. On the reconciliation page, Delete on that row fails with "There was a problem deleting the transaction. Please try again." On Transactions, the row's ⋯ menu has no Delete, and a bulk delete leaves it out with "A payable's transaction is removed from the payable itself, not from here." What to do depends on why it's still unreconciled:

  • The check or payment just hasn't cleared the bank yet. Leave it unticked. It's offered again on next month's reconciliation.

  • The payment never happened or was entered by mistake. Void it in Payables: for a check or a bill marked as paid, click ⋯ → Void on the payment, enter the Void Date and click Yes, void it. The payment entry is reversed and the bill goes back to Unpaid, where you can delete it. See Void a check or a payment marked as paid. The void doesn't take the payment off the reconciliation page; it adds a second row that cancels it, and you tick the two together. See A voided bill payment and its Void/Cancel entry.

  • It's on the list twice, once from Payables and once from the bank. Keep the Payables payment. Confirm Gable's match on Transactions if one is suggested; otherwise delete the bank's copy. Don't exclude it: an excluded transaction still counts in the account's balance. See Fix duplicates.

A bill from a vendor is a payable, not an invoice. Invoices in PayHOA are what you send to owners, so deleting an invoice won't remove a vendor payment.

A voided bill payment and its Void/Cancel entry

A check or payment you voided in Payables shows in a bank reconciliation as two rows, not none. Voiding doesn't remove the original payment from the bank account. It adds a second entry that reverses it: a journal entry whose description starts Void/Cancel:, dated the Void Date, for the same amount, going back into the same bank account. On the reconciliation page that entry is marked Journal and counts as a deposit. The payment and its Void/Cancel: entry add up to zero.

When the check was never cashed, neither row is on your bank statement. (If the money did leave the bank and was refunded, see If the money had already left the bank and was refunded below.) To clear a voided check and its reversal from a reconciliation:

  1. Open the reconciliation you're working on and turn on Show all transactions. The payment and the void are often dated in different months, so one of them can be outside the statement period.

  2. Tick both rows in the same reconciliation. One counts as a payment and the other as a deposit of the same amount, so the Cleared balance and the Difference don't change.

Tick both or neither. Ticking only one puts the reconciliation out by the amount of the check. If you leave both unticked, they stay on every reconciliation report, one under Checks and payments not reconciled and one under Deposits and other credits not reconciled.

Don't delete either row. The original payment can't be deleted, because it's a bill payment. The Void/Cancel: entry can be, but deleting it undoes the reversal in your books: the bank account's Ledger balance drops by the amount of a check that never left the bank.

If the bank statement shows that a check you voided was cashed anyway, don't tick the pair. Contact PayHOA support and ask for the accounting team, with the vendor, the amount, the check number, the payment date and the void date.

Don't void a payment the bank has already cleared. A void puts the money back into the bank account in your books on the Void Date. If the payment really left the bank (it's on a statement, or it was ticked in a finished reconciliation), then from the Void Date on the account's Ledger balance and its line on the balance sheet are too high by that amount, although every month is reconciled. So check the bank statement before you void. If two bills were entered for one payment, void the payment on the duplicate, the one with no line at the bank, and keep the one that cleared. If you've already voided a payment that cleared, don't delete the Void/Cancel: entry and don't enter the payment again yourself: contact PayHOA's accounting support team with the vendor, the amount, the check number, the payment date and the void date.

A check that was never a Payables payment is different. A check you added to Transactions by hand, or imported from a file, that was never cashed has no void entry: delete that transaction.

If the money had already left the bank and was refunded

Sometimes the money had already left your bank account when a bill payment was cancelled or voided, and the bank later put it back as a refund deposit. Then both movements are on your bank statement, the withdrawal and the refund. In PayHOA the payment from Payables is the withdrawal, and its Void/Cancel: entry is the refund: the entry has already put the amount back into the bank account in your books. If the bank's refund deposit is then recorded as well, the PayHOA balance (the Ledger balance) is higher than the bank by the amount of that payment.

  • In the reconciliation, tick the payment against the withdrawal on the statement, and tick the Void/Cancel: entry against the refund. If the two are on different statements, tick each in its own month; turn on Show all transactions if the entry's date falls outside the period.

  • On Transactions, the bank's own line for the refund deposit is a second record of the same money. Delete the bank's copy. Don't give it an income category and don't exclude it: either way the refund is counted twice, and the Ledger balance is higher than the bank by the amount of the payment.

  • Don't delete the payment or the Void/Cancel: entry to make the balance come right.

To check, pick the bank account on Transactions and search for the amount: there should be the payment, one entry starting Void/Cancel:, and no separate refund deposit. If the payable shows as cancelled or voided and there's no Void/Cancel: entry, the entry is there twice, or the balance is still off by that amount, contact PayHOA's accounting support team with the vendor, the amount, the payment date, the date it was cancelled or voided and the date the refund reached your bank.

Still won't balance?

If the difference still won't reach zero after these checks, upload the bank statements for the months involved to Documents, then contact PayHOA support and ask for the accounting team. Say which bank account and statement period it is, the Difference shown on the reconciliation page, and what you've already checked. They can look at the account and find where the difference started.

Delete a reconciliation

Open the ⋯ menu → Delete. The Delete reconciliation? dialog shows the period and balances and warns "You may need to reconcile this account again in the future." Click Yes, delete.

Delete a reconciliation when you need to redo a period, for example after fixing transactions in it. One common case is splitting a transaction that's in a finished reconciliation into different categories: split it on Transactions, delete the reconciliation for that period, and reconcile the period again. Deleting a reconciliation takes the reconciled mark off its transactions; it doesn't delete the transactions or change your reports. Reconcile the period again afterward. You can't undo a delete yourself; contact PayHOA support if you deleted one by mistake.

To redo a month that has later reconciliations after it, you don't have to delete the later ones: delete the wrong month and reconcile it again. Its starting and ending balances must join the reconciliations on either side of it. If the later months were built on wrong balances too, delete them as well, newest first, and reconcile forward again.

To redo an in-progress reconciliation from scratch, choose Abandon instead.

Did this answer your question?