Matching sales receipts in Undeposited Funds to a deposit that is smaller than the sales receipt

Our company does trunk shows where the onsite employees can pay with payroll deduction. The sales venue gets a percentage commission of the total pre-tax revenue. We then send them a report showing the pre-tax sales total, the commission we owe them, and the payroll sales deduction they owe us.

We enter sales receipts for every sales transaction, and they go in the Undeposited Funds account.

If the resulting deposit is larger than any single sale receipt, then it is super easy—we just select all the sales receipts from that trunk show—which will have a total larger than the deposit—and then add a resolving expense line item for the commission to match the deposit.

If the payroll sales total is more than the commission, then they send us a check for the difference, and if the commission is more than the payroll sales total, then we send them a check for the difference.

However, if there are any sale receipts larger than the related deposit, then they will not show up in list of the matching transactions, and there is no way to mark the sales receipts in the Undeposited Funds account as reconciled.

Example: All sales receipts are over $50 and the commission owed ends up being only $10 less than the payroll deduction sales, so they send a check for $10. With only a $10 deposit, none of the sales receipts will show up in the matching dialog.

I have verified this is the problem by converting a large sales receipt into multiple smaller receipts. But that is ridiculously cumbersome and is not a workable solution—this would cause an untenable explosion of sales receipts whenever any sales receipts are larger the deposit transaction.

Ideally, there would be some simple checkbox to show all transactions for the given time period, so that larger receipts would then become selectable.

I’m open to suggestions on another way to work around this problem.