Ledger Report: Overview

This Manual will give an overview of the Ledger Report.

All transactions must be posted to a ledger account in financial terms.

A Ledger account is a financial book (or record) for collecting historical transaction data from a journal and organizing entries by account.

Ledger account is summarized in types, for example:

  • Income Ledgers.
  • Expense Ledgers.
  • Current and Fix Asset Ledgers.
  • Liabilities Ledgers.
  • Sundry Ledgers.
  • Capital and Long-term ledgers.

The ledger report is a report of all the accounts of your business and is primarily used for monitoring the financial activity of your business. It details all business account and account activity during a period.

The ledger report contains the account summaries, including details of every transaction going in and out of your accounts. It is organized not only by date but also by account type.

The Ledger Report can be found under the Financial Reports Module.

  • The contents of this User Manual will consist of the following information:
    • Current Profile: Print Ledgers Overview 
    • Date Parameters 
    • Report Options 
  • From the Navigator click on Financial Reports


  • The Financial Reports screen will open


  • On the Menu bar, click on the 'Ledgers' menu
  • From the sub-menu select the 'Ledger Report' option


Current Profile: Print Ledgers
  • The Current Profile: Print Ledgers screen will open. 
  • The BLANK and NONAME profiles will be loaded by default.


  • Click on New to add a new profile to the list that can be customised to the needs of the practitioner.


  • Click on Edit to make changes to an existing profile set up.


  • Click on Print Direct to print the report directly to the printer without viewing the report.


  • Click on Print to Grid to view the report in a grid format.


  • Click on Set as Default to set the current selected Profile as the preferred profile 

  • Click on Options to access specific choices that can be applied to the profile. 
 

    • Rename: This allows the user to change the name of the selected profile.
    • Save As: This allows the user to change the name of the selected profile.
    • Unset Current default: Overrides the current default option that was set. 

  • Click on Close to exit the Print Ledgers profile list.


  • After selecting the profile and clicking on 'Print to grid', the 'Timespan for report' screen will open.
Date Settings

  • Select the Timespan for Report.

Please Note: The Report will always default the current Period and the Financial Year according to the computer date. The financial year is a period of twelve months used for tax or accounting purposes and for companies to determine and calculate their budgets, profits, and losses, for example, the South African tax year, runs from 1 March until 28/29 February of the following year unless specified that the client has their own financial year-end date.

  • Check that the Financial Year is correct.
  • Select the Type of Dates (From the beginning when the system was used until the date in this section). The Ledger Report can be pulled for All dates (the period the Practice has been running for) or between dates. 
  1. All dates - The financial period.
  2. Between Capture dates - The date the transaction was captured on the system.
  3. Between Transaction dates - The date the service took place, the goods purchased, the patient treated or payment done or received.

  • Ledgers to print: All transactions must be posted to a ledger account in GoodX. A Ledger account is a financial book (or record) for collecting historical transaction data from a journal and organizing entries by account. Tick the ledgers that you want to print in the report.
  • The Ledger accounts are summarized in types, for example:
    • Income Ledgers - INC
    • Expense Ledgers etc. - EXP 
  • Ledger range: Every ledger account is created with an abbreviation and a number, for example, INC 1. The ledger range is the range of the ledger accounts that you want to include in the 'Ledgers to print' report.


    Take Note: Of the differences between the types of Dates:

    1. Capture date: the date on which the transaction is captured onto the system (is not necessarily the same as the transaction date).
    2. Transaction date: the treatment date, when the patient was treated.

    • Click on the Next button to continue
    • The Print Ledgers Report will display as follows depending on the Settings and Parameters in the Report Set-up:


    Report Options 
    Mail a View
    • This option allows to e-mail the current view on the screen.


    Mail all Views
    • This option allows for an e-mail to be sent in the current view on the screen.


    Drill down

    • This option allows for the report to be exported to a CSV file.


    Print
    • Click on Print to print the report.


    • Click on the dropdown menu and select how to print the report.
      •  All Columns: Will print the report with all the columns.  
      •  Choose Columns: This allows the user to select the columns that they would like to print.
    Export
    • Click on Export to export and save the Report in an MS Excel sheet.


    • Click on Exit in order to return to the Current Profile Screen. 


    • When clicking on Print the Report will display as follows.
    • From here you have the option to E-mail an HTML/PDF, Print Preview, Save or Print the Report.


    Last modified: Friday, 17 September 2021, 3:00 PM