Custom Payment Tracker Excel
Budget: ₹600 – ₹1,500 INR
I'm looking for a skilled Excel professional who can create a detailed, user-friendly template tailored to my needs for managing customer payments for a new residential building. This tool must give me a clear view of financial transactions and outstanding balances.
Requirements:
- Generate unique customer profiles capturing name, rate per sq. yard, payment terms, and payment history
- Automatically calculate current outstanding amounts, incorporating cash and bank payment segregation
- A clearly defined section for cash and bank transactions
- Easy manual data entry system for recording new payments
Ideal Skills:
- Advanced proficiency in Excel formulas and functions
- Experience with financial tracking and reporting
- Detail-oriented with strong organizational skills
- Excellent communication for any needed clarifications
The right candidate will deliver a template that simplifies my financial monitoring, ensuring accuracy and ease of use. If you have a proven track record and the skills needed, please bid on this project.
Requirements:
- Generate unique customer profiles capturing name, rate per sq. yard, payment terms, and payment history
- Automatically calculate current outstanding amounts, incorporating cash and bank payment segregation
- A clearly defined section for cash and bank transactions
- Easy manual data entry system for recording new payments
Ideal Skills:
- Advanced proficiency in Excel formulas and functions
- Experience with financial tracking and reporting
- Detail-oriented with strong organizational skills
- Excellent communication for any needed clarifications
The right candidate will deliver a template that simplifies my financial monitoring, ensuring accuracy and ease of use. If you have a proven track record and the skills needed, please bid on this project.