The Principal Book of your accounting system, also known as General Ledger is a record that contains individual accounts that showcase your transactions related to accounts. It is basically a group of accounts that gives your details for your transaction in respect of each of your accounts. Hence, General Ledger lets you know the result of all your transactions taking place in account in sequential order by date. For a complete tally, you may need to import general ledger into QuickBooks Desktop from Excel which is quite possible. If you are willing to know how to import general ledger into QuickBooks Desktop or QuickBooks Online using Excel, we will enlighten you.
How to Import General Ledger into QuickBooks Online & Desktop?
QuickBooks allows you to import several types of lists and transactions into your account. Moreover, you can use different file formats to import the data such as IIF(Import IIF Files into QuickBooks), CSV, and MS Excel files. To import General Ledger, you can opt for two different methods. One method allows you to import your data through the Excel sheet within QuickBooks. Whereas the other method requires you to install the QB Import Excel and CSV toolkit. By doing so, you can import the data in CSV format.
In the following discussion, you will learn how to import general ledger into QuickBooks Desktop and QuickBooks Online in two different ways.
Method 1: Import General Ledger into QuickBooks Online & Desktop using Excel Sheet
To perform this method, you will just have to open QuickBooks and continue to import data by using the Excel sheet. Have a look at the following steps to learn how to import general ledger into QuickBooks Desktop or Online:
- Login to your “QuickBooks” account.
- Then, go to the “Gear icon“. It should be located on the top right.
- Here, you will see the “Import Data” button; click on it.
- After this, select the “Accounts” tab.
- Now, you can browse the excel sheet and upload it to QuickBooks.
As you upload the Excel sheet, General Ledger starts importing it into your account. Please note these steps can be followed for QuickBooks Online, QuickBooks Desktop, Pro, and Enterprise editions.
Method 2: Import General Ledger using QuickBooks Import Excel and CSV Toolkit
This method requires you to install the QB Import Excel and CSV toolkit. By doing so, you can import the list easily in CSV format. This should be noted that this procedure cannot be reversed. Also, it is suggested to create a backup of QuickBooks.
Continue following these steps to import general ledger into QuickBooks Desktop from Excel using QB Import Excel and CSV toolkit:
- Once you install “QB Import Excel and CSV toolkit” on your computer, save the file on the desktop.
- Then, open the file by clicking twice on the “QuickBooks_Import_Excel_and_CSV.exe”. This will launch the “WinZip Self-Extractor” screen.
- Press the “Browse” option.
- Now, select the folder where you prefer to install the toolkit and press the “OK” button.
- After that, click on the “Unzip” option. This will extract the contents.
- Select the “Close” button. This will close the “WinZip Self-Extractor” screen.
- Then, launch the “QuickBooks Import Excel and CSV” folder by going to the location you chose before.
This is how you can use QB Import Excel and CSV toolkit. As you unzip the file, you can extract all its content. This will allow you to import transactions and lists to QuickBooks Desktop.
To Wind Up
In QuickBooks, you can import transactions and lists in different types of file formats 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 information, we have shared how to import general ledger into QuickBooks Desktop and QuickBooks Online. Hopefully, you have got your query resolved.
Do you want to set up the QuickBooks deposits or find out what all checks have not been cleared, the following guides can be helpful for you:
- How to Make a Deposit in QuickBooks Online?
- How to Run an Uncleared Check Report in QuickBooks?