cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
2sCo
Level 1

Entering a End of Day Sales Receipt with CC Processing fee already taken out

I use QBO and it does not integrate with our POS software (this is highly annoying). I have created an End of Day sales receipt template to account for deposits and am ready to play catch up. The stumbling block is that our credit card deposits automatically have the processing fees taken out. For example, if the credit card sales for the day were $177.49, they take out their fee and deposit the balance of $164.33 the next day. How do I account for the $5.16 in fees that were taken out on the sales receipt? Do I need to create an "Item" for CC fees and put that on the template? I will not be doing this daily, so will often be going back creating sales receipts days later to get caught up and will know what the fees are each day. Just trying to figure out the best way to do this. Thanks.

4 Comments 4
Charies_M
Moderator

Entering a End of Day Sales Receipt with CC Processing fee already taken out

Thanks for bringing your question here, kate-2sconeedlep.

 

Issues with POS integration can best be handled by out Point of Sale Team. They're equipped with tools to securely look into your account and closely look into the reasons why processing fees are automatically taken out from your credit card deposits. 

Please click this link to reach out to our support: Contact Point of Sale Support.

 

In case you have future questions about POS, check out this guide to learn more: QuickBooks Desktop Point of Sale User Guide.

.

Anything else you need help with POS can be answered here in the Community. Just let me know and I'd be happy to assist. Have a good one.

2sCo
Level 1

Entering a End of Day Sales Receipt with CC Processing fee already taken out

Charies,

 

Thanks for the link, but I do not use QB point of sale or their credit card processing system. I have a separate point of sale software system that handles my sales, inventory, and credit card payments. At this time, it does not integrate with QB Online, so that is why I am having to look in the community for figuring everything out. 

Thanks though!

jamespaul
Moderator

Entering a End of Day Sales Receipt with CC Processing fee already taken out

Hello, Kate. 

 

I'd like to help you record the fees for your end of day sales receipt process in QuickBooks. 

 

We have two options to record the fees, so I'll lay down the details below. 

 

Our first option is to add the fees to the template as what you've mentioned. We'll want to enter it as a negative value to deduct the accumulated fees from the sum of all sales. 

 

Create a service item then map it to an expense account: 

 

  1. Go to the Gear icon, then select Products and services.
  2. Click the New button.
  3. Select Service.
  4. Enter a name and other details.
  5. Under Income account, map it to an expense account (where you track the fees). 
  6. Hit Save and close.

 

After creating the service item, add it to the sales receipt template when you're ready to record the daily or regular sales. Make sure to add it as a negative value. Here's an example of what your sales receipt template would look like: 

 

fees1.PNG

 

Another option is to leave the sales receipt template as is. Then, we'll want to record the fees when we make a bank deposit. Here's how: 

 

  1. Click the + New button.
  2. Select Bank deposit
  3. Check the daily sales transactions under Select the payments included in this deposit
  4. Under Add funds to this deposit, add the credit card processor or bank's profile (enter them in QuickBooks if you haven't done it already). 
  5. Add the expense account (where you track the fees) under Account.
  6. Enter the fees as a negative amount.
  7. Add other information if needed.
  8. Click Save and close

 

This is what the Bank Deposit form would look like as an example: 

 

fees2.PNG

 

You might've come across this article before but I'll add this here in case you need help with your end-of-day sales procedures: Record your total daily sales in QuickBooks Online

 

Going back to the integration issue, the POS app in question might have a listing in our App Center page. You can check to see if there are any integration modules here: https://quickbooks.intuit.com/app/apps/home/.

 

I'd also check their support and see if there are any information about integrating their software with QuickBooks Online. 

 

Need to review your sales and other financial data in the future? You can run a reports to achieve this. If you'd like to utilize the Reports feature and its functions, you can check out this article: Run reports in QuickBooks Online

 

Feel free to drop by again if you have more questions about recording your sales entries. Would you like some assistance in recording other entries? Or do you need help with reports? Let me know and I'll gladly help you out. 

Rainflurry
Level 14

Entering a End of Day Sales Receipt with CC Processing fee already taken out

@2sCo 

 

I have a couple of businesses with the same situation and I don't bother with entering them on a daily basis - too time-consuming.  Therefore, I use the report from our POS system to reconcile the credit card deposits at month-end and then enter the entire month's merchant fees as one entry.  I'm not sure if that helps to answer your question or not.  

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us