eBay

tooltalk · ‎09-13-2013

I work for a Canadian company that runs an eBay store on eBay.ca. (I'm posting here using my personal account). All our transactions are in Canadian dollars and the invoices we receive from eBay are in Canadian dollars. However, when we view our sales summaries in Sales Reports Plus everything is in US dollars.

We are trying to figure how to view our monthly sales reports in Canadian dollars and an eBay rep told us on the phone that this wasn't possible. We find this hard to believe, and just want to view and track our sales and fees in Canadian dollars. The info in Sales Reports Plus is very useful, but not if it's in the wrong currency.

If anyone can help us, your assistance would be greatly appreciated.

Thank you very much.

pierrelebel · ‎09-13-2013

"Canadian company that runs an eBay store on eBay.ca."

As a company, you are GST/HST registered and as such must provide invoices to your buyers for your sales.

Why not get all the sales information you need from copies of those invoices?

The fees information is already available in Cdn$ from eBay.

That is how most GST/HST registered seller do their bookkeeping.

tooltalk · ‎09-13-2013

Thanks for your quick response. We are GST/HST registered and we do provide invoices to our buyers for all sales.

"The fees information is already available in Cdn$ from eBay."

I'm not sure what you mean. Where can we see monthly totals for our fees in Canadian dollars? Our Sales Reports include the information in the attached screen grab, but it's all in US dollars. We'd like to see the same info in CDN$.

Thanks again.

tooltalk · ‎09-13-2013

I should also mention that we've tried using the info available in "My eBay > My Account > Seller Account > Account Activity". The fees are all listed there, but the only way we could figure out how to get any monthly totals was to Download Account Activity using a date range, select "summarized totals for the selected date range", and then open the .csv file in excel or numbers.

However, that is a very convoluted way of doing things and the information generated is a bit confusing and different from the info that is readily available and clearly defined in Sales Reports.

We can also get sales totals from our invoices as you suggested, but that won't help us with eBay fees. It also won't show us useful info from Sale Reports like month-to-month sales growth unless we create our own spreadsheets. But why should we reinvent the wheel when everything we need is already available in Sales Reports? We just need to see the info in the correct currency.

femmefan1946 · ‎09-16-2013

How do you handle exchange which varies at least from day to day?

Any report you set up would be skewed by that.

Does your company keep a US bank account? There are a couple of Canadian banks (Royal/Centaura and TDCanadaTrust/ TDNorth) which have US subsidiaries. Money deposited in those in US dollars can be transferred into a Canadian USdollar account much more cheaply than moving your US dollars to your Canadian account directly.

If you company does more than half a million in US sales, including shipping, one of those accounts could save them a considerable sum.

tooltalk · ‎09-16-2013

We don't do any sales in US dollars. Everything we sell on eBay is in Canadian dollars, all our internal invoices are in Canadian dollars, and eBay bills us in Canadian dollars. But for some reason the sales reports in Sales Reports Plus are all in US dollars.

We just want to see those reports in Canadian dollars like everything else so we can see how much we're paying in eBay fees every calendar month.

We have an accouting department that deals with eBay invoices, which are billed from the 15th to the 15th, but I'm in the eBay sales department and we just want to track our sales, fees, etc, by calendar month in Canadian dollars. All the info we need is in Sales Reports Plus, but we need it to be in Canadian dollars like everything else we do on eBay.

tooltalk · ‎09-20-2013

We just received a "This just in-your latest Sales Report!" email from eBay. Seeing these reports in US dollars is so annoying and I really can't believe there is no solution.

michaelbb2 · ‎09-24-2013

arossphoto, I have the same issue as you do and there is no way of seeing the sales report in Canadian dollars. Too bad because the report could be quite useful. What you could do is just use the exchange rate average for each month from the Bank of Canada webpage and convert each value to Canadian. It takes a few minutes and Canada Revenue will accept this method of calculation. I believe that the sales reports do not include shipping costs collected so if you tally your sales as price + shipping then the report can't help you with that...

I use an excel spreadsheet and enter every sale price under the respective province (takes a few seconds for each transaction). The shipping is added and the tax is auto calculated with formula so at the end of the month I just look at the end of the column and see what the grand total is and how much tax was collected from which province..........don't pull your hair out waiting for eBay to step up........you will be bald and still waiting......