import BILL
A test tax invoice i am trying to import is from AAPT, $4,560.14 (inc GST $414.56), dated 1st Oct 2019. Inv no. is 14540584 with the description of Monthly charge Sept 19.
I'd REALLY appreciate if someone could advise...
!TRNS TRNSID TRNSTYPE DATE DOCNUM NAME DUEDATE AMOUNT ACCNT MEMO TOPRINT
!SPL SPLID TRNSTYPE DATE DOCNUM NAME DUEDATE AMOUNT ACCNT MEMO TAXABLE TAXCODE TAXAMOUNT
!ENDTRNS
TRNS 1 BILL 10/01/19 14540584 AAPT 10/30/19 -4560.14 8000 · Accounts Payable Monthly charge Sep 19 Y
SPL 2 BILL 10/01/19 14540584 AAPT 10/30/19 4145.58 2430 · Telephone Monthly charge Sep 19 Y NCG 414.56
ENDTRNS
Comments
-
Hello Sunnie Using iif for that bulk import it's never easy on 1st attempts. If you do not get any help in the forum Let me know we don't use iif as it's a quite an old tool . If this is on a regular basis we can automate this We import more than 1000 bills or invoice in very short time Chandra 0407068942
Cosmic Accounting Group
Accountants and Tax Agents 22397009
1 -
Hi Sunnie,
I got your email. Sorry, it was public holiday in Victoria. If you can send me your IIF file, I can have a look and let you know what is wrong.
But as Chandra said above, import data via IIF never be the best/easiest option. If it is not a one-off import, then a custom solution will fit you well. You can either ask Chandra or use my service, I can make sure to tailor a tool that will help you to import your file (from any source).
Thanks,
PhuongPhuong Do / Reckon Developer Partner
phuong@cactussoftware.com.au
0 -
Hi Sunnie,
You stated that you are trying to import a 'tax invoice' however the Type in the IIF example you have provided is BILL.
You have indicated that you have not been successful with the IIF import.
What specific error messages are you encountering?
Here is a full example.
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT NAMEISTAXABLE ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 DUEDATE TERMS PAID PAYMETH SHIPVIA SHIPDATE OTHER1 REP FOB PONUM INVTITLE INVMEMO SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 TAXCODE TAXAMOUNT TAXITEM PAYITEM YEARTODATE WAGEBASE EXTRA TOSEND ISAJE
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM PAYMETH TAXABLE VALADJ REIMBEXP TAXCODE TAXAMOUNT TAXITEM SERVICEDATE OTHER2 OTHER3 PAYITEM YEARTODATE WAGEBASE EXTRA
!ENDTRNS
TRNS 2 BILL 10/1/2019 Accounts Payable AAPT "-4,560.14" 14540584 Accounts Payable Monthly charge Sep 19 N N N 10/30/2019 N N N
SPL 3 BILL 10/1/2019 Telephone "4,145.58" N Y N NOTHING NCG 414.56 NCG
ENDTRNS
Chandra and Phuong are great members of the community who would be able to assist you with custom solutions.
The following posts also contain example IIF that you can compare to your own.
https://community.reckon.com/reckon/topics/how_to_import_tax_codes_when_importing_invoices_or_sales_receipts
https://community.reckon.com/reckon/topics/need_example_of_iif_file_showing_invoices_with_stock_codes
Regards,
Data Recovery TeamRegards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0 -
Thank you Chandra. It is a one-off import0
-
I have tried both tax invoice and bill...
There's no error message. It actually imports the file (that's the message i get!) but i can't locate it anywhere in Reckon. I also ran Audit Trail report to confirm this. Definitely not imported...0 -
Hi Sunnie,
Compare your IIF with the example provided above.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0 -
It worked!!!
Thank you, thank you,Data Rec!!!
Really appreciate it
0 -
Hi Sunnie,
Glad we could be of assistance.
What did you find was missing from your original IIF?
This can help others who may find themselves in a similar situation.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0 -
For TRNSTYPE, use BILL for supplier invoices and use DEPOSIT for bank deposits.
One very important & crucial information I've received from Phuong:
"IIF file needs to be in a text delimiter file format, which means you can read the plain text content via any text file editor/viewer"
"When you modify the IIF file using Excel, please make sure to save it as CSV file format and rename the extension".
Thank you, Phuong & Data Rec. I have already imported hundreds of data onto Reckon Hosted!1 -
From Excel we'd recommend saving the text file as a "tab-delimited text' not 'CSV' which is comma-separated'.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0 -
I'm glad to see you manage to import your data. Well done, Sunnie
Phuong Do / Reckon Developer Partner
phuong@cactussoftware.com.au
0
Categories
- All Categories
- 6.9K Accounts Hosted
- 11 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 326 Point of Sale
- 2K Personal Plus and Home & Business
- 74 About Reckon Community