Resolving Difference when Matching Transactions in Quickbooks

cbillings · ‎August 01, 2017

Hi, does anyone know how to go about resolving the difference when matching transactions from banking when you need to resolve it by adding more than one transaction. When you click on the resolve difference button it only allows you to do so by adding one transaction but I need to be able to add more as the amount left needs to be allocated to more than one revenue category.

When a deposit is made up of a couple donations, and some of them we want to match up with invoices and the others we just want to categorize into a revenue category and not match to invoices, I cannot split the remaining amount when resolving the difference I can only add one transaction to resolve when i'd like to add more.

Anonymous · ‎August 01, 2017

HI Cbillings,

Welcome to the community. I am the moderator here, and I think I have an answer for your question.

You are correct, you can only add one line when “resolving the difference” of a matched transaction.

The best workflow that I have found is to create transactions such as invoices for each portion of the deposit that you want to match. You can then use them to complete the process without using the Resolve Difference button.

In the case that you do not want to create transactions, you can find the transaction you created by resolving the difference and split it from there, here is my example:

Select the In QuickBooks tab
Click on the blue link labeled Multiple Transactions to see the detail of the transaction you matched
- The portion created by resolving the difference will show up as a Deposit
Select the Deposit
Add new lines for each portion you need in the Add New Deposits section with the amount you want in each.
Delete the original line by clicking the trashcan next to it
Select Save and close to save the deposit

Here are some screenshots of the process:

I hope that helps, feel free to respond if you need more information.

View solution in original post

Anonymous · ‎August 01, 2017

HI Cbillings,

Welcome to the community. I am the moderator here, and I think I have an answer for your question.

You are correct, you can only add one line when “resolving the difference” of a matched transaction.

The best workflow that I have found is to create transactions such as invoices for each portion of the deposit that you want to match. You can then use them to complete the process without using the Resolve Difference button.

In the case that you do not want to create transactions, you can find the transaction you created by resolving the difference and split it from there, here is my example:

Select the In QuickBooks tab
Click on the blue link labeled Multiple Transactions to see the detail of the transaction you matched
- The portion created by resolving the difference will show up as a Deposit
Select the Deposit
Add new lines for each portion you need in the Add New Deposits section with the amount you want in each.
Delete the original line by clicking the trashcan next to it
Select Save and close to save the deposit

Here are some screenshots of the process:

I hope that helps, feel free to respond if you need more information.

john-pero · ‎August 01, 2017

Best practices in using the tools you are given is to Receive Payment against open Invoices and use Sales Receipts when you are paid concurrent with sale. Post these payments into Undeposited Funds. Then create your deposit from teh Undeposited Funds. All you then need do is accept a green match from the feed.

JS46 · ‎August 31, 2020

i receive a message in QBO:

Your action is required: Please undo the highlighted transactions

Due to an issue with your bank data some income transactions were categorized as expense transactions. To correct this please go to the Categorized tab and undo the highlighted transactions.

i went to categorized tab and see blue and purple for some lettering but no actual transactions hilighted within the time frame I'm working?!

Please help!

Mark_R · ‎August 31, 2020

Thanks for posting here in the Community, @JS46.

At this time, we have an ongoing issue where users are getting an error message when reviewing their bank transactions. Rest assured that our product engineers are diligently working for a fix.

To ensure you'll get an update about the resolution status, I recommend contacting our Support Team. This way, they can add your company to the list of affected users and provide this investigation number for easy tracking: INV-49391.

To reach them, please follow the steps below:

Click the Help icon in the upper right of the screen.
Select Contact Us.
Enter Support in the What can we help you with? field and choose Let's talk.
Choose the Get a callback option to receive a call at a time that's convenient for you.

Just in case you want to match or categorize your transactions, here's an article you can read for the detailed steps and information: Categorize and match online bank transactions in QuickBooks Online.

Thank you for your patience while we work for a fix. Please post a reply below if you have other concerns with your bank transactions in QuickBooks Online. I'll be more than happy to assist you again. Have a great day and take care always.

Topics

Training

Community

Resources

Resolving Difference when Matching Transactions in Quickbooks