Monthly Excel Account Statements
Budget: ₹600 – ₹1,500 INR
I need a detail-oriented finance professional to take raw bookkeeping data and turn it into clear, well-structured account statements every month. The final file must be delivered in Excel and include two key sections for each period: a complete transaction log and the corresponding opening, closing, and running balances. No additional account-holder details are necessary—just the numbers laid out so I can filter and pivot them quickly.
My preference is for someone who already works comfortably in Excel (Power Query or simple macros are a plus) and can keep a clean audit trail in case figures ever need to be traced back. Each monthly statement should arrive ready for review within three business days of month-end.
Deliverable
• One Excel workbook per month containing:
– Chronological transaction list
– Opening, running, and closing balances
I’ll provide the raw exports and a sample layout on award; you return the finished file in the same folder structure. Accuracy and consistency are critical, so let me know what checks you normally run before sending the work back.
My preference is for someone who already works comfortably in Excel (Power Query or simple macros are a plus) and can keep a clean audit trail in case figures ever need to be traced back. Each monthly statement should arrive ready for review within three business days of month-end.
Deliverable
• One Excel workbook per month containing:
– Chronological transaction list
– Opening, running, and closing balances
I’ll provide the raw exports and a sample layout on award; you return the finished file in the same folder structure. Accuracy and consistency are critical, so let me know what checks you normally run before sending the work back.
Related categories:
Data Processing
Data Entry
Accounting
Excel
Financial Analysis
Bookkeeping
Excel Macros
Data Analysis