Automated Excel Payment Tracker

I have the raw customer-payment table ready and now I need it turned into a clean, easy-to-update Excel workbook that tracks every rupee at a glance. What I need built • Formulas that instantly calculate each customer’s pending amount and assign the correct “paid”, “partial”, or “unpaid” status... (Budget: ₹750 - ₹1250 INR, Jobs: Data Analysis, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic)