Automated posting from journals to ledgeraccounts

Hi there, hoping someone might be willing to help me with the following:


I'm trying to set up automated posting from journal entries to ledger accounts.

What it boils down to is having XL match account numbers, from a 'Post Reference' column in a journal, with the corresponding ledger accounts (carrying the same respective account numbers) on another worksheet.

Then the transaction from the journal needs to be added to the identified ledger accounts in a sort of 'below-the-last-entry' manner.


Could anyone familiar with working with this sort of thing give me a bit of guidance?


Thank you very much for any help.

Thanks for the reply.

I've attached the workbook as it is. I just want to be able to enter the info in the General Journal and have it automatically post the entry to the relevant ledgers.

thank you very macth

Originally Posted by Xx7

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 -->

Thank you very much Xx7. Find this very useful in preparing account with excel, particularly on posting part.

What's the purpose of adding columns M,N,O in generalJournal TAB with reverse impacts of debit & credit?