Good day, Grant. When paying multiple suppliers through a bulk ABA file, QuickBooks records each payment individually to reflect the transactions made to each supplier.
When creating and recording payments to suppliers in QuickBooks Online (QBO), each payment is entered as a separate transaction. However, when these payments are processed via a bulk ABA file, your bank consolidates them into one summary transaction. As a result, your bank statement shows both:
- Individual supplier transactions for each payment.
- A bulk transaction representing the total amount processed in the ABA file (e.g., $800 for Supplier A and Supplier B combined).
The reason they appeared twice is that you recorded them in QuickBooks Online to track payments to each supplier accurately. The bulk transaction appears because the ABA file processes payments as a single consolidated amount, and the bank records it that way.
To resolve this during reconciliation, you'll need to match each payment recorded in QuickBooks Online to its corresponding individual transaction in the bank feed. This ensures accurate reconciliation of supplier expenses.
After that, exclude the bulk transaction in your bank feed to avoid duplicating the transactions in your QuickBooks records.
By reconciling individual payments and excluding the bulk transaction, you’ll ensure your QuickBooks records accurately reflect your expenses without duplication.
If you're reconciling an account for the first time in QuickBooks and encounter issues, this guide provides step-by-step solutions to resolve discrepancies and ensure your records align with your bank statement.
Let me know if you need further guidance or have questions about this process. We're here to help.
