Following on from his previous tutorial, David Carter now introduces two more new fields into his Sage analysis ready file the nominal categories. Having brought them in, we can now produce our Profit and Loss report.
We need to add two more items - the nominal categories - to the Analysisready.xls file we created in tutorial #3.
Click the link to download a copy of the nominal categories lookup table.
1. Contents of Sage_Lookup_Nominal_Categories.xls
This lookup table contains the Nominal Categories in the Sage demonstration company, Stationery and Computer Mart.
There are two worksheets COA and PIVOT. Click onto PIVOT.
This is a pivot table. It shows the format of the P&L report we going to produce.
Now click onto the COA (chart of accounts) worksheet. The P&L...