Manually processing high volumes of financial information in QuickBooks can be time-consuming and lead to mistakes in accounting. Businesses migrating from other accounting software or working with a bulk of transactions often require a faster way to input data accurately. Without an import process in place, users can encounter issues like inaccurate account balances, duplicate transactions, transactions that are deleted, or error messages such as;
“Please balance your debits and credits” or “Could not create journal entry”
“No debits and credits in the same row/line”
“Invalid line account”
“Invalid IIF file- delimiter not found”
The QuickBooks General Ledger Import enables businesses and accountants to import important financial information such as accounts, journal entries, debits and credits, and period information. In this guide, we will cover what General Ledger Import in QuickBooks is, requirements before importing ledger data, how to import general ledger into QuickBooks Desktop and Online, and more.
Table of Contents
ToggleGeneral Ledger Import in QuickBooks refers to the process of importing financial data from a third-party source into QuickBooks using a supported file format and import utility. A general ledger is an entire record of the financial activities of a business, including account balances, journal entries, income, expenses, debits, credits, and transactions.
The QuickBooks General Ledger Import procedure allows businesses to transfer their previous financial information when switching to QuickBooks or to backdate transactions, or even to simply batch upload accounting data quickly. IIF files are used by QuickBooks Desktop users, and QuickBooks Online users may use a supported CSV import or a third-party tool for certain data imports.
QuickBooks’ General Ledger Import is employed by businesses and accountants to ensure the integrity of financial information, to help with financial reporting, and to bulk load or migrate financial data. Key reasons to import General Ledger (GL) data into QuickBooks are as follows.
Speeds up data migration
Improves accuracy
Preserves financial history
Simplifies collaboration
Enhances reporting
Users must prepare an import file, verify account mapping, back up their company file, and ensure all financial entries imported into QuickBooks adhere to import rules before importing general ledger data into QuickBooks. Here are the things to do before you import General Ledger data into QuickBooks.
| Parameters | Details |
| File Format | Save the general ledger file in a supported format such as CSV (.csv) or Excel (.xls, .xlsx) before importing data into QuickBooks. |
| Required Columns | Include essential fields such as Date, Account Name, Description, Debit, and Credit to ensure QuickBooks can process the imported records correctly. |
| Date Format | Use a consistent date format, such as MM/DD/YYYY or DD/MM/YYYY, throughout the import file to avoid transaction date errors. |
| Amount Fields | Enter only numerical values in the Debit and Credit columns. Keep zero-value or unused fields blank instead of adding symbols or text. |
| Chart of Accounts Matching | Ensure account names in the import file exactly match the existing QuickBooks Chart of Accounts to avoid mapping issues. |
| Missing Accounts | Create any required accounts in QuickBooks before starting the QuickBooks GL import process. |
| Sub-Account Structure | Format sub-accounts correctly using the required hierarchy format, such as Utilities: Gas, if your QuickBooks file uses account levels. |
| Data Accuracy Review | Check the import file for missing details, duplicate records, and incorrect entries before uploading financial data. |
| Debit and Credit Balance | Confirm that total debit amounts match total credit amounts to maintain balanced journal entries. |
| Company File Backup | Create a complete backup of your QuickBooks company file to protect existing financial data during the import process. |
| File Size Management | Split large general ledger files into smaller batches, such as monthly or quarterly records, if the import file exceeds system limits. |
| Test Import | Perform a sample import with a small set of transactions to verify file formatting and account mapping before importing complete data. |
Users can import financial data into QuickBooks through the QuickBooks Desktop General Ledger Import by exporting files from other software programs or databases to make files formatted for import into QuickBooks, importing accounting data files to QuickBooks, and reviewing transactions once imported. To import the General Ledger to QuickBooks Desktop, do the following.
The QuickBooks IIF Import allows importing of supported accounting data from another company file or from an external system capable of exporting IIF files to QuickBooks Desktop.
Once the QuickBooks GL Import is complete, verify that the records were imported correctly from QuickBooks. Check the following:
If you don’t need to import an entire general ledger, but just bulk journal entries, some editions of QuickBooks Desktop do allow Excel imports.
After QuickBooks Journal entry import, make sure each transaction appears in the correct account.
Review:
To import general ledger data into QuickBooks Online, you can create supported files, use the import tools to import the Chart of Accounts or journal entries, and review financial reports to verify that the data is accurate. The accurate method to import QuickBooks Online General Ledger is as follows.
If you want to import data into QuickBooks Online, the data needs to be in the correct type of CSV or Excel file. Ensure that your Chart of Accounts file is filled with the right data for the accounts to allow QuickBooks Online to properly map and create records.
Include these fields:
Before uploading the file:
QuickBooks Online has an import feature for importable data types, including the Chart of Accounts. Follow these steps to access the import tool in QuickBooks Online.
The mapping of the fields ensures that the data to be imported from the spreadsheet files will be placed in the correct fields in the QuickBooks Online accounts. Check the following mappings:
Before finalizing the import, verify that your account information is accurate and complete.
Check:
After reviewing the details, select Import to create the accounts in QuickBooks Online.
Once the import process is completed you can check your QuickBooks Online account to ensure the accounts have been imported properly.
Verify:
To import CSV journal entries into QuickBooks, the CSV file needs to be prepared in the correct format, all accounting fields properly mapped, and it is always important to double-check that the uploaded transactions are in balance. Importing journal entries into QuickBooks makes it easy for the company to get a large majority of financial data into QuickBooks.
Import Journal Entries into QuickBooks Desktop Using CSV Conversion
Ensure that you prepare a properly structured CSV file containing all the details of the journal entries before embarking on the QuickBooks CSV import. Please include the following information:
Before converting or importing the file:
As QuickBooks Desktop cannot import journal entries from CSV files, you will need to convert the journal entry CSV file in any format importable or use an import tool to perform the import.
Follow these steps:
Once the QuickBooks Desktop journal entry import is completed, verify the accuracy of the imported transactions.
Check the following:
Verify that:
Create a CSV file containing accurate journal entry information.
Include:
Before uploading:
Follow these steps:
After completing the QuickBooks Online journal entry import, review the imported records to ensure accurate posting.
Check:
Confirm that:
There are several reasons for QuickBooks General Ledger Import errors, including bad formatting, unassigned accounts, and not being balanced. Using effective troubleshooting skills can help find the reason for the import failing, prevent your financials from being wrong, and allow you to complete the QuickBooks GL Import successfully.
| Problem | Solution |
| Unsupported file format or incorrect file structure | Use a QuickBooks-supported format such as CSV, Excel, or IIF based on your version and import method. Ensure the file follows the required structure. |
| Incorrect column mapping or missing required fields | Match file headers with QuickBooks fields and verify that required details such as account names, dates, debit, and credit amounts are included. |
| Invalid date or amount formatting | Use a consistent date format and remove currency symbols, special characters, or extra spaces from numerical fields. |
| Unbalanced journal entries | Confirm that total debit amounts equal total credit amounts before importing the general ledger data. |
| Missing or mismatched accounts | Ensure account names in the import file match the QuickBooks Chart of Accounts and create missing accounts before importing. |
| Duplicate transactions after import | Review the source file for repeated entries and remove duplicates before uploading the data again. |
| Corrupted import file or company data issues | Check the source file for damaged records and use QuickBooks data utilities to identify company file issues. |
| Large file import failure | Divide large general ledger files into smaller batches and import data in manageable sections. |
| QuickBooks Desktop IIF import errors | Validate the IIF file format, correct unsupported fields, and review import error reports before retrying. |
| QuickBooks Online import limitations | Use supported import options for available data types or compatible third-party tools for transferring journal entries and transactions. |
| QuickBooks version compatibility issues | Update QuickBooks to the latest release and confirm that your import method supports your current version. |
Once you have imported the general ledger into QuickBooks, you will reconcile all transactions, accounts, and financial statements to confirm that there are no discrepancies between the imported data and your original data. Reviewing the QuickBooks General Ledger Import is done to find discrepancies, confirm the accuracy of financial data, and ensure reliable financial reporting.
To begin with, check the reports on QuickBooks to ensure that the data imported matches the original records.
Check the imported transactions that were categorized to the proper accounts by QuickBooks.
Check a sample of imported transactions, especially high-value entries, to confirm that QuickBooks recorded them correctly.
Verify:
QuickBooks provides tracking features that help you review recent changes made during the import process.
Use:
Compare the imported general ledger data with your original file to ensure all records transferred correctly. Check for:
Finally, after you have finished the import process, but before making any reports from the import data, do one final check of your QuickBooks file. You can check that:
If you follow these best practices, you can avoid import failures and keep your financial records intact, and have an easy and successful General Ledger Import into QuickBooks Desktop and Online.
Save your import file in the format supported by your QuickBooks version, such as CSV, Excel, or IIF.
Verify that each spreadsheet column is mapped to the correct QuickBooks field to prevent incorrect account assignments.
Upload a small batch of transactions first to confirm that the file structure and mapping work as expected.
Back up your QuickBooks Desktop company file or export key financial reports from QuickBooks Online before making bulk changes.
You can import general ledger entries into QuickBooks by importing IIF files, using QuickBooks Desktop import utilities, importing the Chart of Accounts and other compatible accounting data in QuickBooks Online, or using third-party tools that are reputable to import mass journal entries and general ledger transactions. The method used to import a General Ledger into QuickBooks varies depending on your version of QuickBooks, the type of financial data you wish to import, and what source file format you are using.
You can import General Ledger data into QuickBooks, but the process will differ based on whether you use QuickBooks Desktop or QuickBooks Online.
The most common file type to import accounting data into QuickBooks is CSV, as it is compatible with most import tools.
No, QuickBooks does not have an Undo function available for all types of General Ledger imports.
No, General Ledger importation usually adds new data instead of replacing it
Generally, imports of General Ledger files take a few minutes, but this can vary according to the size of the file and the number of transactions, as well as system performance.
Report your Issue
Latest QuickBooks Topic
Accounting Issue and Problem
Search by Categories