Cash Flow Tools In Quickbooks

If you have a seasonal business, then you know some months are fabulous and some months – aren’t. You have also noticed (I hope) that your profit from your Profit and Loss doesn’t match your cash balance.  That’s because loan payments, payroll tax liabilities, sales tax and more, don’t show on that report, but they definitely affect your cash balance!

Here are 5 tools in QuickBooks that can help you monitor your cash flow.

  1. Cash Flow Forecast (Reports>Company & Financial) – This assumes your customers pay timely as do you. While that may not always be the case, this is a quick tool.  If you don’t enter your payables, this report will give you a very lopsided projected balance!
  2. Cash Flow Projector (Company>Planning & Budgeting). Most businesses find fluctuations in their cash flow, so this tool lets you account for known income or expenses you expect in the 6 weeks that might be out of the norm (e.g. quarterly insurance payment, big deposit for a new job starting…).

  3. Balance Sheet Ratios – I find many businesses ignore reviewing their balance sheet and think it’s not useful, but it can very helpful in many ways, including warnings about heading into tough financial situations if you’re not careful! You can take a quick look to see how your cash balance and receivables compare to payables and debt.  Here’s a link to two ratios you can easily get from your balance sheet that are worth reviewing.
  4. Trackers – These trackers are meant to give you a quick visual as well as a way to filter and/or take appropriate action..
    1. Income Tracker – What I like about the Income Tracker is the ability to see open Estimates and Sales Orders in addition to Open Invoices and Overdue Invoices – all with total dollar amounts! Starting with 2015, they added unbilled time and expense. Seeing those numbers will get some people moving!
    2. Bill Tracker – New in 2016 was the Bill Tracker. Like the Income Tracker, you can do 1 action on multiple transactions at one time

Click here to see how you can customize the trackers and take action

  1. The Company Snapshot – Still one of my favorite features in QuickBooks. You can check on payables (very important for cash flow), receivables, account balances, reminders, trends in income and expenses and much more – all in one You can choose from 12 possible reports, organize them any way you want and choose the time frame from the drop-down menu (no custom dates). Past due invoices and bills show up in red, making it easy to pick them out.  You can even print the snapshot.  You can also click on the payments tab to see who’s paid you recently.  If you don’t see this on your toolbar, you can find it in the Company menu.

Click here to take a closer look at this feature.

Hopefully your cash flow is in good shape, but these tools can be very useful.  I’d love to hear which one(s) you like best!

This entry was posted in Business Finance, Cash Flow, QuickBooks and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *