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)
Social Media Ad Design for Father's Day Category: Adobe Creative Cloud, Advertisement Design, Graphic Design, Photoshop, Photoshop Design, Social Media Management, Social Media Marketing, Web Design Budget: $250 - $750 USD
08 Jun 2026 22:04 GMT
Illustrate Adventure Kids Book Category: Animation, Art Consulting, Art Installation, Caricature & Cartoons, Character Illustration, Creative Design, Graphic Design, Illustration, Visual Arts Budget: $250 - $750 USD
Casual Bikini & Lingerie Model Category: 3D Modelling, Fashion Design, Fashion Modeling, Photography, Photoshop, Social Media Marketing, Visual Arts Budget: $30 - $250 AUD
08 Jun 2026 21:59 GMT
Modern High-End Apartment Design Category: 3D Rendering, Architectural Engineering, Architectural Visualization, Architecture, Building Architecture, Building Design, Building Engineering, Building Information Modeling, Home Design, Interior Design Budget: $250 - $750 USD
08 Jun 2026 21:58 GMT
Football Finance Animation Videos Category: 2D Animation, After Effects, Animation, Content Creation, Graphic Design, Motion Graphics, Video Editing, Video Services Budget: ₹37500 - ₹75000 INR
08 Jun 2026 21:55 GMT
UGC Video Editor for DTC Brand Category: Adobe Premiere Pro, AI (Artificial Intelligence) HW / SW, AI Video, CapCut, Content Creation, Final Cut Pro, Social Media Marketing, Video Editing, Video Production, Video Services Budget: $1500 - $3000 USD
08 Jun 2026 21:52 GMT
Youth Video Editor & Setter Category: Adobe Premiere Pro, After Effects, Appointment Setting, Color Grading, DaVinci Resolve, Motion Graphics, Video Editing, Video Processing, Video Production, Video Services Budget: $250 - $750 USD
Long-Term SEO Website Assistant Wanted Category: Content Writing, Elementor, Internet Marketing, Link Building, SEO, Web Development, Wix, WordPress Budget: $30 - $250 USD
08 Jun 2026 21:51 GMT
Android Business App Development Category: Android, Android App Development, Android SDK, Android Studio, Java, Mobile App Development, Software Architecture, Software Development Budget: ₹100 - ₹500 INR
08 Jun 2026 21:49 GMT
Gemma 4 LoRa Fine-Tuning Category: Data Analysis, Deep Learning, Hugging Face, LoRa, Machine Learning Algorithms, Natural Language Processing, Prompt Engineering, Python Budget: $250 - $750 AUD
08 Jun 2026 21:47 GMT
Expert Slack Consultant for Setup and Structuring Category: Automation, Business Consulting, PHP, Project Management, Salesforce App Development, Salesforce.com, Slack, Software Architecture Budget: $10 - $30 USD
08 Jun 2026 21:46 GMT
Investment Referral Web Platform Category: Full Stack Development, HTML, JavaScript, Laravel, MySQL, PHP, Vue.js, Web Development Budget: $100 - $150 USD
