We've got some troubleshooting steps we can perform to resolve the unexpected entries in Accounts Receivable (A/R) that should not exist in QuickBooks Online (QBO), Rachel-Ohalek.
When moving from QuickBooks Desktop to QBO, particularly while using a cash basis accounting approach, you might encounter unforeseen entries in Accounts Receivable (A/R) that shouldn't be imported into the program. To fix this, we can create a reversing journal entry for A/R. Here's the process to set up a journal entry for Accounts Receivable:"
- Click the + New Plus icon.
- Under Other, select Journal Entry.
- Enter the Journal date. The Journal date is the date of the end of the period.
- On the first line, choose the account affected by the invoice from the dropdown list in the Account column.
- In the Debit column, enter the amount.
- Enter the reason for this journal entry in the Description field.
- In the second line, select Accounts Receivable (A/R) from the Accounts dropdown list. The amount is automatically entered in the Credits column. If splitting this over several customer accounts, change the amount to reflect a single customer's sales tax.
- Choose the customer from the dropdown list in the Name field.
- Press Save and close.
Once the accounts receivable journal entry is created, we can reverse it by following the steps below:
- Click the Search icon in the toolbar.
- Locate the journal entry you created and select it to open it.
- Tap Reverse.
- Change the Journal date to one day after the original journal entry's Journal date.
- Press Save and close.
We should also verify whether there are any unapplied payments. Unapplied bill payments not linked to bills, or received payment entries not associated with invoices, can adversely impact accounts receivable. You can resolve this issue by accessing the payments from the Customer or Vendor registers and appropriately applying them. For the steps and details, you can check out this article: Resolve accounts receivable or accounts payable balances on a cash basis balance sheet in QuickBooks.... Then, go to the Unapplied payments section.
Moreover, you can refer to this article about how your features and data move from Desktop to QBO: Learn how features and data move from QuickBooks Desktop to QuickBooks Online.
The QuickBooks Community team is committed to supporting your business success. If you have further questions about managing your Account Receivable or any QuickBooks-related concerns, revisit this thread. We're always here to assist you in achieving your financial goals, Rachel-Ohalek.