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)
French-English Literary Translation Category: Creative Writing, Editing, English (US) Translator, English Translation, Proofreading, Translation, Writing Budget: $25 - $50 USD
06-Feb-2026 17:01 GMT
Real Estate Marketing Specialist Category: Advertising, Brand Management, Brochure Design, Digital Marketing, Email Marketing, Facebook Marketing, Graphic Design, Marketing, Print Design, Real Estate Budget: $15 - $25 USD
06-Feb-2026 17:00 GMT
Social Media Graphics Design Category: Adobe Illustrator, Photoshop, Branding, Content Creation, Graphic Design, Illustration, Social Media Management, Social Media Marketing Budget: $10 - $30 USD
06-Feb-2026 17:00 GMT
3D Print Object from Photos Category: 3D CAD, 3D Design, 3D Drafting, 3D Graphic Design, 3D Illustration, 3D Model Maker, 3D Modelling, 3D Printing, 3D Rendering, 3D Visualization Budget: $250 - $750 USD
06-Feb-2026 16:59 GMT
Need Photoshop Designer Category: Graphic Design, Photoshop, Web Design Budget: ₹600 - ₹2000 INR
