A range of reports covering financial, statistical & business, including totals, commissions, production, staff attendance & ADA DelDC survey upload.

Exporting, emailing and printing options available for all reports

Links to 50+ other reports can be found at the bottom of this article thread.

Where to find the Reports page

Accounting: Invoices and Receipts Over a Period Report

1. Double click to open Accounting: Invoices and Receipts over a period
   
2. Report Parameters:
   
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
    
12. For Providers/Accounts: Select an individual or all locations
    
13. For Payments/Refunds: Select an individual or all locations
    
14. Click 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
   
15. Click OK
    

1. Dated The date of the invoice and/or receipt.
   
2. Name The name of the patient the invoice and/or receipt refers to.
   
3. 
   Inv/Rec ID The unique number assigned to each invoice and/or receipt generated.
   
4. 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.
   

1. Total The total amount invoiced shown as a $ figure.
   
2. % involved If two providers worked on the one invoice the % involved will be split, otherwise it will show 100%.  
   
3. E.g. Provider 1 % involved = 44%, Provider 2 has % involved = 56%.
   
4. $ Discnt The total amount discounted shown as a $ figure.
   
5. $ involved The total amount invoice for after discount and if split by % involved.
   
6. 
   Expense The total of the expense (e.g. Lab) for this invoice/patient on that date.
   

1. Total The total amount paid on this invoice on that date.
   
2. % involved If two providers worked on the one invoice the % involved will be split, otherwise it will show 100%. 
   
3. E.g. Provider 1 % involved = 44%, Provider 2 has % involved = 56%.
   
4. $ involved The total amount paid for that providers % involved.
   
5. Credit/Deposits A positive amount in this field refers to an amount paid, but not allocated to  treatment. 
   
6. A negative amount in this field refers to a deposit amount allocated to treatment or refunded to patient. 
   
7. If allocated to treatment it will  show as a receipt against the invoice.
   
8. Discounts (inc. GST) Total amount of discounts given in the period for all providers in the report.
   
9. Promotions (inc. GST) Total amount of promotional discounts given in the period for all providers in the report.
   
10. Expenses (inc. GST) Total amount of expenses paid in the period for all providers in the report.
    
11. Total before discount otal amount received before discounts given.
    

1. Invoices (ex. GST) Total invoices for the period excluding any GST.
   
2. GST Total GST involved in invoices for the period.
   
3. Invoices (inc. GST) Total invoices including GST for the period.
   

1. Receipts (ex.GST) Total receipts for the period excluding any GST.
   
2. GST Total GST involved in receipts received for the period.
   
3. Receipts (inc.GST) Total receipts including GST for the period.
   
4. Credits/Deposits Total amount of deposits for the period.
   
5. Receipts -  Expenses (inc.GST) Nett Total Total receipts minus any expenses based on cost to provider.
   
6. Commission  Calculations On Invoices (ex.GST) 
   
7. Commission Total commission for this provider based on invoices created excluding GST.
   
1. Calculated as: Invoices x Commission Percentage.
   
8. Expenses Total expenses for this provider based on the Provider Cost for Expenses. 
   
9. Comm - Expenses Total commission minus expenses based on invoices created excluding GST.
   
1. Invoices x Commission Percentage – Portion of Expenses provider is responsible for.
   
10. Commission  Calculations On Receipts (ex.GST)
    
11. Commission Total commission for this provider based on payments received excluding GST.
    
1. Calculated as: Receipts x Commission Percentage.
   
12. Expenses Total expenses for this provider based on the Provider Cost for Expenses.
    
13. Comm - Expenses Total commission minus expenses based on payments received excluding GST.
    
1. Calculated as: Receipts x Commission Percentage – Portion of Expenses provider is responsible for.  
   

Commission Details on Invoices Raised

The Commission Details on Invoices Raised is used to calculate commission in these circumstances:

Providers are paid based on invoices generated

Providers income is based on a commission calculation from the invoices

It is presumed that commission details have been set for the Provider(s). 

1. Double click to open the Commission Details on Invoices Raised report
   
2. Report Parameters:
   
