Day End Procedures

Reports

Day End Procedures

4 min read

There are a few standard practices that are helpful to do to reconcile your end of day.

Transaction Report

This report will ensure that you have entered all payments correctly into Jane. This is what people often call the “Cash Out” report, and when reconciled daily, you will reduce problems down the road. I like to run this report at midday for staff change over so that the morning front desk can confirm that their numbers make sense and then again at the end of the day for the entire day.

This report will show you the transaction method, the number of transactions, and the dollar amount you should have.

On this report you will see all payments made on this day, regardless of the date of the invoice or if the payment was applied to anything. So for example, you’ll find payments here made to pay an appointment from 3 weeks ago, a payment that was placed as a credit on someone’s account, a payment paying for a same-day purchase etc. Absolutely any money that came into your clinic on the reporting period you select will show up on this report.

Most people will compare these numbers to their payment processing terminal and their cash and cheques on hand.

Note that Jane Payments and Payfirma integration payments don’t need to reconcile against anything as there is no way to have entered the information incorrectly.

You cannot filter the transaction report by Practitioner because when a payment is taken, it is not attached to a practitioner in Jane. The payment does not belong to a practitioner until it is applied to an invoice - so, for example, a payment that creates a credit does not belong to anyone yet. If you want to see amounts applied to a practitioner for a specific time period (so what a practitioner had paid during a day, for example) you can use the Compensation Report.

Sales by Staff Member

The second report to review - and again, I do this both at change over and at the end of the day - is the sales by staff member. This report will ensure that you’ve charged (or invoiced) everyone appropriately for the day. It’s a really handy check to make sure that all new charges you’ve created are entered properly.

You can see if someone was charged the wrong amount, if the insurance status looks incorrect or if there’s anything else unusual happening with any of the billings.

This report will only show invoices created for the reporting period you choose (in this case one day). If payments were taken on invoices created before or after this date range the invoices will not show up here. Again, that can be seen on the compensation report or the transaction report.

Unscheduled Patients Report

This is the unsung hero of the reporting suite and well worth a review at the end of the day. The unscheduled patient report will show you all clients from the day (or week, or whatever period for which you run the report) who have not yet booked back in for a future appointment.

You can create a return visit reminder right from the report to remind the client to book back in as per their prescribed treatment plan and they will be linked right to the appropriate practitioner’s online booking.