4.0. GL Report

4.0. GL Report

General Ledger Module

A general ledger represents the record-keeping system for a company’s financial data, with debit and credit account records validated by a trial balance.
It provides a record of each financial transaction that takes place during the life of an operating company and holds account information that is needed to prepare the company’s financial statements.
Transaction data is segregated, by type, into accounts for assets, liabilities, owners’ equity, revenues, and expenses.


STEPS:
  1. EDIT any existing document
  2. Click on 'GL' at the bottom-left of the module
Most modules that create GL entries will have a ‘GL’ button.
This 'GL' button can be found in entries that have already been created, at the bottom left of the module.
This is to provide quick access to the double entries related to the document.


FILTERS:

Balance B/F
When using date filter Period. You have the option to enable  Balance B/F.
This will sum the values of all entries that occur before the from date in a single row.

Description
Select the amount of details in the remarks column.
Only the first row’s item description is used in Full Description.
Document
Specify which document to display in your GL.

Document Date Allows you to filter by document date, the default is to filter using Post Date.

Document Type
Allows you to choose which document type to include in the report.
Right click to select all or unselect all.

Remark
The dropdown provides the BP selection.

Account
Lets you choose which accounts to display in your GL.
Use the three dots '…' next to the bottom right of the Account box to filter specifically which accounts to display in your GL.
You can right click to choose & apply multiselect function.

Job
Lets you choose which jobs to display in your GL.
Use the three dots '…' next to the bottom right of the Job box to filter specifically which jobs to display in your GL.
You can right click to choose & apply multiselect function.
​
Show Job
Display job code

Drilling Down Documents from GL


STEPS:
  1. REFRESH your General Ledger
  2. Double-Click on your desired document to drill down.

Generating GL Report



STEPS:
  1. REFRESH your General Ledger
    You have to REFRESH every time you filter in the GL.
  2. Click on REPORT
  3. Filter to your needs
  4. Select the Style Options
  5. Click PRINT
    You can Excel/PDF your report from here.


    • Related Articles

    • 1.0. Generate Report

      LISTING REPORTS / Invoice Listing Document Listings are available for all modules in Sales and Purchase activities STEPS: Click SALES activity Click INVOICE module Select a report Click REPORT FINANCIAL REPORTS / Profit & Loss Income Statement STEPS: ...

    • 2.0. Opening GL

      Opening GL As you have not started your business yesterday, you are already operating with balances in your accounts. These need to be brought forward to system. Note: Opening Entry does not have to be completed entirely in one sitting. Opening Entry ...

    • Trial Balance/General Ledger values not matching with Ageing values.

      When comparing the Trial Balance values against Ageing, we are looking at the Trade Debtor/Creditor accounts. Ageing Report In order for the report to generate values, the Trade Debtor/Creditor accounts needs to have the following information. 'Who' ...

    • 12.0. Understanding Lot Number

      What Is The Use Of Lot Number? Lot Number is a ‘Tag’ assigned to a stock item. It can be understood as a batch number assigned to your purchase as it will separate the costing from those without Lot Number. Location Purchase> Supplier Invoice Action ...

    • 2.0. Budgeting Report

      Budgeting > Budget Group This enables you to give a name to your budget. You may have as many Budget Groups as you like. E.g. Sales 2012 Budget, Expense 2012 Budget, etc. > Budget Registration This enables you to give a name to your budget. You may ...