cancel
Showing results for 
Search instead for 
Did you mean: 
Experienced Member

How can I import the general ledger in excel format to Quickbooks?

Hi, 

 

Until yesterday I was using an old version of QB Desktop (2013 i believe). 

However, laptop crashed, and Harddisk is gone.

 

What I have left is the General Ledger Excel export (per account). 

 

How can I import this? 

The import options (including Import Accounts) do not seem to recognize the data in the file?

Error message:

The following error has occurred:
File doesn’t contain any data.
 
Needless to say, the data is in that file

Ideally I import all transactions, but at the very least the balances per item! 

 

Thanks,

Rob

1 Comment
Highlighted
QuickBooks Team

Re: How can I import the general ledger in excel format to Quickbooks?

Let's get your balances entered in QuickBooks, Rob.

 

By the way, you tag your question as QuickBooks Online, so we'll do the steps for this version.

 

We're unable to import a general ledger data, but you can manually enter them instead.

 

For Bank accounts and other balance sheet accounts:

  1. Click the Gear icon and choose Chart of Accounts.
  2. Find your bank account and click on View Register. If you don't have one yet, you can click on New to add a bank account first.
  3. Click the Add drop-drown below DATE and choose Deposit.
  4. Enter the details and select the Opening Balance Equity account in the Account field.
  5. Enter a memo in reference to this transaction.

For the Income and Expense accounts, we're unable to enter opening balances since they are based on transactions like checks, bills or invoices. You can seek help from an accountant to know the best approach to enter the values.

 

For the Accounts Payable (A/P) and Accounts Receivable (A/R) accounts, these are from your vendor and customers balances. You can do a lump sum invoice and bill for each customer to get the values. However, since you only have a the ledger data, I would suggest to refer this to an accountant as well.

 

About your accounts, try saving your Excel file in a CSV format, then import it back. 

 

Please go back to this thread if you have questions.