GL Financial Statement Query

Field	Description
Compare
Ledgers	Select this to perform the query on all the actual ledgers and the budgets currently available in your SYSPRO company.
Periods	Select this to perform the query for a specific ledger/budget year. You indicate this ledger/budget year using the Financial year option.
Financial year	You use this option to select the specific year's actual ledger or budget you want to query. The number of years for which the actual ledgers are available for inclusion in the query depends on the number of years for which you are retaining your General Ledger history General Ledger Setup). The number of budget ledgers available for inclusion in the query depends on the number of budgets you have defined (General Ledger Codes).
Go arrow	Select this icon to view the results of the query for all the ledgers or for the period you selected.

Financial Statement

This listview includes a treeview which enables you to select the calculation you want to perform. The results of your selection are displayed in the Financial Statement Graph pane. The listview also displays the actual values for each entry in the treeview.


	To produce accurate results from the calculations, you need to ensure that your General Ledger accounts are correctly defined. The accounts used in each calculation are included in the table below.

Field

Description

Income Statement

Individual items included in the Income Statement can be selected for graphing from the treeview. These items are listed below together with the origin of their values.

Net Sales

The sum of the Movements of the Sales Accounts less the sum of the Sales Returns Accounts less the sum of the Trade Discount Accounts as defined in AR Sales Ledger Interface.


	If your Sales accounts are not correctly defined, then all the financial statement results displayed in this query will be incorrect.

This is only available when the Sales Order module installed.

Cost of Sales

The sum of the Movements of all Cost of Sales Accounts as defined in AR Sales Ledger Interface plus the value in the Cost of goods sold adjustment account (General Ledger Integration).


	If your Cost of Sales accounts are not correctly defined, then all the financial statement results displayed in this query will be incorrect.

This is only available when the Sales Order module installed.

Gross Profit

Net Sales less Cost of Sales.

Other Revenue

Total Revenue less Net Sales,

where Total Revenue = the sum of the Movements of all G/L Accounts defined as Revenue Accounts in General Ledger Codes or GL Structure Definition.

Other Expenses

Total Expenses less Cost of Sales

where:

Total Expenses = the sum of all Movements of all G/L Accounts defined as Expense Accounts in General Ledger Codes or GL Structure Definition.

Net Profit

Gross Profit plus Other Revenue less Other Expenses.

Balance Sheet

Individual items included in the Balance Sheet can be selected for graphing from the treeview. These items are listed below together with the origin of the values.

Assets

Field	Description
Bank and other Current Assets	Current Assets less Receivables less Inventory.
Receivables	The sum of the Closing Balances of all A/R Control Accounts as defined in AR Branches. This is only available when the Accounts Receivable module is installed.
Inventory	The sum of the Closing Balances of all Inventory Control Accounts as defined in Warehouses. This is only available when the Inventory module installed.
Current Assets	The sum of the Closing Balances of all G/L Accounts defined as Current Asset Accounts in General Ledger Codes or GL Structure Definition.
Non-current Assets	The sum of the Closing Balances of all G/L Accounts defined as Non-current Asset Accounts in General Ledger Codes or GL Structure Definition.
Total Assets	The sum of all Assets.

Owner's Equity and Liabilities

Field	Description
Payables	The sum of the Closing Balances of all A/P Control Accounts as defined in AP Branches. This is only available when the Accounts Payable module is installed.
Other Current Liabilities	Current Liabilities less Payables.
Current Liabilities	The sum of the Closing Balances of all G/L Accounts defined as Current Liability Accounts in GL Structure Definition or General Ledger Codes.
Non-current Liabilities	The sum of the Closing Balances of all G/L Accounts defined as Non-current Liability Accounts in GL Structure Definition or General Ledger Codes.
Total Liabilities	The sum of all Liabilities.
Capital	The sum of the Closing Balances of all G/L Accounts defined as Capital Accounts in GL Structure Definition or General Ledger Codes.
Net Profit	Taken from the Income Statement (i.e. Gross Profit plus Other Revenue less Other Expenses).
Owner's Equity	Capital plus Net Profit
Total Owner's Equity and Liabilities	Total Liabilities plus Owner's Equity

Financial Statement Graph

This pane contains the graph of the financial calculation you selected from the treeview in the Financial Statement pane.

You may need to resize the Financial Statement Graph pane in order to view the entire graph.