How to Identify, Resolve, and Prevent Duplicate Transactions in PayHOA
Duplicate transactions in PayHOA can occur due to interactions between Payables, manual entries, and bank feed imports. This guide explains the common causes, steps to resolve duplicates, and preventative measures to avoid future issues.
Common Causes of Duplicate Transactions
Payables and Bank Feed Imports: - When a payable is created, PayHOA records an expense transaction (often labeled "Invoice"). - When the check or ACH payment clears, the bank feed imports a second transaction for the same payment. - This results in duplicate entries for the same expense.
Manual Entries and Payables: - Duplicate expenses can occur when both a Payable transaction and a manual entry exist for the same item.
Transfers and Grayed-Out Transactions: - Grayed-out transactions indicate a transfer between accounts. If the transfer is incorrectly categorized, it can create duplicates.
Budget Report Discrepancies: - Duplicates in Budget reports may arise from mixed entries (e.g., Payables and manual transactions) or exclusions that don’t address underlying records.
Steps to Resolve Duplicate Transactions
1. Identify the Source of the Duplicate
Check if the duplicate is from a Payable and a bank feed import.
Look for manual entries that overlap with Payables.
Review transfers and grayed-out transactions for errors.
2. Retain the Correct Transaction
Payables vs. Bank Feed: - Keep the Payables-created transaction (labeled "Invoice"). - Delete the duplicate bank feed transaction.
Manual Entries vs. Payables: - Retain the Payables transaction and delete the manual entry. If the Payables transaction was deleted, restore it first.
Transfers: - Convert the grayed-out transfer back to a regular transaction or delete the duplicate transfer.
3. Reconcile Correctly
Use the retained transaction for reconciliation.
Delete any reconciliations that included duplicates and re-reconcile with the correct transaction.
4. Adjust Categories if Needed
For duplicates under different categories, update the category of the correct transaction and delete the duplicate.
Preventing Duplicate Transactions
Manage Bank Feed Approvals: - When a bank feed transaction appears for an expense already recorded as a Payable, do not approve it. Delete the bank feed transaction instead.
Avoid Manual Entries for Payables: - Use Payables to record all vendor payments and avoid creating manual entries for the same expenses.
Review Transfers Carefully: - Ensure transfers are correctly categorized to avoid duplicates.
Reconcile Regularly: - Perform monthly reconciliations to identify and address duplicates promptly.
FAQs
Why does a vendor expense appear twice during bank reconciliation?
This happens because the expense is recorded at two stages: when the Payable is created and when the check clears via the bank feed. Keep the Payable transaction and delete the duplicate from the bank feed.
How do I fix duplicate entries in my Budget report?
Restore the Payables-linked transaction, delete manual duplicates, and re-reconcile the affected month.
How can I prevent duplicates when using offline checks?
Delete the bank feed transaction and retain the Payables-created transaction as the source of truth. By following these steps, you can effectively manage duplicate transactions in PayHOA and maintain accurate financial records.