Excel automation – eBay payouts → Sage 50 import

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)

Deliverables

One Excel file

Clear instructions (or short Loom video)

Ideally reusable for future eBay payouts

Experience required

Strong Excel

Power Query / data transformation

Accounting awareness (Sage 50 / journals)