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)
Influencer Marketing Campaign Category: Brand Management, Content Creation, Digital Marketing, Influencer Marketing, Internet Marketing, Marketing, Social Media Marketing Budget: $30 - $250 USD
24 Mar 2026 23:03 GMT
Irish Heritage E-commerce Website Development Category: ECommerce, Graphic Design, Payment Gateway Integration, PHP, User Experience Research, Web Application, Web Design, Web Development Budget: €6 - €12 EUR
Native Conversational Japanese Voice Recording -- 2 Category: Audio Editing, Audio Services, Conversational AI, Japanese Teaching, Japanese Translator, Japanese Tutoring, Voice Acting, Voice Over, Voice Talent Budget: ₹600 - ₹1500 INR
24 Mar 2026 22:56 GMT
Real Estate Guidebook Design Category: Book Design, Brochure Design, Content Development, Flyer Design, Graphic Design, Photoshop, Print Design, Real Estate Budget: $30 - $250 USD
24 Mar 2026 22:56 GMT
Business Strategy Consultant -- 2 Category: Business Analysis, Business Consulting, Business Development, Business Plans, Business Strategy, Competitor Analysis, Market Research, Marketing Budget: £250 - £750 GBP
24 Mar 2026 22:55 GMT
Sitcom Production and Casting Category: Audio Production, Casting, Film Production, Media Relations, Music Production, Post Production, Pre Production, Project Management, Talent Acquisition, Video Production Budget: £10 - £25 GBP
Ongoing Google Ads Campaign Management Category: Conversion Rate Optimization, Digital Marketing, Google Ads, Google Adwords, Google Analytics, Internet Marketing, PPC Marketing, WordPress Budget: $8 - $15 CAD
24 Mar 2026 22:52 GMT
Indoor & Outdoor Scene Segmentation Category: Computer Vision, CUDA, Data Annotating, Deep Learning, Image Processing, Machine Learning (ML) Budget: $30 - $250 USD
24 Mar 2026 22:52 GMT
Activities Management Platform Development Category: Agile Development, API Development, Budgeting And Forecasting, Database Design, Figma, Frontend Development, Full Stack Development, PHP, Project Management, SaaS Budget: $1500 - $3000 AUD
24 Mar 2026 22:51 GMT
Rediseño de cartilla digital Category: Corporate Identity, Covers & Packaging, Editorial Design, Graphic Design, Illustration, Logo Design, PDF, Typography Budget: $10 - $30 USD
24 Mar 2026 22:49 GMT
iwandasaputraa Category: CMS, CSS, Email Marketing, HTML, Mailchimp, PHP, SEO, Web Development, Website Optimization, WordPress Budget: $15 - $25 USD
