Automatic application of account credit to new invoice?
Context: I manage finances for a nonprofit summer recreation association. We manage an onsite cafeteria. We require all members to pay a $500 deposit at the beginning of the season, and use the funds for startup costs. Members are automatically billed weekly via QBO e-mailed invoice for meals consumed.
The way we want it to work: Each invoice debits the $500 balance until the balance is exhausted, at which point the member pays. An invoice will show meal charges, any credit remaining on the account, and a net total payment due.
The way it actually works: QBO automatically issues invoices each week without checking for or applying any credit remaining from the $500 deposit. The member gets an invoice which shows nothing but meal charges and an amount due, and calls to ask why their deposit wasn't applied.
Trying to fix it: Our accountant tells me there's no way to configure QBO to do this automatically because "there's no per-customer escrow ledger". The only solution she offers: tell members not to pay their invoices for a few days. This gives her time to manually apply credits to new invoices, and reissue an invoice showing the applied credit and the correct amount due.
My question: This can't be right, can it? How is it possible that accounting software won't automatically apply credits on a customer's account? How do law offices handle retainers? They manually apply payment to every new invoice? How do wholesale businesses handle prepayments or overpayments on charge accounts?
If this is really how QBO works, does someone at least know the reason so I can make peace with it?