Will someone help me with a bank feed?

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.

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?

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:

• Categorize and match online bank transactions
• Reconcile an account

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.

After viewing the refund receipts, I created in the customer’s account, the drop down at the end shows "print check".  I do not want to print a check.   They showed up in the print check screen.  How can I remove the two checks? Did I choose the wrong option in the refund from drop down?  My bank register seems right.  see attached.

The money has already been refunded from the third party Auth.net. Auth.net took the refunds out of a batch deposit from Auth.net and then downloaded into QB bank feed for review and match.  The batch deposit also included two sales deposits.   When I click the bank feed to review and click "find match" I click the two sales payments which then leaves a difference of the refund receipts.

Match transaction screen:

2 Selected transaction(s)

$1,082.40

Downloaded transaction

$1,050.72 this was deposited into my checking account already.

Resolve

Difference

-$31.68 (total of the two refund receipts I created) Total $1,082.40

attached

attachment

Thank you for reaching out to us, @Jennifer529!

You can uncheck the "Print later" box if you don't want to show the transactions in the print check screen. Here's how:
1. Go to Expenses, then click Filter.
2. Select Check. Click Apply.
3. Choose the specific check account.
4. Uncheck the Print later box.
5. Click Save and Close.


If you don't want to resolve the difference, deposit the total difference between the two refund receipts to "Undeposited funds," then match the transaction by selecting sales and refund receipt transaction to the bank deposit.

If the issue persists, you may need to exclude the downloaded transactions from your bank feeds and edit the Refund receipt so that it immediately posts to the account while manually clearing the previous transactions. Here's how:

1. Go to the Sales menu and look for the Refund receipt. 
2, Under the Refund from field. 
3. Select the bank where you'll get the funds for the refund. 
4. Click Save and close.

Moreover, please follow the steps below to manually clear the existing transaction in your bank register: 

1. Go to the Accounting menu.
2. Click the Chart of accounts tab.
3. Choose the account that has the reconciled transaction, then select View register.
4. Locate the appropriate transaction, then select it to expand the view.
5. Continue to click the box in the Checkmark column until you see the letter "C." This indicates that the transaction has been cleared.
6. Click Save, then close the register.
 

Once everything's good, you can proceed to reconciliation. You can use this link for reference: Categorize and match online bank transactions in QuickBooks Online.

Additionally, I've added these articles that'll help you manage your checks:
 

• Print a Check in QuickBooks Online
• Configure your Print Settings for Printing Checks

Feel free to reach us again if you have additional concerns about your transactions.

Thank you I was able to uncheck the print check.

What would happen if I clicked resolve in the match transaction screen at the bottom?  the difference is a negative -31.68 which is a total of two refund receipts I created.  What are the steps if I choose to resolve?

You mentioned if I did not want to resolve it to make a deposit.  I'm not sure why I would make a deposit with a negative amount.  What are the steps If I choose this option? 

Hi, @Jennifer529.

Allow me to chime in and provide some clarification about what will happen if you click resolved the difference in QuickBooks Online (QBO).

You can use the Resolve Difference option to fix your payment difference. This helps match your transaction through its difference until it'll be equal to zero.

Here's how:
 

1. On the Banking page, find an item with an amount that doesn’t match the transaction you entered for it.
2. Tap the item, and choose Find Match.
3. In the MatchTtransactions page, hit the transaction to match.
4. Once you select the transaction and tick Resolve difference on the right.

On the other hand, if you don't want to resolve differences. You'll need to create a deposit between the two refunds to "undeposited funds" to match the transaction by selecting sales and refund receipt transaction to the bank deposit.

Check out this article in case you want to learn about matching transactions: Categorize and match online bank transactions in QuickBooks Online.

Feel free to browse this link in case you need help with bank-related tasks. It has general banking topics: Find help with bank feeds and reconciling accounts.

Please let me know how else I can help you with your bank feeds by adding a comment below. I'm more than happy to help. Have a good one!

I'm missing something.  I created a deposit for the two refunds as negative amounts.  Now my bank register shows the refunds as a payment.  I still don't know how to match the downloaded deposit in my bank feed.

Match transaction screen:  Where is the -31.68 to match?

2 Selected transaction(s)

$1,082.40

Downloaded transaction

$1,050.72 this was deposited into my checking account already.

Resolve

Difference

-$31.68

How do I use the resolve button? 

I appreciate you for coming back to the thread and adding some clarification about matching transactions, Jennifer529. Let me discuss further details on how downloaded and manually entered entries works in QuickBooks. Then, ensure you'll be able to handle your deposit and refund in QBO.

Creating a refund receipt as a negative amount in the Deposit section will indicate an expense that's why you're unable to directly match a deposit transaction posted in your bank feeds. 

However, you'll have the option to match the created refund to another transaction on the Banking page by using the Resolve difference option. To use the feature, click the Resolve difference button to the right or turn it on so the difference will be equal to zero. 

Once done, they're recorded into QuickBooks. You can review your work and make sure everything is correct in the Categorized or Reviewed tab.

On the other hand, if you don't wish to resolve the difference, I recommend excluding the downloaded deposit from your bank feeds and editing the refund receipt. This way, you're able to immediately post the entry to the specific account. You may follow the steps shared by my colleague SirielJeaB on how to perform the process.

Lastly, you may refer to this article to see steps on how you can reconcile your accounts so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.

Please click the Reply button below if you still have a concern with your transactions or how else I can help you with your bank feeds. I'm happy to help further. Have a good one!

I clicked resolve. The difference is -31.68.  This is a total of two refund receipts.  There is a box at the bottom that says "Add resolving transactions".  Do I fill this out?

Good afternoon, @Jennifer529. 

Thanks for coming back on this thread. 

Yes, you're on the right track. Filling that out will help to add the resolving transactions.

 However, I recommend consulting with your accountant to be sure these are the transactions you need to be making in order to fix the difference. If you don't have one, check out the link to find one near you. 

If you have any more questions or concerns, don't hesitate to reach back out. Take care!