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:
CliffNotes - Accounting https://www.cliffsnotes.com/search?q=accounting
Khan Academy has a whole group of FINANCE videos - the first explains INTEREST http://www.khanacademy.org/video/introduction-to-interest?playlist=Finance
Universal Accounting & Business FREE Tips http://www.accounting-and-bookkeeping-tips.com/accounting-resources.html
University of Florida Business Library http://businesslibrary.uflib.ufl.edu/ Tutorials http://businesslibrary.uflib.ufl.edu/cat.php?cid=4136
QuickBooks by Intuit - $150-600 http://quickbooks.intuit.com/product/accounting-software/quickbooks-comparison-chart.jsp
Quicken by Intuit - $ 30-100 http://quicken.intuit.com/
Mint acquired by Intuit in 2009 - is an online Quicken, and FREE if you give them your VISA, it ties into banks & had iPad/Android applications