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)
Global Social Media Growth Strategy Category: Content Marketing, Digital Marketing, Facebook Marketing, Influencer Marketing, Internet Marketing, Marketing, Social Media Management, Social Media Marketing Budget: ₹12500 - ₹37500 INR
04 Feb 2026 17:04 GMT
كتابة تدوينات نصائح صحية -- 2 Category: Article Writing, Blog Writing, Content Writing, Copywriting, Creative Writing, Editing, Medical Writing, Proofreading, Research, SEO Budget: $250 - $750 USD
04 Feb 2026 17:03 GMT
Download Coaching App Videos Category: C, Programming, Python, Scripting, Software Architecture, Video Editing, Video Processing, Video Streaming, Web Scraping Budget: ₹1500 - ₹12500 INR
04 Feb 2026 17:03 GMT
Ecommerce Sales Meta Ads Setup Category: Advertising, Conversion Rate Optimization, Digital Marketing, Facebook Ads, Facebook Marketing, Google Adwords, Instagram Ads, Internet Marketing Budget: ₹12500 - ₹37500 INR
WordPress E-commerce Legal Services Category: CSS, Elementor, HTML5, JavaScript, Performance Tuning, SEO Auditing, Software Performance Testing, UX / User Experience, White Hat SEO, WordPress Budget: $400 - $1000 USD
04 Feb 2026 17:01 GMT
Local history time machine Category: API Development, Data Analysis, Data Integration, Data Management, Data Processing, Data Visualization, Database Design, Database Development, Software Development, Web Development Budget: £10 - £15 GBP
04 Feb 2026 17:01 GMT
Excel Monthly Consumption Dashboard Category: Data Analysis, Data Management, Data Processing, Data Visualization, Excel, PHP, Power BI, Visual Basic Budget: ₹600 - ₹1500 INR