Hi everyone...I have scoured the internet and QB forums but I can't find the answer to this query - maybe because I don't have the right language/terms to describe it (please be understanding of my layness!).
In QBO Plus, I can't figure out how to report on budgeted expenditure Vs actual expenditure - without income changing the reported budget! I just want to know if we spent what we expected to spend, never mind what income we get.
Our forecasted income is currently making our budgeted expenditure very confusing - with minus budgets because we're forecasting expenditure before income etc. What I want is something fairly simple for all classes:
July 22, budgeted spend £200 in Class Green - actual spend: £150, underspend for month: £50 accrued budget balance: £50
August 22, budgeted spend £200 in Class Green - actual spend: £40, underspend for month: £160, accrued budget balance: £210
At this rate I'm tempted just to delete all forecast income entries into the budget so I can get the report above rather than the mess attached...
Hi there, @CANUK.
I can help you show o how to pull up a report in QuickBooks Online.
I suggest running the Transactions Detail by Account. From there, you can customize the report to show the unpaid A/R or the open advances on account receivables.
Here's how to pull the report and customized:
Please check these articles for further information and how Budget vs. Actuals reports by class works in QuickBooks.
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
Thanks for this advice but it doesn't do what I asked for. Again - I need a report that compares what we actually spent with what we thought we'd spend. As simple as that. The Budget vs actuals doesn't give me this because it takes income into consideration. Please re-read my first post about what is needed and advise - thanks so much!
I'm sure this basic need can be fulfilled by QB...
Hi CANUK, thanks for getting back to us - you can remove the income accounts from the Budget vs. Actuals report using the customise tool - to do this, click customise > filter > scroll down and check all accounts that you would like to show on the report. Please get back to us if you're needing any further help. :)