Financial Detailed Reports in D4W

Financial Detailed Reports in D4W

Financial Detailed reports are a collection of reports covering a range of different financial data. 

Prerequisites

Prior Period Lock must be enabled, and the Prior Period date must be higher than 01/01/2000.

Financial Detailed Report for Revenue

The Financial Detailed (FD) Report for Revenue allows the user to view all invoices raised for a period in a selected location.

Run the Report
  1. Go to Location Management > Reports tab
  2. Open FD Revenue Report 
    1. Date: Select the period to base this report on
    2. Location: Select the Location or <All Locations> from the drop list if applicable
    3. Location Page Break: A new page will start for each Location
    4. All Transactions: All transactions will be included in the report
    5. All Adjustments: Not applicable for this report.
    6. PP Adjustments only: Not applicable for this report.
    7. Click OK 
               
Report Details


Transaction ID: The invoice/receipt ID
Transaction Type:  The type of transaction: Invoice - Invoice OR TR-Invoice - Treatment  Refund Invoice
Effective Date: Date of the original transaction
Customer: ID of the patient
Resp. for Installment: Main Responsible Party
Benefit Revenue Incl. GST:  Adjustments made to invoice installments where the Main Responsible Party is an insurance fund
Benefit GST:  GST on adjustments made to invoice installments where the Main Responsible Party is an insurance fund
Gap Revenue Incl. GST: Adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund
Gap GST: GST on adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund
Non-Clinical Revenue Incl. GST: Adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund and where the item contains an alphabetical code
Non-Clinical GST: GST on adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund and where the item contains an alphabetical code
GST Liability: GST of items included in invoices

Financial Detailed Report for Prior Period Adjustments

The Financial Detailed (FD) Report for Prior Period Adjustments allows the user to view all adjustments made to any record where the original date is during a prior locked period in a selected location.

Run the Report
  1. Go to Location Management > Reports tab
  2. Open FD Prior Period Adjustments Report 
    1. Date: Select the period to base this report on. This date refers to the date of the adjustment.
    2. Location: Select the Location or <All Locations> from the droplist if applicable
    3. Location Page Break: A new page will start for each Location
    4. Click OK   

Report Details


Transaction ID: The invoice/receipt ID
Transaction Type: The type of transaction:
                               Payment = Receipt
                               Invoice = Invoice
                               Discount = Discount
                               TR-Invoice = Treatment Refunded from Invoice
                               TR-Payment = Treatment Refunded from Receipt
Effective Date: Date of the original transaction
Benefit Revenue: Adjustments made to invoice installments where the Main Responsible Party is an insurance fund
Benefit GST: GST on adjustments made to invoice installments where the Main Responsible Party is an insurance fund
Gap Revenue: Adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund
Gap GST: GST on adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund
Non-Clinical Revenue: Adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund and where the item contains an alphabetical code
Non-Clinical GST: GST on adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund and where the item contains an alphabetical code
Debtors+Creditors: Debts of Patients - Debts of Location
GST Liability: GST of items included in invoices
Discount: Discounts entered into invoices
GST on Discount: GST on discounts entered into invoices
Other Payments: Payments made to invoice installments where the Main Responsible Party is NOT an insurance fund
Paid by Fund: Payments made to invoice installments where the Main Responsible Party is an insurance fund

Financial Detailed Report for Payments (Receipts)

The Financial Detailed (FD) Report for Payments allows the user to view all receipts for a period in a selected location.

Run the Report
  1. Go to Location Management > Reports tab
  2. Open FD Payments Report 
    1. Date: Select the period to base this report on
    2. Location: Select the Location or <All Locations> from the droplist if applicable
    3. Location Page Break: A new page will start for each Location
    4. All Transactions: All transactions will be included in the report
    5. All Adjustments: Any transaction entered with a date prior to the current period lock date. This also includes any adjustments to deposits created in a previous lock period. The date range for this report is based on the date of the modification, not the original transaction.
    6. PP Adjustments only: Any adjustment made to a transaction originally created in a prior period. The date range for this report is based on the date of the modification, not the original transaction.
    7. Click OK    
       
