I’m Australian too and I’ve worked on solving this issue too.
It’s a work in progress, but I’ve found a way to use Australian dates in the Transactions sheet and still get the benefits of all the other sheets that rely on the American dates column for their formulae.