Scenario
User wants to customize the Balance Sheet report to show the balances as of report date. User also wants additional columns to be displayed to show prior balances by period of previous quarters.
Solution
Using calendar year - by having Jan 2024 as the report date, last fiscal year would be Dec 2023 since it will be looking at the 2024 as this fiscal year which means last fiscal year of 2024 would be Dec 2023. Further, if we select the quarters for the last fiscal year, it would be: As of Dec 2023, As of Sept 2023, As of June 2023, and as of March 2023.
1.To illustrate, Customize the Balance Sheet and under Edit Columns:
2. Expand Financial folder
3. Select Amount
4. Add it 5 times then select each Amount column:
5. Alternate Period Range Type = Relative to Report Date (for all columns)
6. Alternate Period Range (select each on each column):
- Last Fiscal Year
- Fourth Fiscal Quarter Last FYL
- Third Fiscal Quarter Last FY
- Second Fiscal Quarter Last FY
- First Fiscal Quarter Last FY)
7. Range Segment = None
This is how it would look like (as of Jan 2022 is used here as an example):
-----
If you find this information useful, let us know by reacting or commenting on this post!