Report Details


Transaction ID: The invoice/receipt ID
Transaction Type: The type of transaction: Payment - Receipt OR TR-Payment - Treatment Refunded
Effective Date: Date of the transaction
Payer: Name of the responsible party
Other Payments: Payments made to invoice installments where the Main Responsible Party is NOT an insurance fund
Paid by Fund: Payments made to invoice installments where the Main Responsible Party is an insurance fund

Financial Detailed Report for GST

The Financial Detailed (FD) Report for GST allows the user to view all GST invoiced for a period in a selected location.

InfoSee Setup GST (link coming soon) for more information on setting up GST on items.

Run the Report
  1. Go to Location Management > Reports tab
  2. Open FD GST Report 
    1. Date: Select the period to base this report on
    2. Location: Select the Location or <All Locations> from the droplist if applicable
    3. Location Page Break: A new page will start for each Location
    4. All Transactions: All transactions will be included in the report
    5. All Adjustments: Not applicable for this report.
    6. PP Adjustments only: Not applicable for this report.
    7. Click OK  
                                                     

Report Details


Transaction ID: The invoice/receipt ID
Transaction Type: The type of transaction: TR-Invoice - Treatment Refund Invoice OR TR-Payment - Treatment Refunded OR Discount - Discount assigned to an invoice
Effective Date: Date of the original transaction
Customer: ID of the patient
Benefit GST: GST on adjustments made to invoice installments where the Main  Responsible Party is an insurance fund
Gap GST: GST on adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund
Non-Clinical GST: GST on adjustments made to invoice installments where the Main Responsible Party is NOT an insurance fund and where the item contains an alphabetical code
GST Liability: GST of items included in invoices
GST on Discount: GST on discounts entered into invoices

Financial Detailed Report for Discounts

The Financial Detailed (FD) Report for Discounts allows the user to view all discounts for a period in a selected location.

Run the Report
  1. Go to Location Management > Reports tab
  2. Open FD Discounts Report 
    1. Date: Select the period to base this report on
    2. Location: Select the Location or <All Locations> from the droplist if applicable
    3. Location Page Break: A new page will start for each Location
    4. All Transactions: All transactions will be included in the report
    5. All Adjustments: Not applicable for this report.
    6. PP Adjustments only: Not applicable for this report.
    7. Click OK  

Report Details


Transaction ID: The invoice/receipt ID
Transaction Type: The type of transaction: Discount - Discount applied to an invoice
Effective Date: Date of the original transaction
Customer: ID of the patient
Resp. for Installment: Responsible Party of the Invoice
Debtors: Amount of the transaction
Discount (Incl GST): Total amount of the discount
GST on Discount: GST component of the invoice (if applicable)

Financial Detailed Report for Balance of Debtors

The Financial Detailed (FD) Report for Debtors Balance allows the user to view a total of all outstanding invoices (debtors) in a selected location.

Invoices stay as outstanding until a receipt and/or discount is applied.

Run the Report                          
  1. Go to Location Management > Reports tab
  2. Open FD Debtors Balance Report
    1. As on: Select the date to base this report on. Any transactions after this date will not be included in the report.
    2. Location: Select the Location or <All Locations> from the droplist if applicable
    3. Show totals only: The grand total will be displayed
    4. With bad debts: If ticked, any invoices marked as bad debt are included in the report.
    5. Click OK 

Report Details


