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

Budget Reports

In QB Online how do you create a report that shows actual vs budget for month and YTD along with total year budget.  This report is available in QB desktop, but I cant figure out how to create it in QB Online.

19 Comments 19
SophiaAnnL
Moderator

Budget Reports

I'll be your guide today to generate the data you need, lnovak.

 

You can run two reports for this. One that shows the budget vs. actuals for the month, and the other for the YTD with total year budget. Just customize the report to display the YTD amounts.

 

Here's how to run the monthly report:

  1. Click Reports on the left panel.
  2. Type Budget vs. Actuals in the search box.
  3. Select the budget you want to display

 

Here's how to run the YTD report:

  1. From the same report you opened above, click the Customize button in the upper right-hand corner.
  2. Maximize the Rows/Columns section.
  3. Under Show Grid, select Accounts vs. Totals from the drop-down menu.
  4. Filter the Report period.
  5. Click Run report.

You can leave a reply if you have any follow-up questions on this. Thanks.

eappel
Level 2

Budget Reports

I don't see a place to filter the report period on this report.

vpcontroller
Level 11

Budget Reports

@eappel

 

That's true. You will need to manually change the dates for report period you want and click Run report.

Berlee
Level 2

Budget Reports

Is there way to combined both the monthly and YTD total on one page report?

IamjuViel
QuickBooks Team

Budget Reports

Greetings, @Berlee.

 

Allow me to furnish you with some details on how you can generate your account's budget report.

 

Yes, you can combine both the monthly and YTD total on one page report. Just make sure to customize how you want to view the report by selecting Show Grid options of:

  • Accounts versus Months
    147.jpg
  • Accounts versus Quarters
    12345674.gif
  • Accounts versus Totals
    159.jpg

Here's how:

  1. Go to Reports.
  2. Under Business Overview, select Budgets vs. Actual.
  3. Click the Customize button.
  4. Go to Rows/Columns section.
  5. Under Show Grid, choose Accounts vs. Months.
  6. Click Run Report.

That should do it! You can always feel free to visit us here in the Community if you have other questions about generating your YTD Budget reports in QuickBooks Online. I'm always here to lend a hand.

Berlee
Level 2

Budget Reports

Thank you for explaining those different views. I'm specifically wanting one column for the current month only and the second column to be YTD with the % of total remaining. Does that make sense or is there a way to generate this type of report thru QB Online?

AldrinS
QuickBooks Team

Budget Reports

Hi there, Berlee.

 

I'd like to join this discussion and provide additional clarification regarding this matter.

 

Yes, the additional details that you mentioned do make sense. However, while we don't have a way to show the Actuals for the current month and the Year-To-Date (YTD) total on one report, I highly suggest the workaround suggested by my colleague SophiaAnnL.

 

Although, instead of pulling up two reports, we could just use one report and customize it appropriately to get this information. Here's how:

 

To pull up the Actuals for the current month

  1. Click Reports on the left panel.
  2. In the Business overview section, select Budget vs. Actuals.
  3. Click the Customize button.
  4. Change the Report period as necessary.
  5. Maximize Rows/Columns.
  6. From the Show Grid drop-down menu, choose Accounts vs. Total.
  7. Click Run report. From there, you could either select the Print icon to print, or the Export icon (right next to the Print icon) to export to Excel.

To show the YTD budget with the percentage (%) remaining

  1. From the same report, click the Customize button in the upper right-hand corner.
  2. Change the Report period as necessary.
  3. In the Rows/Columns section, check the $ Remaining and % Remaining checkboxes.
  4. Click Run report. You may also print or export this report, just like the previous one.

Please let me know if this isn't quite what you're looking for. I've got your back and am always happy to help you however I can. Have a great day!

Berlee
Level 2

Budget Reports

Thank you so much! Although it didn't automatically give me what I needed, your suggestion helped me customize the report I need by cut/pasting the data for the same result. Thank you, you were both very helpful!

Berlee
Level 2

Budget Reports

 

@AldrinS How do I clear VERY old transactions while not affecting the bank balance?

FritzF
Moderator

Budget Reports

Hey there, @Berlee.

 

Thanks for getting back to us. Allow me to step in for a moment and help walk you through deleting transactions in QuickBooks Online (QBO).

 

To make sure I'm on the same page, are you referring to deleting transactions from the For Review screen? If so, here's how:

 

1. Go to the Banking menu at the left. then Banking.
2. Make sure the correct account is highlighted blue at the top of the page.
3. From the For Review tab, check the box for the transaction(s) you'd like to delete.
4. Click the Batch actions drop-down, then choose Exclude Selected.

 

48.PNG

 

Once done, you can delete them by going to the Excluded tab. Here's how:

 

