Convert from Online to Sage 50

I have 1 1/2 years of accounting data on Sage Online.

I want to convert to Sage 50.

I've spoke to an adviser and went through the steps to download the transactions.

Since there is a full year plus the current year it won't allow the current year transactions to upload.

But even with that the balance sheet and income statement aren't even close to balancing.

Looking at the journal entries, it is missing a ton.  one revenue account is our by $60K.

Does anyone have any help, have they done this before?