I've been struggling with this problem for a while and I can't figure it out.
It seems as though the first billing statement for every client does not deduct the fees and expenses from their retainer, but lists the bill amount as a "Balance Due" until a new payment is made to the account.
For example. Client paid a $3,000 retainer. Their first bill has charges for $1,000. The Bill will show a balance due of $1,000, and the retainer balance shows a $3,000 balance. All of the services show up correctly, but the fees are not deducted from the retainer. In their second bill, the charges are $500. It still shows the Balance due of $1,000, correctly lists the services for the billing period, but now the retainer balance is $2,500 (when it really should be $1,500).
I keep a backup paper record of all credits and debits for each client, so I have an accurate balance for everyone - but it's frustrating to have to explain to everyone that their bill is constantly wrong.
Is there a way to fix this from happening, or to apply the current retainer balance to a past due balance?
Thank you in advance for any help!