Hi. I have billed a customer 3600, and he paid with his credit card. The CC company paid 3521.41 and kept the balance as commission. How do I enter this transaction?

girishk1963 · ‎November 09, 2020

MaryLandT · ‎November 09, 2020

I'm here to help record the customer's payment, girishk1963.

You can receive the full payment of the invoice and post it to the Undeposited funds account. Here's how to accomplish this:

Click + New, select Receive Payment.
Choose the name of the customer from the drop-down menu.
From the invoice from the Outstanding Transactions section.
Select the payment method.
Enter the Reference no. and Memo if applicable.
Deposit the payment to the Undeposited funds account.
Click Save and close.

Once done, you can record the commission by making a bank deposit. Here's how:

Click + New, select Bank Deposit.
From the Account drop-down ▼ menu, choose the account you want to deposit the money into.
Mark the payment you've recorded above
Go to the Add funds to this deposit section and record the commission.
Make sure to select an expense account in the Account drop-down menu to track the commission.
Enter a negative amount.
Select Save and close.

I've adding this link for more details about the steps above: Record and make bank deposits in QuickBooks Online

Stay in touch if you have follow-up questions about recording the payment and commission. I'm always right here to help you.

View solution in original post

JasroV · ‎November 12, 2020

You're always welcome, @girishk1963.

I also appreciate you for taking the time to go through the steps shared by my colleague MaryLandT.

I’m glad the steps above were able to help resolve your query. However, the only way to record a commission in QuickBooks Online (QBO) is to manually create a bank deposit. I see having the option to have it done automate can benefit you and your business.

I’ll take note of this as a feature request on your behalf and pass it along to our product team. This way, they’ll consider adding this in future updates. Nonetheless, I’m unable to provide you a specific date as to when this feature will be available.

For now, I recommend checking our QuickBooks Blog page regularly. Here, you’ll stay updated on the current news and updates about QuickBooks.

I’ve also collected this resource that you can guide you through the detailed steps in case you need to record a refund to your customer.

Please let me know if there’s anything else I can help you with in managing your transactions in QBO. I’d be more than happy to help you out. Have a wonderful day ahead!

View solution in original post

MaryLandT · ‎November 09, 2020

I'm here to help record the customer's payment, girishk1963.

You can receive the full payment of the invoice and post it to the Undeposited funds account. Here's how to accomplish this:

Click + New, select Receive Payment.
Choose the name of the customer from the drop-down menu.
From the invoice from the Outstanding Transactions section.
Select the payment method.
Enter the Reference no. and Memo if applicable.
Deposit the payment to the Undeposited funds account.
Click Save and close.

Once done, you can record the commission by making a bank deposit. Here's how:

Click + New, select Bank Deposit.
From the Account drop-down ▼ menu, choose the account you want to deposit the money into.
Mark the payment you've recorded above
Go to the Add funds to this deposit section and record the commission.
Make sure to select an expense account in the Account drop-down menu to track the commission.
Enter a negative amount.
Select Save and close.

I've adding this link for more details about the steps above: Record and make bank deposits in QuickBooks Online

Stay in touch if you have follow-up questions about recording the payment and commission. I'm always right here to help you.

girishk1963 · ‎November 12, 2020

Thanks a lot, that worked well!!! I wish it was not so manual.. Can something be done to automate it? I may have 100s of CC transactions daily..

JasroV · ‎November 12, 2020

You're always welcome, @girishk1963.

I also appreciate you for taking the time to go through the steps shared by my colleague MaryLandT.

I’m glad the steps above were able to help resolve your query. However, the only way to record a commission in QuickBooks Online (QBO) is to manually create a bank deposit. I see having the option to have it done automate can benefit you and your business.

I’ll take note of this as a feature request on your behalf and pass it along to our product team. This way, they’ll consider adding this in future updates. Nonetheless, I’m unable to provide you a specific date as to when this feature will be available.

For now, I recommend checking our QuickBooks Blog page regularly. Here, you’ll stay updated on the current news and updates about QuickBooks.

I’ve also collected this resource that you can guide you through the detailed steps in case you need to record a refund to your customer.

Please let me know if there’s anything else I can help you with in managing your transactions in QBO. I’d be more than happy to help you out. Have a wonderful day ahead!

girishk1963 · ‎November 12, 2020

Thanks for taking my feedback.

To make things simple for automation, you can consider the Merchant Service provider as just another bank or financial institution and take a direct feed from them. The downloaded data can then be categorized accordingly and also "Matched" against appropriate invoice.

For e.g., my Merchant service provider is ICICI Merchant Services, which is part of ICICI Bank, you already give me feeds from ICICI Bank, so arranging for a feed from them should be just extending your existing arrangements. Please see if that can be done. Thanks a lot for your support.

AlexV · ‎November 12, 2020

Hi there, girishk1963.

You can still match the transaction from your Merchant Service provider to the one recorded in QuickBooks Online. All we have to do is follow the steps shared by MaryLandT. Once you download the transactions, you can match them to the Bank Deposit you created.

These steps will ensure that we properly categorized the fees collected by your payment gateway provider. You can check this link for more details: Categorise and match online bank transactions in QuickBooks Online.

We'll announce and post all our new features and innovations to our QuickBooks Blog.

Post again here if you have more questions. I'll be here!

girishk1963 · ‎November 13, 2020

Not sure if I understand. How do I download ICICI Merchant Service data for my Merchant ID? I don't think Quickbooks has a way to attach to my merchant services account for automatic download of data.

ChristieAnn · ‎November 13, 2020

Hi there, girishk1963.

Thank you for coming back here to QuickBooks Community to share your concerns.

Currently, there's no option to download your ICICI Merchant Service data or to attach your merchant services account for the automatic download of data in QuickBooks. QuickBooks can only integrate the Razorpay account connect it to your QuickBooks company file. This is a leading Indian electronic payments processor that lets you receive online payments on your invoices. For additional information, you can click this article: Payment enabled invoices—Razorpay.

However, QuickBooks can integrate with hundreds of apps. With this, you can go to the App center inside QuickBooks. Then look for a compatible app that can help you connect your merchant services account to automatically download your ICICI Merchant Service data in the QuickBooks system.

Here's how:

Click Apps in the left navigation menu.
Click the Browse Category drop-down menu, select Sync Data.
Select the app you want to integrate.
Click Get App Now and complete the following on-screen instructions.

If you don't see a specific app in QuickBooks Online, I'd suggest looking for other 3rd-party software that's supported.

I'd also recommend visiting our Online Blog so you'll be updated with the features and enhancements that our developers are currently working on.

If you have any other questions or would like me to clarify anything else about your account, let me know. I'm always glad to help in any way I can. Have a good day.