Sage - How to produce a detailed P&L account
I tried Sage as a bookkeeping package some 10 years or so ago and did not enjoy the experience. Since then I have avoided using Sage for clients bookkeeping and used other packages instead. However recently I decided to do one client on Sage and see how things have improved.
I have versions 12, 14, 16 and 18 to choose from and as 12 was loaded on the machine my bookkeeper sits at I opted for that one.
We have accepted the default Chart of Accounts and have entered a meaningful amount of data using the codes on the default Nominal List. Our client would like a P&L print out to show how he has done this month and the aggregate income and expenditure for the year.
We have gone to [Company][Financials][P&L][Preview] selected the whole year as the period and printed out the report.
The report includes the amount spent on
7100 - 7199 Rent and Rates Period £5,000 Year £20,000
Now both my client and I know that the R&R figure is made up of three elements
7101 Rent Period £4000 Year £16,000
7103 Water Rates Period £200 Year £1,000
7104 Council Tax Period £800 Year ££4,000
What he would like is a report which shows these figures individually and not grouped together
I rang Sage and thought I had explained what I wanted. In fact I tried hard to explain it several times.
The Sage Support told me that the only way this could be achieved is if I completely rewrite the Chart of Accounts
Sage Support also told me that they would pass my idea of a disaggregated P&L Account to the Implementation Team for possible inclusion in future releases.
I cannot believe that my client is the only user of Line 50 ever who would like a detailed P&L account. Surely I don't have to rewrite the complete Chart of Accounts to achieve this. I can see how that is done, and indeed I have started to do so but this is just re-inventing the wheel
Can you tell me if there is a report on Sage which will give the client a breakdown of what he has spent on all his different overheads - I have just picked Rent & Rates as an example but all other overheads have been similarly grouped up. The ideal is a P&L with the figures separated out
I have opened the data file in version 18 to see if that helped but the report was the same
If I really do need a new CofA can I import it from somewhere/someone else to save having to rewrite it
- Accountancy practices - are you closed over Christmas or do you let your staff take it off? 941 29
- You know its over 309 4
- HMRC BACK AND FORTH FIGHT ON BTL PROPERTY ALLOWANCES 482 9
- How do you find shareholders of a Cyprus Company ? 205 13
- Valuing my fast-growing internet business for transfer of goodwill on incorporation 160 2
- HMRC won't let me set up online DD for PAYE 149 2
- What is the amount of dividends received as a shareholder that requires registration for self assessment? 222 3
- Cocaine anyone? 498 8
- Late Registration for VAT 480 13
- EIS/SEIS 135 1
- Amortisation of Goodwill 269 1
- TaxCalc Accounts production 409 5
- Depression - HMRC penalties case won because of this illness. 415 12
- Solicitors now, Accountants next 708 10
- How come if you claim benefits you are not entitled to you either have to pay a 50% penalty or are sent to court and either fined or sent to prison (sometimes suspended) and end up with a criminal record. 550 10
- ACCA - still making me laugh 583 4
- Personal pension 398 9
- Legal Aid Agency claims and VAT 220 1
- How much of your work is admin? 1,213 11
- Petrol expenses for self-employed 166 3
- Hive up 488
- Accounting referance change & deficient accounts. 453
- corporate hierarchy 433
- Advice - 270
- Anyone had HMRC refusing to act on EPS database glitch? 223
- WWOOFers 216
- Co. limited by Guarantee now closed 205
- Art Gallery - Splitting a property between business and personal use 193
- Tax liabilities in USA for warehoused products 175
- Mutual Trading - Exempt CT Income - Do I need clearance? 172