I have worked in Finance for decades and I have learned many lessons from working with very wealthy and successful people by seeing how they manage their own money. I enjoy teaching what I have learnt and seeing it empower people to make a positive change in their own lives.
Пікірлер
Hi what do you enter on the net capital lost unapplied on the tax schedule (the next page that comes up when u select "If your capital gain or lost is more than 10k"). I have a total lost of 20k for this year and 10k previous years. Do i put the total lost only for this year only or both losses? (this year and previous year)?
Does it have a label number that you a referring to?
I bought the excel spreadsheet. It only comes in Euro and Yen.
Are you sure you bought my spreadsheet? Mine is in dollars. In Excel you can easily change the setting to any currency you like.
If I place the transaction value in the values box and change it to sum and to number then my result in the pivot table is 0 and if I place the transaction value in rows I do get the correct numbers I added in the data. Does anyone know how to solve this?
It sounds like your numbers are formatted as Text instead of numbers. I suggest you use the function to convert text to numbers. A step by step guide can be found here: support.microsoft.com/en-au/office/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885#:~:text=Use%20Paste%20Special%20and%20Multiply,-If%20the%20steps&text=Select%20the%20cells%20that%20have,converts%20the%20text%20to%20numbers.
I've only used Kraken to send to or receive money from overseas what would I do in this situation? Idk anything about crypto so i dont even understand what the ATO wants from me. Please help 🙏
The ATO has an easy to read guide that should answer your questions here: www.ato.gov.au/individuals-and-families/investments-and-assets/crypto-asset-investments
Great tutorial. I was able to set it up for my personal bank and credit card accounts. Thanks!
Well done 👍
Horrible system, what were you thinking not doing step by step ?? Are you a mad man ?
Funny you say that. I did another video step by step here: Sole Trader Tax Return: Step-by-Step Guide using MyGov kzread.info/dash/bejne/mqR5qZJuaMXaZKw.html
Is this considering Dividend Substitution Share Plan (DSSP) ?
This is total return. I have compared both investments without DSSP and DRP plans for a fair comparison.
Is there a section in Sharesight where I can see how much fees I am paying for each transaction as well as overall?
Yes. Try the “All Trades Report” in the report section.
Is the loss from last year automatically transferred over or do you have to put it in manually?
It’s always best to check prior year tax return either way and make sure any rollovers are correct. In the past it didn’t rollover some items including losses.
See you again next year
Look forward to it ☺️
Do they classify Nurses in emergency having to do excessive at home online modules & work books??? In addition; those seniors who are on registry for disaster deployments the education at home & education days in own time are relentless Once a month 6 hours minimum face to face unpaid simulations for ED. Excluding the excessive work from home hours to maintain all these NSW health changes for ECAT. I addition; modules in general Webinars Have to do everything at home etc etc
Thanks for your hard work in ED. You may find this video more helpful on this question. 2024 Tax Return Tips: Self-Education Deductions in Australia! kzread.info/dash/bejne/e4qGydqae7rZoqQ.html
Amazing videos!! Thank you
Thanks for watching!
so if i do door dash deliveries would that be a labour hire company?
The PSI tool should be able to help answer that question for you personally. There is no one size fits all answer.
After 2 hours of frustration Dan's simple video helped me at least figure out how to enter my income as a delivery driver. You are a legend Dan!!!!
Thanks so much for your kind comment! Best wishes with completing the rest!
Thanks, bro this came in clutch! I attempted to do this today and couldn't figure out where to simply put my income and expenses because its all labelled funny. I gave up and was looking at an accountant and then found your video!
Glad it helped!
Thanks tax with dan. Youve gotten a subscibe
Thanks so much!
can you make one video for uber driver pls
It’s all very similar. Your individual circumstances make the difference.
Thank you so much for this video! I was getting ready to switch banks because I could not figure out how to download my transactions - I even called TWO CSRs and they said it could not be done! You have saved me hours!!
Thanks so much for watching and commenting. I’m glad it helps!
That's a great video. However, I wonder in the section add asset, do we have to add all kinds of Cryptos we played individually (one by one separate)? Thanks
Depends on what you mean by ‘played’
This is fantastic thank you so much! I will say as someone who literally works with Excel for a living, this can be made much simpler by using a Table in your Data tab. It will automatically copy all your formulas down, and you can make your PivotTable based on the Table rather than a selection of data, which means if you add or delete columns (among other things), you won't have to reset/redefine your data source. Just a lil tip from my experience making my sheet from this tutorial!
Thanks for watching. I agree about comments about tables and encourage their use. However for my audience, I want them to understand the basic concepts first. Many viewers of my channel have never used a spreadsheet before for instance and I don’t recommend tables for them.
Great video. First time seeing this pre filled and stumped my outcome.
Thanks for watching. It surprises a lot of people with negatives outcomes not planned for.
Thank you thank you thank you for this video!!!!
Thanks for watching!
Legend. Great video
Thanks for watching!
hi, ive been doing uber eats for afew months now and i am curious what im supposed to do for the "tax withheld" section. I obviously havent had any tax withheld, and when i put 0 it gives me an error, any help would be awesome.
Not sure but I created another video that goes into more detail that you can watch here: MyTax Tutorial: Personal Service Income for Sole Traders kzread.info/dash/bejne/gYCGw7igdde2nbA.html
put double zero brother it works. if worked thank me later,
How to do owner occupied in myGov tax
Sorry not sure what you mean
I moved 30k Chainlink to my ledger for safety coz I dont trust the exchanges in a bust, is that taxable?
Good question. For a complete answer the ATO guides taxable transaction here www.ato.gov.au/individuals-and-families/investments-and-assets/crypto-asset-investments/transactions-acquiring-and-disposing-of-crypto-assets/crypto-asset-transactions
@@MoneywithDan Ok i suck at this but long story short bought and lost 1600 dollars (classic rugpulls got me)worth so all at a loss would i still get a amount owing from them you think?..Im not an accountant i dunno this tax crap
@@MoneywithDan bought and lost 1600 would i still get a bill from them?
Hey Dan, thanks for these awesome videos. Should I take my credit card info and combine it with checking? I do want the complete picture, but I would still like to differentiate the two. Thanks!
That what I do and the main reason I use excel is to see both sets of data in one view.
If you're doing Uber Eats, do you have to put tax withheld or is it $0?
If they withheld tax they should issue you a PAYG W statement. That should indicate what needs to be entered there.
Legend, thank you!
Thanks for your support!
Beautiful. Is there any way I can check the change in utility bills on a monthly basis!
Thank you. I usually update the pivot table to put the dates data field into the column section of the Pivot table which appears in the field list button is selected. You can then filter on just utilities and expand the field to show the supplier costs on seperate rows. Hope that makes sense.
If I'm a sole trader registered for GST, do I exclude the GST from all the values here? Or do I enter the full amount I was paid and add the GST to deductions?
exclude GST from all the numbers
Whats comma button mentioned repeated @5:26 ! I dint get that part.. Rest is excellent. Thanks
thanks for watching. this button “,”
@@MoneywithDan Thank you so much.
@@MoneywithDan Also can you please share the vlookup code? For some reason, im unable to reproduce what you are performing. After entering the comma, nothing shows up in the data cell because of which im getting the error (probably something to do with mac). Advance thanks. Really appreciate the support.
It worked fine now. Thanks... Great video:)
For claiming deductions for home office do I need to keep receipts for using the 67c fixed rate method?
According to the ATO, To claim your working from home deduction using this method, you must keep: a record of the number of actual hours you work from home during the entire income year - for example, a timesheet, roster, diary or other similar document PLUS at least one record for each of the additional running expenses you incur that the rate per work hour includes - for example, if you incurred electricity and stationery expenses keep one quarterly bill for your electricity expenses and one receipt for your stationery expenses. More information here www.ato.gov.au/individuals-and-families/income-deductions-offsets-and-records/deductions-you-can-claim/working-from-home-expenses/fixed-rate-method-67-cents#ato-Recordkeepingforthefixedratemethod
Thanks so much. Happy EOFY!
Same to you!
Hi! i'm getting lost here, I did ubereat by bike for like 2 months and earned $2000 last year, but how do I report my income as a abn? I only found many videos about tax return. I'm worried if I haven't report any abn income before end of financial year, thank you
From 1 July you will need to lodge you individual tax return where you will need to report this income less expenses in. I created a step by step video tutorial that goes deeper into this here Sole Trader Tax Return: Step-by-Step Guide using MyGov kzread.info/dash/bejne/mqR5qZJuaMXaZKw.html
Thanks! The estate tax treshold you mentioned for $11.4M is for US-citizens.
Non residents too
Hey Dan, how do I apply for tax return as a foreigner who works in Australia in 2006-2007?
That’s a tough one. I think you may need to consider using a tax agent. The alternative would be paper tax return as I don’t recall MyTax going back that far. Best of luck
@@MoneywithDan Thank you for the kind reply. May I ask if you have any recommendations for the best tax agent to use? Your advice is greatly appreciated.
An ETF, or exchange traded fund (not electronic traded funds) , is a marketable security that tracks an index, a commodity, bonds, or a basket of assets like an index fund.
Thanks. One of my first videos and I misspoke.. hopefully the rest of the video is valuable for you.
can you please explain what is PAYG Payment Summary?
Your employer prepares a summary of total payments made to you and taxes withheld for the tax year ended.
Why is everything so difficult with mygov ... getting thru on the phone is as easy as splitting the atom on an iphone
It’s peak time of year as tax return time is coming up.
These are a lifesaver, Dan! I stumbled through this on my own last year, but having this for reference will make things so much smoother, and I’ll have peace of mind I’m filling everything out correctly! I’m not sure if you mentioned this already and I just missed it in the video, but does the 50% discount applied to holdings over a year old start from the day I initially bought stock, or does it reset every time I buy more of the same stock? (Do I need to reset the 1 year timer every time I auto-invest dividends)
Thanks for watching. I’m glad it helps. According to the ATO, discount for distribution relates to how long the ETF held the investment and not how long you owned it - see here community.ato.gov.au/s/question/a0J9s000000OAfT/p00198452
@@MoneywithDan in the case of holding stock in a company directly, though, not through an etf, I assume those two would mean the same thing. I’m just not sure if the 1 year timer resets every time you buy more of the same stock
@@justsnowy2413 oh I see sorry I thought it was an ETF given the video topic. Each parcel of share will have their own 12 month CGT timer discount. This can get difficult to track and I use a paid online service called Sharesight to track this and optimise my CGT for me. I also created another CGT video that covers this issue more in depth which you can watch here How Capital Gains Tax is Calculated in Australia kzread.info/dash/bejne/paSZrtSSn6jZldo.html I hope this answers your question.
does not work at all for the first timer. we need to get the linking code but spent million years to just get it. only by call, nothing else, waiting for hours and still not able to get it. any other way to get the code?
That is a shame. Is this your first time lodging a tax return in Australia?
What happens if you don’t sell your capital gains at the end of the year, do we pay tax on that capital gain at the same year or whenever we sell it?
Thanks for watching. No potential capital gains tax until you sell your interest in asset or otherwise dispose of them (transfer to someone else) in Australia. However ETFs can distribute capital gain to you that it incurs on your behalf which you would see in the Tax Distribution statement sent from the ETF around August each year.
I have a bank statement full of transactions that start with the day the payment was authorized rendering the unique identifier trick ineffective.
Thanks for watching. You can use a MID formula instead of the left formula to skip the starting number of characters that cover the date. Try googling MID formula.
I am a foreigner who owns a property in Aust, and I do not have any of those Aussie identity documents including passport/ driving licence/ Medicare etc , so how do a I register to the "Standard Identity Strength" ? The app system only allows me to go as far as the Basic identity strength which does not allow me to get access to the myGov to lodge in tax return and Vacancy Fee Return. Is there any other way to lodge these forms as foreigner ? Thanks! I called up the hotline and the officer couldn't help much at all.
You will need to contact the ATO to find an alternative way. You may need ton use a tax agent to lodge a tax return if that fails.
Dan, do I continue to add additional years or make a new workbook? PLEASE advise.
Thanks for watching. I keep all the years in the same workbook for ease of analysis.
Use SHARESIGHT to track your shares - www.sharesight.com/moneywithdan/ (BONUS When you signup using this link, the first 4 months of subscription are free if you choose to upgrade to paid plan and I may get a small my commission at no extra cost to you, so we both win!)