Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
Jennifer529
Level 3

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

Authorize.net combined a sale and a refund in a batch.  How can I separate the two in QB?
8 Comments 8
MariaSoledadG
QuickBooks Team

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

Let 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. 

Jennifer529
Level 3

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

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.

Jennifer529
Level 3

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

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.  

MariaSoledadG
QuickBooks Team

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

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:

 

  1. Go to Bookkeeping, select Transactions, then select Banking (Take me there).
  2. Select the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Select Exclude.

 

The transaction moves to the Excluded tab of the Banking page. Then, manually record the refund in QuickBooks Online (QBO). Here's how:

 

  1. Go to the Accounting menu on the left pane. 
  2. Select Chart of Accounts.
  3. Locate the account where you want to record the refund. Then, click View register.
  4. On the Date column, click the drop-down arrow and choose the Refund option. Enter the details.

  5. Click Save.

 

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.

Jennifer529
Level 3

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

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.

 

Jennifer529
Level 3

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

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. 

Jennifer529
Level 3

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

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. 

katherinejoyceO
QuickBooks Team

Will someone assist? A refund and a sale are combined in my bank feed. How can I separate the two?

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:

 

  1. Click the + New menu, then select Bank deposit
  2. Set your bank account under the Account drop-down menu.
  3. Under Add funds to this deposit, add Customer A in the RECEIVED FROM.
  4. Select the income account where you would track your deposit.
  5. Enter the amount as $31.88 in the Amount field, then click Save and close

 

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:

 

  1. Go to the Accounting menu on the left menu, then select Chart of Accounts.
  2. Locate the account where you want to record the refund. Then, click View register.
  3. Below the Date column, click the drop-down arrow and choose the Refund option.
  4. Select the Payee in the drop-down, then enter amount as $75.52 in the Payment field.
  5. Click Save.

 

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!

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us