Clients can undoubtedly import General Ledger Accounts (GL) into QuickBooks text files or Excel bookkeeping pages straightforwardly. Simply by using the steps discussed below; Users can properly import information from their General Ledger accounts. Before you proceed to the import step, there are a couple of things expected to consider that might help you in importing the General Ledger Accounts.

Before importing the General ledger accounts, you must consider the points.

Keep the following information in mind:

1. Make a Backup of your QuickBooks company file

It is strongly suggested you first create a backup of your company to utilize to check or as a test before updating the current record. It might step through a few examinations to get your GL planning precisely how you wish.

At the point when you have prevailed with regards to bringing into the backup file, rehash the arrangement steps you needed to take on your backup file on your creation file. You can save from eliminating somewhat imported files from your creation system utilizing the backup file.

2. Set Up Your QuickBooks Guidelines

QuickBooks authorizes the client to show a client’s name every time they log in to the AR account. QuickBooks allows users to indicate the name of the seller each time they access the Accounts Payable to Sales Tax. This will be the general record of sellers in the QuickBooks to which we will add all the sales tax numbers.

3. Map Your GL Accounts

Before you can import your account details into QuickBooks, you will want to map it correctly. It is necessary to check your mapping every time you add or change an account or use new changes, employee comp codes, or other things that could affect your GL.

How to Import General Ledger into Quickbooks Online, Pro, Enterprise or Desktop

general ledger import into QuickBooks different versions, You need to follow mentioned below steps:

Total Time: 10 minutes

  1. Step One

    Click on the Gear button. This you can find on the top right panel of QuickBooks

  2. Step Two

    Now click on the Import data button.

  3. Step Three

    Click on the Accounts tab and upload your excel sheet in QuickBooks.

Alternate Steps to Import General Ledger into the QuickBooks Desktop

See another step to easily import your General Ledger accounts into QuickBooks.

Step 1: Introduce your account number

You will have to initially type your account numbers into the system to appropriately import your day-by-day or month-to-month general ledger for use in your accounting program.

  • At first, sign in into your system
  • Then, attempt to get to the setup menu
  • Presently, go to the tab named (Store Settings) and afterward click on the message tab
  • In the lower window, you can see Account Name.
  • Under the equivalent, you will see a list of all accounts.
  • Also, this account store is right presently for clients.
  • Just enter the Account Number in the appropriate fields with the comparing list of your Chart of Accounts.
  • Finally, utilize the (Save Store) button to save the progressions made.

Step 2: Create The General Ledger Files

You can import on a day-by-day or month-to-month foundation of your standard ledger into QuickBooks. General Ledger is automatically created whenever Holiday Saved starts from the store.

If you want to create a monthly GL, you will see a button labeled “Create GL <month>” at the bottom of the screen, with previous months listed. You can manually change the date of the end-of-day screen to upload the general ledger of the previous month.

Step 3: Importing

All the steps are taking part of the import of the General Ledger file into QuickBooks:First, open the company file.

  • Next, go to the File menu which, you can see on the top menu bar
  • Using the drop-down menu, you need to select Utilities >> Import >> IIF Files
  • Finally, you will have to ask to choose the IIF file you want to import.

Last Word!

In QuickBooks, you can import exchanges and records in various sorts of file designs including CSV and MS Excel. General Journal Entries, Chart of Accounts, Vendor Types, Items, and more can be imported into your QuickBooks account. In the above data, we have shared how to import a general ledger into QuickBooks Desktop. Ideally, you have your question settled.

Need Professional Help?

If you still are facing issues with the program then you would need to get help from quickbooks customer care staff. To talk to them you can dial Chat now.


Get Experts Advice to Fix Your All Accounting & Bookkeeping Problems


  1. How can I import General Ledger into QuickBooks quickly?

    To import the General ledger file into QuickBooks, first of all, open your company file. Then, you have to choose the file menu. From the drop-menu options, open the utilities followed by import and then leads to the IIF files. Move forward with on-screen instruction until the program is not finished.

  2. What are the essentials parts that users need to import the General ledger into QuickBooks?

    In general ledgers, they contain the four essentials that users usually need to import that are financial transactions, accounting periods, chart of accounts, and account balances to find better results.

  3. How would I add a new ledger account to import a general ledger into QuickBooks?

    Open your QuickBooks and then find the accounting tab and the chart of the Account section. Hit the next click on the new button and then choose the Account Type, detail Type, and then enter a beginning balance if you find one only. Once it’s finished then hit the Save and Close button to save to all new changes.

Related Topics

Further Reading