Custom Residential Payment Tracker

I'm looking for an expert to create a comprehensive Excel template to manage customer payments for a residential building. It's essential that the template be user-friendly and allow me to smoothly track various payment metrics for each customer.

Key Features of the Template:

- **Payment categorization** for cash and bank transfers.
- **Custom rates tracking** per square yard for each customer.
- **Differentiated payment terms** management for all customers.
- **Summary dashboard** including an overview of all payments and outstanding balances, but no late fees or penalties calculations as these are not applicable to our project.

Ideal Skills and Expertise:

- Proficiency in Excel with strong experience in designing financial or accounting templates.
- Ability to implement formulas for customized rate calculations and payment tracking.
- Experience in creating user-friendly dashboards for financial data.
- Attention to detail and understanding of real estate payment structures.

If this project suits your skill set and experience, please place your bid. Your expertise could greatly streamline our payment collection process!