A Trial Balance report can be produced based on Analysis Code, this will provide a higher level of reporting of nominal values, grouping into logical blocks and flexibility in the ordering of the Analysis Codes shown.
To find this report got to Accounts -Nominal Ledger- Reporting -Trial Balance by Analysis Code
Each Nominal Code is associated with a single analysis code, which has a description and an alpha numeric or numeric code, just like a nominal code. These have formerly been known as Categories in the Pinewood DMS and going forwards will now be known as Analysis Codes.
To look at the setup of the Analysis Codes go to Accounts > Nominal Ledger > Ledger Parameters and click into the Analysis Codes tab:
The codes will now automatically pull through with the default blank search on and to narrow this down you are able to filter by code, name, report, status, type, sign and posting/total. These Master Nominal codes associated to the Analysis Codes are the codes that will have their balances displayed on the Trial Balance by Analysis Code report.
Users are able to filter the report using an Analysis code range, Period, Report Type, All Values or Non-Zero only, Location, Nominal Type and users can tick to group the report by nominal type. To hide the search criteria, click the button and this will allow more of the report to be viewed on one page. The report is able to be exported or printed by using the buttons at the bottom of the screen. Click Display to view the report. The reset button will clear the search criteria applied. Once run, each section is collapsible by clicking the report will display the Code, Description and Nominal Type. Then the Figures will show the Period Debit and Credit and YTD Debit and Credit: The figures on the report are displayed at a division level
To view further detail on a figure double click the figure in the report: These can then be further drilled into for the report to display the exact transactions behind the figures:
If you have short code reporting enabled in the system, upon drilling in from the Trial Balance by Analysis Code report it will display a company structure view: The figures at the base of the report will display as below: The Analysis Codes report will only highlight differences between credit and debit values if any are present.
This will highlight any imbalance between the two, however these should usually balance so this report will immediately show any out of balance. Therefore, the figures will not match the normal trial balance totals, so please note that these will not match and should not be compared against each other as they will not reconcile back to one another. The reason for this is the totals calculated from the sum of debit and credit values in the Analysis Codes Trial Balance report are highly likely to differ to those shown in the trial balance by code report.