I need an excel template/spreadsheet to link general journal- ledger to trial balance to preparing financial statements
I need an excel template/spreadsheet to link general journal- ledger to trial balance to preparing financial statements
Why not build one to suit your needs?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There's a variety of ways to do this:
1) If you have each journal entry on a separate row, then create a mapping account in a separate column (eg. "Cash" "Accounts Receivable" "Prepaids")
2) Since each mapping accounts will tie directly to your financial statements, create a pivot table summing the amounts. This will give you your total balance for each account.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks