Welcome to the brand new Reckon Community!

For some tips on getting started check out the 'About Reckon Community' section

import BILL

SunnieSunnie Member Posts: 5
edited December 2019 in Accounts Hosted
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


Comments

  • cosmiccosmic Reckon Developer Partner Posts: 1,179 ✭✭
    edited December 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
  • PhuongDoPhuongDo Reckon Developer Partner Posts: 194 ✭✭
    edited 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


    Phuong Do / Reckon Developer Partner

    [email protected]

  • Data RecData Rec Reckon Staff Posts: 796 ✭✭
    edited 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

    Regards,

    Reckon Data Recovery Team

    You can request assistance via the case request web form below.

    https://www.reckon.com/au/data-services-request/

  • SunnieSunnie Member Posts: 5
    edited November 2019
    Thank you Chandra. It is a one-off import :)
  • SunnieSunnie Member Posts: 5
    edited December 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 RecData Rec Reckon Staff Posts: 796 ✭✭
    edited November 2019
    Hi Sunnie,

    Compare your IIF with the example provided above.


    Regards,

    Reckon Data Recovery Team

    You can request assistance via the case request web form below.

    https://www.reckon.com/au/data-services-request/

  • SunnieSunnie Member Posts: 5
    edited November 2019
    It worked!!!
    Thank you, thank you,Data Rec!!!
    Really appreciate it :)

  • Data RecData Rec Reckon Staff Posts: 796 ✭✭
    edited 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.


    Regards,

    Reckon Data Recovery Team

    You can request assistance via the case request web form below.

    https://www.reckon.com/au/data-services-request/

  • SunnieSunnie Member Posts: 5
    edited 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 RecData Rec Reckon Staff Posts: 796 ✭✭
    edited November 2019
    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

    You can request assistance via the case request web form below.

    https://www.reckon.com/au/data-services-request/

  • PhuongDoPhuongDo Reckon Developer Partner Posts: 194 ✭✭
    edited November 2019
    I'm glad to see you manage to import your data. Well done, Sunnie :)


    Phuong Do / Reckon Developer Partner

    [email protected]

Sign In or Register to comment.