If you have an eBay channel set up in Tradebox, you can download your eBay fees as a monthly lump sum, or managed payment fees pertaining to specific orders as individual transactions.
Setting up to download eBay fees
The option to download eBay fees is found in the Details tab of any eBay sales channel.
There are three fee options:
Download eBay monthly fees: This downloads fees each month after you receive your monthly eBay invoice. The monthly fees are the recurring fees you pay eBay each month, such as the subscription fee, and don't include the individual fees relating to orders.
Download eBay order fees: These are the individual fees relating to the orders you receive on eBay. They download as and when the orders they pertain to are downloaded.
Due to the 30 day limit of eBay's API, it's not possible to download historic fees beyond the most recent month.
Download Paypal fees: If you have eBay order fees selected, this will be greyed out and vice versa, as the two are mutually exclusive. See here for more information on Paypal fees.
If you are posting your eBay fees to an accounts package, you'll also need to choose your posting details.
For Sage, in the Sage 50 > Nominals tab, populate the Marketplace Fees and eBay Order Fees section by choosing a Nominal and Bank account to use for the fee transactions. Choosing a Department is optional, the default department will be used if one isn't chosen.
For Xero, first make sure you've created eBay as a Contact in Xero. Then in the Xero > Accounts tab, populate the Marketplace Fees section by choosing an account, a bank account and a tax rate to use for the fee transactions.
For the eBay order fees, you also have the option to post them as a summary transaction or individual transactions. If you select the option for individual transactions, the fees will be posted individually as and when the invoices are created in your accounts package. If you select summary transactions, you will need to post them manually as described below.
Make sure you click Save after making any changes to your fee settings.
Once you've set up an eBay channel to download fees, they'll come down automatically when the order download runs. This means your sales channel needs to be active and the data service needs to run at least one cycle after you enable fee download.
Once some fees have been downloaded, go to the Reports screen and eBay Monthly/Order fees will appear as an option in the dropdown list.
eBay Monthly Fees
If you select eBay monthly fees, you'll then see a summary of paid fees, showing one line per month.
Over time we've found the only way to get a truly accurate value for eBay fees is to track the payment you make, rather than the itemised transactions. This means there's no option to drill down within the eBay fees report. You can use the To Excel button in the fees report to open the data in an Excel spreadsheet for further manipulation.
If your sales channel has an accounts link set up and you've populated the marketplace fees section, the To Accounts button will be active. Tick the Select box to choose one or more fee lines, then click To Accounts to send those fee transactions to your accounts package. The Posted To Accounts column will update to indicate a successful posting. If you're posting to Sage, you'll also see the Accounts Ref field populates showing the Transaction Number from Sage.
eBay Order Fees
If you select eBay order fees, you'll see a summary of the paid fees for the month showing in the list.
Double click on the month to see the breakdown of the individual fees. If you've chosen to post the fees as a summarised transaction you can select the ones you wish to post, or select all fees for the month, on this screen, and then click the To Accounts button to post them to the account and bank you've specified within the channel.