Anyone Use Microsoft Excel for Your Taxes

Just curious if anyone uses excel to do their taxes to make a summary so that it is easier for accountant.
I would cover standard things around you income, expenses, investment properties, etc.

Update:
After fair bit of research I found some simple one that was optimal. Lots were either really complicated or too basic.
I bought few paid ones and customised to suit someone in Australia who is looking to do:
A. Personal tax - income is from job, interest, etc + track strandard expenses
B. Track Property expense - rental income, expense (property manager, maintainance, etc)
C. Side hustles - you might have side hustles in early stage where it is just loan as expense that you need to track.

Mod: Removed solicitation

Comments

  • +4

    I use Corolla

    • +1

      Thanks for sharing. What is Corolla? When i search on google, it shows me cars :)

      • +5

        Isn't Excel a car too?

  • +6

    I use excel. Makes it much easier to track and summarise.

    • -1

      Any chance you can share the blank template.

  • +2

    Yep, have done for many yrs. My acct is in a different state so easy to make sure he gets everything in an easy to read\use format

    • -1

      Any chance you can share a blank template?

      • +2

        Missing magic word

  • +3

    Anyone has some kind of blank template and dont mind sharing it?

  • +4

    This question comes up every other week on /r/ausfinance, but not quite as frequently as Sankey posts.

    Compiled Sanity is mode du jour: https://cspersonalfinance.io
    CS Subreddit for support: https://www.reddit.com/r/CSPersonalFinance/

    The bottom line is: don't venture into uncharted territory for complex tax affairs, especially if you're not familiar with troubleshooting and QA in Excel. Also: templates were usually built for one person's needs, which won't apply to you.

    In many cases, you might actually be better off just using Excel for basic maths, and smashing the numbers straight into https://paycalculator.com.au/

    • Thanks. Do you use it yourself?

  • +5

    I am happy to share a blank template for Microsoft Excel with you Yoman55555.

    1. Open Microsoft Excel.
    2. Click Blank workbook in the New section.
    • I didn't follow. Can you provide more details

      • +1

        Everyone's circumstances differ. Some times it's better to start from scratch. I may have lotus 123 template, or quatro pro template.

        • sure. thanks

  • Etsy surprisingly offers a good solution for these templates: https://www.etsy.com/au/search?q=australia+tax+excel+propert…

  • +1

    Lots of free Excel downloads with a google or youtube search.
    But it's easier to setup your own personalised template. FWIW I've moved from Excel to Google sheets.

    https://indzara.com/2013/05/personal-finance-manager-excel-t…

Login or Join to leave a comment