Skip to main content

Exclude, delete or fix duplicate transactions

Keep transactions out of your books, remove ones that shouldn't be there, and clean up duplicates.

M
Written by Michael Bollinger

Keep transactions out of your books, remove ones that shouldn't be there, and clean up duplicates.

Exclude or delete?

Exclude

Delete

What happens

The transaction stays in PayHOA and still counts in the bank account's balance, but it's left out of your income and expenses.

The transaction is removed from your books altogether.

Can you undo it?

Yes, from the Excluded tab.

Not yourself. Contact PayHOA support.

Comes back from the bank?

No, it stays excluded.

No. A deleted bank transaction never imports again, unless the bank is linked again with a new bank login.

Use it for

Money that really went through the bank account but isn't the association's income or expense: a personal or mistaken charge, or the opening deposit into a new bank account.

Transactions that shouldn't be in your books at all: ones you added by hand by mistake, and the extra copy of a duplicate.

Exclude a transaction

Open the transaction with ⋯ → View details and click Exclude. It moves to the Excluded tab.

To bring it back, open it on Excluded and click Undo exclude. It returns to For review.

An excluded transaction still counts in the bank account's balance. Excluding keeps the amount out of every income and expense category, so it's not on the profit and loss or the budget. The money still moved at the bank, so the amount stays in the account's Ledger balance (formerly called the In PayHOA balance) and on the balance sheet, and the transaction is still listed when you reconcile. On the current accounting system the other side of it goes to the Excluded equity account. See Balance sheet and trial balance.

When to exclude: an example. You open a new bank account with a deposit from an old account that isn't in PayHOA. That deposit isn't income, so you don't want it in an income category, but the new account's balance needs it or the account won't reconcile. Exclude it.

The same applies to money wired or transferred in from an account that isn't in PayHOA, such as a previous management company's account or an old reserve account. If the deposit hasn't come in from a linked bank, add it first: click Add transaction, choose Income, enter the amount as a positive number and pick the bank account, then open it and click Exclude. If the account's balance went down instead of up, the deposit was saved as an Expense: open it and type a minus in front of the Amount to switch it to money in. See Add a transaction.

