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 nowLet me share some information about how you can separate transactions, Jennifer529.
Based on the research, Authorize.net is a payment gateway service provider that allows merchants to accept credit card and electronic check payments through their website and over an Internet Protocol connection. Since QuickBooks Online (QBO) is only the receiver of those transactions, you'll want to contact the Authorize.net support team so they can help you separate the two transactions from QBO.
In addition, if you're only using QBO without any integration. QuickBooks automatically downloads the latest transactions and tries to add and match them with those you've already entered into your account. Learn how it downloads and categorizes the transactions. For more information on how it works, I've got this article for your guide: Categorize And Match Online Bank Transactions In QuickBooks Online.
Any questions about the bank feed? Write a reply below so we can get back to you as soon as possible.
Hello. I apologize. I processed the refund in Auth.net. A sale(deposit) and the refund(withdrawal) in my bank account, came in as a batch through my merchant services. QB bank feed shows the two added together. I just want to split the two up and categorize it properly.
For customer A ( sale ) I already received payment. For customer B ( refund ) I only created a refund in Auth.net. I did not reference a refund in QB yet.
Thank you for providing more details about your issue, I have another way how you can split the transaction, Jennifer529.
Once a downloaded transaction is either accepted or excluded, QuickBooks will stop the bank from bringing the transaction into the bank feed again. You can exclude the downloaded transactions instead. To do that, follow the steps below:
The transaction moves to the Excluded tab of the Banking page. Then, manually record the refund in QuickBooks Online (QBO). Here's how:
At the same time, since the transaction in the bank is already cleared, you can manually clear the status of the payments and refunds by clicking repeatedly the Check column until the letter C appears which means Cleared. Attached is a screenshot for your visual guide:
Furthermore, after you've categorized the transactions, you may also have to review your accounts in QuickBooks to make sure they match your bank and credit card statements. For more information, go through this article for more details: Reconcile An Account In QuickBooks Online.
Feel free to let me know if you have any questions about categorizing the transactions I'm always right here to help.
I apologize for not understanding. The bank feed shows $-75.52 that was taken out of my bank account.
This is a batch of two transactions from my merchant services. One is a sale for $31.88 from Customer A and one is a refund for $107.40 from Customer B. a difference of $75.52. QB can't match it.
My bank account is okay I just want to make sure I record this correctly in QB so when I get ready to reconcile everything will balance.
How can I see the sale for $31.88 and the refund $107.40 separately in the bank feed? I did not know it was going to be batched together.
One more detail I forgot to mention. The refund was a return of a product that is in inventory. I need to put that product back into inventory.
Thanks for adding more details to your concern, @Jennifer529.
In QuickBooks, you can split the transactions in the banking feed to separate two or more transactions and assign to a single payee.
In your case, where a single transaction involves two customers, you'll want to follow the steps shared by my peer to exclude the transactions from the list so it will not be added to your books. Then, record these two different transactions manually instead.
To record a deposit, here's how:
The transaction is now directly to your register. Next, enter a refund directly from your register. You can follow the steps shared by my peer.
Here's how:
To put the product back to the inventory, you can follow the steps to create a return and refund in QuickBooks Commerce.
For future reference, check out this link to learn more about matching your QuickBooks transactions with your actual bank statement: Reconcile an account in QuickBooks Online.
Know that I'm always here to guide you should you need more assistance in splitting and categorizing your transactions. Take care!
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