Accounting: Invoices and Receipts Over a Period Report

Centaur Training

October 02, 2019 07:06

In this article you will find the following:

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

Go to Location Management > Reports tab
Open Accounting: Invoices and Receipts over a period report
Report Parameters
1. Date: Select the period to report on
2. Provider: Select the Provider or <All>
3. Sort By: Select the sort order of the report as Date/Invoice ID/Receipt ID/Name
4. Accrual Based: Tick to base report on when transactions occur, not when payments are received
5. Show Discount Only: Tick to only show discounts on the report
6. Show Totals Only: Tick to remove details from the report
7. Group Date Totals: Tick to group totals by date when two or more days are included in the report
8. Provider Page Break: Tick to view/print each Providers report on a separate page
9. Commissions: Tick to calculate commissions
10. Show inactive providers as well: Tick to include Providers made inactive
11. Specify Locations
  1. For Providers/Accounts: Select a location or All Locations
  2. For Payments/Refunds: Select a location or All Locations
12. More...:
13. 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
14. 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%. Automatically Split Accounts by Provider
$ 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%. Automatically Split Accounts by Provider
$ 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.

Accounting: Invoices and Receipts Over a Period Report

In this article you will find the following:

Considerations

Run the Report

Report Details

Comments

Articles in this section