importing items from excel with Amts Inc Tax column - no corresponding field available in Reckon map

Tableland Agri Services
Tableland Agri Services Member Posts: 1
edited October 2019 in Reckon Accounts (Desktop)

HELP! I am converting from MYOB to Reckon Premier: Retail Edition. I have exported all my items to excel and mapped them correctly. EXCEPT when I do the item mapping in Reckon there is no option to select "Amts Incl Tax" (for the Gross Sale Price). My items all import OK except Reckon adds another 10% to the already inclusive price.

Comments

  • Sally McIntosh, Accredited Consultant
    Sally McIntosh, Accredited Consultant Accredited Partner Posts: 468 Accredited Partner Accredited Partner
    edited February 2017

    Hi,

    This all needs to be done in the Excel document before importing. I would suggest using the IIF file import method, not excel mapping.

    If you need help with this I would suggest to ask a Reckon professional.

    I am available if you like.

    Kind regards,

    Sally McIntosh (sally@samsolutions.com.au)

  • sertrans1@bigpond.com
    sertrans1@bigpond.com Member Posts: 14
    edited April 2015
    If you go to the item list, select each item and chose "item button lower left, edit item, on the lower right of the page is "Amt Inc tax", tick this box. Bev B
  • Graham Boast
    Graham Boast Accredited Partner Posts: 331 Accredited Partner Accredited Partner
    edited December 2017
    Hi TAS

    The Cost and Price mappings in the Excel Import are all net of GST prices, so you will have to calculate new columns for Net Cost and Net Price, then map these columns before you import.  Best formula to use is Round(GrossPrice/1.1,5).

    Once you have imported, you can export the list as an iif file, change the values in the AMTSINCTAX column from N to Y, then reimport.

    Graham Boast
    Reckon Accredited Consultant
    graham@reckonhelp.com.au
    www.reckonhelp.com.au/remotesupport.htm

    Graham Boast | 0409 317366 | graham@reckonhelp.com.au