topic Re: Help with generating sales report for tax in Selling

Help with generating sales report for tax

phonebite — Sun, 27 Apr 2014 07:25:07 GMT

I am about to do my BAS which is due in a few days.

I need to generate a report from eBay which only shows purchases from people who are living at an Australian address, however I am unable to find a quick effective way to filter out all the world wide sales (ie: people from overseas buying my products).

How do I go about this?

Because I don't think I would have to go thru each sales individualy .. because that would be hell... 😞

Re: Help with generating sales report for tax

*sparklz* — Sun, 27 Apr 2014 07:46:51 GMT

You need to keep a record of this for yourself if OS sales are to be separated from Aussie sales.

But in the end sold OS or sold locally it is still income.

Re: Help with generating sales report for tax

kopenhagen5 — Sun, 27 Apr 2014 07:47:51 GMT

Sales records need to be kept by yourself.

If you have subscribed to Selling Manager, I don't know if that program has some sort of search refinements in the history.

Otherwise looks like you might have some late nights.

Re: Help with generating sales report for tax

clarry100 — Sun, 27 Apr 2014 08:56:05 GMT

You need to be registered for GST if you think you will exceed $75,000 in total sales during the tax year. And you will need to have an ABN as well.

As already mentioned I don't believe it matters if you sell off-shore or not. All sales count towards the $75K total.

I use the file management centre to download the Paid and Posted report each month and keep that by month in an Excel spreadsheet. It's then a very simple matter to sum up each month's sales and roll up to a year.

The above was some guidance given by my own tax agent.

Re: Help with generating sales report for tax

wehavethatau — Sun, 27 Apr 2014 10:29:31 GMT

He needs to separate Australian and overseas sales because he does not pay GST on international sales (just like international postage is also GST free).

This is very easy to do.

Go to paid and posted, select all and download as a csv file. You can then sort your national and international sales. However you need to do this report monthly as it only keeps the past 60 days which wont help you complete your BAS if you haven't done it yet this quarter.

Re: Help with generating sales report for tax

phonebite — Sun, 27 Apr 2014 11:45:04 GMT

Thanks for that, I have ABN and its already registered for GST since I already make more than $75,000 externally anyways.

I find that since my payments on eBay only allows paypal transaction to make, it was better to goto paypal and generate a report and filter and sort out each transaction with excel (though I had to look you on a tutorial just for it).

But thanks, your hint made it possible and my life 100x easier...