1001 Freelance Projects -- eBay Sales Reconciliation & Categorisation Spreadsheet

Latest Projects from
Freelance Marketplaces

View this project in detail (Note: you will be redirected to external marketplace)
Project title:
eBay Sales Reconciliation & Categorisation Spreadsheet
Posted by:
External project from PeoplePerHour
Started:
05-Jun-2025 17:57 GMT
Description:
Scope of Work: Combine and clean all provided eBay sales/order reports (Excel format) for Q1 2025. Combine and clean all provided eBay payout/transaction reports (Excel format) for Q1 2025. Cross-reference sales and payout reports to: Ensure that all payouts correspond to reported sales. Reconcile any timing differences or mismatches. Flag and categorise each sale as either “marginal” or “standard-rated”: Use the provided margin stock book (Excel file) to identify the specific marginal transactions. Everything else should be categorised as standard-rated. Produce a single, consolidated spreadsheet with: eBay order number Date Item title Quantity Sale price Postage (if any) VAT rate VAT collected Fees (if available) Net payout VAT scheme (margin/standard) Reference to payout/bank record (if possible) Calculate total sales and net payouts for both margin and standard-rated sales. Highlight any discrepancies between sales, payouts, and bank statement records (if provided). What you will get from me: Multiple cleaned eBay sales/order Excel files for Q1 2025 Multiple cleaned eBay payout/transaction Excel files for Q1 2025 Margin stock book (Excel) showing exactly which orders are marginal Deliverable: One master Excel spreadsheet as described above, with all sales and payouts clearly reconciled and classified. A brief written summary of any findings, issues, or mismatches. Requirements: Experience with eBay sales reporting, VAT, and margin scheme work (preferred) Excellent Excel/data cleaning skills Can complete the project within 2–3 days (faster preferred) Good English communication
Project ID:
3435934
Project category:

Project budget:

View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
Automate Shopify Order Export and Integration with Internal System Category: Google Chrome, JavaScript, PHP, Shopify, Software Architecture Budget: $250 - $500 USD	02 Dec 2025 01:13 GMT
Solicitar cotizaciones de manera presencial en negocios de Cancún -- 30319 Category: Admin Support, Audit, Customer Service, Customer Support, General Labor, General Office, Local Job, Market Research, Marketing, Virtual Assistant Budget: $30 - $250 USD	01 Dec 2025 23:03 GMT
Update Corporate Event Invitation Category: Adobe Illustrator, Adobe InDesign, Photoshop, Branding, Graphic Design, Illustration, Invitation Design, Print Design, Visual Design Budget: $30 - $250 AUD	01 Dec 2025 23:01 GMT
Solicitar cotizaciones de manera presencial en negocios de Querétaro -- 75776 Category: Admin Support, Audit, Customer Service, Customer Support, General Labor, General Office, Local Job, Market Research, Marketing, Virtual Assistant Budget: $30 - $250 USD	01 Dec 2025 23:01 GMT
Gießen Verification Field Task Category: Customer Service, Data Collection, Data Entry, Field Sales, Geolocation, PDF, Photo Editing, Photography, Photoshop, PHP Budget: $30 - $40 USD	01 Dec 2025 23:00 GMT
Medir conversiones Google Ads & WhatsApp Category: A / B Testing, Analytics, API, Google Ads, Google Adwords, Google Analytics, JavaScript, PHP Budget: $30 - $250 USD	01 Dec 2025 22:59 GMT
Solicitar cotizaciones de manera presencial en negocios de Ciudad de México -- 64675 Category: Admin Support, Audit, Customer Service, Customer Support, General Labor, General Office, Local Job, Market Research, Marketing, Virtual Assistant Budget: $30 - $250 USD	01 Dec 2025 22:59 GMT
AI-Savvy Employment Lawyer Sought Category: AI (Artificial Intelligence) HW / SW, AI Consulting, AI Development, Employment Law, Legal, Legal Consultation, Legal Research, Property Law Budget: $30 - $250 USD	01 Dec 2025 22:59 GMT
Next.js Newsletter Signup Integration Category: API Development, Cloudflare, Frontend Development, HTML, JavaScript, Next.js, Web Development Budget: $30 - $250 USD	01 Dec 2025 22:59 GMT
Flutter Webview App & Admin Category: Android, Backend Development, Flutter, JavaScript, Mobile App Development, REST API, Web Development Budget: $250 - $750 USD	01 Dec 2025 22:57 GMT
Solicitar cotizaciones de manera presencial en negocios de Lerma -- 8 Category: Admin Support, Audit, Customer Service, Customer Support, General Labor, General Office, Local Job, Market Research, Marketing, Virtual Assistant Budget: $30 - $250 USD	01 Dec 2025 22:56 GMT
Short videos Category: A / V Editing, After Effects, Video Ads, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services, Video Streaming, Video Tours Budget: $30 - $250 USD	01 Dec 2025 22:56 GMT
24×36 Charcoal Portrait Gift -- 2 Category: Drawing Artist, Illustration, Matte Painting, Sketching Budget: $250 - $750 USD	01 Dec 2025 22:54 GMT
Custody Documentation and Temporary Order for Jackson County Missouri (64056) Category: Editing, Family Law, Legal Consultation, Legal Research, Legal Writing, Microsoft Word, PDF, Proofreading, Research Writing, Word Budget: $100 - $250 USD	01 Dec 2025 22:53 GMT
Vectorizar Gráficos Completos de Furgoneta Category: Adobe Illustrator, Graphic Design, Illustration, Logo Design, Photoshop, SVG, Vector Design Budget: €30 - €250 EUR	01 Dec 2025 22:53 GMT

Browse All Projects

New!
Проекты на русском (Projects in Russian)