import excel file into quickbooks desktop

#Import excel file into quickbooks desktop manual
#Import excel file into quickbooks desktop download
#Import excel file into quickbooks desktop windows

First - it's much slower, and the second is - if you have any mistakes, let's say, the Vendor name is incorrect, if the account name is incorrect, then all those entries will be rejected and a new IIF file, with a timestamp added, will be created for your IIF file. This new way of importing IIF files is a little different. If you get used to a regular way of importing the IIF files - this is the way to keep importing them. It is for how Quickbooks 2018, and earlier would import the IIF files. If you have Quickbooks 2018 or earlier it would just go to the import screen, but in 2019 there's two options 'Import IIF' or 'Import IIF for me.

In Quickbooks 2019 and later (2020, 2021), the IIF import was changed, so to import the IIF file you go to 'File - 'Utilities' - 'Import' - 'IIF files'. This is Quickbooks 2019 and it's the same as 2020, 2021, or any previous Quickbooks, as far as IIF files are imported. Then you switch to Notepad and press the 'Ctrl' - 'V'.Ĭlick 'File' - 'Save', and then you would say 'entries.iif' and save. When you open Notepad (File - New), then you would switch back to Excel, select this final result, click 'Copy' or 'Ctrl' - 'C'. Start Notepad, if you don't know where is Notepad, just open your start menu and start typing 'Notepad' and that's where you would see Notepad.

#Import excel file into quickbooks desktop windows

The easiest one would be using Text editor or Notepad, which is included in all Windows, starting from Windows 7, Windows 10, Windows 11. There are different approaches to convert. The final step is what would you do to get this into the IIF file. Then you can start copying this column as well to the IIF result. The credit lines should be minus and debit lines should be plus. Then you press 'Enter' and then you would multiply this column for all lines. How do you get those minuses and plusses in right place? What would you do? You would create the amount column in your template and then would enter the formula, as simple as this - which is debit minus credit. If you have debit and credit, in IIF it must be just the amount. The most difficult one would be the amount column. Then you go on the template, paste, you start multi-lines, same you do for the second one, same you do for the dates, for account number, account names, classes, names. Then, you will need to insert those TRNS lines at the end of each entry. So, in this case, you would have six lines. How you would start working on this? First, you would create as many lines, as you need. You can fill it, as fast, as you work in Excel, you can copy this column, TRNS type usually should be General Journal, you can copy the Date, it should be month/day/year format, and then account.

Then for the second entry, I have the first line always TRNS and then I have three split lines and again ENDTRNS line. As you see, I filled the first entry TRNS line and then split line, and then ENDTRNS. The header first three lines you don't change, but each transaction or each General Journal Entry has the first line, as TRNS and then you have one or more split lines and then you have to have ENDTRNS line.įor this file, as here, the final result would look like this. What is the IIF template? It is an Excel file, formatted as an IIF file: it should have a header and different rows.

#Import excel file into quickbooks desktop download

This file, which you can download and try yourself, has the IIF template. We have some Memo, we have some Name for one of the lines and we have optional class and subclass available as well. This entry has one credit line, one debit line and another entry has two debit lines two credit lines. We have the Account Name, we have some subaccounts, and we have regular debit and credit lines. They are for the same date but could be for a different date. So, let's take a look at our file, which has two General Journal Entries, and they are separated by entry number.

#Import excel file into quickbooks desktop manual

There is also an easier and faster way to create an IIF from your CSV file using a ProperSoft tool - General Journal Entries and will be shown in comparison to the manual approach.Īll documents, shown in this video are available to download, see spreadsheet at IIF files are a great help when you need to import many transactions without manually typing in Quickbooks. You may have a bunch of General Journal Entries as CSV or Excel file created quickly in Excel, or exported from your production system, but Quickbooks will not import it.