Excel Sales Data Entry & Tracking

via Freelancer ·

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.
visual basic data processing data entry excel excel macros data visualization data analysis data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.