1. Date: Select the date range to base the report on
   
2. Location: Select the location or All Locations to base the report on
   
3. Provider: Select the Provider or <All> to include in the report
   
4. Show inactive providers as well: Tick to include inactive provider(s)
   
5. Include Discounts: Tick to include discount details in the report
   
6. Discounts of all periods: When Include Discounts is ticked, tick this box to include discounts of all periods
   
3. Select from the drop list for information to include in the report:
   
1. Item's details: Show items details included in the invoices
   
2. Invoice's details: Show invoice totals only
   
3. Provider summary: Show total for each selected Provider only. When this option is selected, check boxes below will be unavailable
   
4. Provider Page Break: When multiple providers are included in the report, tick to show one provider per page
   
5. Group by providers: When All Locations is selected, tick to group report by provider, instead of by location
   
6. Click OK
   
   

Report Details

Depending on the selection from [ABOVE], the report will be viewed one of three ways. 

      Item's Details View
      

1. Date: Date of treatment
   
2. Patient: Patient full name and Card ID
   
3. Item / Time Fee /  Disc Exp.: The item performed. How many times
   
1. The fee charged. Any discounts given
   
2. Any expenses relating to the item.
   
4. Amount Total amount for the item
   
5. Comm/Tar The pre-set commission / tariff percentage set up in provider file
   
6. Exp. Any expense costs 
   
7. Comm The calculated fee after commission
   
8. Provider Fees Total fee charged 
   
9. Discount Total Discounts
   
10. Expenses  Total expenses
    
11. Commission Total commission 
    

      Invoice Details
      

1. Date: Date of the invoice
   
2. Responsible Party: Person responsible for the invoice
   
3. Invoice Details:  Inv. Total / Disc. / Exp.: 
   
1. Total amount for the invoice
   
2. Any discounts given
   
3. Any expense costs within the invoice
   
4. Commission details: Prov.Fees / Disc. / Exp.: 
   
1. Provider fees
   
2. Discounts
   
3. Total discounts
   
5. Provider Fees: Total fee charged 
   
6. Discount: Total Discounts 
   
7. Expenses: Total expenses
   
8. Commission: Total commission 
   

      Providers Summary
      

1. Total for: A list of all the providers
   
2. Provider Fees: Total fee charged
   
3. Discount: Total Discounts
   
4. Expenses: Total expenses
   
5. Commission: Total commission
   

Commission Details on Receipts

This report shows commission details of Providers when their income is based on a commission calculated from receipts generated under their names.

1. Double click to open Commission details on Receipts report
   
2. Report parameters:
   
1. Location: Select the location or All Locations to base the report on
   
2. Date: Select the date range to base the report on
   
3. Provider: Select the Provider or <All> to include in the report
   
4. Show inactive providers as well: Tick to include inactive provider(s)
   
1. Select from the drop list for information to include in the report:
   
5. Item's details: Show items details included in the receipts
   
6. Receipt's details: Show receipt total only
   
7. Provider summary: Show total for each selected Provider only. When this option is selected, check boxes below will be unavailable
   
8. Provider Page Break: When multiple providers are included in the report, tick to show one provider per page
   
9. Group by providers: When All Locations is selected, tick to group report by provider, instead of by location
   
10. Click OK

Report Details

      Show Item's details
      

1. Date : Date of receipt
   
2. Patient: Patient name and Card ID  
   
3. Item / Times  /  Fee:  The item code  /  How many times  /  Item fee
   
4. Receipt Com/Tar  Comm: Total receipt for the item  Commission / Tariff %  Commission amount 
   

      Show Receipt's details
      

1. Date: Date of receipt
   
2. Rec. #: Receipt number 
   
3. Responsible party: Person responsible for the payment 
   
4. Total Rec.: The total receipt amount 
   
5. Commission: The calculated commission amount 
   
6. Total For:  Name of provider /  Total Rec /  Commission: The name of the provider /  Total receipts /  Total commission amount  
   

      Show Provider summary

      

1. Total for: Provider (code) and name 
   
2. Total Rec: Total Receipts for each provider 
   
