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

• 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

1. Access the reports from Administration > Reports...
2. Select the Invoices and Receipts Report to display the Invoices and Receipts Report dialogue:

   

3. By default this displays with no Provider selected, which specifies "all Providers".
4. Leave the Provider field blank to report on all Providers, or use the selectors to select an individual Provider.
5. Select a time period.
6. 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.

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.)

(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.)