Accounting Spreadsheets

I am creating some curriculum for Accounting using Spreadsheets.

I will incorporate the Excel & Google Spreadsheet class information. Excel/Spreadsheets

There are many ways to teach Accounting & Spreadsheets.

One way is to use a popular program like Quicken or QuickBooks, but that requires software to be purchased.

So I will use Excel & Google Spreadsheets to teach Accounting. Excel/Spreadsheets

Workshops:

    • Create a worksheet (one page/tab of a spreadsheet) for Assets

    • Create a worksheet (one page/tab of a spreadsheet) for Expenses

  • Create a Worksheet (one page/tab of a spreadsheet) for Checking

  • Learn to POST - as checks are written - they are either:

    • Deducted from the Checking for

      • an expense

      • to purchase an asset

    • the appropriate Workpage (Asset or Expense) is updated

    • This is called: Double Entry Accounting

      • Deduct from the checking

      • Add to an expense or an asset

  • A Profit & Loss Statement worksheet will be created and maintained

  • A Journal Entries worksheet will be created and used for things such as:

    • Depreciation of an Asset

    • Interest for Savings

    • Appreciation of Property or Investments

LINKS: