...
Column No. | Column Header | Column Type | Ledger Entry Type | Amount Type | Formula | Comparison Date Formula | Comparison Period Formula |
---|
1 | Last Year | Net Change | Entries | Net Amount |
| -1Y |
|
2 | Apr | Net Change | Entries | Net Amount |
|
| FY[1] |
3 | May | Net Change | Entries | Net Amount |
|
| FY[2] |
4 | Jun | Net Change | Entries | Net Amount |
|
| FY[3] |
5 | Jul | Net Change | Entries | Net Amount |
|
| FY[4] |
6 | Aug | Net Change | Entries | Net Amount |
|
| FY[5] |
7 | Sep | Net Change | Entries | Net Amount |
|
| FY[6] |
8 | Oct | Net Change | Entries | Net Amount |
|
| FY[7] |
9 | Nov | Net Change | Entries | Net Amount |
|
| FY[8] |
10 | Dec | Net Change | Entries | Net Amount |
|
| FY[9] |
11 | Jan | Net Change | Entries | Net Amount |
|
| FY[10] |
12 | Feb | Net Change | Entries | Net Amount |
|
| FY[11] |
13 | Mar | Net Change | Entries | Net Amount |
|
| FY[12] |
14 | Current Year | Net Change | Entries | Net Amount |
|
|
|
5. Compare Actual and Budget with Variance %
Column No. | Column Header | Column Type | Ledger Entry Type | Amount Type | Formula | Comparison Date Formula | Comparison Period Formula |
---|
1 | Actual | Net Change | Entries | Net Amount |
|
|
|
2 | Budget | Net Change | Budget Entries | Net Amount |
|
|
|
3 | Variance | Formula | Entries | Net Amount | (1-2) |
|
|
4 | % | Formula | Entries | Net Amount | (1-2)/2*100 |
|
|
{"serverDuration": 200, "requestCorrelationId": "c2fc65c6e00b5c27"}