Invoice Date: The date of the invoice
A/c No: The invoice ID
Customer: The patient's name 
Responsible Party: Responsible Party of the Invoice
Installed: Total amount of the invoice
Paid: Payments applied to the invoice
Discounted: Discounts applied to the invoice
Closing Balance: Closing balance of the invoice
Rec #: Record Number
Bad Debts: Indicates if the invoice is a bad debt
Total for: As an invoice is created and is outstanding, this balance increases
Total quantity of debtors in the selected location/s. The quantity of debtors follows the quantity of invoices. Therefore, if one patient has two outstanding invoices, they will be counted as two debtors.

Financial Detailed Report for Debtors

The Financial Detailed (FD) Report for Debtors allows the user to view all invoices for a period in a selected location with a closing balance of outstanding invoices.

Run the Report
  1. Go to Location Management > Reports tab
  2. Open FD Debtors Report 
    1. Date: Select the period to base this report on
    2. Location: Select the Location or <All Locations> from the drop list if applicable
    3. Location Page Break: A new page will start for each Location
    4. All Transactions: All transactions will be included in the report
    5. All Adjustments: Any transaction entered with a date prior to the current period lock date. This also includes any adjustments to deposits created in a previous lock period. The date range for this report is based on the date of the modification, not the original transaction.
    6. PP Adjustments only: Any adjustment made to a transaction originally created in a prior period. The date range for this report is based on the date of the modification, not the original transaction.
    7. Click OK  
                                                                   
Report Details



Transaction ID: The invoice/receipt ID
Transaction Type: The type of transaction: Invoice - Invoice OR TR-Invoice - Treatment Refund Invoice OR Payment - Payment (receipt) OR TR-Payment OR Treatment Refunded OR Discount - Discount assigned to an invoice
Effective Date: Date of the original transaction
Customer: ID of the patient
Resp. for Installment: Responsible Party of the Invoice
Debtors: Amount of the original transaction
Balance (Debtors): Balance of outstanding invoices
Total for: As an invoice is created, this balance increases. As a receipt or discount is created, this balance decreases
Overall Total: This is a running total with an opening balance. As an invoice is created, this balance increases. As a receipt or discount is created, this balance decreases

Financial Detailed Creditors Balance

The Financial Detailed (FD) Creditors Balance Report allows you to view all credits (unallocated deposits) for a period in a selected location.

Deposits stay as credits and do not calculate in the Accounting: Invoices & Receipts over a period Report as profit until they are allocated to treatment.

Run the Report
  1. Go to Location Management > Reports tab
  2. Open FD Creditors Balance Report 
    1. Date: Select the period to base this report on
    2. Location: Select the Location or <Any Location> from the droplist if applicable
    3. Show totals only: The report will show totals for the selected Location(s)
    4. Click OK        
                                                              
Report Details


Dated: The date of the deposit
Customer No: The Patient ID
Name: The patient's name
Rec ID: ID of the deposit
Unallocated Deposits: Total of unallocated deposits
#: Total number of creditors
​
​At the bottom of the report, you will see total amount of credits and total quantity of creditors in the selected location/s.

The quantity of creditors follows the quantity of receipts. Therefore, if one patient has two unallocated deposits, they will be counted as two creditors.

    • Related Articles

    • Financial, Statistical & Business Related Reports in D4W

      A range of reports covering financial data, including totals, commissions, deposits and production. 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 ...

    • Financial, Statistical & Business related Reports in Dental4Web

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

    • BIM Reports in Dental4Web

      Business Intelligence Module is designed to enhance the analysis & statistic side of reporting. In addition to the numerous standard reports available in D4Web, there are 13 additional reports available here in the BIM. Setup Procedure ...

    • BIM Reports in D4W

      Business Intelligence Module (BIM) reports which include Items preformed by a provider report, Appointed patient statistics report, Fee level financial analysis report, Huddle checklist report, Insurance financial analysis report, KPI-01 Report, Key ...

    • Patient Reports in D4Web

      There are a number reports found directly in the various Patients pages Communication Log Report View communication <sent to> and <received from> the patient Click the navigation menu > Patients > any Patients page View toolbar > Communication Log In ...