ZAP ACCOUNTING SOFTWARE
  • Home
  • Testimonials
    • Sales System Templates
    • Bookkeeping Template
  • The Challenge
  • Education
    • !! Start Here !!
    • ----------------------
    • Single Page Visuals (and more...)
    • Fun Seekers Corner >
      • FSC 101
    • Accounting Studio Magic >
      • ASM 101
      • ASM 103
    • ----------------------
    • Software in Greater Detail... >
      • Spreadsheets 101
      • Sales Systems 101
      • Bookkeeping 101
      • DIY Software Programming 101
    • Intro Videos
    • Books & Pamphlets
    • ------------------------
    • Empowerment
    • Reimagination
    • ----------------------
    • End User Benefits
    • FAQs
  • Software
    • !! Start Here !!
    • ----------------------
    • Via the 6 Box Model
    • ------ By Box -----
    • Box 1 >
      • Invoicing 101 - Petes Electric
      • Statements 101 - Martha's Counseling
      • Legal Billing (images only)
    • Box 2 >
      • Expense and Profit Analysis
      • Time and Attendance
      • Payroll System
    • Box 3 >
      • Bank Deposit Prep WB
      • Acc'ts Receivable - Digital Bar Tab
      • Acc'ts Receivable - Double Entry
    • Box 4 >
      • Check Journal Example
      • Check Journal w/ 3 up Printing
      • Acc'ts Payable - Simple Digital List
    • Box 5 >
      • Bookkeeping
      • Transaction Generator
      • Bank Statement Generator
      • Bilbo's Bank - Faux Bank Website
      • Manual Balance Sheets
    • Box 6 >
      • Tax Prep Summary Worksheet
      • Tax Return Journals
      • Taxable Income Tracking
      • Tax Simulation & Estimating (Fed, State, PremTaxCred)
      • Real Estate Transaction Journal
      • Sales Tax Remittance Tracking
    • ------------------------
    • Other >
      • Accounting Master File
      • DIY1 uBoundGScriptProject
  • FAQs
  • More...
    • Orientation >
      • ------ INFORMAL ------
      • Models & Data Flow for folks on the GO!
      • Problems, Solutions and Bigger Backstory
      • ------- FORMAL -------
      • Step 1 - Welcome
      • Step 2 - Custom For You... >
        • Accounting Alchemists
        • Categorizing Crackerjacks
        • Simmering Sages
        • Sorcerous Students
        • Magical Millennials
        • Enchanting Educators
        • Spreadsheet Gurus, Javascript Wizards, Database Devils, & Full Stack Devs too...
      • Step 3 - Reunited!
      • Step 4 - The Accounting System 6 Box Model
      • ----------------------
    • For CPAs >
      • Welcome & Orientation
      • Resources >
        • Bookkeeping Template Data Flow Details
        • Balance Sheet Re-imagined
        • Income Statement Re-imagined
        • Bookkeeping Re-Imagined
        • Demystification Documents
        • Empowerment For CPAs
      • Notifications >
        • 11/6/2021 - Sea Change Notice
        • 1/17/2022 - The Opportunity
        • 5/14/2022 - Seeking CPE Partners
    • Contribute
    • Admin > Login/Logout
    • Archive >
      • Home_out20210331
      • Commerce Snippets
    • About
    • Contact
  • Home
  • Testimonials
    • Sales System Templates
    • Bookkeeping Template
  • The Challenge
  • Education
    • !! Start Here !!
    • ----------------------
    • Single Page Visuals (and more...)
    • Fun Seekers Corner >
      • FSC 101
    • Accounting Studio Magic >
      • ASM 101
      • ASM 103
    • ----------------------
    • Software in Greater Detail... >
      • Spreadsheets 101
      • Sales Systems 101
      • Bookkeeping 101
      • DIY Software Programming 101
    • Intro Videos
    • Books & Pamphlets
    • ------------------------
    • Empowerment
    • Reimagination
    • ----------------------
    • End User Benefits
    • FAQs
  • Software
    • !! Start Here !!
    • ----------------------
    • Via the 6 Box Model
    • ------ By Box -----
    • Box 1 >
      • Invoicing 101 - Petes Electric
      • Statements 101 - Martha's Counseling
      • Legal Billing (images only)
    • Box 2 >
      • Expense and Profit Analysis
      • Time and Attendance
      • Payroll System
    • Box 3 >
      • Bank Deposit Prep WB
      • Acc'ts Receivable - Digital Bar Tab
      • Acc'ts Receivable - Double Entry
    • Box 4 >
      • Check Journal Example
      • Check Journal w/ 3 up Printing
      • Acc'ts Payable - Simple Digital List
    • Box 5 >
      • Bookkeeping
      • Transaction Generator
      • Bank Statement Generator
      • Bilbo's Bank - Faux Bank Website
      • Manual Balance Sheets
    • Box 6 >
      • Tax Prep Summary Worksheet
      • Tax Return Journals
      • Taxable Income Tracking
      • Tax Simulation & Estimating (Fed, State, PremTaxCred)
      • Real Estate Transaction Journal
      • Sales Tax Remittance Tracking
    • ------------------------
    • Other >
      • Accounting Master File
      • DIY1 uBoundGScriptProject
  • FAQs
  • More...
    • Orientation >
      • ------ INFORMAL ------
      • Models & Data Flow for folks on the GO!
      • Problems, Solutions and Bigger Backstory
      • ------- FORMAL -------
      • Step 1 - Welcome
      • Step 2 - Custom For You... >
        • Accounting Alchemists
        • Categorizing Crackerjacks
        • Simmering Sages
        • Sorcerous Students
        • Magical Millennials
        • Enchanting Educators
        • Spreadsheet Gurus, Javascript Wizards, Database Devils, & Full Stack Devs too...
      • Step 3 - Reunited!
      • Step 4 - The Accounting System 6 Box Model
      • ----------------------
    • For CPAs >
      • Welcome & Orientation
      • Resources >
        • Bookkeeping Template Data Flow Details
        • Balance Sheet Re-imagined
        • Income Statement Re-imagined
        • Bookkeeping Re-Imagined
        • Demystification Documents
        • Empowerment For CPAs
      • Notifications >
        • 11/6/2021 - Sea Change Notice
        • 1/17/2022 - The Opportunity
        • 5/14/2022 - Seeking CPE Partners
    • Contribute
    • Admin > Login/Logout
    • Archive >
      • Home_out20210331
      • Commerce Snippets
    • About
    • Contact

 Software > Box 5 > Bank Statement Generator (PN)

