Technical > Bookkeeping Module > 2017 videos

These are the original detailed videos I did for an older version. They are just here for reference and as a place holder. In theory, all of these will get redone, but these fully document every tab and every cell in the worksheet...

Sections below include:

1. ​Debits, Credits, Double Entry Bookkeeping
2. Part A > Software Functionality  Overview
3. The Bookkeeping Routine
4. Software Setup and Education > Part 1
5. Part A > Software Setup and Education > Part 2
6. Detailed Videos > Working Tabs
7. Detailed Videos > Silent Tabs

These videos were originally found on the following:

•  ​http://zap-accounting-software0.weebly.com/part-a1.html
• http://zap-accounting-software0.weebly.com/part-a-v2.html
• http://zap-accounting-software0.weebly.com/part-a-v3.html

1) Debits, Credits, Double Entry Bookkeeping

This video set is designed to introduce you to the most basic of accounting vocabulary including debits, credits and double entry bookkeeping.  You will NOT be any means be a master of vocabulary nor accounting after this short video set, but you will gain an amazing amount of insight with a very small time investment, and after viewing this you should have all you need to be successful using ZAP Accounting Software. ​

1. What is Single Entry Bookkeeping? (5:55)
2. What is Double Entry Bookkeeping and does the Positive and Negative values version of ZAP qualify as a Double Entry system? (7:33)
3. Where can I find a cheat sheet for Debits and Credits? (5:41)
4. Why didn't Do-It-Your-Selfer's use simple, signed ledgers and spreadsheets for formal double entry bookkeeping years ago? (6:41)

​Total Viewing Time:  25 minutes

2) Part A > Software Functionality  Overview

This video set will provide you with a brief overview of the Software so you get an idea of all the components in a single file. We also provide a glimpse at the File Sharing and Multiple File instance benefits of using Google Sheets and Google Drive as compared to Microsoft Excel for your accounting. ​

1. Debits and Credits Version (6:28) 
2. Debits and Credits Version vs Positive Negative Values Version (2:56)
3. File Sharing  and Viewing Multiple Instances at one time! (3:37)

Total Viewing Time: 13 minutes

3) The Bookkeeping Routine

See Pre-Licensing Video Set 2  for current versions of this... the stuff below is much older...
This video set is designed to show you how easy this work can be once you have your Google Drive set up, your ZAP file configured for your use, and your bookkeeping software routines in place.  This is a good video set for gaining introductory insight into the full bookkeeping process from A to Z.   This is also a good video set to use as a refresher as you are learning the processes and before your routines are established.  You will need to put some time into setting up the folder structure and your file before you will be able to zip through this process as shown below.    

1. Enter your statement data into the reconcile tab (optional) (5:09)
2. Download Data and Paste into Raw Txns Tab (2:23)
3. Manipulate Data in Raw Txns Tab, filter it, enhance it and paste into ledger (5:05)
4. Categorize Transactions (6:14)
5. Close out the Reconcile Tab (1:32)
6. View and Print Transaction Reports and Income statement Reports (4:27)​

​​Total viewing time:  25 minutes

4) Software Setup and Education > Part 1

This is the foundation for what is currently Private Video set 1
​

1. ​Create a Folder Structure in Google Drive for a new business and  ZAP Accounting related files (5:38)
2. Download ZAP Accounting Software Part A from our website, move it to an appropriate folder, and make several copies (4:00)
3. Open your working copy of  Part A, remove Demo Data, and prepare the file for your personal data  (6:12)  ​

Total Viewing Time:  16 minutes

​5) Part A > Software Setup and Education > Part 2

​In this section you will learn to configure the Raw Transaction tabs to match your bank's data download formats. You will also learn about various data download file formats and anomalies.  You will learn about credit card related date issues that are relevant to our style of reconciling.  You will  be introduced to our Bank Configuration pages which greatly assist with this entire one time configuration process. You will learn about creating starting balance records before and after entering data in the ledger.

1. Raw Txn Tabs for Checking and Credit Cards > Blue Bar Configuration - Download data from your bank in Excel format and configure Blue Bar Column Headers (4:51)
   1. Excel format vs Delimited Formats - Download data in comma, pipe, tab or space delimited formats (5:56)
   2. Handling CSV files that won't open in Excel or Google Sheets (5:05)​
2. Raw Txn Tab for Checking > Green Bar Configuration -  With Downloaded data, configure formulas filtering raw data (6:11)
3. Raw Txn Tab for Credit Cards > Green Bar Configuration - With downloaded data, configure formulas for filtering raw data and setup data validation (8:02) 
   1. Credit Card Posting Date vs Transaction Date vs something else and special handling processes (6:22)
4. Starting Balance (4:16)  AND Oops! This too! (1:04)

Total Viewing Time:  41 minutes

​​6) Detailed Videos > Working Tabs

1. ​Home Tab (8:54)
2. Notes Tab (5:23)
3. Chart of Accounts Tab - Overview (4:36)     (Total time for Chart of Accounts ~ 33 minutes)
   1. Account Naming Convention (3:27)
   2. Add/Remove Asset/Liability Accounts (7:43)
   3. Add/Remove Expense Accounts (4:07)
   4. Add/Remove Income Accounts (10:27)
   5. Swapping out Entire Chart of Accounts (4:11)
4. Checking6677 Tab - Overview (7:00)                    (Total time for Checking6677 ~ 39 minutes)
   1. Sorting by Column (Sort Sheet A-Z), Optional Txn ID Column Into, and View>Freeze Bar Intro (5:15)
   2. Date Column details and Inserting/Removing Transactions in the ledger (6:28)
   3. Payor/Payee, Transaction Amount, Categorizing Transactions and "Memorized Transactions" (6:41)
   4. Acct1 Column details, Running Balance Column details, and  the Red, ArrayFormula Equation Row (4:39)
   5. Split Transactions and Split Transaction Column alternate use (4:15)
   6. Optional TxnID Column Details (5:04)
5. CreditCard8899 Tab (4:47)
6. TxnAggregator Tab (4:10)​​
7. Transaction Search Tab (5:36)
8. Income Statement Tab (7:03)
9. Income Statement by Month Tab (x:xx)
10. Income Statement by Month - Graph Tab (2:40)
11. Reconciliation Tab (16:08)
12. Non-Inc/Exp Txns Tab (5:14)
13. Other Expenses (2:07

Detailed Videos > Silent Tabs

1. Validation Lists Tab (6:12)
2. _rawTxns1_Checking6677 Tab (10:43)
3. _rawTxns2a_CC8899_corp Tab (6:04)
4. _rawTxns2b_CC8899_john Tab - [see video 3  - _rawTxns2a_CC8899corp Tab - info included there]
5. _JDA Demo Data Backup Tab (1:30)