QB Power Hour: Budgets, Forecasts, Cash Flow Projections, and Business Plans in QuickBooks Desktop

Description:

In this video we show to you how budgets, forecasts, cash flow projections, and business plans works in QuickBooks Desktop

Video:

Table of contents:

  • 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)
Hector Garcia

Hector Garcia

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published.



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022