Excel Accounts Receivables Spreadsheet Design
Budget: $10 – $30 USD
I am looking for an expert in Excel spreadsheet design to create a comprehensive and user-friendly accounts receivables sheet for my business.
Key Features:
- Calculation of total receivables
- Aging analysis of receivables
- Customer-wise summary of receivables
- Report by department
- Aging report
- Total Sales
- VAT report
- Report by month
Specific Formulas and Calculations:
- Sum
- Average
- Count
- Xlookup
Data Organization:
- By customer name
- By invoice date
- By payment due date
- By month
- By department
Ideal Skills:
- Proficiency in Excel and experience in creating complex spreadsheets
- Strong understanding of accounting principles and reporting
- Attention to detail to ensure accuracy in formulae and data organization
- Ability to design a user-friendly interface for easy data input and analysis
This project requires someone with a strong background in Excel and accounting, who can deliver a comprehensive and efficient tool to manage and analyze our accounts receivables.
Key Features:
- Calculation of total receivables
- Aging analysis of receivables
- Customer-wise summary of receivables
- Report by department
- Aging report
- Total Sales
- VAT report
- Report by month
Specific Formulas and Calculations:
- Sum
- Average
- Count
- Xlookup
Data Organization:
- By customer name
- By invoice date
- By payment due date
- By month
- By department
Ideal Skills:
- Proficiency in Excel and experience in creating complex spreadsheets
- Strong understanding of accounting principles and reporting
- Attention to detail to ensure accuracy in formulae and data organization
- Ability to design a user-friendly interface for easy data input and analysis
This project requires someone with a strong background in Excel and accounting, who can deliver a comprehensive and efficient tool to manage and analyze our accounts receivables.