My financial year starts 1 March, so March = Period 01.
I built a 12-month rolling Trial Balance using ARM based on a Start Period/Financial Period parameter.
Requirement:
- P&L accounts: show Turnover (period activity only)
- Balance Sheet accounts: show Ending Balance (cumulative)
The monthly columns work correctly.
However, the issue is with the YTD column:
For P&L accounts, even if I set the column to Ending Balance, the YTD column shows only the previous month’s amount instead of the cumulative total.
Example:
Jan = 500
Feb = 600
Expected YTD = 1100
But the report shows 500.
Has anyone configured a rolling ARM trial balance like this, especially with a financial year starting in March, P&L Accounts should show Turn Over and Balance sheet Accounts Should show ending balance. How did you handle the YTD column for P&L accounts? I have attached my XML File for quick reference
