Hi. Thanks for watching. If a column is left empty then data overflowing from columns nearby will expanded automatically until data is filled in. Simply copy your formula in Left and Year fields down to stop this overflow happening.

Thanks for watching. All of the tips in the videos can be used by everyone in Australia which is democratic to me.

Haha… sort of. This is one of my early videos and I tried to slow my voice down and over pronounce so the auto voice to text on function on KZbin would work better. It seems to have over emphasised my Aussies accent at the same time 😀

Thanks. That’s a great suggestion!

Thank you

That is strange. Have you formatted the cells with dates or is it formatted as numbers m? The version of excel should not impact this formula.

@@MoneywithDan No formatting was done to the CSV sheet other than opening it in Excel and saving it as an XLSX file. I checked the cells with the dates and they are all formatted as "General". The entire DATA tab/sheet is. I agree it is weird. I've looked all over online to find a possible cause, and none of the suggestions have worked.

@ you said the cells with dates are formatted as general… they should be formatted as dates

@@MoneywithDan Tried switching, but it doesn't work. Thanks for trying.

Thanks for watching

Sorry I don’t have a template for GST.

I’m so glad you found it helpful! Best wishes for the new year!

So no business activity to report would mean no tax return.

@@MoneywithDan I suppose my question is...how do I fill those out? just put a bunch of zeroes? I selected the "Im a sole trader" on my ABN and I have my 9-5 job on top of this so do I just do my normal tax return and not check the box that says "You were a sole trader or had business income or losses or partnership distributions"??

@ that’s right. Don’t select that section as there was no business based on your description.

Sounds like there is not a unique reference to match with this line. Does this transaction have a date or something that makes it different every time? If so then you may get around this by using a MID formula instead of the LEFT which allows you to jump over the beginning characters. Hope this helps!

@ thank you for the response. I’ll keep you posted. Take care

💯

Sorry to hear that. You’ll need to call Centrelink

No worries mate! Glad it helped!

Thank you!

Not in an automatic way. You would need to manually add two lines in the data tab - one entry line to reduce the category in question and another line to increase it by the same amount to another category by the same amount. I don’t do this often as it is not time efficient, but it is good for large items bought at the same store.

@ ok thanks so much! Your video is very helpful and much appreciated! Thank you for posting it and for your response!!

Wow that’s huge. It’s worth seeing a registered tax agent for that kind of money.

Sorry to hear. Unfortunately it sounds like you need to ring ATO

Thanks for watching!

Hi PearlyGabe. Nice to hear from you in Tassie. I’m glad you are liking the content. Best wishes. Dan

I’ve never heard of those until now. Interesting question. These don’t appear to be common for Australians as ETFs in Australia must distribute or else there are significant Australian tax penalties. This one where you should seek tax advice.

@ I think for me, this is what makes US domiciled ETFs more appealing compared to Aus domiciled ones. The internal capital gains are allowed to continue to compound instead of being distributed, so effectively gives you a boost up 0.5% depending on your income tax bracket if you sell when your stop working.

Thanks so much

Thanks so much!

So glad it helps!

@@MoneywithDan Please do videos on investing, budgeting - anything related to money. Thank you kindly.

Sometimes you can.

Is it correct?

Thank you!

You likely have been asked to pay PAYG instalments quarterly on your activity statement on your ABN income? This is normal after first year of running a business as the ATO want the tax money before Yu lodge your next tax return using an estimate of the last tax return lodged. If your circumstances have changed you can look at varying the tax amount, but be wary as there are penalties if you get it wrong. More detail can be found at ATO link here www.ato.gov.au/businesses-and-organisations/income-deductions-and-concessions/payg-instalments/how-to-vary-your-payg-instalments

Glad it helped! One day maybe 😀

Did you receive the NOA in your myGov inbox last year?

@@MoneywithDan si pero el problema es que no me reconocer la cuenta del banco. Por eso quiero usar la referencia del Noa y el PAYG pero no sé de dónde usar la referencia para el PAYG.

