Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI appreciate your input from every angle, bpetryak.
You're right about creating a credit card credit transaction and just excluding the transaction from the bank feed. Since the option to match a credit card credit to a banking transaction isn't an option. The transactions that you can match under the RECEIVED column on the Bank transactions page are the following:
The transactions that you can match under the SPENT column are as follows:
To better guide you in managing your downloaded bank transactions, I recommend checking these articles:
To ensure hassle-free reconciliation of your account in the future, you may refer to our article on the best practices for the reconciliation workflow in QuickBooks. It also guides how to overcome challenges during the reconciliation process.
If I can be of further assistance in managing your credit card credit or bank transactions, I'm just a post away. The Community Team is on the lookout for your response on this thread.
I don't believe qbo agents do not know how to work with bank feeds. What they do not understand is when you are working with bank feeds, you are not going to "New" and creating anything. You are working from the checking account feed or the credit card account feed. When you have a charge come in on your credit card feed, it comes in as a positive amount. When you categorize and save, it saves automatically as an expense. You do not have to create anything. QBO does it for you. When you return a product to a vendor it shows up in your credit card account feed for review as a negative number. At this point again, you do not create anything "New". This is suppose to be automated so that it streamlines the process. Im assuming that this is something fairly new for QBO because I haven't corresponded with anyone in customer service that isn't doing it old school and are not familiar how bank feeds work. To make it simple, I simply categorize the credit that comes in as a negative number as the same category I categorized for the initial positive transaction. This way my project reports and expenses numbers are correct. For example... I purchased something from Home Depot for a job (project). The credit card feed from Home Depot showed up for review as $100.00. I categorized this transaction from the review screen as Cost of Goods:Supplies and Materials, assign it to the project and click record. QBO automatically creates that expense for me. Three weeks later, we did not need all the material we purchased for the Job (project) so I returned $50.00 worth of products. The next day that return transaction from Home Depot is in my credit card bank feed as a negative number because it was a credit. I categorize it as Cost of Good:Supplies and Materials, choose the project and click record. QBO records it as a negative expense. But that is ok because it will total out correctly in the end because when it was all said and done I only spent $50 out of that $100 that was originally charged. So when I pull up the project report it shows me that I only spent $50 on Cost of Goods:Supplies and Materials. And if I look at my total expenses, that credit has been taken out of the total expense category as well. This may not be the old school accounting way to do things, but it is easy and provides that same number in the end. The only issue that I have encountered by doing it this way is when I match receipts. When I upload the refund receipt, QBO will not recognize it as a negative number so it will not match without me opening the receipt and changing the number to a negative. Then it will match and the receipt is attached to that refund transaction. Hope this helps anyone who is working in QBO through bank feeds. The wonderful thing is when you strictly using bank feeds you don't have to deal with miss types or entries. Plus when you reconcile bank statements, it is rare that they don't reconcile first time!
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.
For more information visit our Security Center or to report suspicious websites you can contact us here