Calculation Models automatically generate missing monthly figures — monthly beginning balances or monthly activities — and add them to your data table. For what calculation models are, the list page, recalculation schedules, and archiving, see Calculation Models: Overview.

All three model types are created in the same four-step wizard. The only differences are the calculation each type performs and a few type-specific defaults, summarized below.

Choose a Model Type

Yearly to Monthly beginning balances

Formerly "Beginning Balance Y to M".

Use when your data includes a beginning balance for the start of each year plus monthly activities — typically for Balance Sheet figures.

Monthly Beginning Balance = Yearly Beginning Balance + YTD Activity

Example: January 2026 Beginning Balance is $10,000 and January 2026 Activity is $2,000 → the calculated Beginning Balance for February 2026 is $12,000.

Single starting balance to monthly beginning balances

Formerly "Beginning Balance Onetime to M".

Use when your data includes only one starting balance at a single point in time plus monthly activities — typically for Balance Sheet figures.

Monthly Beginning Balance = Onetime Starting Balance + To-Date Activity

Example: January 2025 Beginning Balance is $10,000 and total 2025 Activity is $10,000 → the calculated Beginning Balance for January 2026 is $20,000.

Note: because this model rolls a single starting balance forward, all activity from before the From Date is included in the calculation — that's what makes it a beginning balance.

Year-to-date to monthly activity

Formerly "Cumulative to M".

Use when you have year-to-date (cumulative) balances for every month and need monthly activities — typically to convert YTD ("TB") P&L data into monthly data.

Monthly Activity = YTD Balance − Previous Month's YTD Balance

Example: May 2026 YTD Balance is $12,000 and April 2026 YTD Balance is $10,000 → the calculated Activity for May 2026 is $2,000.

Type-specific defaults at a glance

Before You Begin

The source table must include a Reporting Month field (representing the end of each month), a Data Type field with the values Activity and Beginning Balance, and a Scenario field. The Year-to-date to monthly activity model also requires an Account Group L0 field.

Tables missing required fields appear disabled in the table selection list, with a tooltip listing the missing fields.

Create the Model

1. Go to Setup → Calculation Models.
2. Click + New, choose your model type, and click Next.

The wizard walks you through four steps: Input → Output → Trigger by → Validation. Use Save in the top right to finalize, or Cancel to exit without saving.

3. At the top of the wizard, give the model a clear name — it appears in the models list and is stamped on every row the model creates (the Calc_Model_Name column).
4. Set the Model run dates: a From Date for when the model should start generating figures, and optionally a To Date.

Step 1 — Input

1. Select the source Table. A list of the table's fields is displayed.
2. Drag the desired field into the Value section. The default is Sum of Posting Amount, but you can use any numeric field.
3. Adjust the Filters section. The following filters are added automatically and can be changed:
   • Scenario = Actuals
   • Account Group L0 = Balance Sheet (beginning-balance models) or P&L (year-to-date model)
   • Account Group L2 — excludes Net Income Calc
4. Click Next.

Step 2 — Output

1. Under Breakdown data by, review the fields that determine the granularity of the generated rows. Click Add fields to add more. For faster calculations, use only the fields you need in your outputs.

2. Under Custom columns, review the Added columns the model stamps on each generated row. The Data Type column is added by default ("Beginning Balance" or "Activity", per the table above). Suggested columns you can add with one click:

   • Posting Date — SOMONTH([Reporting Month])
   • Reporting Year — FY_Year([Reporting Month])
   • Amount — [Posting Amount] * [Currency EOP rate]

   Click + New to create your own custom column.

3. Use the preview panel on the right to check the results. Turn on Real time update or click the refresh icon to recalculate the preview (up to the first 100 rows are shown). Each row represents a new entry the model will create — note the model's name stamped in the Calc_Model_Name column.
4. Check the Estimated output rows banner above the preview:
   • Good row count for optimal performance — you're fine.
   • Approaching limit — consider reducing breakdown fields.
   • Likely to cause performance issues — reduce breakdown fields.
5. Click Next.

Step 3 — Trigger by

Under Calculation trigger, choose the Fileboxes that trigger the calculation — when any selected filebox is updated, the model recalculates. Any connected lookups also trigger recalculation. Search or browse the filebox tree, select the relevant Fileboxes, and click Next.

Tip: you can change the trigger selection later from the model's action menu (Calculation trigger).

Step 4 — Validation

The wizard creates a table widget based on your model so you can validate it before saving.

Validation check by type:

• Beginning-balance models: each month's Beginning Balance should equal the previous month's Beginning Balance plus its activity — the per-month Subtotal column (Activity + Beginning Balance) should equal the next month's opening balance.
• Year-to-date to monthly activity: each month's generated Activity should equal that month's YTD balance minus the previous month's, and the generated activities should sum back to your YTD totals.

If everything looks correct, click Save. If not, go back and edit the previous steps.

After Saving

• The first calculation is queued and the generated rows are written to your data table.
• A dedicated data table is created for the model. Open it any time via the model's action menu → Details → Go to data table.
• The model recalculates automatically based on its Recalculation schedule (Auto or Daily) and Calculation trigger settings — see Calculation Models: Overview.

Q&A

Which beginning-balance model should I use?
If your data includes a beginning balance at the start of every year, use Yearly to Monthly beginning balances. If you only have one starting balance from a single point in time, use Single starting balance to monthly beginning balances.

How can I verify the model keeps functioning correctly over time?
Open the model's Details and click Go to data table to review the generated entries, or re-open the model and go to the Validation step, then apply the validation check for your model type (above).

Why is my table disabled in the table selection list?
The table is missing one or more required fields. Hover over the table name to see which fields are missing.

My January activity looks wrong (Year-to-date model) — why?
January's activity equals the January YTD balance itself (there is no prior month in the fiscal year to subtract). Make sure your January YTD figures are correct, and that the model's From Date aligns with your fiscal year start.

How do I stop the model without losing it?
Archive it from the model's action menu. Archiving stops future recalculations and removes the model's rows from your data table; you can restore it later from Archived models.

Updated August 30, 2026 14:08