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)
Konsultasi Teknik Kimia Industri Category: Chemical Engineering, Data Entry, Data Processing, Excel, Industrial Engineering, Manufacturing Engineering, Process Engineering, Project Management, Technical Documentation, Web Search Budget: $250 - $750 USD
21-Apr-2026 09:58 GMT
6amMart Conversion to Microservices Architecture Category: API Development, Continuous Integration, Database Management, DevOps, Documentation, FastAPI, Laravel, Penetration Testing, Software Architecture, Software Development Budget: $1500 - $3000 USD
21-Apr-2026 09:57 GMT
AppSheet: App Pedidos y Caja Category: App Development, Data Visualization, Database Management, Documentation, Google Sheets, Mobile App Development, Project Management, Video Production Budget: $30 - $250 USD
21-Apr-2026 09:56 GMT
OPC Registration Assistance Bangalore Category: Accounting, Business Consulting, Business Development, Business Management, Compliance, Corporate Law, Legal, Tax Budget: ₹1500 - ₹12500 INR
21-Apr-2026 09:55 GMT
WordPress Car Wash Site Build Category: CSS, HTML, JavaScript, PHP, SEO, Web Development, Website Optimization, WordPress Budget: $250 - $500 AUD
21-Apr-2026 09:54 GMT
Supreme Cup 2031 Schedule Poster Category: Adobe Illustrator, Photoshop, AI Art Creation, AI Content Creation, Flyer Design, Graphic Design, Illustration, Poster Design, Print Design Budget: $20 - $30 USD
Perfume Brand Performance Marketing Campaign Category: Ad Planning & Buying, Advertising, Digital Marketing, Facebook Marketing, Google Adwords, Instagram Marketing, Internet Marketing, Social Media Marketing Budget: ₹1500 - ₹12500 INR