3. Commissions: Total calculated commissions for each provider
   

Deposit Allocation Report

1. Double click to open Deposit Allocation Report
   
2. Report Parameters:
   
1. Date: Select the date range to base this report on
   
2. Location: Select the location to base this report on, if applicable
   
3. Provider: Select the provider(s) to include in the report
   
4. Show inactive providers as well: Tick to include inactive Providers
   
5. Exclude allocations if original payment in this period: Tick to exclude deposits that have been created and allocated in the same reporting period
   
6. Group by Provider: Tick to group allocations by same Provider
   
7. Click OK
   
   

Report Details

1. Date Allocated: The date the deposit was allocated to an invoice
   
2. Patient Name/Card: The patient's name and card number the deposit was from
   
1. Third party name will be shown next to the patient's name if deposit was from a third party
   
3. Total Amount Allocated: The amount of a deposit that has been allocated to an invoice
   
4. Invoiced ID: The invoice ID that the deposit has been allocated to
   
5. Prv Code: The code of the provider whom the deposit has been allocated to
   
6. % Involved: The percentage of the deposit allocated to the invoice
   
7. Amount Involved: The amount of the deposit allocated to the invoice
   

Discount Categories Report

The Discount Categories Report shows all discounts that have been entered into patients' invoices/receipts over a period of time, separated by the category of discount. 

1. Double click to open Discount Categories Report
   
2. Report Parameters:
   
1. Date: Select the period to base this report on
   
2. Location: Select the location or <All> to base this report on, if applicable
   
3. Providers: Select the Provider(s) to include in the report
   
4. Show inactive providers: Tick to include inactive Providers
   
5. Show Details: Tick to include details of each account name
   
6. Discount Categories: Select the categories to include
   
7. Show inactive categories: Tick to include inactive Categories
8. Click OK
   
   

Report Details 

      Summary View

      The report is separated by Providers, then by Discount Category

      

      Show Details View

      The report is separated by Providers, then by Discount Category, and includes account name

      

Efficiency of Referral Sources (Financial Results)

This report generates a list of the financial results for a selected period of time based on referral details.

A referral source must be linked to the patient for the report to generate the correct statistics.

1. Double click to open Efficiency of Referral Sources (Financial Results) report
2. Report Parameters
   
1. Date: Select the period to base this report on
   
2. Location: Select the location or <All> to base this report on, if applicable
   
3. Providers: Select the Provider(s) to include in the report
   
4. Show inactive providers as well: Tick to include inactive Providers
   
5. Click OK
   
   

Report Details

Amounts will only be shown on this report when payment has been received.

No outstanding invoice amounts will be calculated.

1. Financial Results, $: The amount generated from the referral source
   
2. Share in income, %: The % of the overall practice income received
   

GST Report

This report shows GST information on invoiced item numbers for a selected period of time.

1. Double click to open GST report
   
2. Report Parameters:
   
1. Date: Select the period to base this report on
   
2. Location: Select the location or Any Location to base this report on, if applicable
   
3. Show item details: Tick to include details of the items that incurred GST
   
4. Accrual based: Tick to only show invoiced items that incurred GST
   
5. Show ABN Only: Tick to only show information for items that incurred GST
   
6. Show totals only: Tick to show total GST amount only for each provider that belongs to the selected business entity
   
7. Business Entity: Select the Business Entity/ABN to base the report on
   
8. Click OK
   

Report Details

The report is based on paid item numbers within a selected time period that are inclusive of GST. 

1. Dated: The date of the item
   
2. Responsible Party: Person/company responsible for the payment
   
3. Account ID: Every invoice has an ID record 
   
4. Discount: Any discount given
   
5. 
   GST Due: The amount of GST due
   
6. GST Collected: The amount of GST that was paid 
   

      Show item details ticked

     

      Show item details not ticked

      

Key Performance Indicators Report (Non BIM)

This report shows the total amount of hours setup in Key Performance Indicators for each Provider, along with the total amount of invoices and receipts generated each month for the Provider. The total hours will be divided into productive and administrative hours

The report will work out the average $ amount per hour invoiced and paid to the surgery

