Hi all Two questions for our new company which has been set up: * how do we get the amounts include tax to be ticked always in cheques and bills? 2. Why is this cheque not balancing? Our preferences are set up as: Thank you!!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Tax included

Mann

Hi all

Two questions for our new company which has been set up:

how do we get the amounts include tax to be ticked always in cheques and bills?

2. Why is this cheque not balancing?

Our preferences are set up as:

Thank you!!

Accepted answers

Acctd4

Great to hear @Mann ! 👏🏻👌🏻🙌🏻😊

All comments

Kris_Williams

it should balance of course everything looks ok, I would click the recalculate box and see what happens. Have you got the NCG tax code setup in the chart of accounts in the expense 309, so that it comes up instantly?

Tanvi_kataria

Hi @Mann

Please confirm, if you have tried to delete this Cheque completely and created a new one with the same details and figures?

If so, did it give you the same error message?

Also, if you run verify and rebuild of the data file?

Please feel free to let us know, if any concerns/issues. Thank you!

Regards

Tanvi

Acctd4

Hi @Mann

You can make it default to tax-inclusive in you Preferences however this will remove the checkbox option on all form (including invoices)
Check you don’t have a rogue amount on the Item tab

Mann

Thanks all. I have verified and rebuilt. It is still doing the same.

Shaz - our preferences show this:

Is there somewhere else that I need to update?

The cheque is still saying it doesn't balance. No amounts in the item tab.

Tanvi - we have entered and deleted this cheque numerous times, still the same outcome.

Kris - the chart of accounts has NCG for that code.

Any other ideas please?

Kris_Williams

when you enter the amount in the cheque and tab to the account field down the bottom it should automatically break it down to GST and total amount. Have you tried selecting a different account?

Kris_Williams

I’m happy to help if you want to call me

Kris

0415 940843

Mann

Hi Kris - I have tried a different account, same outcome

Doesn't make sense

Kris_Williams

call me if you have time

Kris_Williams

in my Preferences Tax - do you want to edit tax amounts - I have No, because I never edit them I change them if necessary by using 2 lines

Mann

Hi Kris - I have the luxury of having the company that was sold's computer using desktop right next to this new one. We have always had 'yes' as editing tax amounts as sometimes it is just 1c or so.

I have been able to see what the old company has done for a number of years, and replicated that in this new company. (I have worked here for a few years using desktop)

Kris_Williams

is it possible to backup the file and restore to the old computer, or is it an older version?

Mann

Not an older version, but only part of the company was sold, and the information is not interchangeable

Mann

When we set up the new company we imported lists of debtors, creditors and items. We did not bring in the chart of accounts. Would this have made a difference?

Kris_Williams

No I shouldn’t think so

Kris_Williams

is this happening with every single cheque?

Mann

yes it is - why doesn't this let me just type 'yes'!!

Kris_Williams

I would love to see this happening

Acctd4

@Mann

Do you also have auto recall set to last transaction … here ? :

Also, try changing this to Net & saving it. Exit out of the program then go in & change it back to Gross again & re-save (in case the setting has glitched):

Regarding the 'out of balance' issue … when you tab down to the next line on that Chq, does it populate a remaining balance amount ?

Check the following:

Scroll further down the Chq to ensure there are no random amounts on any other lines on that Expenses tab
Check your Tax Items & Tax Codes are configured correctly
Make sure only the default "Australian Taxation Office" Supplier is set as the Tax Agency

John Graetz

Regarding the issue of editing tax amounts. Years ago I used to be pedantic about doing this. Then I stopped after realising (as far as I was concerned) that ultimately it made no difference. As far as I am aware, when completing the BAS in Reckon, the GST total for the period will be 1/11th of the gross amount, meaning that it makes no apparent need to use the exact figure that might be shown on an invoice. Apart from that, there are always cents included in the BAS preparation, but the ATO ignores them and only uses whole dollars. If Reckon actually adds up all of the tax figures that we include on our cheques etc, then I stand to be corrected. Also, is it worth it to spend time and effort in order to gain one or two cents?

Kris_Williams

I agree @John Graetz , unless the ATO went through every transaction they would not be able to find any difference. When we used to enter GST and FRE they could have calculated the 1/11th to check 1A, but not any more

Mann

Hi John - I only use the function of editing tax amounts in a general journal that won't let me complete because it has rounded the wrong way.

Mann

Omg Shaz - thank you - turns out the tax codes were linked to ATO instead of Australian Tax Office. I have changed them, and I have been able to write cheques this morning.

What a relief!

Acctd4

Great to hear @Mann ! 👏🏻👌🏻🙌🏻😊