Bank Stmt/CSV Generator

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.

Create data in either the PN or DC version of the Double Entry Bookkeeping Module.
Make sure it reconciles on the statements tab
Cut and paste statement data and transaction data from Double Entry Bookkeeping module into parallel (PN or DC) version of this utility
Print Faux Bank Statements - one at a time*
Create CSV files - one at a time*
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).