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.
Quick Answers
What do numbers in red mean?
Numbers in red and in parentheses are negative numbers. They will subtract from the total on the tab they appear on.
What does the small triangle in the bottom right corner of a cell/field mean?
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.
Why are some items in the grid checked, while others are unchecked?
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.
Why did some of the changes I made to the Cash Flow disappear?
- 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.
Why did Sage 50 automatically uncheck a line item after I reset the date of a transaction to its original value?
Resetting the date of the transaction to its original value placed it outside of the Time frame selected for the current cash flow.
Why do some invoices appear overdue when I know they aren't?
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.
How do I adjust the balances of my cash accounts?
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.
How can I change the sort order of line items on the grids?
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.
I just converted from QuickBooks and none of my customer and vendor beginning balances appear in my Cash Flow. What should I do?
You will need to change the information in the Invoice Number field on the beginning balances window for your customer and vendors.
How do I send my cash flow information to Microsoft Excel?
- 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?
What does Add Attachments do?
You can attach files, such as Word or Excel documents, to a sales invoice.
How to Delete Adjustments/"What if" Transactions, and Reset Dates and Amounts on the Cash Flow Manager
Delete individual adjustment/"What if" lines
To delete a single adjustment line
- Highlight the line you want to delete.
- Right-click the mouse button.
- Select Delete "What if" Transaction Row.
Delete all adjustment/"What if" lines
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).
Reset individual amounts and dates
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.
Reset all amounts and dates
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).