Cash Flow Manager
How do I use the Cash Flow Manager?
Give me a quick overview of the different ways I can modify the Cash Flow Manager.
Tell me more about the tabs in the grid section of the window.
How do I use and understand the graph?
What settings are selected when I first open the Cash Flow Manager?
The Cash Flow Manager gives you a powerful tool you can use to quickly grasp the state of your business's cash. It shows you the balances of your cash accounts, cash expected to come in, and cash expected to go out. In addition, you can modify settings, such as the time frame you want to see, the types of transactions (invoices, quotes, purchases, and so on) you include and expected totals.
- You can use it to determine whether or not money will be available in the near future for additional expenses.
- It also allows you to enter adjustments and changes balances so you can forecast the flow of cash into and out of your business over a period of time. For example, you might be considering some large purchase and you want to see the effect that purchase would have on your cash flow over the next two weeks or month.
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).
Quick Answers
Numbers in red and in parentheses are negative numbers. They will subtract from the total on the tab they appear on.
This triangle indicates that the field was modified in the Cash Flow Manager. For instance, a user might have changed the due date of a sales invoice to see how it would affect the forecast in the graph. To see the original value of the field, simply roll your mouse over the triangle.
Certain items on each tab will be checked or unchecked. For instance, on the Expected Incoming Cash tab, overdue invoices will be unchecked by default, while other unpaid invoices will be checked by default.
- When you change the way Sage 50 calculates the due dates for customer invoices, some of the modifications you made to the cash flow will be lost. For instance, if you change the Expected Receipt date setting from Transaction due date to Average days to pay, any changes you made to the due dates of customer invoices will be lost, since Sage 50 will recalculate due dates based on customer payment history.
- If you modify a transaction outside of the Cash Flow Manager, any changes to the Amount or Due date will be lost.
Resetting the date of the transaction to its original value placed it outside of the Time frame selected for the current cash flow.
Most likely, this is because the Cash Flow Manager has been set to calculate the due dates based on Average days to pay rather than the actual due dates. Get more information about this setting.
You will need to change the information in the Invoice Number field on the beginning balances window for your customer and vendors.
- Click the Excel button in the toolbar.
- Select the options you want.
- Click OK.. What format will my cash flow will appear in after I send it to Microsoft Excel?
You can attach files, such as Word or Excel documents, to a sales invoice.