Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
T
totalisetrading
June 14, 2025
Solved

how to deal with ebay sales its such a headache

  • June 14, 2025
  • 4 replies
  • 6 views

so none of the third party apps work correctly the one that works the best is the ebay connector however im lucky if i get data from more than 2 days ago. yes ive been through troubleshooting with the app people ive tried other apps 2 of which didnt support uk ebay at present something to do with a signature is different for ebay uk compared to say usa. 

anyway i got my stock in quickbooks but i cant manage it because i cant get my sales in
i cant get my sales in because the format of reports from ebay not only doesnt map correctly to quickbooks quickbooks doesnt support multiple amounts from 1 transaction what i mean by that is sold amount (or payout amount either works) deductions for postage and ebay fees. 

ebay bunches them together on 1 record which is useless because i cant separate them our without a whole days worth of work and i aint doing that! 

i need my ebay transactions in quick books theni  can go into each one say this is for this product. or in the case of multiple products this is for this this and this product. 

then i can alter my inventory quantities daily to know how much ive got left. 

the other issue i had is i set in a spreadsheet "Sales Record No" which is a field that quickbooks supports but when i import the csv its seeing that column as a date but its not a date its a chuffing order number! so why is it seeing a date? and yes i already set the date field up correctly so why is it not treating sales record number as a sales record number? 


at the moment its a complete shambles! there must be other UK ebay users who have had to do this? i cant be the only uk ebay user on the platform 

so in summary i have to import previous data as none of the apps will do it so i need to figure that out and once the data is in quickbooks i can probably use ebay connector going forward. 

Best answer by EduardA

Allow me to provide you with solutions for each error you encountered when mapping your sales receipts data in QuickBooks, @totalisetrading.

 

First, map the Sales Record No from your spreadsheet to Sales Receipt No, ensuring it is not assigned to either Sales Receipt Date or Service Date in QuickBooks.

 

Next, make sure that there's a Deposit Account for each sales receipt in your CSV, and that the Deposit Account is your actual bank account or income account in QuickBooks.

 

When the locations do not exist in QuickBooks, first turn on the Track locations feature, and then create location information for GB, CZ, and NO. Follow this article to track these locations: Set up and use location tracking in QuickBooks Online.

 

Also, ensure that you add the product/service items from your CSV to the Products & Services section in QuickBooks to avoid encountering the error 'Item (Product) invalid'.

 

Then, correct the Service Date format for each sales receipt in your CSV to D/M/YYYY.

 

Lastly, review your CSV again to correct any necessary information, ensuring you map the Memo column, Location column, and Sales Receipt Date column from your CSV to their appropriate QuickBooks fields.

 

For further guidance on the reconciliation process, you might find this article helpful: Reconcile an account in QuickBooks Online.

 

Should you have any questions about mapping your sales receipt data in QuickBooks, feel free to leave a comment in the Community.

4 replies

T
totalisetradingAuthor
June 14, 2025

weird error

T
totalisetradingAuthor
June 14, 2025

another error 

T
totalisetradingAuthor
June 14, 2025

correct mapping

EduardA
EduardAQuickBooks TeamAnswer
QuickBooks Team
June 14, 2025

Allow me to provide you with solutions for each error you encountered when mapping your sales receipts data in QuickBooks, @totalisetrading.

 

First, map the Sales Record No from your spreadsheet to Sales Receipt No, ensuring it is not assigned to either Sales Receipt Date or Service Date in QuickBooks.

 

Next, make sure that there's a Deposit Account for each sales receipt in your CSV, and that the Deposit Account is your actual bank account or income account in QuickBooks.

 

When the locations do not exist in QuickBooks, first turn on the Track locations feature, and then create location information for GB, CZ, and NO. Follow this article to track these locations: Set up and use location tracking in QuickBooks Online.

 

Also, ensure that you add the product/service items from your CSV to the Products & Services section in QuickBooks to avoid encountering the error 'Item (Product) invalid'.

 

Then, correct the Service Date format for each sales receipt in your CSV to D/M/YYYY.

 

Lastly, review your CSV again to correct any necessary information, ensuring you map the Memo column, Location column, and Sales Receipt Date column from your CSV to their appropriate QuickBooks fields.

 

For further guidance on the reconciliation process, you might find this article helpful: Reconcile an account in QuickBooks Online.

 

Should you have any questions about mapping your sales receipt data in QuickBooks, feel free to leave a comment in the Community.

T
totalisetradingAuthor
June 14, 2025

first error 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement