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 > Bank Stmt/CSV Generator



​Instructions:  Click on link to open. From File menu, select File > Make a Copy.  Then make another copy for you to use. Keep your original in a safe place for reference in case you mess up some of the original programming. ​
  • ZAP_BK_PN_BankStmtGenerator  - The PN refers to the transaction data being pasted in. You must use the parallel utility based on your source data. The Statements and CSV files are also aligned to produced single digit, signed data, but those could be modified. 
  • ZAP_BK_DC_BankStmtGenerator  - The DC refers to the transaction data being pasted in. You must use the parallel utility based on your source data. The Statements and CSV files are aligned to produce dual column information without signs but those could/should be modified for training and education. Show them how the banks intentionally produce confusing statements for pleasure.

These versions require transactions and statement data to be pasted in. A modified version is coming where only transactions are needed. The statement data, if it is not had, will simply be created from the transactions themselves. 

Details

This is how the statements and CSV files on Bilbo's Bank Website were created.
  1. Create data in either the PN or DC version of the Double Entry Bookkeeping Module. 
  2. Make sure it reconciles on the statements tab
  3. Cut and paste statement data and transaction data from Double Entry Bookkeeping module into parallel (PN or DC) version of this utility
  4. Print Faux Bank Statements - one at a time*
  5. Create CSV files - one at a time*
  6. Use for Educational and training purposes. Ideal for accounting education, programming education or occupational simulation. Build a faux website similar and/or different. Will share this for copying purposes if interested.  https://bilbos-bank.bryancanary.com/

​* -- Please note, we will have a version of these which allows you to bulk print the statements and bulk create the CSV files. Big time saver and bad a-s code with many applications.  The bulk processing version is all open source code, so those interested in learning can see how it all works too. It is $29 for that module (or it may be free too, tbd).
Picture
What's a HELOC in 1st?  Link coming soon...
ZAP Accounting Software - a 
220Club Initiative - copywrite 2017 and beyond...
Proudly powered by Weebly