Transaction not in Balance when write cheques & enter bills

Barbara Day-Dresen

As you can see by the above, with the first screen the amounts do add up. Then when I entered through to the next line (shot 2) it came up with double the amount of tax as a negative. Then I kept entering through lines (shot 3) and it kept getting worse.

I have tried deleting the lines - that doesn't work either. I've tried changing the amount in the gross tax field and it keeps reverting back. I keep getting the message:-

The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equals the amount at the top of the form.

I am going nuts trying to fix this problem. Help!

Barbara Day-Dresen

Hi Shaz, I think I have fixed the problem. In the 'Tax Item List' I had the Tax Items linked to ATO - Australian Taxation Office under Tax Agent and not just Australian Taxation Office. Once I changed the Tas Agent to Australian Taxation Office and then tried to re-enter the cheque, it was okay, the cheque balanced. So I went ahead and did the next cheque entry and that one worked also. Therefore the problem was in linking the correct tax agent. Thank you for trying to help me Shaz, this may help you to advise someone else in the future.

Acctd4

Hi @Barbara Day-Dresen

Have you clicked on the Items tab to check there's not a random amount sitting there that could be causing it? 🤔 (This can happen sometimes, especially if you have the "Automatically recall ..." Preference enabled 😬)

Barbara Day-Dresen

Yes, I checked the items - none. But as you can see by the screen shots, the problem worsens each time i enter down a line. Those amounts happen automatically, they are not keyed in

Acctd4

@Barbara Day-Dresen Hmm ... It usually does that due to another amount somewhere in the transaction. Scroll right down as far as you can to check there's not a random amount sitting there too 🤔 The negative amount that the system keeps auto-entering looks to be related to the GST so try ticking & unticking the Amounts include tax checkbox in case that setting has 'stuck'.

Do you Verify your Company File regularly ?

I'd recommend running the Rebuild 3 times (under the File dropdown menu > Utilities > Rebuild Data) For some reason THREE rebuilds fixes a lot of issues.

Barbara Day-Dresen

I tried ticking and unticking Amounts includes tax before and again just now. I rebuilt & verified the file already but just rebuilt again now 3 times. It is not just this transaction. I have tried 3 other transactions with the same problem. It also happens if I try to put them on as Bills. It is definately something to do with the GST amount

Acctd4

Aha! Yes - the Tax Agency name link is very specific … Good to hear you managed to resolve it 👏🏻