Customer Sales Report Totals

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Customer Sales Report Totals

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

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?

Re: Customer Sales Report Totals

There's two other reports in the standard distribution that may help you:

  • Key Performance Indicators
  • Practice Summary

 

Syndicate content