New Record Added -> Search Vendor-> Connect Vendor

Problem:

Manual matching of bank transactions with vendors was time-consuming and prone to errors

Solution:

Built an automated workflow in Airtable that checks new bank records against the Vendors table using Description and Reference fields

Result:

Improved accuracy, reduced manual effort, and ensured faster transaction reconciliation