Skip to main content
D
DGORDON333
April 9, 2023
Solved

ebay fees

  • April 9, 2023
  • 1 reply
  • 0 views

Hi everyone, apologies if this is a stupid question, but I am new to digital and quite an accounting novice. I've searched the boards and found many questions regarding eBay fees, but none of the answers quite fit.

 

I sell on eBay a lot, and the banking deposits they make have already had fees deducted. I understand I can raise a receipt for those fees, but then this causes my balance to be lower, as the deposited amount has obviously already had them deducted.

 

How do I balance this? - Please note that due to the package I use, I can't use any of the linking software such as the eBay app, Snyder etc to import my transactions,so unfortunately I am stuck to a manual system.

 

I've been using a spreadsheet to now which is SO much simpler, as I can add the total sales (instead of deposit) and fees in their applicable income/expenses columns, which then results in the correct deposited amount change in my balance without any fuss.

I am a sole trader using the cash basis, and under the income level requirements for making tax digital so don't HAVE to do things this way. Is the reality, that it IS much simpler to keep to my spreadsheet? 

Many thanks in advance for your help! 🙂

Best answer by LieraMarie_A

Hey there, @DGORDON333. Let me share another way to handle transaction fees.

 

If your bank is connected to QuickBooks Self-Employed, you can split deposits to include the fees. Follow these steps:

 

  1. Go to the Transactions menu.
  2. Find the transaction you want to split.
  3. Select Split from the Type column.
  4. Choose Amount from the Split by dropdown.
  5. For each split, select Business or Personal from the Type dropdown.
  6. If you pick Business, click the link in the Category column and choose the category you want the split to go into.
  7. Enter the total sales amount instead of the deposit.
  8. To add the fees, select Add line. Then, choose the expense category. It will automatically calculate the amount.
  9. If you need to exclude a split, select the Exclude checkbox.
  10. When you're done, click Save.

 

If you prefer using the spreadsheets, ensure the data is in the correct format before uploading it. 

 

If you have more questions about working with bank feeds, let me know in the comment section. I'll be right here to lend you a hand. Have a good one!

1 reply

LieraMarie_A
LieraMarie_AAnswer
April 9, 2023

Hey there, @DGORDON333. Let me share another way to handle transaction fees.

 

If your bank is connected to QuickBooks Self-Employed, you can split deposits to include the fees. Follow these steps:

 

  1. Go to the Transactions menu.
  2. Find the transaction you want to split.
  3. Select Split from the Type column.
  4. Choose Amount from the Split by dropdown.
  5. For each split, select Business or Personal from the Type dropdown.
  6. If you pick Business, click the link in the Category column and choose the category you want the split to go into.
  7. Enter the total sales amount instead of the deposit.
  8. To add the fees, select Add line. Then, choose the expense category. It will automatically calculate the amount.
  9. If you need to exclude a split, select the Exclude checkbox.
  10. When you're done, click Save.

 

If you prefer using the spreadsheets, ensure the data is in the correct format before uploading it. 

 

If you have more questions about working with bank feeds, let me know in the comment section. I'll be right here to lend you a hand. Have a good one!

    A
    APANININS
    December 16, 2023

    hi

    I cannot split as the fees they keep are in Ebay 

    I cannot use SYNDER as i am a small business selling on Ebay.

    any other ways please 

     

     

     

     

     

    i

    A
    AbegailS_
    December 16, 2023

    Hi there, @APANININS. I'm here to lend a hand on how you can split your eBay transaction fees.

    QuickBooks Online (QBO) allows you to integrate with several third-party apps and software. While we can't recommend an app you can use to integrate with QBO to help you track your sales, expenses, and fees from eBay transactions, you can search for an app from the App Center. 

     

    Here's how:

     

    1. Sign in to your QBO account.
    2. Click Apps from the left menu.
    3. In the Find apps tab, enter a keyword.
    4. Get the app you want to use.

    On top of that, I've also included this reference for a compilation of articles you can use while working with us: Sales and Customers for QuickBooks Online.

     

    Please keep me posted by replying to the thread. I'd be delighted to help you manage your transactions. Stay healthy always!

    Terms & ConditionsAccessibility statement