TAX CODE not pick up after iif file import in General journal enteries

CKETG
CKETG Member Posts: 5 Novice Member Novice Member
in Reckon Accounts (Desktop)

Hi Everyone,

I am having trouble picking up the tax code in General Journal after iif file load.

Only the first line pick up the tax code and the rest is blank.

not sure why only first line of journal pick up.


image.png


Answers

  • Datarec
    Datarec Reckon Staff Posts: 1,246 Reckon Staff

    Hi @CKETG

    You've uploaded a screenshot of the first three rows of an IIF file.

    Consider providing an example of the JOURNAL IIF that you are creating.

    Also note that there are TAX ITEMS and TAX CODES, which are associated but are separate things.


    Consider reviewing the other Community Posts that may be related:

    https://community.reckon.com/discussion/8031044/iif-file-for-general-journal-discussion
    https://community.reckon.com/discussion/7953649/general-journal-import-iif-file-taxcode-not-showing


    Regards,

    Reckon Data Recovery Team

    How to ask good questions on the Reckon Community

    #TipTuesday - A Picture Paints A Thousand Words

    How do I add an image or screenshot to my discussion?

  • Dianita
    Dianita Member Posts: 120 Reckoner Reckoner

    Hello morning @CKETG,


    I had to test this for myself as there is not a requirement for our company to use the tax coding for our monthly journals, but this template below seems to be pushing the journal with GST. Not sure if this helps, but tweaking your file multiple times and uploading the file into a test file normally does the trick for us.


    Excel which will be converted to IIF file as below:

    image.png


    Uploaded journal with GST on the COGS line (note that in this example below, the balance sheet item seemed to be not picking up the code):

    image.png

    Not a perfect fix but hopefully it could help you, good luck.

    Regards,

    Nita

  • CKETG
    CKETG Member Posts: 5 Novice Member Novice Member

    Thank you Dianita,

    Same thing happen only first line able to import the tax code and the rest of the other line are unable to pick up the tax code.

    Seem like I am missing something.

  • CKETG
    CKETG Member Posts: 5 Novice Member Novice Member

    Hi Reckon support,


    I have view the post and seem can't find solution to my problem.

    image.png


    I trying to load example above but tax code only pick up first line transaction, not sure why?

    image.png


    CK

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,820 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited July 2023

    Hi CK

    This is because tax codes are only applicable on sales/income & purchases/expenses. Tax codes are not applicable to a bank account as this is a balance sheet asset account 😬

    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!)
  • CKETG
    CKETG Member Posts: 5 Novice Member Novice Member
    edited July 2023

    Hi Shaz,


    The expenses account can not pick up the tax code, it is a testing example trying to see how I am able to import the iif file and pick up the tax code for all transaciton line.

    The tax code only able to pick up in first line and not able to pick up for the rest of the journal.

    CK.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,820 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Hi CK

    If you look at the Tax Amount column though, you'll see it actually is picking up the GST on the expenses 😊:

    image.png


    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!)
  • CKETG
    CKETG Member Posts: 5 Novice Member Novice Member
    edited July 2023

    Hi Shaz,

    Even it show on the tax amount in the journal from the import, the GST amount doesn't pick up in GST GL accounts without the Tax code in the journal.

    I need the GST amount to be able to pick up in GST accounts thats why I need the code in each line.


    CK

  • Kris_Williams
    Kris_Williams Member Posts: 3,702 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    I have had this many times before, the GST amounts in journals don’t display in certain reports but it is included in the GST reports, e.g. Tax Summary Report

  • Dianita
    Dianita Member Posts: 120 Reckoner Reckoner

    Morning @CKETG,

    Not sure if you have abandoned this IIF idea but if you insist on having the NCG's appear, you can prepare it in one IIF file but will upload into 3 journals, e.g. template below:

    Excel/ IIF file

    image.png


    Journal #1

    image.png

    Journal #2

    image.png

    Journal #3

    image.png


    Otherwise (if entering transactions that appear in your bank account is what you are trying to do here, perhaps not), I strongly advise not to use IIF file and use the general Reckon tax invoice (then receive payments) for your income and Reckon general BILL (then pay bills) for your outgoings. Anything else can be done via cheques, liability cheques, paycheques (and with some occasional journals). I would try to avoid using IIF files to do daily tasks like this because you end up spending too much time personalising the file each time, not to mention potentially could be breaking the file altogether.

    The IIF file upload is used only when dealing with 50+ lines that you cannot otherwise afford to enter manually in the Reckon. E.g. if you have to split your payroll tax expense by employees (500 people), or you have to reclassify your cost of sale and split those into the future - say for the next 36 months, of if you just have 200 lines of services that you will need to split in your supplier invoice.

    Hope this helps.

    Regards,

    Nita

Categories