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
Google Sheets Balance Sheet Entry Category: Accounting, Data Analysis, Data Entry, Data Management, Data Processing, Excel, Google Sheets, Visual Basic Budget: ₹750 - ₹1250 INR	19 Jan 2026 11:04 GMT
One-on-One Quran & Arabic Tutoring -- 2 Category: Arabic Translator, Education & Tutoring, Language Tutoring, Personal Development, Teaching / Lecturing, Translation Budget: $10 - $30 AUD	19 Jan 2026 11:04 GMT
Raw Material Inventory Excel Sheet Category: Data Analysis, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Excel Macros, Excel VBA, Inventory Management, Visual Basic Budget: ₹100 - ₹400 INR	19 Jan 2026 11:03 GMT
Modern Logo Design Project Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Visual Design Budget: $750 - $1500 USD	19 Jan 2026 11:03 GMT
GST Filing Assistance with CA Category: Accounting, Documentation, Finance, Tax, Tax Compliance, Tax Law, Tax Management Consulting, Tax Preparation Budget: ₹600 - ₹1500 INR	19 Jan 2026 11:03 GMT
Male Kannada Voice Over for Relationship Stories (Romantic Tone) Category: Audio Production, Audio Services, Creative Writing, Fiction, Voice Talent Budget: min ₹600 INR	19 Jan 2026 11:02 GMT
Photographer for Thailand Bachelor Trip Category: 3D Modelling, 3D Rendering, Color Grading, Drone Photography, Photography, Photoshop, Video Editing, Videography Budget: ₹12500 - ₹37500 INR	19 Jan 2026 11:02 GMT
City Google Maps Data Scrape Category: Cartography & Maps, Data Collection, Data Entry, Data Management, Data Mining, Data Processing, Data Scraping, Excel, Google Sheets, Web Scraping Budget: $30 - $250 AUD	19 Jan 2026 11:00 GMT
Logo Modern & Copywriting Category: Adobe Illustrator, Photoshop, Branding, Content Writing, Copywriting, Corporate Identity, Graphic Design, Logo Design Budget: $250 - $750 USD	19 Jan 2026 11:00 GMT
Paid Research study (IDIs) – Airport Cargo Community Systems (ACCS) \| Global Transportation Sector Category: Cargo Freight, Logistics, Strategic Planning, Supply Chain Budget: min $50 USD	19 Jan 2026 11:00 GMT
Sugar Plant Gasketed PHE plate heat exchanger Design Category: 2D Drafting, 3D CAD, AutoCAD, Bill Of Materials (BOM) Analysis, CAD / CAM, Engineering, Engineering Drawing, Mechanical Design, Mechanical Engineering, Thermal Analysis Budget: $100 - $150 USD	19 Jan 2026 10:59 GMT
Smart Parking Disc Modification -- 3 Category: Automation, Circuit Design, Control Engineering, Electrical Engineering, Electronics, Hardware Security Module, Mechanical Engineering, Microcontroller, Prototyping, Robotics Budget: €30 - €250 EUR	19 Jan 2026 10:58 GMT
Aluminum Window Profile CAD Drawings Category: 2D Drafting, 3D CAD, 3D Design, 3D Modelling, AutoCAD, CAD / CAM, Product Design, Solidworks Budget: ₹1500 - ₹12500 INR	19 Jan 2026 10:58 GMT
Custom Kids Bedroom Design Category: 3D Design, 3D Modelling, 3D Rendering, Architecture, Creative Design, Design Thinking, Graphic Design, Interior Design Budget: ₹1500 - ₹12500 INR	19 Jan 2026 10:58 GMT
Logo Tagline Integration Using Nunito Category: Adobe Creative Cloud, Adobe Illustrator, Photoshop, Design, Graphic Design, Illustration, Logo Design, Vector Design Budget: €8 - €30 EUR	19 Jan 2026 10:58 GMT

Browse All Projects

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