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?
Ideally I import all transactions, but at the very least the balances per item!
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:
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.