Transaction not in Balance when write cheques & enter bills


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!

Best Answer

  • Barbara Day-Dresen
    Barbara Day-Dresen Member Posts: 7
    Answer ✓

    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.

Answers

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,325 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited January 22

    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 😬)

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Barbara Day-Dresen
    Barbara Day-Dresen Member Posts: 7

    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
    Acctd4 Accredited Partner Posts: 3,325 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited January 22

    @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.

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Barbara Day-Dresen
    Barbara Day-Dresen Member Posts: 7

    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
    Acctd4 Accredited Partner Posts: 3,325 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

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

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)