Excel Template/spreadsheet to prepare financial statements, linking from journal to statem

[gella]

I need an excel template/spreadsheet to link general journal- ledger to trial balance to preparing financial statements

[mikeTRON]

Why not build one to suit your needs?

[Xx7]

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.