Daily Sales & Purchase Updates

Customer: AI | Published: 30.12.2025
Бюджет: 750 $

I keep a live Google Sheets workbook that tracks both sales and purchase activity, and it now needs a reliable daily touch-up. Every 24 hours I pull fresh order data from the POS along with supplier invoices; your task is to enter those numbers into the correct tabs, double-check formulas and running balances, and make sure everything ties out. You will be working directly in Google Sheets, so familiarity with its formulas, filters, data validation and, if you prefer to speed things up, Google Apps Script, will help. Accuracy is more important than speed: quantities, unit costs, tax columns and totals must match the source documents exactly, and any mismatch should be flagged in a comments column before the next business day. Deliverables each day: • All new sales and purchase records entered in the proper format • Reconciled subtotals that agree with the source reports (no broken links or #REF! errors) • A brief note highlighting any discrepancies or missing paperwork If you already have a systematic way of importing CSVs or automating repetitive parts, feel free to propose it once your first few manual updates prove accurate.