One of the surprises to people who are new to business is that profit does not always result in surplus cash.  To help you know when you will have surpluses and shortages of cash, Peachtree provides a tool called the Cash Flow Manager (or just Cash Manager in version 2008 and older).

To get to this tool, click on the Analysis menu at the top of the main Peachtree window and choose Cash Flow Manager (Cash Manager for older versions).  The “Using cash flow manager” window may pop up.  Review it if you want and then close it.

At the top of the screen is a drop down box that lets you choose how many days or months out you want to project.  The minimum is 7 days, the maximum is 12 months.

To the right is a button labeled “Change Cash Flow Settings”.  This lets you make some important choices about how your projections are made:

  • “Projections based on” Open transactions or historical transaction.
    Open transactions is the most common methods but the historical option may be helpful if you business is very cyclical.
  • Expected Incoming Cash/Expected Outgoing Cash
    These two sections are only available if projecting based on open transactions.  They let you choose which types of transactions should be used to project incoming and outgoing cash.  The most common choices are automatically selected.
  • “Expected Receipt date based on”  For incoming cash, you can choose to base your projection on transaction due date or on average days to pay.  If you choose average days to pay, Peachtree calculates the average number of days each customer takes to pay.

You can click the Update Cash Flow button to apply your settings or click Cancel to undo any changes you have made.

Back on the main window are 3 tabs: Starting Cash, Expected Incoming Cash, and Expected Outgoing CashStarting Cash will already be selected.  You will have a list of cash accounts.  You can select which accounts you want to include in your calculations.  You can also add lines to run “what if” scenarios.  Below that will be a table of numbers and a bar chart summarizing the current projections for cash balance, incoming cash, and outgoing cash.  Any changes that you make are immediately reflected here.

Moving on to the Expected Incoming Cash tab, you will see that it looks basically like the Starting Cash tab, but instead of selecting cash accounts, you can select invoices and other transaction that you want included in your projection.  You can also change the amount if you expect a partial payment.  Also notice that the first line is empty so that you can enter other items that you want to include in the projection that aren’t in Peachtree.  To enter more than one item, click on “Add new row” at the top right.

The Expected Date here is either the due date or an estimated date based on that customer’s average days to pay, depending on what you chose in the cash flow settings.  If an invoice is past its expected date, it will not be included in your projected cash.  If you think it should be included, you can change the expected date to a date within your forecast time frame and check the Include box.  You can also uncheck invoices that you think should not be included, such as invoices that are in dispute. 

The last tab is Expected Outgoing Cash.  It looks identical to the incoming cash tab and works the same way, except that it list AP and payroll transactions.  If your projection is based on open items, the only payroll transactions that will show up are payroll checks that are already posted and that fall in the selected date rage.  To include payroll estimates, you need to enter them manually in the top line of Expected Outgoing Cash.  Click on “Add new row” to enter additional payroll or other estimates.

As you make changes on each tab, the balance in the bottom half of the window is updated immediately so you can see result of different scenarios.  When you are done you can print your projections, send them to Excel, save them so you can come back to them later, or Reset to start fresh.

Those of you on version 2008 or older are probably feeling a bit lost.  But I won’t leave you out.  Instead of tabs, you have 2 buttons.  One will be labeled either Numeric, or Graph.  When you select that button you will see your projected cash balance.  You can use the Numeric and Graph radio buttons that are below the main button bar to change how your projection is displayed.  The second button, “SSheet” switches you to a spreadsheet style view showing the transactions used in the projection.  Near the top right, you will see a drop down box that lets you choose between “Sales to Collect”, “Cash Adjustments [+]”, “{Payments to Make”, “Payroll to Pay” and “Cash adjustments [-].

This older version is still helpful but far less flexible.  It doesn’t let you change the dates of items.  There is no option for average days to pay instead of due date, you have fewer choices for your time frame, and you can’t send the results to Excel.

[Facebook] [LinkedIn] [StumbleUpon] [Twitter]