# Monthly Trail balance for Prior year

Hi

I am creating a trial balance report to breakdown all the month balance for current year and prior year in one report.

Our year end closing is on 30 June of each year.

The information show correctly for all the months of the current year with formula as below:

=FRAMTA("BAL12P")  -  for the month June 2020

=FRAMTA("BAL11P") - for the month May 2020

=FRAMTA("BAL10P") - for the month Apr 2020

... and till the column =FRAMTA("BAL1P") - for the month Jul 2019

As for the prior year monthly balance it didn't show correctly . Below is the formula I used :

=FRAMTA("BALPY12PA") - It show correctly for this month Jun 2019 only

=FRAMTA("BALPY11PA") - Starting from this formula, it show the period 1 of the current year - Jul 2019, which suppose should be May 2019.

=FRAMTA("BALPY10PA") - same goes to the next column, it show the balance for period 2 of the current year - Aug 2019, which suppose should be Apr 2019

Only the first formula  =FRAMTA("BALPY12PA")  - is correctly the rest are showing wrong info.

Am I using the wrong formula? Please advice.

=FRAMTA("ABALPY1PA") for 1 period ago preceeding year, yours looks like it should have worked though

• Hi Stacey
I have tested your formula, it show the balance for 1 period ago but for current year.. not preceding year.

Since =FRAMTA("BALPY12PA") work find for period 12 proceeding year,
so i tried =FRAMTA("BALPY13PA")  for period 11 preceding year... it work find..

but couldn't work for 14,15,16.... hahaha..
still cannot get it..

• I have tried = FRAMTA("BALPY11PA.L1) it work fine from period from 1 to 11 in preceding year but somehow the result didn't fixed in that same column of the period if I choose any other month then the last month of the accounting year.

• Use:

=FRAMTA("BAL12P.L1")  -  for the month June 2019

=FRAMTA("BAL11P.L1") - for the month May 2019

=FRAMTA("BAL10P.L1") - for the month Apr 2019
.....
=FRAMTA("BAL1P.L1") - for the month Jul 2018

The .L1 suffix means "one year ago".

• Yes, I got the answer now. Thanks Ettienne.