Thank you for bringing this to our attention, Wildcat7.
I acknowledge your struggles when condensing the data and migrating your desktop file to QuickBooks Online (QBO). I'm here to help you explore solutions that can work for you.
Some transactions may not transfer when you move your desktop company file to QuickBooks Online (QBO). That's why certain information didn't appear in your online company. These are some of the examples:
- Inactive customers will stay inactive unless there are no unbilled charges.
- Estimates utilized for progress billing won't sync with the invoices made in QuickBooks Desktop (QBDT).
- Progress invoices (invoices based on estimates) and their extra fields won't come over to the online platform.
- Attachments
Moreover, look at this resource to discover how features and data are transferred from the desktop program to the online platform: What does and doesn’t move to QuickBooks Online?
You may want to export your desktop entries to QBO again to tackle your concern. This will overwrite all current data in your online company with new data, so you'll no longer have to go through each transaction. Please note the task can be carried out only if your subscription is within 60 days.
In the event the subscription is beyond 60 days, you can manually receive the payments (entries with past due status) or consult an accountant for further guidance. They can offer suggestions on the best way to manage the unapplied payments, as well as any differences in progress billing for sales entries.
If you'll have to manually record the payments, perform the process one at a time for each customer. Simply follow these steps:
- In your company, head to the Plus icon in the upper left and choose Receive payments under Customers.
- Tap the Customer drop-down and select the name from the list.
- Click the Payment method drop-down, and pick which method you wish to use (credit card, debit, PayPal, Venmo, or ACH bank transfer).
- From the Deposit to dropdown, choose the account you put the payment to.
- In the Outstanding Transactions section, tick the box for the invoice you're working on.
- Enter the Reference no. and Memo if needed.
- Press the Save and close or Save and new button.
Check out this article to learn how to track a partial payment and combine multiple payments into one deposit: Record invoice payments in QuickBooks Online.
Also, attachments didn't come through after the conversion because they weren't included in the QuickBooks company file. You'll have to manually attach the documents in QBO.
When condensing data in QBDT, you have the option to Keep all transactions, but remove audit trail info to date or Remove the transactions you select from your company file. Selecting the latter may have resulted in the deletion of deposits.
Check out this article to gain more insights into the Condense Data Utility: Condense your QuickBooks Desktop file for import to QuickBooks Online. From there, you'll learn how it affects your entries and reports.
I've gathered various resources that include online tutorials and topics to easily navigate through the program. Click each one for complete information:
If you're still facing any hurdles while migrating to QBO or have any other concerns or questions about our products, keep me posted in the comment section below. I'll be here to provide the best help I can, Wildcat7.
