This report provides detailed information about all the invoices issued: before and after discounts, provider involvement %, expenses, GST, commissions and all the payments received over the selected period of time (including deposits) and refunds for each provider.
Considerations
-
GST is setup
-
Provider Commission is setup (if applicable)
-
Cost to Provider for Expenses is setup if applicable
-
Prior Period Lock considered
Run the Report
-
Click the navigation menu > Management > Reports page
-
Accounting: Invoices and Receipts over a period
-
Date: Select the period to base this report on
-
Provider: Select the Provider or <Any Provider>
-
Sort By: Select the sort order of the report as Date/Invoice ID/Receipt ID/Name
-
Accrual Based: Tick to base report on when transactions occur, not when payments are received
-
Show Discount Only: Tick to only show discounts on the report
-
Show Totals Only: Tick to remove details from the report
-
Group Date Totals: Tick to group totals by date when two or more days are included in the report
-
Provider Page Break: Tick to view/print each Providers report on a separate page
-
Commissions: Tick to calculate commissions
-
Show inactive providers as well: Tick to include Providers made inactive
-
Specify Locations
-
For Providers/Accounts: Select an individual or all locations
-
For Payments/Refunds: Select an individual or all locations
-
- More...
-
Show data...Main Provider only: Only select this option to base the report on the Main Provider of the patient instead of the Treatment Provider
-
- Click OK
-
Report Details
Dated |
The date of the invoice and/or receipt. |
Name |
The name of the patient the invoice and/or receipt refers to. |
Inv/Rec ID |
The unique number assigned to each invoice and/or receipt generated. |
In/Out |
Only shown against a patient's name when a deposit has been put against one provider and another provider completes the treatment / uses the deposit. |
Invoice Details | |
Total |
The total amount invoiced shown as a $ figure. |
% involved |
If two providers worked on the one invoice the % involved will be split, otherwise it will show 100%. E.g. Provider 1 % involved = 44%, Provider 2 has % involved = 56%. |
$ Discnt |
The total amount discounted shown as a $ figure. |
$ involved |
The total amount invoice for after discount and if split by % involved. |
Expense |
The total of the expense (e.g. Lab) for this invoice/patient on that date. |
Receipt Details |
|
Total |
The total amount paid on this invoice on that date. |
% involved |
If two providers worked on the one invoice the % involved will be split, otherwise it will show 100%. E.g. Provider 1 % involved = 44%, Provider 2 has % involved = 56%. |
$ involved |
The total amount paid for that providers % involved. |
Credit/Deposits |
A positive amount in this field refers to an amount paid, but not allocated to treatment. A negative amount in this field refers to a deposit amount allocated to treatment or refunded to patient. If allocated to treatment it will show as a receipt against the invoice. |
Discounts (inc. GST) |
Total amount of discounts given in the period for all providers in the report. |
Promotions (inc. GST) |
Total amount of promotional discounts given in the period for all providers in the report. |
Expenses (inc. GST) |
Total amount of expenses paid in the period for all providers in the report. |
Total before discount |
Total amount received before discounts given. |
Invoice Totals |
|
Invoices (ex. GST) |
Total invoices for the period excluding any GST. |
GST |
Total GST involved in invoices for the period. |
Invoices (inc. GST) |
Total invoices including GST for the period. |
Receipts Totals |
|
Receipts (ex.GST) |
Total receipts for the period excluding any GST. |
GST |
Total GST involved in receipts received for the period. |
Receipts (inc.GST) |
Total receipts including GST for the period. |
Credits/Deposits |
Total amount of deposits for the period. |
Receipts - Expenses (inc.GST) Nett Total |
Total receipts minus any expenses based on cost to provider. |
Commission Calculations On Invoices (ex.GST) |
|
Commission |
Total commission for this provider based on invoices created excluding GST.Calculated as: Invoices x Commission Percentage. |
Expenses |
Total expenses for this provider based on the Provider Cost for Expenses. |
Comm - Expenses |
Total commission minus expenses based on invoices created excluding GST.Invoices x Commission Percentage – Portion of Expenses provider is responsible for. |
Commission Calculations On Receipts (ex.GST) |
|
Commission |
Total commission for this provider based on payments received excluding GST.Calculated as: Receipts x Commission Percentage. |
Expenses |
Total expenses for this provider based on the Provider Cost for Expenses. |
Comm - Expenses |
Total commission minus expenses based on payments received excluding GST.Calculated as: Receipts x Commission Percentage – Portion of Expenses provider is responsible for. |
Comments
Article is closed for comments.