Members > Video Library > Part A
This will be a paid, subscribers only section...
We've done the majority of the videos below with the Debits and Credits version so apples to apples comparisons can be made to past accounting software. The Debits and Credits version of Part A is nearly identical to the Positive and Negative values version. Occasionally we reference the Postive and Negative values version and at the bottom there is (will be) a section specific to it's features.
1) Part A > Overview Videos
2) Part A > Procedural Videos > One Time Setup Items
With a gmail account or a google suite account you automatically get access to your own 'google drive'. In any browser, type "drive.google.com". Login if requested. These directions pickup there...
# | Video Description | Time | View |
---|---|---|---|
1 | Create a Folder Structure in Google Drive for a new business and ZAP Accounting related files | 4:00 | view |
2 | Download ZAP Accounting Software Part A from our website, move it to an appropriate folder, and make several copies | 4:00 | view |
3 | Open your working copy of Part A, remove Demo Data, and prepare the file for your personal data | 6:40 | view |
4 | AND Oops! do this too! | 0:21 | view |
5 | Testing 9 min video | 0:21 | view |
- Create a Folder Structure in Google Drive for a new business and ZAP Accounting related files (4:00)
- Download ZAP Accounting Software Part A from our website, move it to an appropriate folder, and make several copies (4:00)
- Open your working copy of Part A, remove Demo Data, and prepare the file for your personal data (6:40)
- AND Oops! do this too! (0:21)
3) Part A > Procedural Videos > Bookkeeping Routine
- Download Data from your bank (4:52)
- Open Download files and copy and paste below Grey Bar in a rawTxns Tabs. Optional - store download files (5:29)
- Troubleshooting -- Handling CSV files that won't open in Excel or Google Sheets (5:05)
- One Time Setup -- Raw Txns Tabs - Grey Bar Customization Process (3:41)
- One Time Setup -- Raw Txns Tabs - Green Bar - Customization Process (9:41)
- One Time Setup -- Starting Balance (4:16) AND Oops! This too! (1:04)
- Filter downloaded data below Green Bar in rawTxns Tab, enhance data as desired, and cut and paste into Checking or Credit Card Ledger (3:44)
- Categorize Transactions in Checking or Credit Card Ledger (3:54) AND Oops! This too! (1:01)
- View and Print Transaction Reports and Income Statement Reports (2:12)
- Reconcile Checking and Credit Card Ledgers - an intro (4:40)
4) Part A > Detailed Videos > Working Tabs
- Home Tab (8:54)
- Notes Tab (5:23)
- Chart of Accounts Tab - Overview (4:36) (Total time for Chart of Accounts ~ 33 minutes)
- Checking6677 Tab - Overview (7:00) (Total time for Checking6677 ~ 39 minutes)
- Sorting by Column (Sort Sheet A-Z), Optional Txn ID Column Into, and View>Freeze Bar Intro (5:15)
- Date Column details and Inserting/Removing Transactions in the ledger (6:28)
- Payor/Payee, Transaction Amount, Categorizing Transactions and "Memorized Transactions" (6:41)
- Acct1 Column details, Running Balance Column details, and the Red, ArrayFormula Equation Row (4:39)
- Split Transactions and Split Transaction Column alternate use (4:15)
- Optional TxnID Column Details (5:04)
- CreditCard8899 Tab (4:47)
- TxnAggregator Tab (4:10)
- Transaction Search Tab (5:36)
- Income Statement Tab (7:03)
- Income Statement by Month Tab (x:xx)
- Income Statement by Month - Graph Tab (2:40)
- Reconciliation Tab (16:08)
- Non-Inc/Exp Txns Tab (5:14)
- Other Expenses (2:07)
5) Part A > Detailed Videos > Silent Tabs
- _Validation Lists Tab (6:12)
- _rawTxns1_Checking6677 Tab (10:43)
- _rawTxns2a_CC8899_corp Tab (6:04)
- _rawTxns2b_CC8899_john Tab - [see video 3 - _rawTxns2a_CC8899corp Tab - info included there]
- _JDA Demo Data Backup Tab (1:30)