Bookkeeping - 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.
This is how the statements and CSV files on Bilbo's Bank Website were created.
* -- 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).