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
Shopify New Customer Discount Setup Category: Automation, HTML, PHP, Shopify, Shopify Development, Shopify Templates Budget: $10 - $30 USD	08 Jul 2025 22:00 GMT
Konstruktionsprojekt im Maschinenbau (Maschinentechnik) "Nur Deutsch bitte" Category: 2D Drafting, AutoCAD, Engineering Drawing, Mechanical Design, Mechanical Engineering Budget: €30 - €250 EUR	08 Jul 2025 21:58 GMT
Need Help Recovering Encrypted Files (WinRAR or Windows Encryption) Category: C#, Programming, Data Protection, Encryption, System Admin, Technical Support, Windows Desktop, Windows Server Budget: $10 - $30 USD	08 Jul 2025 21:57 GMT
Blog/YouTube Channel Design on Social Justice Category: Blog Design, Branding, Content Creation, Creative Writing, Graphic Design, SEO, Social Media Marketing, Video Editing Budget: $30 - $250 USD	08 Jul 2025 21:57 GMT
OIC Integration - SAP ariba Category: Data Integration, Oracle, REST API, SAP, SOAP API, SQL, XML Budget: ₹12500 - ₹37500 INR	08 Jul 2025 21:57 GMT
2D Stick Figure Animation Needed Category: 2D Animation, 2D Animation Explainer Video, 2D Game Art, 3D Animation, After Effects, Animation, Character Illustration, Motion Graphics Budget: $10 - $11 USD	08 Jul 2025 21:57 GMT
UX/UI Designer for SaaS Dashboard Category: Data Visualization, Figma, Graphic Design, UI / User Interface, User Interface / IA, UX / User Experience, Web Design Budget: £20 - £250 GBP	08 Jul 2025 21:56 GMT
AI Multilingual Voice & Messaging Agent Category: AI Chatbot Development, Android, GPT 4, Hindi Translator, Java, PHP, SAP, Twilio Budget: ₹12500 - ₹37500 INR	08 Jul 2025 21:55 GMT
Shopify Modern Jewelry Theme Design Category: Graphic Design, HTML, Shopify, Shopify Templates, Web Design Budget: $30 - $250 USD	08 Jul 2025 21:54 GMT
Immersive Escape Room Mobile Game Category: AI Development, Augmented Reality, Game Design, Game Development, IOS Development, IPhone, Mobile App Development, Unity 3D, Unreal Engine Budget: $1500 - $3000 USD	08 Jul 2025 21:53 GMT
3D Artistry for Visuals Category: 3D Animation, 3D Modelling, 3D Rendering, 3ds Max, Blender, Cinema 4D, Maya, Photoshop Budget: €30 - €250 EUR	08 Jul 2025 21:52 GMT
Birthday Invite Template Category: Canva, Digital Art, Graphic Design, Invitation Design Budget: $10 - $30 USD	08 Jul 2025 21:52 GMT
تصميم لوجو حديث ومبسط Category: AI Agents, AI Chatbot, AI Content Creation, AI Content Writing, AI Development, AI Model Development, AI Research, AI Text To Speech Budget: $25 - $50 USD	08 Jul 2025 21:51 GMT
Interactive Dashboard SaaS Platform Development Category: AI Development, Cloud Computing, Full Stack Development, SaaS, UX / User Experience Budget: £750 - £1500 GBP	08 Jul 2025 21:51 GMT
Telegram Inline Form Creation Category: Android, API Integration, Bot Development, Mobile App Development, PHP, Software Architecture, Telegram API, User Experience Research Budget: $250 - $750 USD	08 Jul 2025 21:50 GMT

Browse All Projects

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