Skip to main content
J
Jennifer529
October 19, 2022
Question

Will someone help me with a bank feed?

  • October 19, 2022
  • 1 reply
  • 0 views
My bank feed deposit amount from Auth.net is combined with a customers refunds and another customer sale.  I created a refund receipt for the refund but how can I match the refund if it did not show in the bank feed?  I need to separate these transactions.

1 reply

M
MirriamM
October 19, 2022

Hello there, @Jennifer529. Thanks for reaching out and providing detailed information about your concern. 

 

Right now, splitting transactions from bank feeds into two transactions is unavailable since you can only split transactions into different categories. As a workaround, you can exclude the transactions in the bank feed. Then, manually enter the customer sale and refund receipt. 

 

To guide you further with excluding bank entries, follow the steps below:

 

  1. Go to the For Review tab.
  2. Mark the box next to each transaction you want to exclude.
  3. Select Exclude from the pop-up at the top.

 

Excluded transactions are then moved to the Excluded tab and won’t be added to QuickBooks or downloaded again. To permanently delete duplicate entries, put a checkmark on them, then click Delete.

 

In addition, you may want to use the bank rule feature to help you review your transactions. To know more about this, see this article: Set up bank rules to categorize online banking transactions in QuickBooks Online.

 

Then, use this reference to ensure your account are balanced and accurate: Reconcile an account in QuickBooks Online. 

 

I'll be right here to continue assisting if you have any other concerns or additional queries. Just leave the details below and I'll get back to you.

J
Jennifer529Author
October 20, 2022

If I click "find match" in the bank feed, I see my two sales that need to be checked.  If I click both it leaves a difference of the amount of the two refunds.  These refunds are included in the batch deposit.   The $31.68 are the two refund receipts I already created.  How can I match the refunds?

$424.21
$658.19
2 Selected transaction(s) Show | Remove  $1,082.40
Downloaded transaction  $1,050.72
Resolve Difference  -$31.68 Total $1,082.40
L
LeizylM
October 20, 2022

Hi there, Jennifer529.

 

I'll make sure you'll be able to match the refund receipts in QuickBooks Online (QBO). 

 

You can add a bank deposit as a negative amount. I'll show you how:

 

  1. Select + New.
  2. Choose Bank Deposit.
  3. From the Account ▼ dropdown, choose the account you want to put the money into.
  4. Tap the checkbox for each transaction you want to combine.
  5. Make sure the total of the selected transactions matches your deposit slip. Use your deposit slip as a reference.
  6. Select Save and close or Save and new.

 

For more information, as well as how to review past bank deposits, I recommend the following article: Record and make bank deposits in QuickBooks Online.

 

I'm also adding these articles to help manage your bank transactions and keep your QuickBooks balance accurate:

 

 

Do you have more questions about bank feeds? Let me know the details, and I'll get back to help you. Have a great day.

Terms & ConditionsAccessibility statement