cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How should I apply a payment to an invoice when the fees are deducted prior to the bank deposit (Braintree deposits are less than the invoice because the 2.9% fee)

When receiving Braintree deposits, the fees are already removed from my customer payments. So when applying the payment the amount is less than the invoice. What is the best way to apply these Braintree payments to my invoices?

Solved
Best answer 10-19-2018

Accepted Solutions
ProAdvisor

On the receive payment screen, enter the full amount of t...

On the receive payment screen, enter the full amount of the invoice so the invoice can be paid. On the make a deposit screen, check off the customer payment being deposited, then on the next line enter the credit card discount as a negative number. This will match what Braintree is depositing.
11 Comments
ProAdvisor

On the receive payment screen, enter the full amount of t...

On the receive payment screen, enter the full amount of the invoice so the invoice can be paid. On the make a deposit screen, check off the customer payment being deposited, then on the next line enter the credit card discount as a negative number. This will match what Braintree is depositing.
Not applicable

The only downside I see to this is that you can't run an...

The only downside I see to this is that you can't run an expense report for the vendor to see how much you paid in credit card fees for some reason.  I guess if I go into my P&L report I can click on the sub ledger and get a detail there, but it seems like a workaround for a basic thing that lots of people struggle with.
Not applicable

Re: On the receive payment screen, enter the full amount of t...

This is not a credit card discount though so it'll through off the p&l come tax time.  When applying the payment you will see a button that says discounts and credits.  That's where you need to deduct the fees.  

mmp
Not applicable

Re: On the receive payment screen, enter the full amount of t...

In doing this- will it affect the P&L- I don'w want it to show the full amount if I actually received less, it seems that this should be a merchant fee- but now sure how to apply it.

 

mmp
Not applicable

Re: On the receive payment screen, enter the full amount of t...

In doing this- will the P&L be affected- it seems that it should be a merchant fee and deducted... not sure what the best is for this?

 

QuickBooks Team

Re: On the receive payment screen, enter the full amount of t...

Allow me to jump right in and help with your question, mmp

 

Yes, it will affect your P&L. The best way of doing this is to use Undeposited Funds when receiving the payment. Then, add a line for the merchant fee when making a deposit to your bank. Make sure to add the merchant fee as a negative amount so it will deduct from the total amount that you received.

 

You can always reply to this thread if you have follow-up questions. 

Not applicable

Re: On the receive payment screen, enter the full amount of t...

@JenoP I have a similar situation with fees taken out by Shopify.

 

I have a Sales Receipt created by Cloud Cart Connector (Imports Shopify sales to Quickbooks) and I have a transaction imported from my bank in the "for review" state.

 

I want to match the Sales Receipt to the imported bank record, however the Sales Receipt is for an amount ($15.41) higher than the bank transaction  ($14.66 (Sales Receipt - Shopify fee)).  The Quickbooks Online match interface for the bank transaction will not show any Sales Receipts for amounts greater than the bank transaction amount. I'm at a loss as to how to properly match the Sales Receipt and associated bank transaction while appropriately accruing the fees.

 

FWIW... I've contacted Quickbooks customer support and they told me they don't have a solution for me and just told me to submit feedback in hopes of future enhancements. 😕

 

This doesn't exactly help me get my books in order for tax time.  Any suggestions?

QuickBooks Team

Re: On the receive payment screen, enter the full amount of t...

Hi there, kbolton.

 

QuickBooks will match the transactions if they have the same amount. It's also considered a Match if the transaction date is within 90 days. Since the imported imported transaction is different from the what's recorded in QuickBooks, it will be not considered it as a match.

 

You might want to post the Sales Receipt in the Undeposited Funds first. Then, follow the same steps I've shared above to record the merchant or Shopify fee in making a deposit to the bank. Once done, use the deposit in looking for a match. 

 

I will also forward your feedback and feature request to our product engineers. They will review this future updates. 

 

Visit us again in the Community if you have other questions.

Not applicable

Re: On the receive payment screen, enter the full amount of t...

@JenoP In the short term, how would you propose handling this situation? Manually adjusting the Sales Receipt to match the bank transaction and then a separate journal entry to account for the fees assessed on the Shopify side?

QuickBooks Team

Re: On the receive payment screen, enter the full amount of t...

Thanks for getting back to us, @kbolton.

 

You can definitely consider that option. However, I still encourage seeking help from your accountant for more guidance. He/She could check if recording your fees this way won't affect your accounting books.

 

Please let us know if you have any other concerns. Have a good day!

Not applicable

Re: On the receive payment screen, enter the full amount of t...

wow. thank you! 

Need to get in touch?

Contact us