Excel Sales Data Entry & Tracking
Budget / Salary$250–750
TypeFreelance project
LocationRemote
Posted1 hour ago
I regularly receive batches of sales, invoice, and payment records and need them turned into a clean, reliable Excel workbook that lets me track every transaction at a glance. Your task is straightforward but accuracy-critical: enter the figures exactly as provided, format them consistently (dates, currency, invoice numbers), and structure the sheets so totals, outstanding balances, and monthly summaries update automatically.
A typical batch arrives as CSVs or scanned PDFs. Once entered, the file should show billed amounts, payments received, and any open invoices without my having to hunt through rows. Tables, filters, conditional formatting, and formulas such as SUMIFS or XLOOKUP are welcome as long as the sheet remains easy for me to extend later.
Deliverables
• One fully populated, well-formatted Excel workbook per data drop
• A summary sheet that rolls up sales vs. payments and flags unpaid items
• A brief note on any discrepancies or assumptions encountered
Data is confidential, so discretion is a must. Small sets may come through weekly, larger sets monthly; let me know your typical turnaround time and any questions about file structure. If everything runs smoothly, I’d like this to become an ongoing collaboration.
A typical batch arrives as CSVs or scanned PDFs. Once entered, the file should show billed amounts, payments received, and any open invoices without my having to hunt through rows. Tables, filters, conditional formatting, and formulas such as SUMIFS or XLOOKUP are welcome as long as the sheet remains easy for me to extend later.
Deliverables
• One fully populated, well-formatted Excel workbook per data drop
• A summary sheet that rolls up sales vs. payments and flags unpaid items
• A brief note on any discrepancies or assumptions encountered
Data is confidential, so discretion is a must. Small sets may come through weekly, larger sets monthly; let me know your typical turnaround time and any questions about file structure. If everything runs smoothly, I’d like this to become an ongoing collaboration.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.