Using the Cash Flow Manager
Learn about what information appears when I first open the Cash Flow Manager
Learn more about each tab in the grid
Read an overview of the Cash Flow Manager
Get quick answers to common questions about the Cash Flow Manager
The Cash Flow Manager is an extremely versatile tool to help you see the state of your business's cash at a glance.
How to open the Cash Flow Manager
- Open the Cash Flow Manager by selecting Analysis from the menubar, then Cash Flow Manager.
- Select the Time frame that you want. The Time Frame you select determines how far in the future the cash flow projection will be, as well as how far out the graph will display data. It will default to Next 14 Days.
- On the Starting Cash tab, select the Cash accounts that you want to include. This tab shows you all of your Cash accounts and their balances as of the time you start to use the Cash Flow Manager. These balances are system balances and do not necessarily display the exact bank account balance at that moment.
- Enter any adjustments you want to make. This could include changes to bank balances and cash balances that are not reflected in Sage 50 yet.
- Select the Expected Incoming Cash tab. This tab shows you expected incoming cash. This includes unpaid invoices that are not overdue, unapplied receipts from customers, and customer credit memos.
- Select or clear the transactions that you want to include in your Cash Flow.
- Select the Expected Outgoing Cash tab. Expected Outgoing Cash is money that you expect will go out of your business in cash, checks, credit card payments, and so on.
- Check or uncheck the transactions that you want to include in your Cash Flow.
- Select which bars you want to appear in the graph by checking or unchecking Balance, Incoming, and Outgoing.
- You can print the Cash Flow or send it to Microsoft Excel.
You can change which types of transactions appear here by clicking Change Cash Flow Settings. What are the default types of transactions that appear?
You can change which types of transactions appear here by clicking Change Cash Flow Settings. What are the default types of transactions that appear?
You can do this in one of two ways:
- Simply click in the Amount field of the Cash account on the Starting Cash tab and change the amount.
- Enter an adjustment on the first line of the Starting Cash tab.
Note: This will NOT affect Sage 50's actual balance for the cash account; it will only affect the figures in the Cash Flow Manager.
By clicking on the Title of a column in the grid, you can cause Sage 50 to sort alphabetically by the items in that column. Click the title again and Sage 50 will sort the items in reverse alphabetical order. For instance, clicking the Name column on the Expected Incoming Cash tab will cause the line items to sort alphabetically by the customer name.
To delete a single adjustment line
- Highlight the line you want to delete.
- Right-click the mouse button.
- Select Delete "What if" Transaction Row.
To delete all lines
- Right-click the mouse button.
- Select Delete All "What if" Transaction Rows.
Note: These steps will affect ONLY the transaction rows on the current tab (Starting Cash, Expected Incoming Cash, and Expected Outgoing Cash).
To reset single amounts and dates
- Highlight the row you want to reset.
- Click the Reset button in the toolbar.
- Select Reset Row to Original.
To reset all rows to their original amounts and dates
- Click the Reset button in the toolbar.
- Select Reset All Rows to Original.
Note: These steps will affect ONLY the transaction rows on the current tab (Starting Cash, Expected Incoming Cash, and Expected Outgoing Cash).
You can modify the data on this tab in three ways:
- Change which items are checked or unchecked. Simply click the check box to change the setting.
- Select the Change Cash Flow Settings button to change which types of transactions appear on the tabs. Learn more about the cash flow settings.
- Click in the Expected Date or Amount fields to change the information. When you change the information in a cell on the grid, a small triangle will appear at the bottom right corner of the cell. When you roll the mouse over this triangle, you will see the original value.
Note: Changes you make to balances on the Cash Flow Manager window, as well as adjustment lines you enter on the tabs, will NOT affect actual balances in the system. They will be used exclusively in the Cash Flow Manager. All changes to balances and due dates are indicated by a small triangle in the bottom right corner of the field. When you roll over this field, you will see the original value (date, balance, and so on).