There is no revenue report on Payment Date!
We cannot accurately pay our practitioners a percentage of what they earned (money actually received) in a fortnight, without the risk of over or under paying them.
Why are the current Reports Inaccurate:
A revenue by closed or open invoices only tells us payments that were made according to the “invoice” date. So, if a partial payment is made, the current reports will show as no payment at all (closed invoices) or full payment (open invoices). No report will actually show what has been paid. The compounding problem is that, if we assume all invoices will eventually be paid in full, then we will be overpaying practitioners, essentially for revenue they did not receive. A big example of this is cancellation fees that only get paid 50% of the time. And to compound the problem even further, because we sync with Xero (which does produce reports of payment date), we have no way of cross-checking our figures. And before you say, “Why don’t you use data exports?”, well the data export for Payments does not include a practitioner column. So there is no report and no work around.
I did bring this up a year or so ago, in direct communication with support, and am happy to provide working examples should that be helpful. The response then was that payments were not associated with practitioners behind the scenes. This does seem very odd to me. As when I transfer the info to Xero I can produce a payment date report - as is required by my accountant and anyone else that works on a Cash Basis.
The importance of a “Payment Date”
Imagine having the “Daily Payments” report not actually show the revenue of a clinic. And instead showed, for example, what was invoiced - but not paid. No one would be able to reconcile their daily takings to the bank or their cash ledger. And imagine if you had to generate this report a week later and got a different result, because a payment was made after you drew the original report. No consistency or accuracy. That’s why we need reports on payment date.
A “revenue by Payment Date” report, that enables me to to select a date range and practitioner as query fields.
Do any other clinic owners share my sentiments? Or possibly have you been generating reports thinking you’ve been paying your staff accurately, when possible you or them have been underpaid?