Find match not finding sales receipt

melliepebbles · ‎May 30, 2019

Hello! I am looking for a little advice.

I have created numerous sales receipts and have been matching them to the deposits when they arrive in the bank account. I use the resolve toggle switch to send some of the sales receipt to bank charges as we do not actually receive this payment, it is debited prior to us being sent the money.

All my sales receipts have been created the same, however I have one transaction that when I use 'find match' cannot be found!

I have tried numerous things, including playing with the dates, trying to find the customer, etc. Nothing works, it just cannot find it!

Any suggestions? Or is there a way I can manually 'match' this?

Thanks for your help in advance!

Mel

John C · ‎May 30, 2019

Hi melliepebbles

The correct method for accounting for receiving net amounts due to having fees deducted is;

When creating your sales receipt ensure that you select undeposited funds in the Deposit to box > create a bank deposit > in the Account box select your bank account and enter the date you received the net amount > tick the sales receipt the net amount you have received into your bank account relates to > in the 'Add funds to this deposit' section select your fee expense account/or you can create one > enter the amount, as a minus amount, that has been deducted from the gross amount of your sales receipt figure, save and close. You will then be able to match the deposit you have just created to the net amount on your for review page.

You may not be able to automatically find match for a number of reasons, if the transaction is outside of the date range you are searching, the difference to resolve is too large, the sales receipt is over 90 days old etc.

If you are not able to find match follow the instructions above and exclude the transaction from the banking screen, excluding the transaction in the for review section will not affect your figuyres within QuickBooks.

View solution in original post

John C · ‎May 30, 2019

Hi melliepebbles

The correct method for accounting for receiving net amounts due to having fees deducted is;

When creating your sales receipt ensure that you select undeposited funds in the Deposit to box > create a bank deposit > in the Account box select your bank account and enter the date you received the net amount > tick the sales receipt the net amount you have received into your bank account relates to > in the 'Add funds to this deposit' section select your fee expense account/or you can create one > enter the amount, as a minus amount, that has been deducted from the gross amount of your sales receipt figure, save and close. You will then be able to match the deposit you have just created to the net amount on your for review page.

You may not be able to automatically find match for a number of reasons, if the transaction is outside of the date range you are searching, the difference to resolve is too large, the sales receipt is over 90 days old etc.

If you are not able to find match follow the instructions above and exclude the transaction from the banking screen, excluding the transaction in the for review section will not affect your figuyres within QuickBooks.

melliepebbles · ‎May 30, 2019

Thanks :)

gtramble · ‎February 15, 2020

I'm also receiving net amounts because of having fees deducted and can't get match to find my sales receipt. Obviously the amounts don't match because the bank deposit is for the net amount and the sales receipt is before the fees are deducted.

What I expect to happen is for the sales receipt to appear in the list of transactions and then I would select Resolve difference where I would make the entry for the transaction processing fee. The date of the Sales Receipt is within the range.

I can get the transactions to match if I use a manual journal entry but that is far from ideal.

SarahannC · ‎February 15, 2020

Thanks for sharing your insight here, gtramble

What my colleague shared with this thread is right. We can deposit the fees in your book and enter it as a negative amount. You can follow the steps provided by my colleague above.

You'll want to check these articles where you can get more information about depositing the amount in QuickBooks Online:

We are right here if you need help with QuickBooks. Take care!

gtramble · ‎February 15, 2020

Thanks very much for your response and the links you provided.

It is a convoluted workaround but it does work. It would simpler if Match Transactions found the Sales Receipt and allowed me to enter the fee as a negative deposit (offset is the negative CR to an expense account)

(As an aside, I think the reason QuickBooks didn't "find" the Sales receipt is because it exceeds the amount of the net deposit. For deposits for which there are multiple Sales Receipts associated with the deposit,QuickBooks does "find" the Sales Receipts - each is less than the total net deposit - I include them as appropriate and then book the fees as a negative)

Kind regards,

Greg

Topics

Training

Community

Resources

Find match not finding sales receipt