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

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. Required fields are marked *



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

30% Off QuickBooks

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