Accounting: Invoices and Receipts Over a Period Report

Follow

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

 

Run the Report

  1. Click the navigation menu > Management > Reports page

  2. Accounting: Invoices and Receipts over a period

    1. Date: Select the period to base this report on

    2. Provider: Select the Provider or <Any Provider> 

    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 an individual or all locations

      2. For Payments/Refunds: Select an individual or all locations

    12. More...
      1. 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

    13. Click OK
      mceclip0.png


 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.

 

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.