Question asked by Shirley Wyatt 9 years ago
I'd like an expenditure report, detailing all expenditure over certein periods. I cant seem to find one whereby I can use pdf or csv. I need the transactions with dates. Grateful for ideas. Thanks.
Ok so why not just use the expenditure section of the P&L?
You can export the P&L to excel, remove the income codes then you'll be left with expenditure by nominal code on a month by month basis.
Best answerIs the 'Expenditure by account code' report any good?
You can't export but you could copy/paste into Excel then PDF from there if needed.
Not really Kevin, as I want a list of all expenditure per month/quarter in order to compare. (So, like the report for P&L, but only for expenditure) I don't want individual account codes, as I'd be there all day
Ta, Shirley
I'm guessing you mean you don't want individual bills as opposed to individual account codes?
Hi what I meant is, I don't want to have to enter in each individual account (ie labour, marketing) in order to get a report. I need a list of ALL expenditure, in one report (detailing all expenditure) account codes with dates, in order to compare months/quarters general trends.
Ta, Shirley
But in the 'expenditure by account code' you don't actually have to select a nominal code from the dropdown. If you leave it blank you will get a report showing everything bill wise for that period. If you get it over into Excel you could then quickly filter anything out that wasn't related to an expense category of required.
So.......go to reports,expediture then?
Ah, I think I know where you mean, there are no dates here Kevin, so Management cant compare. Unless I produce a separate report for each month, which They don't want. Aaaaargh
I'm not saying it's what you're after but it's worth a look.
Yes just noticed no dates.
Shame.
I presume they want to see how the total within the nominal is actually made up instead of just the total itself?
Just the total of each code (labour, marketing, rent.............) with the related date, to compare months/quarters etc. New Company, so looking at trends.
Eeek, frustrating
Ok so why not just use the expenditure section of the P&L?
You can export the P&L to excel, remove the income codes then you'll be left with expenditure by nominal code on a month by month basis.
Best answerHi, Exactly what I DID do in the end Kevin!! Thank you so much, the fact that you'd do the same is encouraging! Shirley
I can't imagine another way of achieving it in all honesty.
We got there in the end... ;-)
Again, thank you so much, I thought there would be a report to do the job, without manipulation, but hey ho, thanks again.
You must 