Somit Guha - Data Analyst | ContraWork by Somit Guha
Somit Guha

Somit Guha

Data expert: Fast typing, clean formatting, zero errors

    5.00
    Rating
    3
    Followers
Followed by Pankaj V, Tushar V, and Rajib B

Delhi, India

WorkPostsReviewsServicesAbout

Delhi, India

Cover image for 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.
2
0
107
Cover image for SOP - Oracle R12 Uploader Usage
SOP - Oracle R12 Uploader Usage
1
2
Cover image for Accounts Payable (AP) Efficiency &
Accounts Payable (AP) Efficiency & Throughput Dashboard I built a comprehensive operations dashboard to track invoice lifecycles, measure team performance, and pinpoint costly bottlenecks. This tool transforms raw corporate timeline data into actionable insights, helping finance leaders optimize workflows and scale their processing capacity.
0
104
Cover image for Automated AP Invoice Processing System (Excel & VBA)
Automated AP Invoice Processing System (Excel & VBA)
0
3