Excel Accounts

Options
lmiddleham
lmiddleham Registered Posts: 71 Regular contributor ⭐
in General accounting discussion
Hi

Does anyone out there have any templates for some real basic accounts.

I'm trying to build myself some at the moment, based around a sales & purchase day book, a tab for journals, a bank GL acount and a trial balance.
I'm then trying to feed the TB into a basic P&L and Balance Sheet.

Does anyone have anything to hand they wouldn't mind sharing. I'm getting somewhere with what I'm building but wondering whether I'm going about it the right way.

Thanks

Comments

  • Scalloway
    Scalloway Registered Posts: 10 New contributor 🐸
    Options
    Excel setup

    I haven't got a blank template handy but how I set mine up is a page for each ledger, ie Purchases, Sales and Cash Book. Additionally I may have a page for accruals. The totals for each page is then linked to the Extended Trial Balance (ETB).

    The ETB is set up as an extended trial balance with columns for opening balances, ledgers & cash book and adjustments. The adjustments column is what I use instead of Journal Entries, either referencing a page such as Fixed Assets for depreciation, or with adjustments directly entered with comments for narrative. The final column is the cross summed total for entries.

    As a check the debits and credits in each column should equal zero.

    The P&L and Balance Sheet reference the total column of the ETB. Some lines may come from more than one ETB figure.
  • sdv
    sdv Registered Posts: 585 Epic contributor 🐘
    Options
    try the following link

    http://www.osbornebooks.co.uk/foundation_accounting_tutorial_second_edition_reso


    http://www.osbornebooks.co.uk/financial_records_accounts_tutorial_resources
  • lmiddleham
    lmiddleham Registered Posts: 71 Regular contributor ⭐
    Options
    Hi

    I've managed to build something thanks along the lines of what Scalloway said.

    Pages for Sales & Purchases and a Jourals tab which feeds into a bank account (as there are no credit purchases or sales)

    These then feed into an ETB, which in turn feeds into a P&L and Balance Sheet

Categories

Privacy Policy