Nominal reports
Note: You can also track nominal transactions by using the Nominal Account enquiries and Nominal Transaction enquiries.
Account Analysis
Use the nominal account reports to keep track of your nominal accounts and their associated transactions.
Open: Nominal Ledger > Account Analysis.
This provides details of transactions posted to the Nominal Ledger for either a single posting date or a range of posting dates. The posting date is the physical posting date of the transaction; the system date on which the transaction was entered, not the date entered for the transaction itself.
If you enter transactions using other modules and they are held in the waiting postings file for update to the ledger, the posting date is the date they were entered into the posting file and not the date they were updated to the Nominal Ledger.
This lists all or a selection of your nominal accounts currently stored on the Nominal Ledger, depending on the criteria you select when preparing the report.
There are three Account Analysis reports that provide details of your nominal account balances.
- The Account Analysis (Detailed) report is the most extensive report of the three. It analyses and displays the balances of posting and group accounts, grouping balances, where appropriate. This report show details of all posting accounts, grouped according to the group accounts you have set up, and showing the group totals. Any posting accounts that do not belong to a group will also be shown but not included in any group total.
- The Account Analysis (Summary) report only details group totals. This report will show the group accounts with the group totals, but not the posting accounts that make up the groups (use the Detailed report for that). Posting accounts that do not belong to any group will however be shown but not included in any totals, but they are shown in italics.
- The Account Analysis (Posting Accounts) report simply displays the balances for each posting account. This report will not show any group information but will show all the posting accounts (use the Detailed or Summary reports for groups). This report also includes a separate section where memorandum accounts are listed.
Use an Account Analysis report to analyse a range of accounts to obtain a balance. For example, when reconciling the Purchase Ledger to the Nominal Ledger use this report to select your creditor control accounts in a given range to obtain a reconciliation amount.
The two Transaction Listing reports provide a list of current or archived transactions on the ledger. The listed transactions are grouped with the relevant nominal account and displayed in the order in which they were added to the ledger.
You can sort the reports by date, source (Sales, Purchase, Cash Book or Nominal), URN The unique reference number assigned to a complete transaction to assist in tracing the progress of the transaction through Sage 200. This number is 12 digits long and comprises of: 3 digits for the user number, 2 digits for the source module in which the transaction was created, and a 7 digit sequential reference number. and user name. You can even enter a minimum balance to identify accounts by the status of their balance.
You can choose to display Transaction History (Current) or Transaction History (Historical) reports. Current transactions have not yet been removed from the accounts by closing the period. archived transactions have been deleted from the current files by closing the period but are then stored in a transaction history file (if you have enabled Archive transactions after this period in the Ledger Settings). How long transactions remain current depends on your setting for Keep transactions for on each account.
This report details a list of nominal and cash book transactions added to the ledger during the current month, that involve VAT. You can run this report for current or archived transactions.
Specify the number of VAT months over which transactions are included. Only transactions up to 300 days old, calculated from the current system date, are included in the report. This means old transactions (transactions for the previous year) are not included in the report. Use the information printed in this report to reconcile with your VAT Return transactions for the same VAT period.
This report provides a list of unique reference numbers (URNs) allocated to transactions associated with both posting and memorandum type accounts. The report is sorted by URN and it is possible to restrict the report to a range of URNs. You can run this report for current or archived transactions.
For each URN listed, the report details the source of the transaction, the name of the user who entered the transaction, the transaction date, type and the account it was posted to. Additional details include the transaction reference assigned to it when entered into Sage 200 and its associated value, credit or debit.
Note: If the list of transactions do not balance (i.e. total credits do not equal total debits) it may be because some transactions have been deleted from the current files by closing the period. If you have different settings for Keep Transactions For, on different nominal accounts, some of the set of transactions can be deleted before others. If this happens, run the Historical version of this report for the same URN range and you may find that the missing transactions are included.
Use this to view postings that are yet to be updated to the nominal accounts.
You can see:
- Waiting postings.
- Deferred waiting postings.
Use this to view a breakdown of your nominal by department.
Use these to view journal entries.
Use this to check which nominal accounts are hidden and who changed their status.
Financial statements
You can print Profit and Loss, Balance Sheet and Trial Balance statements for the current and previous periods.
Open: Nominal Ledger > Financial Statements.
The Trial Balance includes account balance information for this month and year to date. You can produce three versions of the report:
- Detailed: This lists all group accounts and all posting accounts. Posting accounts are listed in relation to group account, if relevant. Account balances and subtotals are also displayed. The detailed report displays a Trial Balance with all accounts listed, in their group accounts and including group account subtotals. Individual posting accounts that are not part of a group will also be shown although not included in any group totals.
- Summary: This lists all group accounts. The posting accounts that are not associated with the group accounts are referred to as orphans. The associated balances are also displayed. The summary report only shows the group accounts not the individual accounts that make up that group. However, posting accounts that do not belong to a group will be shown in italics.
- Posting Accounts: This lists all posting accounts and memorandum accounts and their associated balances. The report shows all posting accounts, whether they are part of a group or not, but it does not show group accounts or group totals.
Note: If you are using cost centre breakdown, you can analyse information for your Trial Balance report, by cost centres and departments.
The statement totals the value of all your credit entries and your debit entries. As Sage 200 follows the principle of double-entry bookkeeping, these values will balance.
You can print the statement in base currency or in a different currency from the exchange rate table.
Profit and Loss is the financial statement that shows whether the organisation is trading profitably.
The balance of each income and expenditure nominal account, chosen by category code in the layout are shown with columns for the period, budget and year on year analysis.
You can produce four versions of the report:
- Detailed
- MTD-YTD
- MTD-YTD-Budgets
- MTD-YTD-Percentages
Note: If you are using cost centre breakdown, you can analyse information for your Profit and Loss report, by cost centres and departments.
A Profit and Loss report is normally printed at the end of each accounting period, and, for final accounts, at the year end. You can print one any time that you want to see the current profit or loss situation in your company as a whole, or for a specific cost centre.
You can print the statement in base currency or in a different currency from the exchange rate table.
Note: Before printing the Profit and Loss, you must have set up your Financial Statement Layouts.
The Balance Sheet shows your organisation's assets and what it owes (your liabilities). The difference between the two is the net worth of the company. The Balance Sheet also shows capital that has been introduced (such as share capital or directors' loans) and what has been retained from each year's surplus or profit after VAT, to finance the company's activities.
Information in the Balance Sheet is controlled by the Financial Statement Layouts.
The Balance Sheet always balances (capital equals assets less liabilities), because Sage 200 follows the rules of double-entry A system of bookkeeping in which every transaction of a business is entered as a debit in one account and as a credit in another. As every transaction must have an equal or zero effect on both sides of the accounting equation, every positive amount entered (debit) must be mirrored by a negative amount or amounts (credit). bookkeeping. If it does not balance, and the Trial Balance does, check the Balance Sheet layout. The chart of accounts may not fit the standard layout, or you may have created a layout incorrectly.
You can produce two versions of the report:
- MTD-YTD
- YTD
Note: If you are using cost centre breakdown, you can analyse information for your Balance Sheet by cost centres and departments.
A Balance Sheet report is normally printed at the end of each accounting period, and for final accounts, at the year end. You can print one any time that you want to see a snapshot of the current situation in your company as a whole, or for a single cost centre.
You can print the report in base currency or a different currency from the exchange rate table.
Note: Before printing the Balance Sheet, you must have set up your Financial Statement Layouts.
When you select this report, the Layout defaults to one you have created. If you have created more than one, select the Layout you want.
The Start Period and End Period default to the next period after the current open period, but you can change this selection.
A report is generated, which shows the Cash Opening Balance, Incomes less Expenditures and the Cash Closing Balance for the periods selected.
Budget comparisons
Budget reports help you analyse how effectively your company is performing against your expectations. You may have budgets set for both income and expenditure. By regular budget reporting you can quickly identify deviations from your forecasted balances.
Several budget reports are provided for you to display the current values in your nominal accounts with comparison budget forecasts and variances.
For more detailed help on budget reporting, including using the additional Excel reports, see How to report on your budgets.
Open: Nominal Ledger > Budget Comparisons.
These reports display all budgeted accounts, whether they are associated with a group or not.
The budget, actual and variance figures are shown for each account, for the year to date, this month and last month. Overall totals are shown. Posting accounts that do not belong to a group will also be reported in italics.
You can print these reports any time, to monitor the budgets you have set up, and how you are doing.
This report shows the budget figures assigned to an account, the actual expenditure on the account and the difference between both figures.
If the ledger is set to view the budget history for the last five years, you can report on these figures for next year and the previous five years. Otherwise, the report only provides figures for the current year.
You can pint this report at any time, to monitor the budgets you have set up, and how you are doing.
The Budget Statement by Cost Centre / Department reports shows the budget, actual, committed and difference (Balance) for all nominal accounts with the same cost centre / department. The report is broken down into sections per cost centre / department, so the report can easily be separated and sent to different people.
Use the Period Budgets report to check the budget figures per period that you have set for your nominal accounts. For example, you might want to compare past, current and future budget figures for a selection of nominal accounts
You can use the Budget v Actuals reports to compare your budget and actual figures, and see these grouped by cost centre, department, or the type of nominal account.
- Budget v Actuals By Cost Centre, to group by cost centre.
- Budget v Actuals By Cost Department, to group by department.
- Budget v Actuals By Nominal Type, to group by nominal account type (expense, income, asset, liability).
Tip: You can also compare your budget against actuals using the Budget vs Actuals Excel report.
Steps in this task
Design layouts for Financial Statements (Report Designer)
Maintain balance sheet and profit and loss layouts
Maintain cash flow report layouts
Overview
Reports and documents in Sage 200
Designing your own reports and documents
Other tasks
Send reports and documents by email
Reference