Course Content | MS Excel Templates | Tutorials | Games | Newsletters

 Using Excel for Small Business Accounting

MS Excel Templates:  Working Papers

The links below are in MS Excel 1997-2003 format and should be compatible with ALL versions.  By using this format, they are more likely to download correctly (some networks block newer versions of Microsoft Office files from downloading). 

Please feel free to use as long as you leave my attributes intact. Depending on your security settings, they will open in Protected View and you will need to click the Enable Editing button to use.  These are "plain Jane" simple workbooks that do not automate calculations.  They are literally spreadsheet versions of traditional working papers. 

A fun computer project would be to add formulas and functions to calculate and even create an autormated set of accounting ledgers & statements.

  1. Accounting Equation
  2. Balance Sheet
  3. Transaction Analysis
  4. General Journal
  5. Using "T" Accounts
  6. General Ledger
  7. Accounts Receivable Ledger
  8. Accounts Payable Ledger
  9. Work Sheet (8 Column)
  10. Balance Sheet Statement
  11. Income Statement with % of Sales
  12. Purchase Journal
  13. Sales Journal
  14. Payroll Register
  15. Employee Earnings Record
  16. Owner's Equity Statement
  17. Trial Balance
  18. Petty Cash Report
  19. Cost of Inventory
  20. Corporate Accounting
    1. Balance Sheet
    2. Income Statement
    3. Cash Receipts Journal
    4. Stock Record
    5. Cash Payment Journal
    6. Financial Analysis Online Scavenger Hunt (MS Word)
Course Content | MS Excel Templates | Tutorials | Games | Newsletters

Top of Page