|
|
|
|
|
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
|
|
|
|
|
|
