Importing Transactions Into QuickBooks with IIF Files
Vložit
- čas přidán 10. 08. 2017
- In this QuickBooks training tutorial, you will learn how iif files work. Iif files are special files in a special format that allow you to import any kind of transaction into any version of Quickbooks desktop. Creating iif files is like programming. It is complex and takes time. You can use excel to make them but there is a lot of studies involved.
👉Subscribe for more videos:
bit.ly/thequickbooksdude
Other Related Videos 👇
Learn QuickBooks Bank Reconciliation
• 1 - What Is Bank Recon...
Learn QuickBooks Online Bank Feeds
• Setting Up Bank Feeds ...
QuickBooks Register, Checks, Deposits & Banking
• QuickBooks Desktop Dep...
✅ You can download "follow along files" for this video at:
marksmolen.com/index.php/yout...
➡Follow us on social media:
/ certifiedquickbookstra...
/ quickbooksforlandlords
Mark Smolen is a certified instructor and the creator of the QuickBooks Instructional CZcams Channel and Website.
➡Get In Touch Today
Have a question or need help with your QuickBooks Instructional Course? Contact Mark directly.
marksmolen.com
quickbooksforlandlords.net
#thequickbooksdude #Quickbooks #importtransactions
I am able to export an IIF file from our software. If I want to review the data before importing into QB, do you foresee an issue with changing the file to a ".txt" file, opening in Excel, making the necessary edits, and then changing the file back to an IIF file? I've already tested that I can open the converted .txt file in Excel, but I'm not sure if these conversions back and forth have any impact on the final IIF. I look forward to your reply. Thanks!
Here is IIF SOLUTION
czcams.com/video/8zd76mWHXPo/video.html
I've actually found IIF to be quite nice!
It took a lot of trial and error to get the correct format and then even MORE trial and error to correctly input the account names (especially the SUBaccounts) correctly.
Additionally there is often a strange character between subaccounts that needs to stay the same as you convert the excel document to an IIF file.
The only way I found to convert to IIF was to save the Excel file as Unicode (text) and then open the text file with Visual Studio Code and then "Save As" and then add ".iif" to the name.
The Unicode format kept those weird dot symbols between an account and sub-account, and visual studio code was the only option that just let me add ".iif" to the file and have it actually save as an .iif file.
Thank you for sharing that and there are still people who are fans of the I. IF format but I can't help but think that everything you told me is a great sacrifice of time energy and attention and a fraction of that would just. Be easier if you just paid for Zed access and you software to put everything in.
I guess everybody has their preference
Mark
@@worldwidequickbooks Zed Axis is a novel point of research for me. Their product(s) remind(s) me of what I wish I could set up with Excel macros: One macro (for each banking institution) to format bank statements that were downloaded to excel, then a macro to convert the worksheet into IIF file *format* that would then have a macro to download the worksheet as an IIF file to be imported and reconciled within QB. Other than that, I'm not aware of external sources that would be useful to streamline importation into quickbooks, besides checks and wildly distinct invoices that would both be hard to automate.
@@worldwidequickbooks Also I'm quite excited about the prospect of creating excel formulas that use logic to convert bank-specific transaction details into accounts for the IIF file formatting; that would be requisite to automate the bank transactions conversion to qb transactions
Thanks your videos teach me how to import the IIF file's transaction into Quickbooks but seem not to finish my task, actual this transaction just cut to AR but I would to deduct from the Subaccount of AR and apply to individual invoices please help me on this case. Thanks in advance!...
Thank you Chork for your question. If you import invoices or invoice payment transactions in any way, not only from IIF files, then unfortunatly you CANNOT APPLY the payments to the invoices until after they are imported. Yes, you have more work when you are finished. However, if you are importing many past invoices and payments, it is likely that all or most of the past payments were applied to past invoices and you only can apply them in a bunch just by openingthe payments and selecting all invoices.
The only one's you have to CAREFULLY apply ae the payments to the invoices that are cuurently open at the moment you import.
I hope that helps and I hope you will subscribe and "like" the videos that helped you
-Mark
I have been importing iff files for many years (Invoices, Sales Receipts and Credit Memos)... it has always worked out well. However, I am trying ti import to Enterprise 2019.. and it is giving me a problem. I think they layout is different now. Can you guide me to someone who can help me with this?
I regret that you will have to ask enterpirse solution support for the reading material in IIF files that apply to enterprize solutions.
very helpful overview video. I am considering using this to upload bills. In your example, you had Netflix as a vendor. After importing this data I can see you were able to find the Netflix transaction in your journal...but would you have also been able to find the transaction if you went to "vendors" and looked to see if it was listed under the vendor Netflix? I ask because that part is important to me. If I am going to start importing using IIF, I want to information to be associated with the vendor also, not just a journal entry. thanks.
I assume that if you use iif files for other types of transactions before journal entries that it records the transaction just as if you recorded it normally so the answer should be yes
The only way to know for sure about anytime a student asks me what would happen if I did this or what would happen if I did that
His to tell the student to give it a try and see what happens but I predict in this case that there should be no difference between transactions and dirt from the iif file and transactions you entered manually
When I am going to import petty cash transactions there is a error message " Missing required amount field" . How to correct this error?
You have to study theIIF file formats forthe tranaction type you are importing
Can you do this to import invoices and bills too? Or does this only allow you to do a journal entry?
worldwidequickbooks thank you!
You can do it for any transaction type but you need to know the "format" for that transaction type from the iif data that you study.
I think there is an issue in QB 2019 Desktop. If I format my input like yours then it throws out a whole string of errors. If I simplify it down to just the bare minimum and try to import the below I get the Error 3040:
!TRNS DATE TRNSTYPE ACCNT NAME AMOUNT
!SPL DATE TRNSTYPE ACCNT NAME AMOUNT
!ENDTRNS
; [ERROR] The record at (or starting at) this line could not be imported. There was an error when converting the amount "100.00" in the field "item amount". QuickBooks error message: This field contains an invalid character. [3040]
TRNS 07/16/2017 BILL Accounts Payable Bob 100
SPL 07/16/2017 BILL Accounts Receivable Bob1 100
ENDTRNS
Thank you Mark
i am so sorry that I cannot help you
This video is a general example.
You should call QB support to get links and reading materials if you want to really use them.
I reccomend the other import options.
-Mark
@@worldwidequickbooks So the answer is: IIF 2019 is broken (Officially). You can still import but you need to use the old method which is the link under the big blue IMPORT button. bigredconsulting.com/quickbooks-2019-iif-import/
I'm going to dive into your resources once I'm done with this mountain.
Thank you!
@@markberry2704 My pleasue,
I hope you will click "like" and sunscribe"
-Mark