QB Power Hour: Budgets, Forecasts, Cash Flow Projections, and Business Plans 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...
Recorded 11/17/2016
Hector Garcia, CPA shows how to use Budgets, Forecasts, Cash Flow Projections, and Business Plans in QuickBooks Desktop
00:00:00 - Intro (agenda, about QB power hour, hosts, upcoming events, CPE & ACE process)
00:04:39 - Budgets (budget vs actual comparison report, budget by class customer: job or overall, budget YTD performance report, budget export and import via IIF) (how it works) (step by step) (example)
00:05:35 - How to set up a budget (company, planning & budgeting, set up budgets) (create new budget)
00:08:26 - Adjust row amounts
00:10:03 - Reports (budgets & forecasts, budget overview) (budget report)
00:11:14 - Reports (budgets & forecasts, budget vs actual)
00:12:30 - Modify report: profit & loss budget vs. actual (fonts & numbers) (in bright red, without cents)
00:13:44 - Advanced button (advanced options)
00:15:45 - Reports (budgets & forecasts, profit & loss budget performance)
00:17:18 - Customize report (filters)
00:17:55 - Print preview
00:18:19 - Forecast (forecast vs actual comparison report, NO forecast by class customer: job or overall, NO YTD performance report, cannot be exported and imported via IIF)
00:19:00 - How to set up or create a new forecast (step by step)
00:19:51 - Reports (budgets & forecasts, forecast vs actual) (forecast report) (modify report)
00:20:33 - Budget vs actual graph
00:21:42 - Set up budgets (export to file in excel) (file, utilities, export, lists to IIF files, export)
00:22:34 - Excel (CSV file) (import/export file)
00:24:04 - QuickBooks Desktop (file, utilities, import, IIF files, import)
00:24:24 - Budget report
00:24:55 - Cash flow forecast (baseline, inflows, outflows, no bills/invoices make it impossible to project net inflows, current balance on undeposited funds is ignored)
00:26:00 - Cash flow projector (baseline, allows you to make adjustments without affecting your books, manually enter projected expenses, several options to project income)
00:26:16 - Reports (company & financial, cash flow forecast) (how it works) (create invoice) (example)
00:30:39 - Reports (customers & receivables, average days to pay summary)
00:31:53 - Average days to pay
00:33:00 - Vendors (enter bills) (example)
00:35:43 - Cash flow projector (company, planning & budgeting, cash flow projector) (how it works) (step by step) (welcome, beginning balance, cash receipts, business expenses, accounts payable)
00:40:59 - Business planning tool (how it works) (step by step)
00:41:30 - Company (planning & budgeting, use business plan tool) (welcome, company, income, expenses, interview, plan)
00:45:17 - Profit & loss statement (5 years) (reports)
00:45:54 - Break-even income analysis (5 years)
00:46:10 - Cash summary (5 years)
In depth Budget Import/Export Video:
• Importing Budgets into... - Věda a technologie
Very thorough. Thank you for making this.
Thank you for teaching us this feature of Quickbooks Desktop.
You welcome
Video on Exporting/Importing Budgets with Excel: czcams.com/video/EVf9VXm6Sq8/video.html
Great work....Impressive and super helpful....u r smart!!!
111lainy thanks.. glad you find it useful
This is Useful tutorial . thanks
+Tavga Hawramy glad you like it
Hello Hector thank you so much for making this useful video. I just got a QB Pro 2016, how can I build a business plan on this version considering that it does not have the Business Plan tool? Please advise. Thank you.
Katumbella need accountant edition
From my perspective, one would forecast their P&L midstream during any given year. Info/data becomes known to us, for example, in the midst of the reporting year that we did not possess during budget creation. If I enter forecast data for, say, Aug thru Dec, will the QB's reporting use actuals thru July and read my forecast input for the out periods?Thank you for your help. Always enjoy your informative videos.
MrRoadcrankr not really
Hi Hector, I have budgets and forecasts in Enterprise. When downloading, there's only an option for "Budgets". The downloaded IIF contains both the budget and the forecast, however, there doesn't appear to be a field that distinguishes between the two, as the first column reads "BUD" for both budget and forecast rows. Am I missing something or it that just the way that it is? Thanks.
there is no way to import/export forecast
When working with the budget projector, this shows old bills that were already paid as past due. How can i delete these balances from the projector
Brianna T are the bills showing paid in quickbooks?
Please specify which features at only available in accountant or enterprise desktop version
Theresa Higby most of the feature here are Premier, Accountant, and Enteprise.. not Pro
@@HectorGarciaCPA Thanks Hector. Can any of the forecasting be broken down by class?
Theresa Higby no
how do i set up cost centers in quickbooks Enterprise or Pro etc.,??
Javed Shakir a CLASS is a cost center
Hector Garcia CPA thanks alot for your reply and you are doing a great job. Keep it up
Is a good video but is not working only at the begining