Using the Tabs on the Cash Flow Manager
Learn how to use the Cash Flow Manager
Get quick answers about the Cash Flow Manager
Learn how to improve my business's cash flow
Prepare and print collection letters
The Cash Flow Manager tool has three tabs: Starting Cash, Expected Incoming Cash, and Expected Outgoing Cash.
Starting Cash
- You can enter adjustments on the first line of the grid. When you complete the line, another one will appear for an additional adjustment. Note that adjustments entered here will NOT affect the actual balances of any cash accounts. These are hypothetical, "what-if" adjustments made solely for forecasting the status of your business.
- You can modify the amounts in each cash account.
- You can also select the Change Cash Flow Settings button and choose to display Inactive accounts.
Starting Cash is the total amount in all of your cash accounts at the time you open the Cash Flow Manager.
All of your cash accounts will appear here. Cash accounts are defined by the Account Type selected for an account in Maintain Chart of Accounts. By default, they will all be checked.
Note: Accounts marked as Inactive may not appear, depending on the selections made on the Change Cash Flow Settings window.
The starting balance for each cash account reflects the balance of the cash account as of the time you opened the Cash Flow Manager. Note that this is not necessarily the balance of your bank accounts. That will depend on the lag time between when you entered a payment or receipt and the time it takes to clear the bank.
Expected Incoming Cash
- Overdue customer Invoices: these will be unchecked, since it is uncertain whether or not they will be paid. The Expected Date appears in red.
- Unpaid Invoices due during the time frame selected
- Unapplied Receipts made during the time frame selected. Unapplied receipts are those that have been entered but have not yet been applied to the cash account.
- Unapplied Customer Credit Memos dated during the time frame selected: these will be displayed in red and in parentheses since they are monies actually going out of the business. An unapplied credit memo is one that has been entered but not applied to an existing invoice or refunded.
- General Journal Entries
- Customer Prepayments/Deposits
- Vendor Receipts. These are refunds you have received from vendors.
- 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 tab. Learn more about this tab.
- 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.
Expected Incoming Cash is money you expect to be coming into your business in the form of checks, credit card payments, cash, and so on.
This will depend on whether or not you have saved the information in the past. If this is the first time you opened the Cash Flow Manager, Sage 50 will display the following types of transactions by default:
You can modify the data on this tab in three ways:
Expected Outgoing Cash
- Unpaid overdue bills/invoices displayed but unchecked.
- Unpaid purchases due within the next 14 days displayed and checked.
- Unapplied Vendor Credit memoes displaeyd in red and checked. An unapplied credit memo is one that has been entered but not applied to an existing purchase or refunded by the vendor.
- Unapplied Payments to vendors displayed and checked. Unapplied payments are those that are in but have not been applied to the cash account.
- Payroll checks displayed and checked.
- General Journal Entries
- Vendor Prepayments/Deposits
- Customer Payments. These are refunds you give to your customers for returned goods or services.
- 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 tab. Learn more about this tab.
- 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.
Expected Outgoing Cash is money that you expect will go out of your business in cash, checks, credit card payments, and so on.
When you first open the Cash Flow Manager, the following types of transactions will appear.
You can modify the data on this tab in three ways: