New Workpapers - Income Tax workpaper - truncated balances are well intentioned but poorly executed
Income Tax workpaper we have two columns, completely unnecessarily, and neither is correct.
The first has decimals the whole way down.
The ATO doesn't accept decimals in most fields in the tax return. Income, expenses, tax rec adjustments, all must be entered excluding decimals.
Anybody who prepares an income tax workpaper with decimals, is silly and likes doing things the hard way.
One of two things happen:
1. You end up with a Taxable Income amount in your Income Tax workpaper which has decimals, and then the tax calculated on that same workpaper is incorrect (because if you have taxable income of $100.64 and tax at 25%, your tax expense is going to say $25.16, but your tax return is going to say taxable income of $100 and tax of $25). You take up the wrong Income Tax Payable amount in liabilities and it doesn't clear to nil when you lodge and pay.
2. You enter all of your amounts from your Income Tax workpaper in your tax return, and now each one has been rounded/truncated individually, you end up with a taxable income per the tax return which is $5, $10 more/less than the taxable income in your Income Tax workpaper, similar issue as above.
There is no benefit.
You prepare the Income Tax workpaper without decimals (as you must the tax return) and you will never have this issue.
The next issue with New Workpapers - Income Tax workpaper...
The second column, doesn't have any decimals at all, but a tax return does have decimals for tax amounts (tax on taxable income, tax credits, tax offsets etc).
So you end up with another calculated amount in your Income Tax workpaper which doesn't match your tax return.
I need rounded/truncated amounts to correctly calculate the tax payable (which isn't rounded).
I can't achieve it easily with the two columns given to me..
I need to manually edit all of the lines in the first column š¤¦š½āāļø painful.
Thanks for submitting your idea on Xero Product Ideas. We appreciate you taking time to let us know how we could improve Xero for you.
Your feedback will soon be reviewed by our Community team, and in the meantime this can begin to build support with votes from other community members.
If you're interested to see recent releases or get a pulse on what's coming soon see The Long and Short of it. š
-
Stephen Healy
commented
Ok Sam.
-
Sam Gray
commented
Cool. Next time I find something that annoys me in Xero, I'll ask whether you see it as a problem and whether I am allowed to post it on XPI šš½
You dismissed something I find very annoying, because you have a workaround that you happily do, but I don't want to have to do every time.
The "presumption" was to highlight that there are also other things, that have workarounds, but are illogical and don't match the real world and Xero could fix them. Maybe you agree that the PAYG Installment (sic) one is also silly? In which case, "I presume" you can see where I'm coming from here..
Maybe you don't think it's silly, in which case, enjoy your many workarounds. -
Stephen Healy
commented
@sam - umm ok.
Let me rephrase - I don't see it as a problem.
Would your way be better. Yeah probably. Should xero aim for best possible solution. Yes definitely.
Should Xero prioritise where to put their resources to maximise efficiency gains - absolutely.
"you probably also think..." I wouldn't presume to know what you think, perhaps don't presume what I think?
Edited by Community Manager
(Edited by admin) -
Sam Gray
commented
Sounds like you have had that problem, Stephen.
Mathematically it could very easily be more than a dollar either way.
Is it material? No. Is it insanely easy to fix with a better workpaper that has no downside? Yes.
You probably also think it's also fine that Xero's Income Tax workpaper includes the current year's June PAYG instalment in the Balance sheet income tax reconciliation section so that you have to manually add an adjustment to remove it. Every. Single. Time.
"But it only takes all of 0-1 seconds"
Every. Single. Time. š„“ -
Stephen Healy
commented
@Sam - I've never had that problem.
I put a rounding entry into my tax rec to calculate correct tax - and in the tax return - sure I might have to put a rounding dollar either way to make sure my reconciled balance matches my tax rec workpaper - but it takes all of 0 seconds.
Ok maybe 1 second.
And when we import from Xero into Xero tax - we're importing the accounts anyway which automatically remove the decimals.
All in all - I don't think it's a big deal and it certainly isn't a time waster - there's much more things Xero can be focussed on to get these workpapers much more improved to create much better efficiency.
-
Sam Gray
commented
@Stephen, the easier fix is to prepare an Income Tax workpaper without decimals.. as I have done for a decade.
If you do as you say, you might end up having to do a rounding entry in the tax rec AND a rounding entry in the tax return.
Because whilst it's easy to see what the 0.01-0.99 rounding issue is on your tax rec, once you enter the individual components from that tax rec, into your tax return, but have to round/truncate each one of them, it could be very different to your taxable income in your tax rec.
So, the least difficult thing that takes the least time, is preparing a tax rec that doesn't have decimal places (until you get to tax calculation).
-
Stephen Healy
commented
We've always gotten around this issue by putting a rounding entry (plus or minus) within the tax rec itself.
This is not difficult and takes no time at all - I'd do away with the truncated column and just put in a "rounding" amount field in the first column.
-
Sam Gray
commented
The truncated balances don't even add up correctly.