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:
Click the Gear icon and choose Chart of Accounts.
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.
Click the Add drop-drown below DATE and choose Deposit.
Enter the details and select the Opening Balance Equity account in the Account field.
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.