Customer Sales Report Totals

Submitted by gretalloyd on Fri, 29/05/2020 - 17:04

General User's Discussion

Hi,

Quick question, is the Customer Sales Report on invoice basis or cash basis?

Our accountant wants a report on invoice basis (all invoices paid and unpaid) and I'm pretty sure the Customer Sales Report are only paid invoices. Is there a report I can use?

Thanks,

Greta

Re: Customer Sales Report Totals

Submitted by tanderson on Mon, 01/06/2020 - 10:56.

If you are running the Customer Sales Report included in the OpenVPMS distribution, it doesn't distinguish between paid or unpaid transactions.

It looks at all Finalised transactions between the From and To Dates that are:

Invoices
Counter Sales
Credits
Credit Adjustments
Debit Adjustments
Bad Debts
Initial Balances

It doesn't look at payments or refunds, nor does it take into account any unfinalised transactions.

Re: Customer Sales Report Totals

Submitted by gretalloyd on Mon, 01/06/2020 - 15:41.

Thanks Tim,

I have another question now then.

Is there a report that includes invoices that have been finalized between a certain date (ie January 1st to March 31st) but are unpaid?

Would you just use the Debtors Historical Report and add columns <30 + 30-59 + 60-89? Or is there a better report for this?

Accountant is using Xero (if anyone uses that with their accountant) and need to enter in an amount to deduct from the Customer Sales Report to match with the actual paid invoices for the quarter.

nb. the Customer Payments Report is not quite what wanted because it includes payments for invoices finalized prior to the specified period.

How does one reconcile between OpenVPMS and Xero the total $ in customer invoices that are paid and unpaid during a certain period?