+ Reply to Thread
Results 1 to 4 of 4

Quickbook Experts IIF file bill payment imports

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    25

    Quickbook Experts IIF file bill payment imports

    Hello,

    I need some help, I was not sure where to post this but I need someone quickbooks help.

    So I want to import bill payments into quickbooks by using a IIF file. It keeps saying I have "You cannot import a blank transaction, Fill in the appropriate fields and try again." I tried many ways and I cannot figure this out. I use the same method importing checks, bills, etc. and I have no issues. Only when I use billpmt it gives me this error. I got template from the QB website and it looks like I am following the format correctly. Attached is what I used. I labeled A,B,C showing the 3 ways I tried. I have attached the original IIF template too for ref. Full Bill payment is my testing file and Template is the original sample file I downloaded from the website. Did I format something wrong with my file? Any help is greatly appreciated.

    Thank you!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Quickbook Experts IIF file bill payment imports

    I would try to see if you could EXPORT first. Then use that as your template to determine what fields you need to fill in (I do not have QB).

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,273

    Re: Quickbook Experts IIF file bill payment imports

    Template file not open.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    11-09-2017
    Location
    Basalt, Colorado
    MS-Off Ver
    2013
    Posts
    1

    Re: Quickbook Experts IIF file bill payment imports

    Hello,

    I actually tried to Export, and the only thing I could export was "Payment Method" which only details the number of transactions for each different payment method that was used... do you happen to have any other suggestions?

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA that imports a .txt file
    By DaveG93 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2016, 01:57 PM
  2. Macro that imports >65000 lines from Text file problem
    By Lensmeister in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-30-2013, 04:52 AM
  3. [SOLVED] Need Help cleaning up Macro that imports text file and deletes unnecessary rows
    By ppilot in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-16-2013, 10:44 PM
  4. Bill Payment Calendar
    By pgppuppy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2007, 11:03 PM
  5. [SOLVED] Refreshing all data imports on different sheets from the same file at the same time
    By ExcelTricks@gmail.com in forum Excel General
    Replies: 2
    Last Post: 08-07-2006, 08:00 PM
  6. can a cell remind you of an upcoming bill date payment
    By Colin2u in forum Excel General
    Replies: 3
    Last Post: 08-11-2005, 03:05 PM
  7. Replies: 1
    Last Post: 04-01-2005, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1