Tax included

Mann
Mann Member Posts: 11 Reckoner Reckoner

Hi all

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

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

2. Why is this cheque not balancing?

image.png

Our preferences are set up as:

image.png

Thank you!!

Best Answer

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,959 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    Answer ✓

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

    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

    shaz@accounted4.com.au

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

Answers

  • Kris_Williams
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

    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
    Tanvi_kataria Reckon Staff Posts: 448 Reckon Staff Reckon Staff

    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
    Acctd4 Accredited Partner Posts: 3,959 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited June 10

    Hi @Mann

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

    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

    shaz@accounted4.com.au

    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!)
  • Mann
    Mann Member Posts: 11 Reckoner Reckoner

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

    Shaz - our preferences show this:

    image.png

    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
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

    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
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

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

    Kris

    0415 940843

  • Mann
    Mann Member Posts: 11 Reckoner Reckoner

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

    Doesn't make sense

  • Kris_Williams
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

    call me if you have time

  • Kris_Williams
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

    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
    Mann Member Posts: 11 Reckoner Reckoner

    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
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

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

  • Mann
    Mann Member Posts: 11 Reckoner Reckoner

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

  • Mann
    Mann Member Posts: 11 Reckoner Reckoner

    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
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

    No I shouldn’t think so

  • Kris_Williams
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

    is this happening with every single cheque?

  • Mann
    Mann Member Posts: 11 Reckoner Reckoner

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

  • Kris_Williams
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

    I would love to see this happening

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,959 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited June 10

    @Mann

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

    image.png

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

    image.png

    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

    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

    shaz@accounted4.com.au

    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!)
  • John Graetz
    John Graetz Member Posts: 1,584 Reckon Legend Reckon Legend

    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
    Kris_Williams Member Posts: 3,942 Reckon Hall of Famer Reckon Hall of Famer

    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
    Mann Member Posts: 11 Reckoner Reckoner

    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
    Mann Member Posts: 11 Reckoner Reckoner

    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!