HOME / COMMUNITY Switch to knowledge base

Business Planning


#1

Busy trying to put together a cashflow forecast and I am been asked for figures per month ie how much did I spend on marketing in January, how much in February etc. Is there an easy way to see this in QF?


#2

The “custom reports” section can do this. You need to look up the nominal codes you’re interested in from the chart of accounts - e.g. marketing is 6200, advertising is 6201. So you can create a custom report with a formula like:

-1*(6200+6201)

(the -1 because purchase codes are debit, which come out in custom reports as negative numbers). When you save the report it will initially show as a cumulative line graph, but if you click the bar chart icon at the top and change the drop-down to “months” then it should show what you wanted.