Budgets and Forecasts in QuickBooks Desktop
Vložit
- čas přidán 6. 08. 2024
- QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.intuit.com/partner...
Hector Garcia CPA shows you how to work with Budgets and Forecasts inside QuickBooks Online
00:00:00 - Intro (options)
00:00:52 - How to set up a budget (company, planning & budgeting, set up budgets) (create new budget) (step by step) (example)
00:03:10 - Copy across button (set up budgets)
00:04:03 - Adjust row amounts
00:05:20 - Reports (budgets & forecasts, profit & loss budget performance) (budget overview)
00:06:32 - Reports (budgets & forecasts, budget vs actual)
00:07:45- Customize report (modify report: profit & loss budget vs actual) (fonts & numbers)
00:09:06 - Advanced options
00:09:32 - Company (planning & budgeting, set up budgets) (advanced options)
00:11:05 - Reports (budgets & forecasts, profit & loss budget performance)
00:12:24 - How to see my budget for my expenses (customize report) (filters)
00:13:10 - Print preview
00:13:36 - Forecast
00:14:19 - How to create a new forecast
00:15:09 - Reports (forecast vs actual)
00:15:54 - Budget vs actual graph
Excerpt of QB POWER HOUR 11/17/2016 - Věda a technologie
You are a very good teacher. I get so much information from your videos. Thank you
Thank you Hector. I have watched many of your video's and you have been such a help!
delecias1 you welcome
Hector! I have long time looking your training videos. Today, I realized you are from Venezuela. Me too. You are awesone, clear explanation and very helpful videos. Thank you.
María Fernanda Sánchez :)
Thank you sue much! I was soooo looking forward to the iif export/import function. I will look for it on another video.
There is another video with in-depth budget export/import
This is really geat Hector.....you explain things so well. Thanks so much!!!
Valerie S. Mellof thanks glad you liked it
Great video. I really enjoy your videos. You are amazing ! Very helpful, very useful and informative
Thanks!
thank you so much!
This was a great video. Thank you
Thanks.
very nice straightforward presentation
first last thanks
Thank You Hector!
You're welcome
Hector is great!!!
Linda Huffaker thanks...
Great teaching - What could cause the new budget to not matching the Overview?
thank you
You welcome
Nice budgeting intro to a QB budgeting noob like me. May tell some friends...Thanks!
+Jeff Wynn :)
Once i have chosen "no additional criteria" ... it says a budget already exists, can i delete and start fresh as it opens up blank ready to be filled in?
I’m very new with QB. How do I create a budget for a small corporation for the very first time considering this pandemic. Corporation has operated for sometime.
this video is very helpful to me. just want to know if quickbooks has a budget forecast per Item that you sell? not the total amount of Sales only.
maria carmina Cruz not “per item” no
Is there a way to do a 10 year projection?
How do I create a short cut for 'Set Up Budgets'?
Hector, I am enjoying these QB you tube videos! What if the company is run on a Fiscal Year beginning in July and not January?
+Norma Smoley change it in the company settings
Hello, Is quickbooks Entrprise on sale now? how much is it? Please let me know
Hi Hector how I can do my budget from May to Dec instead the fiscal year default on Quickbooks pro 2018?
Silverion26 gaming and vlogs it’s by year and by month
Hi Hector, For the Profit and Loss Budget Performance Report, does it matter how you input the data into the budget? For example - can you put all of the budget into January or does it need to be spread over 12 months for that report to work correctly? Also, we are going to import the budget from Excel. If we do decide to put the budget all into January, will that work for an import? We would just need to put zeros for the other months? Thank you!
12 months
If a company uses QBO but also has QB enterprise for other entities can you upload the information from the entity that uses QBO to use this forecast option?
Yes, but conversions are very imperfect, I wouldn’t use this as a practice. Get a cash flow tool for QBO
Hi Hector. Very helpful video. Thank you. I need to set up new accounts for the 2021 budget, I set up the budget with the information from the previous 2019 Profit and Loss by Account Budget. However, I have new accounts to be added to the 2021 Budget. Please, could you tell me how can I add these new accounts to the Budget that I am creating? I would appreciate your guidance.
Go back and edit the budget
@@HectorGarciaCPA Thank you for your quick reply. Could you give me more details? Do I need to edit the budget from the previous year? I am trying to edit the accounts and It doesn't allow me.
@@mariafernandasanchez6459 Not sure what you mean, just edit the budget you want whatver year you need.. and add the numbers to the accounts you want.
@@HectorGarciaCPAThank you. I mean add new accounts in the Budget from the Chart of accounts.
can you do sales forecast by customer/by product as part of overall forecast? and does quickbooks offer cash flow forecast based on P&L forecast and credit terms with customers and verndors
O S you can’t do that in QB
@@HectorGarciaCPA thanks. by any chance, can you suggest one, as it will make my life a lot easier. currently im on xero, which is ok but lacks the above-mentioned feates
Hector, do you know if it's possible to internally bill another division of same company in QB?
No..
There are some funky workarounds you could do with journal entries and classes... but the bill function, not really
Is there anyway to just export a budget for a specific class?
I have never tried it
How can I export my information from an Excel to quickbooks?
Use an app called Transaction Pro Importer
text