Skip to main content
J
julia48
April 15, 2025
Question

Exporting data from Desktop to QBOnline issues

  • April 15, 2025
  • 1 reply
  • 0 views

We exported our data from Desktop to Online in April last year. We had a few teething problems but undertook the recommended 'house-keeping' but we still had differences in the P&L. We had exported 13 years of data so finding the differences was going to be very difficult. We also learnt that QBO does not like journals so a lot of the difference was probably general journals.

We are a small company and were two staff short so I decided to leave the P&L differences until the summer when we are less busy. However, in the meantime, we had year end so I prepared the accounts for our accountant in QBDesktop as I knew that this data was correct.

I continued to keep QBO up to date.

My accountants suggested that we should input opening balances for 31/10/23 and then un-reconcile all of the November and December bank rec items. So we would be back at year end and we could then move forward reconciling each month to the current month.

 

I would really appreciate some help - do you think the above is the best way forward? Many thanks, Julia

1 reply

L
LollyNino_C
April 15, 2025

Hi, Julia. I understand you have concerns about transferring your profit and loss report and the reconciliation process from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO). I'm here to provide detailed clarification to help you better understand these aspects.

 

Firstly, could you confirm which accounting method you're using (cash or accrual)? Typically, using the accrual basis in QBDT can facilitate a smoother transition to QBO.

 

In QBDT, you can switch between cash and accrual accounting methods. If you're using the Accrual basis in QBDT, maintaining this setting in QBO can help ensure consistency in your financial reports, such as the Profit and Loss. It's crucial to ensure the accounting basis matches between both platforms for accuracy.

 

Concerning reconciled transactions, those marked with an 'R' in the QBDT account register should seamlessly transition to QBO. However, post-migration, it's important to confirm that these statuses remain unchanged. The reconciliation process in QBO mirrors that of QBDT, ensuring familiarity.

 

Additionally, it's beneficial to review the limitations and the recommended order of import stated in this article: Enter customer opening balances in QuickBooks Online.

 

For further reading on the migration process, here’s an article you might find helpful: Why can’t I move my data from QuickBooks Desktop to QuickBooks Online?

 

If you have further questions or need additional assistance with data migration, feel free to reach out. I'm here to ensure your transition to QBO is both smooth and accurate.

Terms & ConditionsAccessibility statement