import BILL

Sunnie · November 2019

I am most desperate for help, please. We need to import over 1000 bills & receipts to enter in Accounts Hosted. I've read and followed so many different advises on how to set up iif file format but have not been successful. What am i doing wrong?
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

cosmic · November 2019

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

PhuongDo · November 2019

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,

Phuong

Data Rec · November 2019

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 Team

Sunnie · November 2019

Thank you Chandra. It is a one-off import

Sunnie · November 2019

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...

Data Rec · November 2019

Hi Sunnie,

Compare your IIF with the example provided above.

Sunnie · November 2019

It worked!!!
Thank you, thank you,Data Rec!!!
Really appreciate it

Data Rec · November 2019

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.

Sunnie · November 2019

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!

Data Rec · November 2019

From Excel we'd recommend saving the text file as a "tab-delimited text' not 'CSV' which is comma-separated'.

PhuongDo · November 2019

I'm glad to see you manage to import your data. Well done, Sunnie

import BILL

Comments