Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column No.Column HeaderColumn TypeLedger Entry TypeAmount TypeFormulaComparison Date FormulaComparison Period Formula
1Last YearNet ChangeEntriesNet Amount 
-1Y
2AprNet ChangeEntriesNet Amount

FY[1]
3MayNet ChangeEntriesNet Amount

FY[2]
4JunNet ChangeEntriesNet Amount

FY[3]
5JulNet ChangeEntriesNet Amount

FY[4]
6AugNet ChangeEntriesNet Amount

FY[5]
7SepNet ChangeEntriesNet Amount

FY[6]
8OctNet ChangeEntriesNet Amount

FY[7]
9NovNet ChangeEntriesNet Amount

FY[8]
10DecNet ChangeEntriesNet Amount

FY[9]
11JanNet ChangeEntriesNet Amount

FY[10]
12FebNet ChangeEntriesNet Amount

FY[11]
13MarNet ChangeEntriesNet Amount

FY[12]
14Current YearNet ChangeEntriesNet Amount


5. Compare Actual and Budget with Variance %

Column No.Column HeaderColumn TypeLedger Entry TypeAmount TypeFormulaComparison Date FormulaComparison Period Formula
1ActualNet ChangeEntriesNet Amount 


2BudgetNet ChangeBudget EntriesNet Amount


3VarianceFormulaEntriesNet Amount(1-2)

4%FormulaEntriesNet Amount(1-2)/2*100