I'm using Sage 50 and my client wants a breakdown of rent and rates shown on the P&L when I print it. Is this possible and how would I obtain a report?
This should be quite simple, you need to set up a new nominal account for Rates and change the description for the existing one from Rent and Rates to just Rent.
You can create a new nominal code by clicking on the nominal ledger and then click on New button and the wizard will guide you through it. Remember to look up the original nominal code, I think it is 7100, so you could make the new one 7101 for example and call it rates.
Or maybe just print a Nominal Activity Report for the existing 'Rent & Rates' Nominal that you have posted everything too already? That way you and your client can see a breakdown of all of the postings to that account for the year.
That's just half the job though to what you are needing.
Going off memory here as we use our own reporting system (bit more grunt & easy to use) rather than Sage's but I'm quite sure after you follow Richard's instructions you'd also need to go into the Chart of Accounts and have to separate it into another line/category for the Sage P&L reporting to pick up on it... as it doesn't just pick up every single account from the Chart/TB.
