General ledger lists and reports
The general ledger is read through lists (which open on screen and can be exported), printed reports, and board tiles. Each is listed here with its menu place and the criteria it asks for. A star marks a criterion that must be filled. How lists, boards and reports behave in general is on Lists, boards and reports.
Statements and trial balances (lists)
| List | Where | Criteria |
|---|---|---|
| Trial Balance | General Ledger › Chart of Account | Date*, Account Group, Account Nature, Account, Reporting Structure, Posting Layer (starts as FR), Posting Status, Currency, Required Zero Values, Exclude Financial Year Closing, Required Reversal |
| Trial Balance Detail | General Ledger › Chart of Account | Date*, Account, Account Group, Account Nature, Reporting Structure, Posting Layer, Posting Status, Currency, Required Zero Values, Exclude Financial Year Closing, Required Reversal, and the currency to show amounts in |
| Trial Balance (Legacy) | General Ledger › Chart of Account | Date From*, Date To*, Reporting Structure, Posting Layer, Posting Status, Required Zero Values, Required On Structure, Exclude Financial Year Closing, Required Reversal |
| Trial Balance Detail (Legacy) | General Ledger › Chart of Account | Date*, Account, Reporting Structure, Posting Layer, Posting Status, Currency, Required Zero Values, Exclude Financial Year Closing, Required Reversal |
| Balance Sheet | General Ledger › Chart of Account | Comparison (none, or earlier periods), Date To*, Posting Layer |
| Income Statement | General Ledger › Chart of Account | Comparison, Date*, Reporting Structure |
| Cash Flow Statement | General Ledger › Chart of Account | Comparison, Date* |
| Cash Receipts & Payments Statement | General Ledger › Chart of Account | Date*, Account |
| Operating Expenses | General Ledger › Chart of Account | Date*, Account, Account Group |
What the criteria do:
- Posting Status - leave empty for all, or pick Posted to leave parked vouchers out.
- Required Reversal - include reversed vouchers and their reversals. Left unticked, both are left out.
- Required Zero Values - show accounts with no balance too.
- Exclude Financial Year Closing - leave out vouchers of the year-closing journal nature.
- Reporting Structure - lay the figures out by the dimensions of a Reporting Structure.
How the statements are built:
- The Balance Sheet groups accounts by nature, category and sub-category. Every revenue and expense account's balance is shown under the Retained Earning Account of General Ledger Setting, so the sheet balances without a closing entry.
- The Income Statement groups by the Account Category set on each account in Release Account in Legal Entity: Operating Revenue and Cost of Sales give Gross Profit; Operating Expenses and Other Expenses give Net Operating Income; Other Income gives Net Income. An account with another category, or none, falls outside these three groups.
- The Cash Flow Statement treats the accounts of the sub-categories on the Cash flow tab of General Ledger Setting as cash.
- Vouchers that were rejected in an approval, and cancelled vouchers, are left out of the trial balances.
Accounts and vouchers (lists)
| List | Where | Criteria |
|---|---|---|
| Chart of Accounts | General Ledger › Chart of Account; also › Financial | None |
| General Ledger Accounts | General Ledger › Financial | Chart |
| General Ledger Accounts In Legal Entity | General Ledger › Financial | Chart, Account Nature, Account Group, Account Category, Account Layer, Account, Bank |
| General Ledger Accounts In Legal Entity - Dimensions | General Ledger › Chart of Account | None |
| Vouchers | General Ledger › Chart of Account | Voucher No, Posting Status, Posting Date, Transaction Journal, Account |
Tax (lists)
| List | Where | Criteria |
|---|---|---|
| Tax Code GL Integration | Tax Controlling › Tax | None |
| Withholding Transaction | Tax Controlling › Withholding Tax | Withholding Tax Code, Withholding for, Payee, Posting Date, Type, Show Pending Only |
Printed reports
| Report | Where | Criteria |
|---|---|---|
| Voucher | General Ledger › Chart of Account | Voucher No, Transaction Journal, Posting Date, Account, Posting Status, Show Dimension |
| Chart of Accounts | General Ledger › Chart of Account | Chart |
| Trial Balance Detail | General Ledger › Chart of Account | Legal Entity, Account Nature, Account Category, Account Group, Account, Date From*, Date To*, Posting Status, Posting Layer, Required Zero Values, Required Reversal, Language, Show Dimension |
| Cash Activity | General Ledger › Chart of Account | From Date*, To Date*, Account*, Posting Status, Posting Layer |
| Income Statement (Legacy) | General Ledger › Financial | Date From*, Date To* |
| Balance Sheet (Legacy) | General Ledger › Financial | Date To* |
| Trial Balance, Journal Voucher | Not on the menu | Trial Balance: Account Nature, Account Category, Account Group, Account, Date From*, Date To*, Posting Status, Posting Layer, Required Zero Values, Required Reversal, Language. Journal Voucher: Voucher No, Posting Date |
Board tiles
The Finance board: Revenue, Expenses, Net profit, Gross margin, Cash and bank, Revenue, expenses and profit by month, Cash in and out by month, Expenses against budget by month, Receivables aging, Payables aging, Top expense accounts, Inventory value, Production: material used and output by month.
The Executive Overview board: Revenue against Budget, Gross Margin, Cash and Bank, Receivables Outstanding, Payables Outstanding, Stock Value, Revenue against Budget by Month, Revenue and Gross Margin by Month, Collections against What Fell Due, Receivables Aging, Payables Aging, Production Orders, Stock Cover.
The Management Overview board: Revenue against Budget, Cash Recovered, Open Quotations, Open Sales Orders, Inventory on Hand, Expenses against Budget, Revenue by Business Area, Revenue and Budget by Month, Top Customers, Quotation Age, Open Quotation Register, Sales Order Age, Open Sales Order Register, Receivables Aging, Collections against Due, Item Receipt by Business Area, Open Purchase Orders, Top Vendors by Invoiced Value, Stock Movement, Stock Value by Group, Expense Tree, Expenses by Dimension.
Related
- Month-end close - the trial balance and statements are read at the end of the close.