How can I avoid errors in reconciliation with recurring transfers from checking to savings? April worked, May didn't. Same recurring $100 transfer both months. Help?

Hello, @tim-root. 

Congrats on making your first post in the Community. To properly assist you with this issue, can you provide me with screenshots of the transfers. I want to ensure that I give you the most accurate answer to resolve this problem. 

In the meantime, you can look into these links that may be able to help you out. 

• Learn the Reconcile workflow
• Fixing issues when you're reconciling

I'm always here to help you get back to business. I'll be on standby. 

Hello there, @tim-root.

The expense $100 was manually recorded which causes duplicates and incorrect balance in both banks. You'll want to delete the transaction is already matched in both bank and existed.

Here's how:

1. Go to Banking.
2.  Select the For Review tab.
3. Check the boxes of the duplicate transactions.
4. Click on Batch actions and click Exclude Selected.

All of these duplicates will be transferred to the Excluded tab. If you wish to delete them, go to that tab and check the boxes of the transactions. Then, select Batch actions and then Delete.

For additional insights, you may check out these articles:

• Bank transactions are duplicates, missing or wrong or bank balance not updating
• Exclude duplicates or personal expenses from downloaded bank transactions.

Drop me a comment below if you have any other questions. I'll get back to you as soon as I can.

"The expense $100 was manually recorded"

It had to be entered by the bank feed because I'm the only user and I haven't manually added ANY entries.  I know, I know, I know it looks like I'm a complete moron.  Like I added this one line item for no reason.  But I didn't.  But here's the thing . . . you can see the same thing happened in April but the QBO reconciliation process didn't have an issue with it.  Have you ever heard of anything like this?

Hi, tim-root.

Let me help you sort things out. What happened here, as you can see on the screenshot, it's an Expense, but the amount is under "Deposit" this means that from the other Bank account "Business Checking" you created an expense. The account detail from that expense is this Bank from the register you showed.

You created expenses from the other Bank. While you created a Bank Transfer from this Bank Register. Also, there are transactions in April that were not reconciled (reconciled transactions are with letter R).

To reconcile your account properly, I'd suggest consulting an accountant. Your accountant can provide more expert ways of dealing with this situation.

Additionally, these write-ups give some helpful pointers on the reconciliation process:

• Reconcile an account in QuickBooks Online.
• Fix issues when you're reconciling accounts in QuickBooks Online

Please let me know if you have any other reconciliation questions, or if there's anything else I can do for you. I'll be standing by for your response. Have a great day.

Greetings RoseMarjorie,

First, I want to thank you sincerely for your response.  I really do appreciate it.

Here's the thing . . . no human being, not me, nor any other created any of those transactions.  They all came from my bank through the automated feed.  I know, I know, I know, it feels like or it looks like I went in there and manually created these entries, but I absolutely 1000% did not.  I've tried to look at the audit trail but what I have is very limited.  Anyway, something happened with my feed at the start of 2019, because now that I look into it further I see one Expense transaction for each month that was not reconciled.  The pattern started 2/1/2019 and has continued.  I believe the months Jan - April reconciled because I didn't notice that QBO excluded those Expense line items.  I sincerely believe the Transfer transaction created them automatically, because I did not.  

Again, I appreciate your input.  What a mess.  And this is just the freaking savings with 2 transactions most months.  Checking and the rest will be horrific if this has perpetuated across all of my accounts.  

TR