Business Planning

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?

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.

1 Like