|
|
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 |
Business Development and Digital Presence for Sustainable Farming
Category: Facebook Marketing, Graphic Design, Logo Design, Social Media Marketing, Web Design Budget: $500 - $1000 USD |
10-Jun-2025 12:17 GMT |
Fix React Native App Build issue
Category: Android, IOS Development, Mobile App Development, React Native, Swift Budget: $10 - $30 USD |
10-Jun-2025 09:57 GMT |
bisnis marketing
Category: Business Development, Customer Retention Marketing, Entrepreneurship, Internet Marketing, Web Design Budget: ₹100 - ₹400 INR |
10-Jun-2025 09:55 GMT |
recruit Chinese people in Malaysia as assistants
Category: Admin Support, English (UK) Translator, Odd Jobs Budget: $250 - $750 USD |
10-Jun-2025 09:54 GMT |
Teams app plugin for users, join teams meeting calls, use third party recording from within the plugin relay the audio to azure speech service backend in real time transcribe, translate and convert to vernacular languages speech to text, text to text, for
Category: Audio Services, Microsoft Access, Microsoft Azure Budget: ₹12500 - ₹37500 INR |
10-Jun-2025 09:54 GMT |
CONFIDENTIAL -- 2
Category: Atlassian Jira, Data Warehousing, GitLab, Snowflake, SQL Budget: ₹12500 - ₹37500 INR |
10-Jun-2025 09:54 GMT |
3D CAD to CAM Conversion
Category: 3D Modelling, 3D Rendering, CAD / CAM, Fusion 360, Mechanical Engineering Budget: £20 - £250 GBP |
10-Jun-2025 09:53 GMT |
English Teaching Landing Page + telegram bot setup
Category: Graphic Design, HTML, JavaScript, PHP, Web Design Budget: €250 - €750 EUR |
10-Jun-2025 09:53 GMT |
Traditional Wedding Photography Specialist
Category: Graphic Design, Illustration, Photo Editing, Photography, Photoshop Budget: ₹1500 - ₹12500 INR |
10-Jun-2025 09:53 GMT |
Customer Management Online System Development
Category: AJAX, HTML, JavaScript, MySQL, PHP Budget: $250 - $750 USD |
10-Jun-2025 09:52 GMT |
Properly hashtag.attractive content use
Category: Article Writing, Content Writing, Copywriting, Ghostwriting, Social Media Marketing Budget: ₹1500 - ₹12500 INR |
10-Jun-2025 09:52 GMT |
Romantic Short Poem
Category: Creative Writing, EBooks, Fiction, Ghostwriting Budget: ₹12500 - ₹37500 INR |
10-Jun-2025 09:52 GMT |
SEO Backlink Campaign -- 3
Category: Internet Marketing, Link Building, Marketing, Search Engine Marketing (SEM), SEO Budget: €30 - €250 EUR |
10-Jun-2025 09:51 GMT |
Professional Video Ad Creation
Category: 3D Animation, After Effects, Animation, Video Editing, Video Services Budget: ₹1500 - ₹12500 INR |
10-Jun-2025 09:51 GMT |
Modern, Vibrant Personal Logo
Category: Graphic Design, Illustration, Logo Design, Photoshop, Photoshop Design Budget: $30 - $250 USD |
10-Jun-2025 09:50 GMT |
|
Browse All Projects
|
|
|
|
|