import BILL

  • 1
  • Question
  • Updated 1 month ago
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


Photo of Sunnie

Sunnie

  • 130 Points 100 badge 2x thumb

Posted 1 month ago

  • 1
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
Photo of Sunnie

Sunnie

  • 130 Points 100 badge 2x thumb
Thank you Chandra. It is a one-off import :)
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
Photo of Data Rec

Data Rec, Employee

  • 8,382 Points 5k badge 2x thumb
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
Photo of Sunnie

Sunnie

  • 130 Points 100 badge 2x thumb
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...
Photo of Sunnie

Sunnie

  • 130 Points 100 badge 2x thumb
It worked!!!
Thank you, thank you,Data Rec!!!
Really appreciate it :)
Photo of Data Rec

Data Rec, Employee

  • 8,372 Points 5k badge 2x thumb
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.
Photo of Sunnie

Sunnie

  • 130 Points 100 badge 2x thumb
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!

Photo of Data Rec

Data Rec, Employee

  • 8,372 Points 5k badge 2x thumb
From Excel we'd recommend saving the text file as a "tab-delimited text' not 'CSV' which is comma-separated'.
I'm glad to see you manage to import your data. Well done, Sunnie :)