Money sent out to an account that isn't in PayHOA works the same way. A transfer or withdrawal to an outside (external) bank account that you don't keep in PayHOA really left this bank account, but it isn't an expense: open it with ⋯ → View details and click Exclude. If the outside account is the association's own and you want its balance on your balance sheet, add it as a bank account instead (it doesn't have to be linked) and record the movement as a transfer. See Record transfers between accounts.

Don't exclude the extra copy of a duplicate. Because an excluded transaction still counts in the bank account's balance, the money would still be counted twice there. Delete the extra copy instead.

You can't exclude PayHOA financial account transactions, PayHOA deposits, split transactions, or a deposit that has payments linked to it (unlink them first).

Delete a transaction

Click ⋯ → Delete (or tick several and choose Actions → Delete). The Delete transactions? dialog asks "Are you sure you want to remove 1 transaction?" and warns This action cannot be undone. Click Yes, delete transaction.

Note: Deleting a Returned Payment transaction undoes the return. The dialog asks Reverse this returned payment? instead, with a Yes, Reverse Return button, and the payment is restored and applied to the owner's account again. This is how you undo a check you marked as returned by mistake; don't delete this transaction just to clear a duplicate. See I returned the wrong payment.

Transactions with no Delete option. A bill payment made from Payables has no Delete in its ⋯ menu, and a bulk delete leaves it out with "A payable's transaction is removed from the payable itself, not from here." Void the payment in Payables instead. See A bill payment that won't delete during a reconciliation. PayHOA deposits and PayHOA financial account transactions can't be deleted either. If you choose Delete on one of these, PayHOA can still show Success ("1 transaction deleted.") although nothing was removed; see I deleted a transaction and saw Success, but it's still there.

I can't find Delete, or a duplicate won't delete (unable to delete this transaction). Work out which of these you're seeing:

  • You ticked a transaction and no Delete button appeared. There's no separate Delete button or banner. Delete for ticked rows is in the Actions menu at the top right of the table: Actions → Delete.

  • No transaction has a checkbox, and there's no Delete in any ⋯ menu. The login you're using has Read access to Transactions in this association, not Write. Access is set separately in each association, so you can have it in one and not in another. Ask an admin of the association; see Give board members and staff access.

  • Delete is missing on one of two rows for the same check. That row is the bill payment made from Payables, and the other row is the bank's copy. The bill payment is the one that opens as Payable details when you click ⋯ → View details; to mark bill payments in the list, click Columns and turn on Bill Payment. Delete the bank's copy and keep the bill payment.

  • One transaction's checkbox can't be ticked. It's a PayHOA deposit, which can't be deleted.

If it's an ordinary bank transaction or one you added by hand, you have Write access, and it still can't be deleted after you reload the page, contact PayHOA support with the bank account, the transaction's date and amount, which of the copies you want removed, and a screenshot of the row's ⋯ menu or of the message.

A transaction that's in a finished reconciliation can be deleted without deleting the reconciliation first. That reconciliation then shows Changes detected. See Reconciliation reports, fixes and deleting a reconciliation.

Fix duplicates

PayHOA prevents most duplicates automatically. See How transactions get into PayHOA. When you do see one twice:

  • A transaction you added by hand and the same one from your bank: delete the one you added.

  • A bill payment and its bank copy, or both sides of a transfer: Gable suggests a match. When you pay a bill in Payables, PayHOA writes that payment to the ledger right away (or on the scheduled payment date, if you scheduled it for later), without waiting for the bank; when the check clears, which can be days or weeks later, the bank sends its own copy, so the same payment is on For review twice until they're matched. If Gable doesn't suggest the match, delete the bank copy and keep the payable payment, which carries the bill's category. The payable payment itself has no Delete; that's expected. See Review Gable's match and transfer suggestions.

  • During a reconciliation: select the duplicates and use Merge transactions. See Reconcile a bank account.

  • A run of duplicates at once, for example after a bank account was re-linked with a new bank login or support reset your ledger: on Transactions, open Filters, set Status to Unreconciled, sort by amount, and delete or match the extra copies. To delete many at once, tick them and click Actions → Delete; you don't have to review each one again. A new bank login is the usual cause: PayHOA can't tell that the new login's transactions are the ones the old login already brought in, so everything dated after the account's Import transactions after date comes in a second time. Repairing or reusing the same login doesn't do this. To avoid it next time, set that date before you relink. See Relink, unlink or delete: what happens to your transactions.

If a vendor actually received two paper checks for one bill, that isn't a duplicate transaction. See A vendor received two checks for the same bill.

A bank copy of a PayHOA deposit or payout

A payout of owners' online payments is written to Transactions by PayHOA itself, as a PayHOA deposit already linked to the payments in it. When the same payout arrives from your bank, PayHOA normally attaches the bank's line to that deposit instead of adding it again. Now and then the bank words the line in a way PayHOA doesn't recognize, and the bank's copy comes in as a second deposit for the same amount. The sign of this is a deposit from owners' online payments that isn't linked to any payment while all the others are.

Tell the two apart like this:

The PayHOA deposit (keep it)

The bank's copy (delete it)

Description

PayHOA Deposit

Your bank's own wording, often with PayHOA.com and a reference starting ST-, or a generic label such as Preauthorized credit or Deposit

Category column

A badge that opens Deposit Details, listing each owner's payment

Empty, or a suggested category; no payments

Can it be changed?

No. Opening it shows "PayHOA Deposits cannot be edited. If you need assistance please contact support.", and PayHOA won't delete it

Yes. It's an ordinary bank transaction that you can edit and delete

Delete the bank's copy with ⋯ → Delete. Never try to remove the PayHOA deposit, and don't link payments to the bank's copy or give it an income category: the income is already counted in the PayHOA deposit. Don't exclude the copy either, because an excluded transaction still counts in the bank account's balance. To see which owners a PayHOA deposit belongs to, click its category badge. If the bank's copy was ticked in a finished bank reconciliation, deleting it marks that reconciliation Changes detected; delete that reconciliation and reconcile the month again, ticking the PayHOA deposit this time.

If you can't tell which is which, or there is a bank line for a payout and no PayHOA deposit to go with it, contact PayHOA support with the bank account, the date and the amount of the deposit.

Two rows that are both described PayHOA Deposit, or a PayHOA deposit that never shows at the bank. Neither of these is a bank copy, and neither can be put right by deleting or by redoing a reconciliation: PayHOA won't delete a PayHOA deposit, and a reconciliation doesn't change one. If two PayHOA deposits list the same owners' payments (compare their Deposit Details, or run the Deposit Details report for those dates), or a PayHOA deposit has no matching line on your bank statement after the payout should have arrived, this needs a person. Don't delete anything, and don't tick the deposit in a reconciliation to make the month balance; leave it unticked, where it's listed as not reconciled. Contact PayHOA's accounting support team with the bank account, the date and amount of each deposit, and a screenshot of each one's Deposit Details. For when a payout should reach your bank, see Payments that haven't arrived.

The same applies to money going out. When a payout comes to less than zero, PayHOA's own row is described PayHOA Withdrawal, and a bank debit with PayHOA.com in its description for the same amount is its copy.

Ask Gable to Find duplicate transactions to list likely duplicates.

If the bank's copy of a duplicate won't delete, or it still shows on For review after you deleted it, refresh the page. If it's still there, contact PayHOA support with the bank account, the date and amount of the transaction, and a screenshot of any message you saw.

Note: There's no list of deleted transactions on the Transactions page. On the current accounting system, a deleted transaction that had been approved or excluded still shows on the General Ledger report as its original entry plus an entry starting Reverse:; see Deleted and changed items on the ledger. You can't restore a deleted transaction yourself. If you delete the wrong copy, contact PayHOA support with the bank account, the date and the amount, and they can restore it.

Deleted the wrong transaction? Stop there. You don't need to un-approve a transaction before deleting it; deleting an approved transaction writes its own Reverse: entry. But don't add the transaction again by hand, and don't delete or re-enter anything else to make the balance come right: each of those adds more entries to the ledger, and a finished bank reconciliation for that month then shows Changes detected. Ask support to restore the one you deleted.

Looking for "reverse"? PayHOA has no button that reverses a transaction. Deleting it, or correcting it in View details, is how a wrong entry is undone. See How do I reverse a transaction I entered wrong?

Did this answer your question?