Expected duration: 1 day or less I’m looking for an Excel + Power Query specialist to build a simple, robust Excel template that converts eBay payout CSV exports into a Sage 50–ready import file.
Input
eBay transaction/payout CSV export
File includes multiple rows per payout and multiple fee columns (final value fees, international fees, etc.)
Required output
A Sage 50 journal import CSV with columns:
Date
Reference
Nominal Code
Debit
Credit
Core requirements
I paste an eBay CSV into one tab
Excel automatically:
Groups by Payout ID
Consolidates to one line per fee type per payout
Produces clean debit/credit lines suitable for Sage 50
Fees should be summed by type (not one line per transaction)
One net payout line per payout (via a clearing account)
No Excel file corruption or version-specific errors
Nice to have
Uses Power Query (Unpivot) rather than complex formulas
A simple mapping table where I can assign:
Fee type → Nominal code
Debit or Credit
Works in Excel 365 (Windows)
What I don’t want
Overly complex VBA
Hundreds of transaction-level lines
Manual steps every time (paste + refresh should be enough)
Influencer Marketing Strategy for Mobile App Growth Category: Android, Content Strategy, Digital Marketing, Influencer Marketing, Internet Marketing, IPhone, Marketing Strategy, Mobile App Development, Social Media Management, Social Media Marketing Budget: $250 - $750 USD
31-Mar-2026 10:04 GMT
LED Ad Design + WhatsApp Leads Category: Advertisement Design, Banner Design, Facebook Ads, Graphic Design, Instagram Marketing, Lead Generation, Poster Design, Social Media Marketing Budget: ₹1500 - ₹12500 INR
31-Mar-2026 10:04 GMT
Client Portal Development and Data Migration Category: API Development, App Design, App Development, Cloud Computing, Data Management, Database Design, Microsoft Access, Mobile App Development, MySQL, PHP Budget: £10000 - £20000 GBP
31-Mar-2026 10:03 GMT
Candy Wholesale Customer Service On-Demand Category: Customer Experience, Customer Service, Customer Support, Email Handling, English Tutoring, Inventory Management, Time Management Budget: $2 - $8 USD
Modern Flat Interior Design Category: 3D Modelling, 3D Rendering, 3ds Max, AutoCAD, Interior Design, Lighting Design, SketchUp, V Ray Budget: ₹1500 - ₹12500 INR
31-Mar-2026 09:59 GMT
Build Advanced DSAV Company Website (.com) Category: CSS, Graphic Design, HTML, JavaScript, Next.js, Web Development, Web Design, Website Optimization, WordPress Budget: ₹900 - ₹1500 INR
Rédaction Articles Cuisine Malgache Category: Article Writing, Blog, Blog Writing, Content Writing, Copywriting, Creative Writing, French Translator, SEO Writing Budget: $2 - $8 USD
31-Mar-2026 09:57 GMT
B2B Promo Video Editing Category: After Effects, Audio Editing, Motion Graphics, Video Post Editing, Video Production, Video Services Budget: ₹750 - ₹1250 INR
