How to Update Forecast Balance Sheet amounts

The following Balance Sheet lines are forecast:

• Accounts Receivable
• Inventory
• Accounts Payable
• Fixed Assets

Accounts Receivable

1. Go to the Forecast Summary screen.
2. Click the Edit pencil on the Accounts Receivable line. The actual AR balance last loaded is displayed, as well as the AR Days.
3. Either enter the number of Days or a manual amount to update the forecast.
4. Click Accept & Save when the data entry is complete.

Inventory

1. Go to the Forecast Summary screen.
2. Click the Edit pencil on the Inventory line. The actual Inventory balance last loaded is displayed, as well as the Inventory Days.
3. Either enter the number of Days or a manual amount to update the forecast.
4. Click Accept & Save when the data entry is complete.

Accounts Payable

1. Go to the Forecast Summary screen.
2. Click the Edit pencil on the Accounts Payable line. The actual AP balance last loaded is displayed, as well as the AP Days.
3. Either enter the number of Days or a manual amount to update the forecast.
4. Click Accept & Save when the data entry is complete.

Fixed Assets

1. Go to the Forecast Summary screen.
2. Click the Edit pencil on the Fixed Assets line. The actual FA balance last loaded is displayed.
3. Enter the expected Acquired and Disposed amounts per month.  This shows a running balance of Fixed Assets including depreciation forecast in the Income Statement.
4. Click Accept & Save when the data entry is complete.