Software > Box 5 > Bookkeeping (BK-PN)

Template(s):   ​​  ZAP_b5_BK_PN (stable copy)   |  ZAP_b5_BK_PN (devCopy-101)
     b5   => This template is part of our "Box 5" offerings. 
     BK  => "Bookkeeping"
     PN  => "Positive and Negative values" (as opposed to DB for debits and credits)
     Stable Copy => the copy you should download for use. It "should" work properly.
     Developers Copy => a prior stable copy with mods for testing and demo purposes
New File Configuration Survey:  view
Written Education:
  • When you become serious about learning how to use this software, read this Written Education first at your own pace. Learning new technical information from videos or speech is too overwhelming and you are left without quick reference material.  .
  • After you have vocabulary and mental framework established, proceed to the videos and/or the subdomains
Intro Videos:  Support Subdomains:     2/12/2022, the rest of these need a final cleanup... 
  • bk-simulation-guide - Use the Transaction Generator for Simulation Exercises
  • bk-programmer-guide - A personal guide through the programming on each W/S
  • NOTE: bk-master-guide taken offline. had details about $5M threshould and cash/accrual bsaed accounting. Need to relocate that info somewhere. 
Visuals: (some of these are included in the support subdomains where relevant)
  1.  BK Data Flow Document  (coming soon)
  2. Journals to General Ledger Logic Flow LC(1)
  3. File Architecture LC(1)
  4.  Download and Install LC(1)
  5. ZAP Bookkeeping Template vs Quickbooks LC(5)
  6. Single Entry vs Double Entry Bookkeeping LC(2) 
  7. 4 Step Bookkeeping ( Single Entry Bookkeeping )   LC(3)
  8. 5 Step Bookkeeping ( Double Entry Bookkeeping )  LC(6)​
Application Specific Process:
  1. Trust management LC(3)
Video posted 2/3/2021. This is a first take for demonstration purposes only. It needs a bit more energy and polish but the gist is there.  The next version should be posted in next 24-48 hours. Landing page videos are a key to uptake that were omitted for a few years now to give time for some to adjust accordingly.  Time's up.
TECHNICAL DETAILS
Approximate # of Active Worksheets: 40
Approximate. # of silent worksheets: 7
​Array Formulas: 100
Internal / Bound Script Project used? Yes
External / Unbound Script Project used? Yes Prior Support:
DESCRIPTION
This is a full bookkeeping solution with General Journal, General Ledger, Income Statement and Balance Sheet.  This is designed for Tax Accounting needs and designed to replace Quickbooks, Freshbooks and comparable commercial bookkeeping solutions. 
IMAGE CAROUSEL
Due to the size of this file , only a portion of the images are shown below. 

OLDER FORMAT for the doc presentation

All these docs are now available at the different subdomains...
Left her for reference only for now...
An external mouse and two or more monitors are highly suggested for  both education and operational use. Without those this is a much more challenging experience. 
gDriveDocs 

Documents

120) BIG PICTURE DOCUMENTS  
  1. Expected and Unexpected Features, Benefits and Drawbacks (no images)  gDoc(x)
  2. ZAP vs Quickbooks Comparison and Bookkeeping For Tax Accounting Education LC(5) 
  3. Single Entry vs Double Entry Accounting  Leads to  3 and 4 Step Bookkeeping   LC(8)​
  4. Introductory Presentation  LC(12)  | ​ Notes ​
    Small Business Accounting System Models (2) , Bookkeeping for Tax Accounting Simplified (2), Bookkeeping Module Ethos - It's Revolutionary (1), Use Scenarios / User Scenarios (1) , Google Platform Introduction - One of the Benefits of Use is a forced exploration of Google's Platform (1), Google Account Introduction (1), Google Drive Introduction(1) 
  5.  GSheet File Template and Application Architecture Diagram LC(1)
  6.  Journals to General Ledger Flow  LC(1)
  7.  Financial You  LC(1)
  8. Detailed Screen Shots of all Worksheets ​gDoc(40+)​
  9. Marketing  

