i wrote a vba macro to help with reconciliation of a excel Check Register with downloaded banks transaction, I attached it here for people who find it useful.
see the attached excel sheet for an example, also note the settings in the named range bank_reconcile_settings
this was built and tested on transactions downloaded from chase, there might be some changing needed for different banks (see the line Interchangeable transactions names)
Last edited by nykbakery; 08-11-2020 at 11:17 AM.
Reason: updated file