Automated posting from journals to ledgeraccounts

Fellow Chartered Accountant here... the most logical way to do this is through pivot tables. I've done the following:

1) Updated the "GeneralJournal" TAB with helper columns H-R
2) Created new BLUE sheets with transactions for each specific account.
3) Updated the Trial Balance and General Ledger sheets.
4) Created new templates for the Balance Sheet and Income Statement so that the amounts are automatically added when a new entry is posted.

**When you post a new entry you must refresh all the pivot tables (eg. Data tab, "Refresh all"..etc.) for the sheets to be updated.

**Edit: Updated -->