1. Double click to open Key Performance Indicators Report
   
2. Report Parameters:
   
1. Financial Year: Select Current, Previous or Custom Financial Year to base the report on
   
2. Show totals only: Tick to show total amount only for the selected financial year
   
3. Providers: Mark the tick box to select the Provider(s) to include in this report
   
4. Show Inactive providers as well: Tick to include inactive providers
   
5. Click OK
   
   

Report Details

1. Monthly: Data in this section are monthly figures
   
2. Cumulative: Data in this section are accumulative figures from the passed months
   
3. Hours: Total amount of hours set in KPI for the Provider. This is not the actual work hour of the Provider.
   
4. Productive (Hrs, %):  Total amount of productive hours set in KPI and the percentage it takes in total work hours
   
5. Administr. (Hrs, %): Total amount of administrative hours set in KPI and the percentage it takes in total work hours
   
6. Invoices ($): $ amount of invoices generated in the month for the Provider
   
7. $/Hr: Average $ invoiced per hour
   
8. Receipts ($): $ amount of payment received in the month for the Provider
   
9. $/Hr Average $ payment received per hour
   

Production Statistics Report

Production Statistics report is used to compare the set production goals per month against issued invoices and money collected.

1. Double click to open Production Statistics report
   
2. Report Parameters:
   
1. Financial Year: Select the year to base the report on
   
2. Location: Select the location or <Any Location > if applicable
   
3. Providers: Select the Provider(s) to base the report on
   
4. Show inactive providers as well: Tick to include inactive Providers
   
5. Show Totals Only: Tick to hide the details of the report
   
6. Click OK
   

Report Details

1. For: The Provider the report is based on
   
2. Month: The month the figures relate to
   
3. Production Goal: The previous and current goals from the Providers page
   
4. Actual Issued: The previous and current issued figures
   
5. Collected: The previous and current collected figures
   

Production from Referral Sources Report

1. Double click to open Production from Referral Source report
   
2. Report Parameters:
   
1. Referral Date: Select the referral period. The referral date is taken from the first seen date 
   and
2. Production Date: Select the date. This is based in the invoice date
   
3. Location: Select the location or Any Location to base this report on, if applicable
   
1. Select Providers from the list
   
4. Tick box to include inactive providers
   
5. Click OK
   
   

      Report Details

      

1. Referral Source: The name of the referral source
   
2. Referral Date: The date of the referral (is set by first seen date of the patient)
   
3. Patient: The Patient details
   
4. Production $: The amount that was invoiced in that period
   

Receipts on "Hold" from Banking Report

Run the Receipts on Hold from Banking report to view a list of all on hold payments. 

1. Double click to open the Receipts on "Hold" from Banking report
2. Report parameters:
   
1. Location: Select the location to base this report on
2. Date: Select the period to base this report on
3. Bank Acc: Select the relevant bank account
4. Providers: Select the provider(s) to base this report on
5. Show Inactive Providers as well: Tick to include inactive providers
6. Show Hidden Bank Accounts as well: Tick to include past bank accounts
7. Click OK 
   
   

Report Details

1. Date: The date of the receipt
2. Receipt ID: The receipt ID automatically generated
   
3. Amt: The amount placed on hold
   
4. Patient: The patient the receipt belongs to
   
5. Provider: The Provider of the patient
   
6. To be banked to: The bank account the receipt should be banked to

Staff Attendance Times

The Staff Attendance Report gathers data entered by staff using the Staff Clock On Clock Off feature.

1. Double click to open the Staff Attendance Times report
   
2. Report Parameters:
   
1. Period: Select the period to base this report on
   
2. Location: Select the clinic
   
3. Staff: Select the staff member(s) to report on
   
4. Show inactive staff as well: Tick to include those made inactive
   
5. Print each staff on separate page: Tick to view/print each persons' details on a separate page
   
6. Export to Excel: Tick box if data will be exported
   
7. Click EDIT STAFF ATTENDANCE TIMES if any editing is required to a staff members times (only available to those with access/ editing permission)
   
8. Click OK
   
   

