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

Tableland Agri ServicesTableland Agri Services Member Posts: 1
edited October 2019 in Accounts Business Range

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 ConsultantSally McIntosh, Accredited Consultant Accredited Partner Posts: 648 ✭
    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 ([email protected])

  • sertrans1@bigpond.com[email protected] 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 BoastGraham Boast Accredited Partner Posts: 319 ✭✭
    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
    [email protected]
    www.reckonhelp.com.au/remotesupport.htm

Sign In or Register to comment.