Customer statements - Change how Credits and Overpayments are reflected
Please look at amending the template for customer statements. Its terribly presented at the moment with overpayments being recognised under the invoiced amount section as a negative and balances not cumulating at the end
Neilin Gulamhussein
shared this idea
Hi Neilin, I know you've mentioned customising the template, however from the sounds you'd like to change the behaviour of how items within a customer statement is represented?
If so it'd be good to understand more of the reason of why you're wanting to show overpayments as a positive?
If a customer has paid more than expected amount this amount is then a credit on their record and in turn draws down the total amount owed.
Alternatively you may want to be looking at recording as a prepayment?
-
Massimo Palo
commented
OVERPAYMENT - Approved, sent and paid - Statement
I am sending two photos. In one there is the statement of account 610 which correctly includes an Overpayment made.
In the second we find the other statement "Approved, sent and paid" which instead highlights an Overpayment made even if allocated in the invoice. From my point of view it should not be there. There should only be if the overpayment has not yet been allocated.
Comment
I checked. On the mentioned report it is not possible to remove overpayments with filters. The problem is that you put a balance at the end that is wrong and not consistent with the customer's accounting position (in fact, put like that that balance is misleading and useless). It would be fine if you also put the overpayments in the outgoing (allocated) so as to align the real position. From the report it seems that the customer is in credit of € 100 but this is not the case in reality. Check with your team if you can optimize the information. -
Neilin Gulamhussein
commented
Thanks for your message Kelly.
I dont believe you have understood the problem my clients are facing.
I have attached a statement for you to see the two main problems appearing on the customer statement.
First, the overpayment is appearing as a negative balance under the invoice amount column, instead of it appearing under the payments column. Please see the highlighted mark in the row dated 23 Jun 2021.
In addition to all that, the balance column on the customer statement is the same as the total of the invoice amount in each row, instead of a cumulative balance (under the balance column).
For example, the balance on the row dated 6th May 2021, I would expect to see £599.30 (£311.20 + £288.10). This is how all customer statements should appear. I have used other software and their customer statement reports are very clear, but Xero customer statement is not providing that.
Please help check this?
-
Neilin Gulamhussein
commented
Standard Customer Statement columns under the Invoice Amount column - show the overpayment amounts with a negative, instead of allocating these to Payments column.
In addition, I would expect to see the Balance column showing the cumulative figures of all invoices (reducing these with overpayments if any). Xero is not up to date with customer statements yet where as other software providers are able to generate good standard customer statements for outstanding balances.
Could this please be amended as a correction on your standard customer statements?
