Weekly Business Data Entry Support
Budget: ₹750 – ₹1,250 INR
I keep my sales ledger and customer records in Excel and I’m looking for someone who can take over the weekly upkeep. Each week you’ll receive a folder of raw data exports (transaction logs from our POS and new customer sign-ups). Your job is to clean the files, append them to the master workbook, and make sure every figure lines up with the control totals I’ll provide.
Because I rely on pivot tables to monitor trends, you’ll need to be comfortable adding new data to an existing model, refreshing the pivots, and checking that the calculated fields still reconcile. Occasional quick analyses—such as highlighting unusual spikes or overdue balances—are welcome; I use those insights in Monday morning meetings.
Accuracy and consistency matter more than speed. At the end of each weekly cycle I expect:
• An updated Excel workbook with all transactions and customer details fully integrated
• Refreshed pivot tables (sales by product, revenue by channel, active customer count)
• A short note flagging any discrepancies or noteworthy findings
The core scope is entering transaction records and managing customer information, though I may ask for inventory updates in the future. If you’re comfortable with intermediate Excel functions—data cleaning, lookups, pivot tables—this should be straightforward. I’ll share the template and naming conventions once we start so we’re both working from the same playbook.
Because I rely on pivot tables to monitor trends, you’ll need to be comfortable adding new data to an existing model, refreshing the pivots, and checking that the calculated fields still reconcile. Occasional quick analyses—such as highlighting unusual spikes or overdue balances—are welcome; I use those insights in Monday morning meetings.
Accuracy and consistency matter more than speed. At the end of each weekly cycle I expect:
• An updated Excel workbook with all transactions and customer details fully integrated
• Refreshed pivot tables (sales by product, revenue by channel, active customer count)
• A short note flagging any discrepancies or noteworthy findings
The core scope is entering transaction records and managing customer information, though I may ask for inventory updates in the future. If you’re comfortable with intermediate Excel functions—data cleaning, lookups, pivot tables—this should be straightforward. I’ll share the template and naming conventions once we start so we’re both working from the same playbook.