@@joseluismartinmendoza9690 ok if you can’t use the NOA reference then you may need to ring ATO for a linking number instead. This may take a long time waiting on hold. Best wishes!

@@MoneywithDan but what is the PAYG? Where can i find it?

Glad it helped!

Were you taxed under the Employee Share Schemes (ESS) rules at the time? More information can be found here community.ato.gov.au/s/question/a0J9s0000001JYG/p00051458

Sorry you need to contact ATO

Hi there. Yes heaters have 7 year life and not 20. Not sure where you are getting 20years. If you use the ATO tool you can search for the correct effective life of the asset you are looking for.

KZbin seem to have lowered the standard resolution of videos to 720p. I created the video with 1080p. You can increase the video quality to 1080p to get the fully quality in the settings of your video.

Glad I could help!

Thanks for the question. It sounds like you pasted across the formulas instead of the values only. The formula would result in an error. Make sure you see which paste button I use at that step.

@@MoneywithDan Thanks Dan. I have looked into this. On video, it does not show which paste button you click as I believe you may have used keyboard shortcuts. I did manage to click on "Paste Special' and selected "Values" rather than all which seemed to have done the trick. Hopefully this method wont create any issues moving forward. I do have another query. I am tracking expenses on a credit card I use for a particular purpose. When it comes to repayments made on the credit card, DO I put this under an "Income" category since it is a credit on the account and not a deduction?

@@barung86 ok thanks for letting me know and glad you found the issue. In regards to transferring money between accounts including credit card payments I usually categorise them the same as “trf”. When I consolidate all my accounts together the credits and debits sum to zero and i only see true expenses of outgoings only. If you wanted to look at just one bank account or credit card in the pivot table, I would suggest that you isolate payments into a seperate standalone category and deselect that category so you can exclude the repayment so it doesn’t distort your review of genuine outgoing expenditure. This is what I do personally.

It sounds like it could be correct as it came from prefill, but is hard to say without looking at tax statement. Having a difference between taxable income and cash payments with ETFs is common. For example, if your ETF distributes a lot of franked income then it will mean taxable income is higher than cash received as the franking credit will gross up your taxable income while the franking credit will reduce tax owing, despite higher taxable income. Sometime it works the other way where your taxable income is less than cash distribution. For example Capital gain paid in cash is higher because taxable income is lower due to CGT discount. It depends on type of income the trust is distributing that year and its tax treatment and tax rules applicable to the owner. Best wishes.

​@MoneywithDan Thanks Dan for reply. I guess it is safe to assume that numbers that mytax has calculated are correct based on correctly generated pre filled data from annual statement.

Thanks so much!

Thanks for letting me know

Thanks

In limited circumstances you might be able to. The ATO provides more guidance on deductibility of occupancy expenses here: www.ato.gov.au/individuals-and-families/income-deductions-offsets-and-records/deductions-you-can-claim/working-from-home-expenses/occupancy-expenses

Hi there. That is strange Centrelink have asked for copies. Have you lodged those tax returns for the years requested? As Centrelink are a federal agency, they can usually obtain lodged tax returns from the ATO if you have already lodged them. Also, if you are registered with myGov they contact you over that portal for certain request as it is more secure. I suggest that you check you are not being scammed by contacting Centrelink on their main contact number first before sharing any details.

@@MoneywithDan Thanks Dan, I really appreciate your suggestion.

Thanks so much. Glad it helps

You might be better off watching the full tutorial and skip to the section where I show this. Watch here How to track expenses AUTOMATICALLY in Excel | BUDGET SPREADSHEET kzbin.info/www/bejne/qXe9mKWXeKyIidU

@@MoneywithDan thanks for the response. yeah I’ve seen this but because I’m doing any exactly match with the VLOOKUP does that not mean the transaction will only be assigned a category for an identical transaction? Like each week I shop at different supermarkets etc? Like for yours you only needed to change a few columns whereas mine seems to be most of them

Why? What issues are you having?