ZAP ACCOUNTING SOFTWARE
  • FAQs
    • FAQs > End Users
    • FAQs
  • Testimonials
    • For the Bookkeeping Module
    • Other
  • Orientation
    • Step 1 - You have arrived!
    • Step 2 - Custom For You... >
      • Accounting Alchemists
      • Categorizing Crackerjacks
      • Simmering Sages
      • Sorcerous Students
      • Magical Millennials
      • Enchanting Educators
      • Spreadsheet Gurus
    • Step 3 - Reunited!
    • Step 4 - The Accounting System 6 Box Model
  • Resources
    • "Software"
    • Intro Videos >
      • Bookkeeping Template Intro
      • Bookkeeping Template Intro (2017)
    • Books & Pamphlets
    • Subdomains for Ed
    • Visuals
    • other >
      • Outreach
      • Reimagination
  • Software
    • The 6 Box Model
    • ------ By Box -----
    • Box 1 >
      • Legal Billing
    • 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
  • Support
  • Cashier
    • Suggested Licensing Fees & Donation Amounts
    • Make a Payment
  • More...
    • Login/Logout
    • Press Releases
    • Thought Leaders
    • About
    • Contact
    • Research
  • FAQs
    • FAQs > End Users
    • FAQs
  • Testimonials
    • For the Bookkeeping Module
    • Other
  • Orientation
    • Step 1 - You have arrived!
    • Step 2 - Custom For You... >
      • Accounting Alchemists
      • Categorizing Crackerjacks
      • Simmering Sages
      • Sorcerous Students
      • Magical Millennials
      • Enchanting Educators
      • Spreadsheet Gurus
    • Step 3 - Reunited!
    • Step 4 - The Accounting System 6 Box Model
  • Resources
    • "Software"
    • Intro Videos >
      • Bookkeeping Template Intro
      • Bookkeeping Template Intro (2017)
    • Books & Pamphlets
    • Subdomains for Ed
    • Visuals
    • other >
      • Outreach
      • Reimagination
  • Software
    • The 6 Box Model
    • ------ By Box -----
    • Box 1 >
      • Legal Billing
    • 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
  • Support
  • Cashier
    • Suggested Licensing Fees & Donation Amounts
    • Make a Payment
  • More...
    • Login/Logout
    • Press Releases
    • Thought Leaders
    • About
    • Contact
    • Research

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
ZAP Accounting Software - a 220Club Initiative - copywrite 2017 and beyond...
Proudly powered by Weebly