Report Details

The report will show each time the staff member has clocked on and off with a total number of hours per date.

If a staff member has clocked on and off multiple times in a day the report will show the date multiple times. 

The total number of hours worked for the period is shown at the end of the report.

1. Staff member: Full name of staff member 
   
2. DOW, Date: Day of week, and date 
   
3. Clock On: time (24hr) staff member clocked on 
   
4. Clock Off: time (24hr) staff member clocked off 
   
5. Hours: How many hours worked
   
6. Total: Overall total of hours 
   

Patient List by top paying invoices report

The Patients List by Top Paying Invoices provides a list of the top paying Patients 10 - 500. The report can be group payments by families and/or individual patients.

Considerations

Only receipts that have been allocated to an invoice will be included

Deposits are excluded until they are applied to an invoice

The report period will filter on the date of a receipt, not the date of the invoice

Refunds and Bounced payments will be shown as negative amounts

1. Double click to open Patient List by Top Paying Invoices report
   
2. Report Parameters:
   
1. Location: Select the Location, if applicable
   
2. Date: Select the period of payments received to base this report on
   
3. Provider: Select the Provider or <All> to base the report on
   
4. Show inactive Providers as well: Tick to include Providers made inactive
   
5. Family View: Select to group payments by families
   
6. Individual View: Select to show payments per individual patient
   
7. Show top: Select between 10 - 500 patients to show on the report
   
8. Click More if the report should be based on Insurance Funds of the Patients
   
9. Select the Funds to base this report on, or select and tick Exclude Selected Plans to not include them
   
10. Click OK
                                                                  

Report Details

1. Patient: The full name and Card Number of the Patient
   
2. Spent: The total amount received for completed treatment for the Patient
   
3. Provider: The Provider(s) of completed treatment which payments were allocated to
   

Total Receipts

The Total Receipts Report generates a list of all payments that have been entered within a selected date range.

The report is commonly used for end of day reconciliation and can be run from both the Reports and Bank Slips pages.

1. Double click to open the Total Receipts report 
   
2. Reports Parameters:
   
1. Location: Select the location or <All> to base this report on, if applicable
   
2. Date: Select the period to base this report on
   
3. Show totals only: Tick to view total amount only - patient details will not be shown in the report
   
4. More: Click to show all payment methods accepted by the practice. You may then select payment method(s) to be included in the report
   
5. Click OK
   
   

Report Details

      Full Details View

      

      Total Only View

      

1. Description: Payment method used within the report period 
   
2. Receipts: Total receipts amount paid via each payment method 
   
3. Refunds: Refund given via the payment method 
   
4. Bounced: Bounced payment attached to the payment method 
   
5. Totals: Total receipts amount after refunds and bounced payments
   
6. Overall Total: Total amount from all payment methods

Total Receipts with Providers

The Total Receipts with Providers Report generates a list of all payments that have been entered within a selected date range, separated by providers. The report can be found in both the Reports and Bank Slips pages.

1. Double click to open Total Receipts with providers report
2. Reports Parameters:
1. Location: Select the location or <All> to base this report on, if applicable
2. Date: Select the period to base this report on
3. Provider: Select the Provider(s) to include in the report
4. MORE: Click to show all payment methods accepted by the practice. User can then select payment method(s) to be included in the report.
5. Show inactive providers as well: Tick to include inactive Providers
6. Show totals only: Tick to view total amount only - patient details will not be shown in the report
7. Show providers from any Location: When a specific location is selected in Location field, tick the box to include providers from all locations
   
8. Click OK
   

      Report Details

           Example of Full Details Report 
            

           Example of Total Only View

            

1. Description: Payment method used within the report period 
2. Receipts: Total receipts amount paid via each payment method 
   
3. Refunds: Refund given via the payment method 
4. Bounced: Bounced payment attached to the payment method 
   
5. Totals: Total receipts amount after refunds and bounced payments 
   
6. Overall Total: Total amount from all payment methods 

Unallocated Deposits Report

The Unallocated Deposits report allows you to view all deposits for a selected period and provider/s that are yet to be allocated to treatment.

