Matching deposits that include credit transactions
We use a payments platform that sends us a deposit each week for the net amount of all the payments and credits processed that week. This shows up as a single deposit transaction in our bank feed. We match this against the individual invoices (and refunds) that we've created in QBO.
The problem is that QBO does not allow us to match part of a deposit against a refund receipt, only invoices. On weeks where a credit is included in the net amount deposited, we have to manually record that a payment has been received for each invoice and credit.
For example, say at the end of the week we receive a deposit for $49,000 that's made up of 25 paid invoices of $2,000 each (=$50,000), and one credit for $1,000. When the $49,000 deposit appears in our bank feed, I can't match it because it will only let me match against invoices (totally $50,000), not the refund ($1,000). I have to manually record that each invoice has been paid and make sure the refund receipt for $1,000 was recorded.
This is error prone - it's easy to miss the payment for an invoice. Additionally it's difficult to reconcile the statement we get from our bank. The statement just shows a single deposit of $49,000, but we need to select 26 transactions (25 payments and one refund) that add up to $49,000 in the reconciliation and hope the sum is the correct amount.
The entire process is error prone.
It seems like it's such a simple fix to allow a deposit to be matched against invoices and refund receipts (as long as the total is positive).