1. Click the Excluded tab.
2. Put a check mark in the box beside the transaction(s) you'd like to delete.
3. Select Batch actions, then choose Delete.
4. You'll be asked if you're sure. Click Yes.

 

For future reference, you can also check out these articles for further guidance:

 

 

That should point you in the right direction. Please let me know how it goes or if you're referring to something in the comment section. I'm always here if you need further assistance. Cheering you to continued success!

Berlee
Level 2

Budget Reports

No, that's not exactly what I am looking for. I have recently taken over our QB Online and although the bank reconciliation has been completed/balanced monthly there are outstanding transactions that have yet to be cleared from 2014-2018. Is there a way to clear all of the old transaction while not throwing off my current balance?

Alessandra_B
QuickBooks Team

Budget Reports

Hello there, @Berlee.

 

You'll need to undo your previous reconciliation when you manually clear your transactions. Let me provide additional detail and help you from there.

 

When you manually clear transactions from a reconciled period, it'll affect your balances. You'll need to manually undo your previous reconciliations and reconcile them again to ensure that your balances are correct.

 

In QuickBooks Online, you can only undo reconciled transactions one at a time. Here's how:

  1. On the left panel, hover your mouse on Accounting, and select Chart of Accounts.
  2. Locate the affected bank account.
  3. Click on View Register form the Action column.
  4. Select the transaction and click on the Reconcile column until it is blank.
  5. Click on Save.

Also, I recommend reaching out to an accountant who has a QuickBooks Online for Accountants account. They have an option on their accounts to correct your balances without undoing a reconciliation.

 

Feel free to let me know if you have other questions about reconciliation. I'll be glad to help you.

Berlee
Level 2

Budget Reports

Thank you for your help. Is there a way to do a general ledger entry to offset the amount so that when I clear the old transactions they are balanced?

Alessandra_B
QuickBooks Team

Budget Reports

Thank you for getting back to me, @Berlee.

 

You can create a journal entry, however, it isn't advisable. Let me provide some details and help you further.

 

Creating a journal entry will not offset those transactions. Instead, it'll lead to duplication in the amounts which need to be reconciled.

 

If you want to create a journal entry, here's how:

  1. Click on the Plus (+) icon, select Journal Entry.
  2. Select the date.
  3. Enter the necessary information.
  4. Click on Save and Close.

I still recommend reaching out to your accountant regarding your reconciliation. This way, he/she can give you their best advice on how to handle your transactions and your reconciliation.

 

Please let me know if you still need help with anything else. I'll be around to assist you.

Berlee
Level 2

Budget Reports

Thank you, I really appreciate your assistance.

Anonymous
Not applicable

Budget Reports

Thanks for getting back on this thread, @Berlee. I'm glad my colleague's suggestion have helped. 

 

If you need some helpful references in the future, please feel free to visit our site: Help articles for QuickBooks Online.

 

Should you need anything else or if you have other questions about your outstanding transactions, I'm also here to help.

bmillerTFK
Level 1

Budget Reports

I find the cutting and pasting to be unacceptable.  One of the features of Quickbooks Online Advanced that made me purchase was the ability to have reports automatically emailed.  If I have to export to Excel and copy and paste just to get the report I want, this makes the scheduling and email of reports useless.  It is a fairly standard report to have current month actual vs. budget and ytd actual vs. budget on the same report.  This should be added.  We utilize the location functionality, so I cannot do the columns as months and use the total on the right hand side, as I need the columns to be locations.

Sarah Bl
QuickBooks Team

Budget Reports

Hello, @bmillerTFK. Welcome to the Community.


I want to first start by saying thank you for your feedback, it helps us improve and grow.


This isn't the impression QuickBooks wants to leave with you. I want to submit feedback with our Product Development Team, where they're always improving features in

QuickBooks that better you today and grow with you tomorrow.


I'd also like it if you'd as well leave feedback. Let me show you how:


1. You'll go back to the Gear icon.
2. Under Profile, select Feedback.


You can also leave feedback images.


Want to keep up with the newest or future updates? There's a site that states any new upgrades in QuickBooks. Just go to The Blog.


I value you and the success of your business, please come back to the Community for any other questions or concerns. Have a happy week!

lnovak
Level 1

Budget Reports

Sarah - I posted a similar comment about a year ago.  I still cant believe that a standard report showing current month budget vs actual and YTD budget vs actual is still not avaialble.  Almost every business I have ever worked with creates this simple report.  The fact that QuickBooks Online doe snot have this report avaialble is astonishing.  How many times do customers need to point out the value of this report for the dvelopment team to get this basic report completed.  it has been in the QuickBooks desktop version for a long time.  I dont understand why it is not avilable in the Online version as well.

Need to get in touch?

Contact us