What is the Receipts Analysis Report?
Summarises the allocated amount totals of all receipts and receipt adjustments. Shown as daily and monthly totals providing you with a clear vision of cash flow.
How to run the Receipts Analysis Report
Go to Financial on the navigation menu on the left and select Receipts Analysis from the dropdown.
Work through the filters to ensure you are reporting on the correct parameters.
Select the reporting period by choosing your Start Date and End Date from the calendar icon.
Select the Practice/Practices.
Click Create Report to run the data.
Viewing your Receipts Analysis Report
A separate column is shown for each day in the reporting period that has a receipt or receipt adjustment transaction.
The rows in the report are split into the following sections:
Takings: Total from the fully allocated portion of receipts in the period, i.e. excluding pre-payment receipt amounts. For example, if a COT will cost a total of 200, the patient pays a deposit of 200, but only an invoice for 50 worth of the overall work has been raised, then the 'Takings' section would only show the 50 of the 200 receipt that has been allocated to the invoice raised. The 'Takings' section is further split according to the receipt payment method - e.g. Cash or Debit Card. Adjustment amounts are shown as a separate row.
Income: Total from all unallocated portions from receipts in the period. For example, in the above case where a patient had paid 200 deposit, of which only 50 was currently allocated to an invoice, this section would show 150 for the unallocated component. This section is split by receipt payment method.
Total Receipts: Addition of the "Takings" and "Invoices" values which is the grand total of receipt transactions in the reporting period.
Accounted for by: This is an alternative breakdown of the Total Receipts value, and splits this total by receipt payment method (Cash, Debit Card, etc).
💡Top tip: The values in the Total Receipts row can be clicked on to drill down to show the Receipts Analysis Detail report for that total value.
To download a copy of your report you can use the Export Data button to download a CSV spreadsheet.
You can use the Print button in the top right as needed.
To set up automation of the report you can use the Schedule Report button.