Coworking:General Ledger Report

Back to Coworking:Financial Management

Introduction

The General Ledger report lists every ledger "subaccount" and its debit and credit ledger entries within a given period of time.

As shown in the image above, the fields to fill in for launching this report are:

• the "Organization" for which the accounting information is required.
  Once more the accounting information provided by this report relies in the organization type selected as:
  • accounting information shown might be just related to a "Generic" organization belonging to a "legal Entity with Accounting"
  • or could be a roll-up in case of selecting either a "Legal Entity with Accounting" or an "Organization" having other organizations underneath.
• "Show Open Balances" option which will hide those entries for which the balance is zero. (Ex. removing receivables/payables entries from invoices once those have been paid.)
• and the corresponding "General Ledger" which will also rely on the Organization previously selected.

It is possible to narrow down the accounting information to be shown in the report by:

• a range of "amounts"
• a set of "sub-accounts"
• and a set of "accounting dimensions" such as business partner, product and project

Finally, it is also possible to:

• "group" the information by any of the accounting dimensions
• and enter a "Initial Page Number" for the report

Once all data have been properly entered, the "Search" button shows the outcome of the report in the same window:

• the ledger entries displayed for each sub-account are ordered by accounting date and besides the sub-account balance is shown for each ledger entry.

The arrows in the toolbar allows to navigate through the report outcome shown in the window

The General Ledger Report can also be viewed and saved in excel format and pdf format:

• Excel format by pressing on the "Export to Excel" action button of the Toolbar:
  • this format contains a list of all the ledger entries per each sub-account do not grouped therefore it is possible to group them as desired.
  • it also lists the corresponding accounting dimensions of each ledger entry.
• PDF format by pressing on the "Print Record" action button of the Toolbar:
  • this format includes an "Initial" balance of each sub-account, the "Subtotal" balance of each sub-account for the given period and calculates the "Total" balance of each subaccount.

Back to Coworking:Financial Management