Solved

Can't Resolve Difference

Forum|Forum|6 years ago
January 31, 2020
2 replies
1 view

So I'm following this guide

https://quickbooks.intuit.com/learn-support/en-au/banking/how-to-account-for-bank-fees-when-matching-transactions-in-bank/00/262597

and have even had support try over screen share and it will just not work it keeps saying

"The selected and downloaded transaction amounts don’t match. To continue, resolve the difference."

I get paid from overseas so there are often differences in the invoice and amount and this is useless!!

QuickBooks Online

Best answer by EmmaM

Hello Stevemdp

Having looked at the link that tells you how to record fees,however if you for example have an invoice for a customer but the amount paid comes through with fees removed you would also need to do an additional action on the invoice.In the invoice go to receive payment and change the bank account to undeposited funds.If you then go to bank deposit in the +symbol and then tick the invoice and then do the expense to the fee account in the add funds to this deposit using the - by the amount for the fee.Then the amount deposited to the bank should match the same amount in the bank feed

If you have already done this and it does not if you can reply back onto the Community thread with a screenshot from the bank deposit itself and we will look at this further

Thanks

Emma

E

EmmaMAnswer

Level 10

Hello Stevemdp

Having looked at the link that tells you how to record fees,however if you for example have an invoice for a customer but the amount paid comes through with fees removed you would also need to do an additional action on the invoice.In the invoice go to receive payment and change the bank account to undeposited funds.If you then go to bank deposit in the +symbol and then tick the invoice and then do the expense to the fee account in the add funds to this deposit using the - by the amount for the fee.Then the amount deposited to the bank should match the same amount in the bank feed

If you have already done this and it does not if you can reply back onto the Community thread with a screenshot from the bank deposit itself and we will look at this further

Thanks

Emma

A

Atif Aslam 0714

I have the same problem. I rang to support team and the agent said to me that create journal entry for this bank charges. so I have to do 100 journal entries every month because my customer pay me by direct debit every month. I think he did not know himself or he was must joking.

RenjolynC

Level 9

Hello there, Atif Aslam 0714,

You can follow the instructions provided by EmmaM, or exclude the transaction from the Banking page. Then, manually clear the transaction recorded in QuickBooks.

To exclude, here's how:

Go to the Banking > For Review tab.
Select the transactions by putting a check mark on the boxes and click the Batch actions drop-down menu.
Choose Exclude Selected.

Please see this sample screenshot:

Once done, the transactions will be added to the Excluded tab were you can undo or delete them. Here's an article for reference: Exclude expenses from downloaded bank transactions.

For clearing the transaction in the register, you can follow these steps:

On the left panel, select Accounting > Chart of Accounts.
Click the View register link of the bank account where the check was added.
Find and select the check to show the options. Under the Reconcile (indicated by a check mark) column, click the blank field until you see the letter C. This letter means cleared and the letter R is for Reconciled.
Press the Save button after.

Here's a sample screenshot:

After the steps above, you can start reconciling your account. I'm also adding these articles that you can bookmark for future reference:

I'll be around if there's anything else you need. Thanks.

M

mortop

Why does it not work to simply resolve the difference and add the bank fee in the resolve amount?

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded