Help with the journal to ledger automation.

[mabubakerali]

in the first screen shot of general journal worksheet that i made, i am making journal entries in the sheet, with the account names written in the column i and its account code is being written in the column J , now i want it to be transferred automatically to individual ledger in such a way as you can see that i made a drop down data validation in C4 in sheet 2 as you can see in screenshot 2, what i want is that when i select specific account code in c4 of sheet 2, all of its entries from the general journal should appear in the individual ledger. I cant think of a way to do it so please help and write the ways i can do this and which formulas will be used.

 

[SanjayGMusafir]

in the first screen shot of general journal worksheet that i made, i am making journal entries in the sheet, with the account names written in the column i and its account code is being written in the column J , now i want it to be transferred automatically to individual ledger in such a way as you can see that i made a drop down data validation in C4 in sheet 2 as you can see in screenshot 2, what i want is that when i select specific account code in c4 of sheet 2, all of its entries from the general journal should appear in the individual ledger. I cant think of a way to do it so please help and write the ways i can do this and which formulas will be used.

Pivot Tables with Accounts or Codes as Filter(s) is the best automated solution for you

 

[mabubakerali]

Pivot Tables with Accounts or Codes as Filter(s) is the best automated solution for you

Except that there is one one problem i faced with pivot tables, i couldnt find a way to calculate running balances

 

[SanjayGMusafir]

i couldnt find a way to calculate running balances

for current balances I understand you will need -

Option 1 - Create another summary of Debtors and Creditors and fetch current balances using SUMIFS function

Option 2 is to add another column and get Running total in that column using same SUMIFS function

It is advisable to convert data, the kind you have, to Structured table - It helps in analysing data in multiple ways.