Movements in FCCS across years

Hello Experts,

I had one observation related to data movements between fiscal years and wanted your input on the approach.

Step 1: YTD balances were loaded at Dec-FY24 using FCCS_Mvmts_NetIncome (see Col ‘BC’ in the screenshot).

FCCS data matches the Customer TB with no variances.

Step 2: Periodic balances were loaded to Jan-FY25 using FCCS_Mvmts_NetIncome (see Col ‘BG’).

Step 3: After the Jan-FY25 periodic load and reconciliation, the client noted differences between FCCS and their TB.

Customer Expectation:

• For Jan-FY25 periodic, the client expects 68,407,630 in TB — the sum of ‘Dec-24 YTD’ and ‘Jan-25 periodic’ balances.

• In FCCS, however, Jan-FY25 shows: