Why does my Statement for my customers not match my open invoices??

[TrudieM]

HI there

Please help, when we went to run the January Statement to send to our customers it appears that the amount in open invoices does not match the total on the statement regardless of the date range...we also found credits that our customers had not taken up did not appear in the open tab and even when we subtracted the $$ amount of the credits it still did not match the statement..

How do we fix this issue?

[Steven_M]

Hi @TrudieM 

When you say the statement doesn't match the open invoices are you referring to the actual Sales>>Customer statements window or the produced statement i.e. the PDF?

The reason for this question is that the Customer statement window balance is the current balance of the customer, not the balance based on the date range you are selecting. For example, if you entered an invoice in January for $100 and then another one in February for $50. The Customer statements window would show $150 regardless of the date range you are entering into that window. 

If you are referring to the actual statement not matching the open invoices for that period, getting a copy of the statement along with a view of the Sales>>Invoices window for that same customer filtered by that date range would be ideal so we can investigate further.