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)
System & App Demo Video Category: Adobe Premiere Pro, After Effects, Animation, Motion Graphics, Video Ads, Video Conferencing, Video Editing, Video Post Editing, Video Production, Video Services Budget: $10 - $30 USD
01-Jun-2026 04:01 GMT
Social Media Creative Design Category: Adobe Creative Cloud, Content Creation, Graphic Design, Illustration, Logo Design, Photoshop, Social Media Marketing, Video Editing Budget: ₹12500 - ₹37500 INR
Energetic Football Academy Ad Category: Adobe Premiere Pro, DaVinci Resolve, Social Media Marketing, Video Ads, Video Editing, Video Production, Video Services, Voice Over Budget: $15 - $25 USD
30-Second Promotional Video Editing Category: Adobe Premiere Pro, After Effects, Animation, Video Ads, Video Editing, Video Post Editing, Video Services Budget: $250 - $750 USD
Retail Store Design for Expansion Category: 3D Modelling, 3D Rendering, Architectural Visualization, Furniture Design, Graphic Design, Interior Design, Lighting Design, Project Management, Visual Merchandising, Web Design Budget: $250 - $750 AUD
01-Jun-2026 03:55 GMT
YouTube Narrative Video Editor Needed Category: Adobe Premiere Pro, DaVinci Resolve, Final Cut Pro, Motion Graphics, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
01-Jun-2026 03:53 GMT
Rewrite AI Real Estate Content Category: Article Rewriting, Article Writing, Content Development, Content Writing, Copy Editing, Copywriting, Editing, Ghostwriting, Proofreading, Real Estate Budget: $10 - $30 USD
01-Jun-2026 03:53 GMT
Penulis & Desainer Bergaji Harian Category: Adobe Illustrator, Canva, Content Writing, Graphic Design, Illustration, Logo Design, Photoshop, Social Media Marketing Budget: $15 - $25 USD
01-Jun-2026 03:52 GMT
TikTok Engagement Video Editing Category: Adobe Premiere Pro, After Effects, CapCut, Motion Graphics, TikTok, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: £10 - £20 GBP
01-Jun-2026 03:51 GMT
Digital Marketing for Asia Kitchen Category: Content Strategy, Content Writing, Digital Marketing, Facebook Marketing, Graphic Design, Instagram Marketing, Social Media Marketing, Twitter Budget: ₹12500 - ₹37500 INR
