Help with generating sales report for tax
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Highlight
- Report Inappropriate Content
on β27-04-2014 05:25 PM
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... π
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Highlight
- Report Inappropriate Content
on β27-04-2014 05:46 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Highlight
- Report Inappropriate Content
on β27-04-2014 05:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Highlight
- Report Inappropriate Content
on β27-04-2014 06:56 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Highlight
- Report Inappropriate Content
on β27-04-2014 08:29 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Highlight
- Report Inappropriate Content
β27-04-2014 09:44 PM - edited β27-04-2014 09:45 PM
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...