importing items from excel with Amts Inc Tax column - no corresponding field available in Reckon map
Options
Tableland Agri Services
Member Posts: 1 ✭
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.
0
Comments
-
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)
1 -
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 B0
-
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
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community