Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI am having problems with a banking rule. I have a rule setup to record deposits to an AR account. QBO is duplicating these transactions by recording them to the AR account, but also booking them to unapplied sales income. Hence doubling my income.
I am in the restaurant industry, so we receive daily deposits from our merchant service provider (MSP). I am currently booking a JE to post my sales ie. CR Sales DR AR. My banking rule should DR Checking Acct and CR AR. By recording transactions this way, it allows me to reconcile my AR to ensure we receive all funds from our MSP.
Why, is QBO re-classing these transactions, and what I am missing in this process? Any suggestions would be greatly appreciated. At this point, I’m not a big fan of QBO for my accounting system.
I have some solutions on how to resolve this duplicates issue, jarrowood.
QuickBooks is dependent on what your financial institution shares with us. Manually updating the bank account and turning on the Auto-add feature can cause duplicates. To fix this, let's turn off the feature, then exclude the duplicates.
Here's how to turn off the feature:
Once done, I'd suggest following these steps to exclude the transactions.
For further guidance, please see this article: Exclude Bank Transactions.
You can also refer to this article to learn more about handling online banking transactions: Categorize and Match Online Bank Transactions.
After resolving the duplicates, you can do your usual reconciliation. This helps make sure your books are correct.
Feel at ease to click the Reply button if you have more banking concerns. I'm always here to help you out.
Hi jarrowood,
Hope you’re doing great. I wanted to see how everything is going about fixing your duplicate bank transactions. Was it successful? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.
Looking forward to your reply. Have a pleasant day ahead!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.