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)
Minimalist Coffee Table Concept Category: 3D CAD, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, AutoCAD, Furniture Design, Product Design Budget: $30 - $250 USD
06-Apr-2026 04:04 GMT
Website Company Profile Responsif Category: CSS, Graphic Design, HTML, JavaScript, Web Design, Web Development, WordPress Budget: $15 - $25 USD
06-Apr-2026 04:04 GMT
Corporate E-commerce Site Design Category: CSS, ECommerce, Graphic Design, HTML, SEO, Web Design, Web Development Budget: ₹12500 - ₹37500 INR
06-Apr-2026 04:03 GMT
Legal Document Typing Specialist Category: Copy Typing, Data Entry, Document Checking, English (US) Translator, Legal Writing, Microsoft Word, Word Budget: ₹750 - ₹1250 INR
06-Apr-2026 04:01 GMT
Can you help making phonk music? -- 3 Category: Audio Editing, Audio Engineering, Audio Production, Audio Services, Music, Music Lesson, Music Management, Music Production, Music Transcription, Sound Design Budget: $30 - $250 USD
Formal Student Blog Writer Category: Academic Writing, Article Rewriting, Article Writing, Blog Writing, Content Writing, Proofreading, Research Writing, SEO Budget: $15 - $25 USD
06-Apr-2026 04:00 GMT
60-Second Instagram Reel Edit Category: CapCut, Final Cut Pro, Music Video, Video Ads, Video Editing, Video Post Editing, Video Services Budget: ₹1250 - ₹2500 INR
06-Apr-2026 03:59 GMT
Lead-Gen Landing Page Clone -- 2 Category: CSS, Frontend Development, Graphic Design, HTML, JavaScript, Lead Generation, Web Design, Web Development, Web Hosting Budget: ₹600 - ₹1500 INR
06-Apr-2026 03:58 GMT
Power BI Analysis for Substance Abuse Program Category: Data Analysis, Data Integration, Data Visualization, Power BI, R Programming Language, SPSS Statistics, Statistical Analysis, Statistics Budget: $10000 - $20000 USD
06-Apr-2026 03:57 GMT
Celebrity Gossip Channel Manager Category: Article Writing, Content Creation, Content Writing, Copywriting, Ghostwriting, SEO, Social Media Management, YouTube Budget: ₹12500 - ₹37500 INR
Your Real Life Embarrassing Dressing Incidents Stories. Category: Call Center, Customer Service, Customer Support, Fashion Design, Fashion Modeling, Lifestyle Coach, Reviews, Short Stories, Web Search Budget: ₹100 - ₹400 INR
