reconcilliation discrepancy

Let's review your transactions so that you can ensure your records are accurate, Sarah_HM.

Duplicate transactions can cause discrepancies when reconciling. To avoid this, you can review your transactions and look out for duplicates.

When you come across duplicate transactions in QuickBooks Online (QBO), you have two options to resolve them. You can either exclude them or delete them. If you choose to exclude a transaction, it won't show up again in the bank feeds. However, if you delete it, QBO will recognize it as missing and download it again. To avoid any reconciliation issues, I'd recommend that you exclude duplicates. Let me guide you on how to do this.

1. Go to Bookkeeping, then select Transactions.
2. In the Bank transactions tab, open the For review tab.
3. Tick the checkbox of the transactions you want to remove.
4. Click Exclude.

If you want to learn more about how to fix issues while reconciling, you can check out this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

In case you ever need to undo a reconciliation, you can follow this guide: Undo or remove transactions from reconciliations in QuickBooks Online.

I'm here to help you, Sarah_HM. If you need more assistance with reconciliation, feel free to click the Reply button.

What is the best way to determine if the issues are caused by duplicate transactions?

Let's figure out a way to determine the issues caused by duplicated transactions, @Sarah_HM. 

One way to determine issues caused by duplicated transactions is to review your Profit and Loss if income or expenses are inflated. 

Here's how: 

1. On the left panel, go to Reports.
2. Enter Profit & Loss in the search box.
3. Click the Customize button.
4. Under Rows/Columns, hit Change Columns.
5. Tick the check box for % of Income and % of Expense.
6. Click Run report.

On the other hand, we can do a quick reconciliation review to see if the balances match the statement. 

In addition, you may want to check this article to learn how to close your books and prevent changes to past transactions: Close your books in QuickBooks Online. 

I'm always available if you need more help managing your duplicate transactions and any QuickBooks-related queries. Keep safe. 

In viewing my reconciliation discrepancies report, I figured out the transactions that were entered twice and throwing off my reconciliation. How do I delete them?

I appreciate you for checking the discrepancies, @Sarah_HM.

To remove the duplicate transaction, open the Account register to find these transactions.

Here's how:

1. On the Left panel, click the Transaction menu.
2. Select Chart of Accounts.
3. Locate the account to where the transactions are, then click the View register.
4. You can utilize the Find field to search by amount, reference number, or memo.
5. Select Apply.
6. Tap the transaction, then click the Delete button.

On the other hand, I recommend reaching your accounting professional to guide you in checking and correcting your balances. If you don't have one, you can find a professional through this link: Find an accountant.

I'm adding this article to guide you further in reviewing and correcting your balances: Fix issues for accounts you've reconciled in the past.

Keep us posted if you have other questions about reconciliation. We'll do our best to fix it promptly. Take care.