Nominal Ledger

Sage 200 Reporting  –  Sage 200 Reports:

Nominal Ledger

If Pay-As-You-Go is not for you why not contact your business partner to see if they would commission a report on your behalf. We will be cheaper than the ‘free’ reports offered by Sage under their Sage Services contract!

Ref: Title Fee £ Details View PDF
101
N/L Transaction Listing linked to Sales Ledger and Purchase Ledger Transaction Lists by URN 149 >>>>> View Sample Print
Each Nominal transaction will link to either a Customer or Supplier account or none.  Non linked transactions have the space reserved for the linked account suppressed.
104
Journal Listing – selected Journal numbers shown in sequence (History and Current combined 99 >>>>> View Sample Print
Data has been filtered to only allow transactions with a Reference field between “J” and J09999999999”.  Transactions under the same reference number may not all fall in the same period and may also have been archived.
112
Nominal Ledger Trial Balance across 12 Periods and 3 Years. (Current and Previous 1 & 2) P.O.A >>>>> View Sample Print
This new report addresses the wish to see all of the 12 periods across the page on a Trial Balance.
123 Profit and Loss Report (MTD-YTD) split across Cost Centres 199 View Sample Print
The standard Sage report has been modified to print in portrait and adapted so each reported Cost Centre has the same full FSL format as when a P & L report is created when all cost centres and departments are not split out.
124
 
Nominal Ledger JOURNAL Transactions Listing 99 >>>>> View Sample Print
This quick report has been created by filtering the data for NLPostedNominalTrans.Source  to be either 3 or 99.  The transactions are then grouped by NLPostedNominalTrans.Reference to report back all the linked transactions with the same REFERENCE.
125
 
Nominal Ledger Trial Balance (Posting A/Cs) – Consolidate  199 >>>>> View Sample Print
This report addresses the wish of many auditors to consolidate the Cost Centre and Department figures into a single Nominal Account on the Trial Balance.  When run the user has the option to display all the details or consolidate.
126

Reports 104 and 124 (Journal Listings)
149 >>>>>  
Companion Pack 
130

Reports 112 and 125 (Trial Balances)
250 >>>>>  
Companion Pack
140

Nominal Ledger Module Settings – Printout 10 >>>>>  
This report addresses the wish of many auditors to consolidate the Cost Centre and Department figures into a single Nominal Account on the Trial Balance.  When run the user has the option to display all the details or consolidate.
164
Nominal Ledger Budgets Report (Detailed) 149 >>>>> View Sample Print
This report has been designed to report back the Current and Future budget figures held against each Nominal Ledger posting account. Show More There are six sets of budget figures that can be set – Current, Next year, Next Year +1, Next Year +2, Next Year +3 and Next Year +4.  Note: the system holds the ‘Years Relative to Current’ as a number.  0 = Current, 1 = Next Year …. The Drop-Down options against the criteria have converted these numbers into their related text.
169 N/L Transaction Listing linked to SL and PL Transaction – Summary by Customers and Suppliers  149 >>>>> View Sample Print
Following the Sage ROTM for January 2019 to attempt to summarise transactions for each nominal code by supplier. Previous report #101  Show More has been reworked to provide a summary for both customers and suppliers in a single report.  Sage’s attempt links the purchase order line’s ‘NominalAccountRef’ field – this is not necessarily the actual code the posted transaction uses.  Also, links to the other nominal codes such as the control and VAT codes, will not be linked.

174

Nominal Ledger Single Line Trial Balance (12 Periods) – This Year

149

>>>>> View Sample Print
This new report addresses the wish to see all the 12 periods across the page on a Trial Balance.  This new version of previous report 112 Show More has been re-designed to report back the current year periods only. The running YTD figures have been dropped and a new YTD column added to show the YTD after the last selected period is reported.
177
Nominal Ledger Trial Balance across 3 Years. (Current, Prior Year and Previous Prior Year) P.O.A >>>>> View Sample Print
This new report addresses the wish to see all three years with MTD & YTD values across the page on a Trial Balance.  The years relative to the current year selected for this report are 0,-1 and -2.

186 Transaction Listing – combining the  History and Current transactions into a single report 149 >>>>> View Sample Print
This new report addresses the request to report across both the archived and current transactions when period transactions have been split across historical and current when the Year End has been performed. 
196 Nominal DEBTORS CONTROL transactions not matched in Sales Transactions F.O.C. View Sample Print
Created to help reconcile the ledgers at Period End