cancel
Showing results for 
Search instead for 
Did you mean: 
frcfire
Level 1

Budget vs Actuals Report

We have four bank accounts that are managed in QBO. I want to use just two of them for our operations budget. The other two are strictly for capital improvements. How can I distinguish the operations budget transactions from the capital transactions? All transactions are showing up in my operations budget and throwing off our numbers. 

1 Comment 1
KimberlyS
QuickBooks Team

Budget vs Actuals Report

I can discuss how data populates in the Budget vs. Actuals report, frcfire. Let me provide the details here, including the report that helps achieve your goal.

 

In QuickBooks Online, the Budget vs. Actuals report will show all your business transactions from different bank accounts to compare your accounts and account total. This way, you'll determine when you're under or over the budget.

 

To distinguish your operations budget transactions from the capital improvement activities, you can run the Transaction Detail by Account instead. With the appropriate customization, displaying specific accounts and corresponding entries is possible.

 

Here's how to modify the report if you're in the modern view:

 

  1. Head to Reports on the left pane.
  2. Enter and select Transaction Detail by Account in the Find report by name field.
  3. Select the appropriate date range from the Report period drop-down and choose an Accounting Method.
  4. In the Funnel icon, pick Account, equals, then the bank accounts in each designated drop-down.

 

Transaction Detail By Account 101.png

 

Otherwise, please refer to this material for the step-by-step process: Customize reports in QuickBooks Online.

 

Moreover, consider memorizing your reports to save their current customization settings, which you may send via email on a recurring schedule.

 

I'll keep monitoring this thread for other questions about generating reports in QuickBooks Online. You can leave your queries below and expect immediate responses with all the possible help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us