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.
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:
Here's how to run the YTD report:
You can leave a reply if you have any follow-up questions on this. Thanks.
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:
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.
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?
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
To show the YTD budget with the percentage (%) remaining
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!
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!
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.
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!
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?
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:
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.
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:
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.
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.
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.
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!
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.