Accounts Payable (AP) Invoice Automation: The

Accounts Payable (AP) Invoice Automation:

The project automates the Accounts Payable process by consolidating separate financial data files.

Using Excel’s VLOOKUP function, it links a central summary sheet (AP_Summary.xlsx) with two source workbooks to automatically fill in missing information. It reads the Vendor ID to pull the matching company name from Vendor_Master.xlsx. It reads the Invoice Number to pull the correct billing total from Invoice_Register.xlsx. This process eliminates manual cross-referencing, cuts down on data entry errors, and instantly creates a unified financial dashboard for efficient invoice tracking and accurate bookkeeping.