Invoices and Receipts Report
(Available from EXACT v10.16 SP2)
Purpose
This report enables a dental practice to track and compare invoices and receipts against deposits for providers over a designated period by
...
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.
Select a time period.
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 one of the entries on their line has a value (is not equal to zero). |
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. |
...
(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.)
...
(Provider 2 invoices Patient A for work to the value of 250.00, discounted by 50.00. This includes lab work of 100.00.)
...
(Provider 3 has a deposit of 75.00 from Patient B, taken in a previous period.)
...
(Provider 4 invoices 75.00 to Patient B. Part of the deposit nominally held by provider 3 is used to settle the invoice.)
...
(Provider 5 takes a deposit of 200.00 from a patient, but doesn’t invoice anything yet.)
...
(Provider 6 invoices 150.00 to a patient but the patient doesn’t pay before the end of the reporting period.)
...
(Provider 7 discounts an invoice from a prior reporting period by 75.00.)
...
(Provider 8 corrects a mistake in an invoice from a prior reporting period, reducing it by 30.00.)
...
(Provider 9 corrects a mistake in an invoice which was already paid for in prior reporting period, reducing it by 40.00.)
...
(Provider 10 enters a 95.00 expense against treatment invoiced in a prior reporting period now that the bill is back from the lab.)