BettyJane, Thanks for the response. I noticed that QB has an online subscription with support. If I sign up for the service, (I assume with the current 2019 version?) will I get specific support on how to import my tab delimited format .IIF file? Frank
... View more
BettyJane, Since this is New Year's Day, I didn't expect a response, given I received one and it more or less answered my specific questions with general answers, I will assume it was an automated response. Whether that is an accurate assumption or not, here is still the issue I pointed out in the last post: 1. Your "answer"/suggestion: You can download the .IIF sample file and follow the format to import your transaction. This way you'll be able to manually enter the details of the transaction. Just edit the columns of the header to make it similar to the sample. " I uploaded a .pdf showing the provided sample header and my "about" data from the QB 2009 installation, that I attempted to "match" to the sample header. Again, since the data in that "about" screen doesn't match well to the sample header contents, I did my best to match it the best I could by guessing and morphing what I had from my QB installation, into the fields I needed to match. If you were to look at the .pdf data I provided, and what I created to match the sample provided, you can see there are obvious dissimilarities. Is that my problem why my import says it is successful, but nothing gets posted? How important is the header details and format? Is its specificity/details crucial to the proper functioning of the subsequent import TRNSs and SPLs? 2. The sample TRNSs and SPLs provided and my "matched" TRNs and SPLs are also provided in the .pdf I included. Again there are obvious dissimilarities, both in number of the fields utilized, their account/list names, etc. . It this the crucial issue with why my two transactions are not being posted? How many of the 41 fields of the TRNS command line need to be "exactly" matched, and with my "about" file provided, how do I do this since my names of some of the accounts are not identical to the sample provided? 3. Can you provide me a similar 2009 version HDR, TRNS, SPL command line that would do 2 simple transactions, 1) a deposit to a bank account in the check register and 2) an expense paid (check written) in the check register? 4. For each of the commands, HDR TRNS SPL, what are the critical fields that need to be included and exactly identically accurately created and included, and what (if any) fields are default(able) and can be left blank? For the TRNS command for instance, it seems rather obvious that 41 fields to do a 5-field (date, entry #, account, note, amount) content deposit is a bit of an overkill and over complicated, so I assume some of those fields could easily left blank and QB manages them w/default assumptions/actions, is this not true? I don't think the import should be this difficult to accomplish, and it has taken far too much time and energy thus far, and I apologize if I have made this too difficult for you to answer, but any specific assistance beyond the "download the sample...." would actually be appreciated. Frank
... View more
Thanks, so I decided to try a basic simple import to try to get it going at all. What I found is I can't get any transaction to import, even though the header, trans and spl (and endtrns) are all in place. I did only 1 simple deposit and 1 simple expense, neither posted but the import said it was successfully imported. I uploaded a file with the information from my 2009 "about" file, my transactions and the sample transactions from the files I was told to use as a model from QB. Since I am out of ideas, and I know any subtile (or not so subtile) detail goof up the import, I need anyone's assistance to get the thing to work at all. I don't know if the header is the issue, I don't have the proper number of fields (too many or not enough or in the improper order or whatever else that can go wrong), there may be a typo on some field, I didn't use the proper tab delimited vs comma separated format, et al.
I included a .pdf of my system, however for the header I had to guess at the Version number, the product name, the time format was most confusing so I guessed at that as well, I included also a couple of screen shots of the check register showing typical entries I am hoping to import if I can get anything to work at all, and I also included a side by side listing of the QB provided general examples of the header, trans spl and endtrns as well as my feeble attempt to match my specific system to those examples for comparison. During my fun times, I have made modifications to the number of fields (like the 41 showing in the sample from QB for trns, the format of the data, etc. all to no avail.)
I also googled sample .IIFs for QB, found a 3rd party app for ~$170 or so, but since I am an hyper user of excel, I can easily structure the excel sheet in whatever manner QB requires if I could only figure out what it is (SPECIFICALLY to the ASCII chars) required for my friend's specific QB version, account names, etc.
So any assistance would be appreciated prior to my throwing in the towel and $170 to a gamble that the 3rd party SW will be any better than my feeble attempts to decipher QB's requirements from their general assistance .IIF help file.
... View more
Christine Mae, Thank you for the illustration. It is for an Accounts Payable transaction. What I need is a Check Register (Bank) check written to a Payee, Account, Memo, Payment, Deposit (I assume the reconcile and balance will be managed by QB during it's subsequent internal processing steps). Since the structure between your illustration of an Accounts Payable transaction and the Check Register are different, how exactly is this structure represented by the following I have loaded from the Bank Statement in Excel? (The 1st line is the Excel column identifiers that I layed-out/"matched" from the QB Check Register layout/format. I also tried to layout the data under the column identifiers to properly represent the field locations, skipping columns when appropriate between the TRNS and SPL layout formats) A B C D E F G H Date Number Payee Account Memo Payment Deposit Bal Type 4/6/18 , 2745, Jim's Pump Srvc, Concrete:Pumping, 172 Hillside, -350.00 4/8/18, Transfer, , Owner's Cap:Dep, Cash Deposit, , 1,800.00 I don't want to goof up the QB database by importing the data incorrectly, so here is my best guess from the TRNS and SPL formats of what it could be. Can you please validate/correct it for me? A B C D E F G H I TRNS 292 Bank 4/6/18 Bank of America Check Register -350.00 SPL 293 Bank 4/6/18 Jim'd Pump Svc, Concrete:Pumping 172 Hillside 350.00 ENDTRNS TRNS 294 Bank 4/8/18 Bank of America Check Register 1800.00 SPL 295 Bank 4/8/18 Owner's Cap:Dep Cash Deposit -1800.00 ENDTRNS Thank you. Frank
... View more
Hello, Can QB Pro 2009 do export IIF to excel files? If so how is that done, I wanted to import transactions so I thought if I exported several, I'd see the exact format required. However I can't see the export transactions option, only lists to IIF and timer lists and addresses to text. Given that limitation, what is the exact format for transactions for QB 2009, I've had no luck getting it to work so far. I have several months of data in Excel I'd like to import to the check register. Thanks, Frank
... View more
Hello, Thanks for the information. I am a neophyte QB user, helping someone out with their business paperwork, as his bookkeeper moved out of state and he needs his P&L done for 2018. I have some familiarity with QB but not the details and subtleties. I want to enter several month's worth of BoA transactions from the statements (which I now have loaded into Excel). I downloaded the IIF kit that defines the header and transaction format, however there are no sample examples, ie exactly how is a line of data formatted for a given transaction; like paying the phone bill (Telephone Account) from the check register (Checking Account). If that detail was provided, the theory would be much easier to understand, since there are 41 fields in each transaction, what do I do with the other 37 fields per transaction? Can you provide such an example for a given transaction for me? Thank you. Frank example: 4/13/2018,VERIZON WIRELESS Bill Payment,($350.00),Telephone:Wireless
... View more