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)
AI Chat Agent for SaaS Category: AI Chatbot Development, AI Development, AI Model Development, HTML, JavaScript, Node.js, PHP, Web Design Budget: $30 - $250 USD
30-Apr-2026 16:04 GMT
Digital Marketing Manager for workerzon Category: Advertising, Analytics, B2B Marketing, Content Marketing, Digital Marketing, Email Marketing, Internet Marketing, Lead Generation, Marketing, Social Media Marketing Budget: $2 - $8 CAD
Android LS Central App Category: Android, Android App Development, API Integration, Business Central, Inventory Management, Mobile App Development, Mobile Development, MySQL, PHP Budget: $750 - $1500 USD
30-Apr-2026 15:54 GMT
YouTube Video Editor for Chinese/Cantonese Content Category: Audio Editing, Audio Production, Motion Graphics, Video Editing, Video Post Editing, Video Processing, YouTube, YouTube Video Editing Budget: $115 - $200 HKD
30-Apr-2026 15:52 GMT
Hyderabad - Livyro Field Onboarding Executives Category: Customer Experience, Customer Service, Customer Support, Field Sales, Lead Generation, Market Research, Sales Budget: ₹12500 - ₹37500 INR
