Using the Cash Flow Calendar in Microsoft Small Business Financials
Updated: December 8, 2004
By Troy Aipperspach
This page explains how you can effectively use the Cash Flow Calendar in Microsoft Small Business Financials to asses your organization's revenues and expenses.
You can use the Cash Flow Calendar window to view cash inflows and outflows for a month at a time. From this window, you can open the Cash Flow Forecast window, where you can revise the cash forecasts used to calculate cash flows. You also can open the Cash Flow Inquiry window, where you can see the source documents that were used to calculate the amount displayed on that particular day.
On This Page
Viewing Cash Flow Information
Using the Cash Flow Calendar window, you can view cash flow information for a specific forecast:
1. | Open the Cash Flow Calendar window by selecting Cash Flow Calendar from the Banking menu. |
2. | Select the forecast to view cash flow information for. |
3. | If you wish to view cash flow information for a different month than is displayed, use the browse buttons on the side of the name of the month. |
4. | To view or change a forecast ID, click Edit Forecast to open the Cash Flow Forecast window. |
The balance for each calendar date for the checkbooks and the general ledger account specified in the selected forecast are displayed in the calendar. The balance also reflects any inflows or outflows for sales or purchase transactions that are included in the forecast. Cash balances are displayed in black, as are saved deposits or banking transactions, if the forecast that is displayed includes them. Click a date link to open the Cash Flow Inquiry window, where you can view the specific documents that make up the balance for the date.
Note On any date for which the amount is displayed in blue, cash receipts are greater than disbursements on that day. On any date for which the amount is displayed in red, cash disbursements are greater than receipts on that day.
Revising Cash Flow Forecasts
Using the Cash Flow Forecast window, you can change the transactions and checkbooks that are included in a forecast:
1. | Open the Cash Flow Forecast window by selecting Banking->Cash Flow Calendar->Edit Forecast button. |
2. | Select the ID of the forecast to revise. |
3. | To change the description of the forecast, type a new description in the Forecast field. |
4. | To include an opening balance in the forecast, select the account whose balance you want to include. If an opening balance has been included and you don’t want it to be, enter zeroes in the GL Account field. |
5. | Select or clear any checkbooks to include or exclude, respectively, from the forecast. |
6. | To include sales or purchase transactions, select to include saved and posted transactions. Saved transactions are those that have been entered in a batch but are not yet posted. To include quotes for sales transactions, select Saved (unposted), and then select Include Quotes. |
Troy Aipperspach is a Technical Lead for Microsoft Small Business Financials support. He has been a part of the Microsoft Dynamics support team since 1997. The Microsoft products he has supported over the years include Great Plains Accounting, Great Plains, FRx, Retail Management System, and Small Business Financials. In his free time Troy enjoys a good day of fishing, even if the fish aren't biting!
