Financial Reports: Compare Accounting Periods using Comparison Period Formulas
- akash shukla
- 54 minutes ago
- 3 min read
Financial reports (previously known as Account schedule) become truly valuable when they help you answer questions like:
How does this month's revenue compare to the same month last year?
Are we performing better than the previous accounting period?
How does the current fiscal year compare with the previous one?
Business Central makes these comparisons easy through Comparison Period Formulas in Financial Report Column Definitions. Instead of creating multiple reports or manually changing date filters, you can configure your financial report once and let Business Central automatically compare accounting periods.
In this article, we'll explore how Comparison Period Formulas work, when to use them, and some of the most useful formulas every Business Central consultant and finance user should know.
What is a Comparison Period Formula?
A Comparison Period Formula tells which accounting period should be used as the comparison for a report column.
For example, if your report displays April 2026, you can configure another column to automatically show:
Previous accounting period
Same period last fiscal year
First quarter of the previous fiscal year
Year-to-date of the previous fiscal year
This makes it incredibly simple to create variance reports and year-over-year comparisons without manually adjusting report filters.
Why Use Comparison Period Formulas?
Many organizations prepare reports such as:
Month vs Previous Month
Current Month vs Same Month Last Year
Current Fiscal Year vs Previous Fiscal Year
Year-to-Date Comparisons
Quarter Comparisons
Without Comparison Period Formulas, finance teams would need to run multiple reports and manually combine the results. With a properly configured Financial Report, Business Central performs these comparisons automatically.
Where Do You Configure It?
Navigate to:
Financial Reports → Column Definitions
The Comparison Period Formula field isn't shown by default.
Simply personalize the page and add the Comparison Period Formula column. Once added, you can enter the required period formula for each report column.
How Does Business Central Calculate the Comparison?
Business Central uses two things:
The Date Filter entered while running the Financial Report.
The Comparison Period Formula configured in the Column Definition.
Instead of using calendar dates, Business Central compares Accounting Periods. This is important because many companies don't use a January-to-December fiscal year. Their accounting periods may follow a custom fiscal calendar. As long as your accounting periods are configured correctly, Business Central calculates the comparison automatically.
Period Formula Abbreviations
Before using formulas, it's important to understand the available abbreviations.
Abbreviation | Meaning |
P | Accounting Period |
FY | Fiscal Year |
CP | Current Period |
LP | Last Period of Fiscal Year, Half-Year, or Quarter |
These abbreviations can be combined to build powerful comparison formulas.
Common Comparison Period Formulas
1. Blank Formula
Formula: <blank>
Meaning: Shows the current accounting period.
Example: If your report is filtered for April 2026, this column displays April 2026.
2. Previous Accounting Period
Formula: -1P
Meaning: Displays the previous accounting period.
Example:
Current Report | Comparison |
April 2026 | March 2026 |
Perfect for Month-over-Month analysis.
3. Same Period Last Fiscal Year
Formula: -1FY
Meaning: Displays the same accounting period from the previous fiscal year.
Example:
Current Report | Comparison |
April 2026 | April 2025 |
This is one of the most commonly used formulas for Year-over-Year reporting.
4. Entire Previous Fiscal Year
Formula: -1FY[1..LP]
Meaning: Displays the complete previous fiscal year regardless of the current reporting period.
Example: Useful for annual financial comparisons.
5. First Quarter of Previous Fiscal Year
Formula: -1FY[1..3]
Meaning: Returns only the first quarter of the previous fiscal year.
Example: Ideal for quarterly management reporting.
6. Previous Fiscal Year-to-Date
Formula: -1FY[1..CP]
Meaning: Returns the previous fiscal year from the first accounting period up to the current accounting period.
Example:
Current Report | Comparison |
January–July 2026 | January–July 2025 |
This is extremely useful for YTD comparisons.
7. Current Period to Fiscal Year End (Previous Fiscal Year)
Formula: -1FY[CP..LP]
Meaning: Returns data from the current accounting period through the final accounting period of the previous fiscal year.
Example: Although less frequently used, it can be helpful for forecasting and remaining-period analysis.
Important Things to Remember
There are a few key points to keep in mind when using Comparison Period Formulas:
Your accounting periods must be configured correctly in Business Central.
Every fiscal year should contain the same number of accounting periods, even if individual periods have different lengths.
The comparison is calculated based on the start date of the report's date filter.
Comparison Period Formulas compare accounting periods, not calendar dates.
Comparison Period Formula vs Comparison Date Formula
Many users confuse these two options.
Comparison Period Formula | Comparison Date Formula |
Uses Accounting Periods | Uses Calendar Dates |
Best for Fiscal Period Reporting | Best for Date-Based Reporting |
Respects Fiscal Calendar | Ignores Accounting Period Structure |
Comments