ch:5/23 d:1/40
Proud endorser of:
https://janeunchained.com/
200-260) "Download and install" iNSTRUCTIONS 
200) Download and Install - Summary Doc gDoc(4) | LC(1) 
210-260)  Extensive Step by Step documents found here
section ref:  11 docs / 84 pages
320) CONFIGURE FOR YOUR USE
Summary Document
320.0) Configure for Your Use (Chart of Accounts, ZIDs, Stmts, RawTxns, Journals, I/S, B/S ) gDoc(4)
320.0.1) New File Configuration Survey gDoc(3) | gS | video (5:43)   210.1
Detailed Documents
320.1) Chart of Accounts Worksheet gDoc(16) 
320.2) ZIDs Worksheet gDoc(3)
320.3) Statements Worksheet  gDoc(6)
320.4) Raw Transactions Worksheets (Checking and CC)  gDoc(9)
320.5) Journal Worksheets (Checking, CC, ExpPaidVia, General Journal, A/R) gDoc(4)
320.6) Transaction Aggregator Worksheet gDoc(3)
320.7) Income Statement Worksheet(s) gDoc(7)
320.8) Balance Sheet Worksheet gDoc(10)
320.9) _!config Worksheet  gDoc(3)

​10 docs / 67 pages
330) BASIC USE FOR YOUR FINANCIAL DATA
Summary Documents  
   330.0) Basic Use - Double Entry Bookkeeping w/o Debits & Credits. A 4 Step Process ( 6 pages )  gDoc(6) | diagram
   Other: Full presentation on Single and Double Entry Bookkeeping & 4 Step Double Entry Accounting  LucidChart(12) 
Detailed Documents
Step 1 - Record Transactions "Accurately"  (diagram)
   331.1.1) Input Checking and Credit Card Transactions into rawTxns Worksheets gDoc(15)​
   331.1.2) Copy/Input your Checking and Credit Card Transactions into Journal Worksheets  gDoc(7) 
   331.1.3)  Input Statement Data into Statements Worksheet  gDoc(8)
   331.1.4) CONFIRM STATEMENT BALANCES MATCH RUNNING BALANCES FOR ACCURACY  gDoc(8)
Step 2 - Categorize Transactions 
   331.2) Categorize Transactions (& Split Transactions) gDoc(10) | diagram
Step 3 - Review your Income Statement 
   331.3) Review Income Statement Worksheet  (aka Net Income Statement)  gDoc(12) | diagram
Step 4 - Review your Balance Sheet 
   331.4) Review Balance Sheet Worksheet (aka Comparative Net Worth Statement) gDoc(9)  | diagram

8 docs / 75 pages
340) ADVANCED USE FOR YOUR FINANCIAL DATA ​
  1. ​ExpensesPaidVia Journal
  2. General Journal
350) faq'S and Trouble Shooting for your Use
350.99) Known Bank Statement Issues gDoc(3)
410) Demo data File for education & bILBO'S bANK sIMULATION sYSTEM 
   410.1) About John Doe Acupuncture and the Demo Data Set gDoc(3)
   410.2) Demo Data File - Basic Worksheets (text only, no images)  gDoc(18) 
   410.3) Demo Data File - Advanced Worksheets (text only, no images)  gDoc(x)  pending
   410.99)  Demo Data File Exercises with Bilbo's Bank gDoc(28)
420) FINANCIAL MODELING WITH THE TRANSACTION GENERATOR
This Bookkeeping module contains four worksheets which can be used to create sample data. That is documented on the Box 5 > Transaction Generator page. 
​430) BANK STATEMENT GENERATOR TO CREATE FAUX BANKING dOCS & dATA FOR SIMULATION
This Bookkeeping module contains  one worksheet related to a Bank Statement Generator process. There is an entirely separate file template that is used to complete the faux statement and CSV file generation process.  Information on that can be found on the  Box 5 > Bank Statement Generator  page. 

This data is typically posted on a Faux Banking Website.  Our documetns on that can be found at Box 5 > Faux Banking Website . 

4) Other Documentation

1) current resources // Old Resources 
​Current Resources​
  1. ​Features and Benefits 
  2. Master Manual 1 
  3. New Client / New File Worksheet​
  4. GoogleSheet User's Guide ​ ​

Alternate Chart of Accounts
New Client Survey
​Sample Data, Data Simulation
  • BKxxxx - Faux Banking Website
  • BKxxxx - Bank Statement Generator
Accounting Educator Material
​Programming Educator Material

​
Older Resources
  1. Screen Shots​ (old version)
  2. Printouts (old version)
  3. Videos - Marketing and Education
  4. Videos - 2017 ​
  5. GoogleSheet CompanionFile - 2017
What's a HELOC in 1st?  Link coming soon...
ZAP Accounting Software - a 220Club Initiative - copywrite 2017 and beyond...
Proudly powered by Weebly