How to report actual expenditure vs budgeted - without income

CANUK · ‎July 11, 2022

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...

Maybelle_S · ‎July 11, 2022

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:

Click the Reports menu at the left panel.
Go to the search icon and type Transaction Detail by Account.
Select the Customize button.
Go to the Filter dropdown arrow. Then, select the Distribution account and A/R Paid.
From the Distribution account, select All Expense account.
Hit the Run report.

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.

CANUK · ‎July 19, 2022

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...

GeorgiaC · ‎July 19, 2022

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. :)

Topics

Training

Community

Resources

How to report actual expenditure vs budgeted - without income