Computer Applications
Automated Bank Reconciliation and GSTR-2B Vendor Matching Toolkit (Excel-VBA) for a Modelled Trading SME
Two monthly chores every SME accountant dreads — BRS and ITC matching — reduced to two button clicks and one exception list
- MS Excel 2016+ with VBA (macro-enabled .xlsm workbook)
- VBA: Scripting.Dictionary matching engine, CSV import, parameterised tolerances, self-test harness
- Tally Prime (bank ledger export, purchase register export, inbuilt BRS for cross-check)
- +2