Template:  ​​ZAP_b5_BK_PN_Bank_Stmt_Generator   
Related Website:  https://bilbos-bank.zap-accounting-software.com
Picture
TECHNICAL DETAILS
Approximate # of Active Worksheets: 10
Approximate. # of silent worksheets: 3
​Array Formulas: 13
Internal / Bound Script Project used? Yes

External / Unbound Script Project used? Yes
DESCRIPTION
Use the Transaction Generator to generate data for simulation.

Copy and paste the statement and journal data that was generated from that processing into this workbook, and then you can create PDFs and CSVs of that data to turn that data into "Banking Data" that can then be used to repopulate empty with a normal work flow for purposes of hands-on learning that is relevant to a given group. 

This file has some fairly complex array formulas and very powerful scripts.  The process itself can get a little confusing as you are creating these documents from the data that they would have generated, but it makes more sense when you remind yourself you would first use the Transaction Generator to generate data from your imagination to start with.

This is an advanced module that is exceptional for advanced educators and programmers. 
IMAGE CAROUSEL
Additional Documents and Details
4xx.0) Bank Statement Generator Docs4 gDoc(16) ​
What's a HELOC in 1st?  Link coming soon...
ZAP Accounting Software - a 
220Club Initiative - copywrite 2017 and beyond...
Proudly powered by Weebly