cancel
Showing results for 
Search instead for 
Did you mean: 
smallengines.mik
Level 1

I need help figuring out how to edit a amount received to match the deposit in our bank account as the amount differs from the invoice as we are charged fees for square

 
3 Comments 3
Mark_R
QuickBooks Team

I need help figuring out how to edit a amount received to match the deposit in our bank account as the amount differs from the invoice as we are charged fees for square

Hello there, @smallengines.mik.

 

You don't have to edit the amount received. Instead, you can create an expense account for the processing fee to resolve the difference between the invoice and the payment when matching transactions from your bank feeds. Let me guide you through the process.

 

First off, let's create an expense account if you haven't set it up yet. Here's how:

 

  1. Click on Accounting at the left panel, select Chart of Accounts.
  2. Select New.1.PNG
  3. In the Account dialog, create an Expense account for Bank Charges, and add the name.
  4. Click Save.

Once you have an expense account for the processing fee/s, you can now resolve the difference between the invoice and the payment when matching transactions from your bank feed.

 

  1. Click on Banking at the left panel.
  2. Select the appropriate bank account from the list.
  3. Locate and select the transaction in the For Review tab, then select Find Match.2.PNG
  4. In the Match transactions window, select the checkbox of the appropriate Invoice.
  5. Select Resolve Difference to open the Add resolving transactions field.
  6. Select Add new transaction.
  7. From the drop-down list in the Category field, select the Bank Fees (processing fee) expense account you created.
  8. Enter the negative Amount of the bank/processing fee.
  9. Click Save.3.PNG

Once completed, your transaction is now matched off against the invoice and the bank fees are accounted for.

 

I'm adding this article to learn more about matching transactions in QuickBooks Online: Match and categorize your downloaded bank transactions.

 

As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a great day.

smallengines.mik
Level 1

I need help figuring out how to edit a amount received to match the deposit in our bank account as the amount differs from the invoice as we are charged fees for square

The Transaction I am trying to fix has been deposited into undeposited funds, so I need to deposit it into our checking but need the amount adjusted so that it reflects the fees from square

Kendra H
QuickBooks Team

I need help figuring out how to edit a amount received to match the deposit in our bank account as the amount differs from the invoice as we are charged fees for square

Hello there, @smallengines.milk. 

 

I recommend reaching out to your Bank to transfer these funds from one account to another. This will record the transaction on your bank's side. If you have Online Banking in QuickBooks, then you'll see the transaction appear in the QuickBooks Bank Feed. If so, then you can delete the incorrect transaction. If you don't have Online Banking, you can create a Bank Transfer to move the funds from one account to the next. Either option will affect your reconciliation, so I suggest reaching out to your accountant for further assistance to ensure your books are accurate. 

 

For more information on transferring funds in QuickBooks Online, you can check out these Community articles: 

 

Please feel free to follow up with me if you have any more questions. I'm always here to help. Have a good rest of your day!

Need to get in touch?

Contact us