![]() ![]() What is the IIF template? It is an Excel file, formatted as an IIF file: it should have a header and different rows. 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. There is also an easier and faster way to create an IIF from your CSV file using the ProperConvert tool (General Journal Entries mode) and will be shown in comparison to the manual approach (the last three screenshots at the bottom).Īll documents, shown in this video are available to download, see the 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. This video shows how to create a Journal Entry or a multiple Journal Entries IIF file in Excel and Notepad without any other software. Import General Journal Entries from CSV/Excel into Quickbooks Desktop ![]()
0 Comments
Leave a Reply. |