Video 2a) Statements Worksheet - Part 1

Familiarize yourself with the Statements Worksheet

1. Review basic functionality

2. Compare an Asset Data Table to a Liability Data Table (there are subtle differences)

Video 2b) Statements Worksheet - Part 2

Use the Statements Worksheet to review basic data trends...

1. Review Checking Data Table for Data Trends

2. Review the Credit Card Data Table for Data Trends

Video 2c) Statements Worksheet - Part 3

Learn about the handy selected data tool that can provide sum, average, max, min and count at a snapshot! Learn to use it now so you can use it later too!

Video 3a) Raw Transactions Worksheet - Part 1

1. Top Left - Download Data Set Table at the top

2. Bottom Left - Bank Data in raw form

3. Bottom Right - Mapped Bank Data

4. Upper Right (rarely) - will have a lookup table if it's a corporate credit card account

Video 3b) Raw Transactions Worksheet - Part 2

The Raw Transactions worksheet is "optional" if you are manually entering data from Paper Statements or just for a transaction list.

!! This is important for those of you who will be manually keying in transactions from paper statements or receipts instead of downloading bank data !!

Video 4a) Introduction to Journals

1. Introduction to 6 Journals

   1. Qty 5, 1 line journals (2 Asset Journals, 3 Liability Journals)

   2. Qty 1, multi line journal (the General Journal)

2. Delineate between Journals and the General Ledger

You really need to know what these are and how they work before we focus on the Demo Data. It helps a lot.

Video 4b) Sorting Journal Demo Data and Categorization Comments

1. Checking Journal

2. Credit Card Journal

3. Expenses Paid Via Journal

4. General Journal

A quick lesson in sorting columns and comments about categorization. It turned out light on discussing transaction categorization details.

Video 4c) Finding and Filtering Data with Google Sheets Filter...

1. Checking Journal

2. Credit Card Journal

3. Expenses Paid Via Journal

4. General Journal

Video 5a) Chart of Accounts Intro

1. An explanation as to why the Chart of Accounts is discussed after the Statements Worksheet and Journals

2. An introduction to the Chart of Accounts as a simple Two Column Lookup Table as opposed to the full view as a Dashboard, with configuration and Budgeting Functionality too.

3. Introduction to 5 standard account types, a sub account that we treated like an account and a 6th account type we created for transparency.

4. Introduction to the Naming Nomenclature we use and reasons for it.

5. Introduction to assigning lists as lookup values in a cell

6. Brief conversation about Categorization systems that only offerred income and expense tracking

Video 5b) ZAP's Chart of Accounts as a Dashboard +

1. Discussion about the Dashboard Details found in our Chart of Accounts.

2. Dashboards are typically one of the more difficult things to build for numerous reasons and some of that...

Video 6a) ZAP's Income Statement +

1. Database Theory 101 - Understanding Reports in the context of "Forms--Datatables-Reports" framework.

2. @ 10:45... Income Statement Basics for w2 Employees as it pertains to their Pay checks and hidden Taxes and Insurance that add an additional 20% loss to the sweat of your brow!!PLUS, I forgot to add the Health Insurance premiums they piggy back out of the employees back without credit to your brow too?!?

3. @ 13:10... Income Statement Basics for Small Business Owners

4. @14:10... The Alternate reports found on our Income Statement - Cashflow Report

Video 6b) Income Statement (Continued)

1. Drill Down Reporting

2. Pre-filtering the General Ledger for Automated Income Statement Reporting

3. Other Income Statement Reports - Income Statement by Month, Income Statement by Month Graph, I/S2** and I/S2** by month which are older less automated reports iwth more traditional spreadsheet reporting features and drawbacks.

4. @11:45 - Budgeting Vs Actual Report

Video 7b) Balance Sheet

1. What is a Balance Sheet - from 50,000 feet

2. Who needs one?

3. Do I need one for Personal Accounting? What would the advantages be for having one?

A Balance Sheet is mandatory for Businesses. It provides a data integrity check for the categorization process for any given time span. It could be used for personal accounting but you would need to be very disciplined with tracking like a business (not hard to do). It would provide some benefits in the event you mis-categorized things although not sure for most that would really be that relevant.

Video 7a) Balance Sheet

1. Development History

2. What is a Balance Sheet - 2 Reports that equal each other

3. Differences from Traditional Balance Sheets from vocabulary to functionality

4. Drill Down Reporting

5. Historical Report Data (covered but obsolete)

In Part 3 you will see the simulations where the Balance Sheet is forced out of Balance. The benefits of a Balance Sheet in general and our Balance Sheet will become easier to understand.