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:
Project
Started
Prospector de clientes
Category : Bulk Marketing, Internet Marketing, Leads, Marketing, Research Budget : $250 - $750 USD
03-Aug-2025 22:04 GMT
Base44 App Conversion to Mobile - 03/08/2025 11:19 EDT
Category : Android, API Integration, App Design, IOS Development, IPhone, Mobile App Development, Mobile Development, PHP Budget : $10 - $30 USD
03-Aug-2025 22:04 GMT
Editor de Video y Animador 2D Profesional
Category : 2D Animation, Photoshop, Adobe Premiere Pro, After Effects, Animation, Graphic Design, Motion Graphics, Video Editing Budget : $250 - $750 USD
03-Aug-2025 22:03 GMT
C++ Stock Trading Program Update
Category : C, Programming, C#, C++, Software Architecture, Software Development Budget : £250 - £750 GBP
03-Aug-2025 21:58 GMT
Optimize Slider Responsiveness
Category : Cloudflare, CSS, Elementor, HTML, PHP, WordPress, WordPress Design, WordPress Plugin Budget : $30 - $250 USD
03-Aug-2025 21:55 GMT
Excel Spreadsheet Replication in Italian
Category : Data Analysis, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Microsoft Office Budget : £20 - £250 GBP
03-Aug-2025 21:55 GMT
Assemble Professional 1-Minute Video (in spanish)
Category : Adobe Premiere Pro, After Effects, DaVinci Resolve, Final Cut Pro, Video Editing, Video Post Editing, Video Production, Video Services Budget : $30 - $250 USD
03-Aug-2025 21:53 GMT
Looking for a Meta Ads Specialist (Facebook / Instagram)
Category : Facebook Ads, Facebook Marketing, Instagram Ads, Social Media Marketing Budget : €8 - €30 EUR
03-Aug-2025 21:52 GMT
Complete Windows System Recovery
Category : .NET, C++, Programming, Software Architecture, System Administration, Windows API, Windows Desktop, Windows Server, Windows Service Budget : $30 - $250 USD
03-Aug-2025 21:51 GMT
Custom 12ft Skeleton Baby Costume
Category : 3D Modelling, 3D Rendering, Costume Design, Fashion Design, Graphic Design, Photoshop, Sewing, Textile Engineering Budget : $250 - $750 USD
03-Aug-2025 21:46 GMT
Fix WordPress Registration Error
Category : HTML, PHP, Troubleshooting, Web Design, Web Development, Website Management, WordPress Budget : $10 - $30 USD
03-Aug-2025 21:44 GMT
Cartoon Laptop Stickers Design -- 2
Category : 2D Animation, Character Illustration, Creative Design, Graphic Design, Illustration, Photoshop, Sticker Design Budget : ₹1500 - ₹12500 INR
03-Aug-2025 21:44 GMT
Modern Company Introduction Brochure Design
Category : Adobe Creative Cloud, Adobe Creative Suite, Adobe Illustrator, Adobe InDesign, Brochure Design, Corporate Identity, Covers & Packaging, Digital Design, Graphic Design, Print Design Budget : $10 - $30 USD
03-Aug-2025 21:43 GMT
Vibrant Live Event Poster Design
Category : Adobe Creative Cloud, Adobe Illustrator, Photoshop, Advertisement Design, Graphic Design, Poster Design, Typography Budget : €8 - €30 EUR
03-Aug-2025 21:40 GMT
High Ticket Closer needed- Expert lvl (30% Commission)
Category : Advertising, Internet Marketing, Leads, Marketing, Sales Budget : $250 - $750 USD
03-Aug-2025 21:35 GMT
Browse All Projects