GL: Variances for Year Comparison in Profit & Loss Statement

From AutoCount Resource Center
Jump to navigation Jump to search

Question : How to show the variances between the years in Profit and Loss Statement?


Answer :

Normal Year Comparison report will not show the variances. To show it, you need to use Custom Column report format. Take note that this function is available only when the Advance Financial Report module is enabled.

1) Select Custom Column report format.

Variances profit loss1.png


2) Click on Edit Columns.

Variances profit loss2.png


3) Click on Add to add a new column. For Header, if you are comparing year 2018 & 2017, you may key in 2018 and add another column for 2017.
For column’s Type, choose Fixed Date and key in Financial Start Date in Param 1 and Financial End Date in Param 2.

Variances profit loss3.png


4) Lastly, add another column for variances and for column Type choose Expression. For Param 1, key in Col1-Col2, means column 1 (which is 2018) ‘minus’ column 2 (which is 2017) and click on OK.

Variances profit loss4.png


5) Click on Preview and now you will get the result 2018, 2017, and Difference.

Variances profit loss5.png


To save custom column template, please refer to the following link for the steps:
GL: How to save the template for custom column in financial report


By : Cheryl 190301, Lay Swan 190312, P190319



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations