Skip to content

a nodejs app to automate the dreaded bank reconciliation process by automatically removing any matching instances (duplicates) found in the user and the bank records.

License

Notifications You must be signed in to change notification settings

ali-farhad/auto_bank_reconcilation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Automated Bank Reconciliation

This handy little website finds matching instances between your records (vouchers, transactions etc.) to that of your banks, and spits out a new excel (.xlsx) file, with all the matching records removed out of the box. you can use this to automate the horrid process of bank reconciliation which has to happed at the end of almost every month. this site aaves a lot of Manual Tick-Off & Saves a Lot of Time!

In order to make this project work you need 3 things: * Python3

  • nodeJS
  • an .XLSX file (with bank records)
  • an .XLSX file (with account book records)

How-To (Easy-Way):

  • make sure your files are ready as described below in the hard-way section
  • go to: https://road-future-softball.glitch.me/ and follow the instructions!

How-to (Harder-Way):

  • Create an excel file for your bank records
  • make sure that the sheet as the exact same columns as below:
Sr Cheque Dr Cr
1 123 5000
2 4567 9000
3 -9345
  • create an excel file for your bank book / local records
  • make sure that the sheet has the exact same columns as below:
Sr Cheque Dr Cr
1 123 5000
2 4567 9000
3 -9345
2 34637 8000
  • download this entire repo

  • download nodeJs from https://nodejs.org/en/download

  • go to the folder root and enter the following commands:

  • npm install && npm run dev

  • go to : http://localhost:5000/

  • after the script is done, your downloaded result file will have duplicates value removed from both bank sheet and bankbook / local sheet. leaving you with unique records that will need to be reconciled manually.

Warning:

  • the order of column matters.
  • the name of column matters. make sure your sheet has exact same names as shown above
  • for reference, you can look into sample files placed in public/samples folder

Side Note:

* I have the whole script in exe format, so if you are not concerned with all the

technical details. shoot me an email. I will be more than happy to provide you with direct .exe file

TO-DO:

  • make the code more modular
  • create a GUI app, may be?

Stuff used to make this:

  • SheetJs for parsing excel files

  • Bootstrap 5 for styling

  • Nodejs, expressJs, and EJS for the rest of functionality

Donations

"Buy Me A Coffee"

About

a nodejs app to automate the dreaded bank reconciliation process by automatically removing any matching instances (duplicates) found in the user and the bank records.

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published