Deposits do not calculate in the accounting report until they are allocated to treatment

1. Double click to open the Unallocated Deposits report
2. Report Parameters:
   
1. Date: Select the date range
2. Location: Select the location or <All> to base this report on, if applicable
3. Provider: Select the Provider(s) to include in the report 
4. Show Inactive Provider as well: This allows you to include providers no longer working at the practice in the report (inactive)
5. Tick Payment methods box for individual selection or select all button
6. Click OK
   
   

Report Details

1. Dated: The date of the payment 
   
2. Name: The name and card number of the patient 
3. Payment method: The payment method used by patient
   
4. Inv/Rec ID: The invoice/receipt ID of the payment 
1. *If a deposit was given to a patient from a Third Party or Guardian then applied against an account, their name will be shown following the patients' name
   
5. Not allocated Deposit - Total: The amount not allocated 

Unprinted Invoices Report

This report shows a list of patients where treatment has been performed and entered into the Treatment page but is yet to be invoiced.

1. Double click to open the Unprinted Invoices report
2. Report parameters:
   
1. Location: Select the location or <All> to base this report on, if applicable
2. Provider: Select the Provider(s) to include in the report
3. Show inactive providers as well: Tick to include inactive Providers
4. Click OK
   

Report Details

1. Name: Patient's name
   
2. Prv: Treatment provider's code 
3. Date Last Seen: Last seen date of the patient 
   
4. Item: The item performed and entered in Treatment tab but not invoiced 
5. Amount: The amount/fee of the item
   
6. Card No: Patient's card number 
   
7. Home Phone: Patient's home phone 
8. Work Phone: Patient's work phone 

Upload ADA DeIDC data file

De-Identified Data Capture (DeIDC) is the system which allows the direct uploading of statistical information from member’s Dental4Web (D4Web) systems to the Australian Dental Association (ADA), eliminating the need for members to respond to the annual fees survey using paper forms manually.

1. The paper survey can be inconvenient for members and time consuming for the ADA to process.
2. It requires you to fill out a very detailed questionnaire manually, and then the ADA must data-enter it.

The security and privacy arrangements for DeIDC are identical to those for the paper survey. Names and personally identifying information are immediately stripped from the data on receipt.

1. We collect names only for the purposes of ‘ticking-off’ members who have responded, and these are discarded and not imported into any database.
2. The information we do collect is used only for aggregated statistical processing – ADA Article
   

Pre-Requisites

1. Location Setup
   A postcode must be entered for each location of the database. 
1. Click the navigation menu > Location Setup > Location page
2. Select the relevant Location if applicable
3. Enter the Post Code
   
2. Provider Setup
   All providers involved in the ADA survey must be recognised as an ADA Member in D4Web.
1. Click the navigation menu > Management > Providers page
2. Place a tick in the ADA member box
3. Repeat for all providers to be included in the survey
   
3. Submit the Survey
1. Click the navigation menu > Management > Reports page
2. Open Upload ADA DeIDC data file
3. Submit New sub-tab
4. Location: Select the location to base the survey on if applicable
5. Location Type: Select the type of practice 
6. Customer Ref #: Enter your Centaur Software Customer ID
7. Providers: Select the Providers to include in the survey. Those marked as an ADA Member in the Providers tab will automatically select.
8. Click SUBMIT
                               
9. Click OK to consent or CANCEL to exit
     
4. View Submitted Survey
1. Click the navigation menu > Management > Reports page
2. Open Upload ADA DeIDC data file
3. View Submitted sub-tab
   
   
4. Date: The date of the survey
5. Receipt No: The receipt of the survey submission
6. Status
1. Successful: The survey was successfully submitted
2. Error: See error reasons below
1. Error Code 100: Timeout error, suggest to retry submission
   
2. Error Code 200, 300 and 310: Contact Centaur
   

Links to other Reports:

1. Automated reports in D4Web
   
2. BIM Reports
   
3. Patient Related reports
   
4. Clinical Reports
   
5. Fees, items & Expense Reports (link coming soon)
6. Health fund & Insurance Reports (link coming soon)