Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowLet'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:
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.