- Currently, unallocated payments are not shown on the statement.
This means that any customer who has either paid in advance of an invoice, or who has not clearly stated which invoice they are paying needs additional information to interpret their balance.
At the moment I have to run out a list of unallocated payments with their dates, make sure it matches the “credit” figure on the statement and send that with the customer statement.
Rename “credits” to “unallocated payments and credits”
Rename “outstanding balance” to “outstanding invoices”
Add new field of “Customer Account Total” (= outstanding invoices - unallocated payments and credits)
On the export file please can you either remove GBP against every number or parse it into a separate column. Currently I have to remove them all in order to add up any numbers.
What are other people doing with their statements when they are not fully representative of a customer’s account?