Skip to content
← For small businesses

Enter your idea

For small businesses: Business features

Categories

(thinking…)

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

4 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Neilin Gulamhussein shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
submitted  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

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? 

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Neilin Gulamhussein commented  ·   ·  Report

    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  ·   ·  Report

    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?