Forecast Revision / Rolling Forecast

Acumatica, Writeback

The Forecast Revision / Rolling Forecast Writeback template revises an existing annual budget during the fiscal year from a workbook, with actual results for completed periods and forecast amounts for the remaining periods. You can use the template for quarterly reforecasts, monthly rolling forecasts, and mid year budget revisions where the actual months stay unchanged. It uses the NECWRITEBACK formula, generated with the Writeback Wizard, to send changes from your workbook back to Acumatica.

important

Before you start, confirm that the budget and forecast ledgers exist in Acumatica. The Cutoff Month sets which periods show actual amounts and which periods stay open for the forecast.

Write a forecast revision back to Acumatica

1. Select the Budget Ledger, Actual Ledger, Forecast Ledger, Cutoff Month, and any optional filters in the forecast header.
2. Click Create Forecast and refresh the workbook, if the forecast doesn't exist yet in Acumatica.
3. Click Initialize.
4. Fill in the forecast periods with the allocation helpers, or enter them directly.
5. Review the forecast, then click Push to Acumatica.
6. Click Release Selected or Release All.
7. Click Reset before you start another forecast revision.

Forecast header fields

The header identifies the ledgers and the cutoff month that separates actual results from forecast periods.

Header field	What it contains
Budget Ledger	Ledger used to populate budget amounts for periods after the cutoff month.
Actual Ledger	Ledger used to populate actual amounts through the cutoff month.
Forecast Ledger	Ledger in which the forecast is created and updated.
Cutoff Month	Last period treated as actual. Periods after this month are treated as forecast periods.
Cutoff Year	Calculated automatically from the selected Cutoff Month. Read only.
Cutoff Month Number	Calculated automatically from the selected Cutoff Month. Read only.

important

Cutoff Year and Cutoff Month Number are calculated from the Cutoff Month, so leave both fields as is.

Forecast filters

• Branch limits the accounts displayed to one branch.
• Subaccount narrows the accounts displayed to one subaccount.

Writeback actions

Writeback action	What it does
Create Forecast	Creates the forecast in Acumatica for the selected year and forecast ledger. Refresh the workbook after creation so the new forecast can be loaded.
Push to Acumatica	Validates and writes the forecast values to the selected forecast ledger in Acumatica.
Initialize	Creates a separate workbook copy with (Initialized) added to the file name. Extracted data is made static in this copy so it remains available while forecast values are entered.
Reset	Clears the current changes and restores the workbook to its last saved state. Any unsaved entries or edits are removed.
Release Selected	Releases only the forecast lines marked in the Select column.
Release All	Releases the entire forecast.

Forecast grid

The forecast grid lists each forecast line by branch, account, and subaccount. The periods up to the cutoff month show actual amounts from the actual ledger and stay unchanged. Enter or calculate amounts only in the forecast periods after the cutoff month.

Forecast grid column	What it contains
Branch	Branch associated with the forecast line.
Account	General ledger account included in the forecast.
Account Description	Description of the general ledger account.
Subaccount	Subaccount associated with the forecast line.
Subaccount Description	Description of the subaccount.
Actual/Budget Total	Combined total based on actual periods through the cutoff and forecast periods after the cutoff.
January to December	Monthly actual or forecast amount, depending on the selected cutoff month.
Actual/Forecast Total	Total of all actual and forecast periods for the line.
Release Status	Indicates whether the forecast line has been released in Acumatica.
Select	Marks the line for use with Release Selected.

Budget allocation helpers

Each helper spreads the forecast amount across the remaining forecast periods with a different method. You can also enter an amount or a formula in any period manually.

• Split Equally divides the entered amount evenly across the remaining forecast months.
• Split Season spreads the entered amount by the monthly pattern of the actual ledger.
• % Inc Budget applies a percentage increase or decrease to the matching monthly values.

Review the forecast before writeback

Writing the forecast back and releasing the forecast are separate actions. After the writeback, click Release Selected to release individual lines or Release All to release the whole forecast.

• Confirm that the Cutoff Month separates the actual and forecast periods correctly.
• Check that the selected ledgers are correct.
• Review the account, subtotal, gross margin, and net income totals.
• Confirm that only the intended forecast months changed.
• Check the Release Status of lines that may already exist in Acumatica.