Purpose
This report The Invoice and Receipt Summary Report enables a dental practice to track and compare invoices and receipts against deposits for providers over a designated period by
Providing totals per provider for invoices and receipts over a period,
Showing the change in amount of money on deposit over that period.
Features
Schedule this report.
Export this report.
The report can be run for an individual provider (by selection) or for all providers (by leaving the provider field blank).
A Total line is included when the report is for more than one provider.
All providers are included in the report, whether they are marked as inactive or not. However, the report will only produce an output line for a provider when that person is the only provider on the report or when one of the entries on a provider's line has a value.
Requirements and limitations
There is no ‘detailed view’ for this report. Details can be obtained by running the Allocated Payments Report and the Invoice Summary Report for the same period.:
To Print, Preview, Email or Export the Invoices and Receipts Report
Access the reports from Administration > Reports
...
.
...
Select the Invoices and Receipts Report to display the Invoices and Receipts Report dialogue:
...
By default this displays with no Provider selected, which specifies "all Providers".
Leave the Provider field blank to report on all Providers, or use the selectors to select an individual Provider.
...
Choose the dates you wish to report on in the From and To fields.
Choose to Print, Preview, Email or Export in the standard manner.
...
The Invoices and Receipts Report output
...
PROV
Providers are shown with an output line when either they are the only Provider, or when
...
Discounts
Total
...
This field only appears when there is more than one provider listed.
Discounts - The sum of all discounts entered for invoices for the provider within the reporting period.
Invoices
...
- These figures are calculated on the sum of all invoices and invoice adjustments entered within the period.
The invoices total (for each provider and overall) matches the total given by the Invoice Summary Report and Invoiced Treatment Report when run for the same period.
Expenses
...
- These are invoices based on the amounts entered for lab items. Blank fields indicate that the provider did not invoice for lab items in this period.
Receipts
...
- Shows the sum of all receipts and receipt adjustments entered within the period.
The receipt totals (for each provider and overall) matches the allocated total given by the Allocated Payments Report when run for the same period.
Deposit
...
(delta)
- This is the change in the amount of money being held on deposit over the period of the report. It matches the Total Advance Payment figure shown on the Allocated Payments Report.
The sum of the Receipts column and the Deposit column equals the total amount receipted within the reporting period.
Line examples:
...
(Provider 1 takes a deposit of 500.00 from Patient A and invoices work to the value of 100.00. No lab work is invoiced.)
...