hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Running a Web Hosting Business : Quickbooks and Merchant Fees?
Reply

Forum Jump

Quickbooks and Merchant Fees?

Reply Post New Thread In Running a Web Hosting Business Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 10-22-2002, 09:43 PM
peachtreewebworks peachtreewebworks is offline
Web Hosting Guru
 
Join Date: Feb 2001
Location: Atlanta. Georgia
Posts: 252
Question

Quickbooks and Merchant Fees?


For those of you using Quickbooks, whats the best way you've found to enter sales receipts accounting for your discount rate on your merchant account?

The only way I've found in documentation is to enter the sales receipts, leave the money in the "Ungrouped Deposits" and then make a deposit and add a line for Discount Rate with a negative amount.

Any better way? Especially if your merchant bank deducts the fees on each deposit before it enters your account.

Thanks!

__________________
Peachtree WebWorks, LLC
http://www.peachtreewebworks.com

Reply With Quote


Sponsored Links
  #2  
Old 10-22-2002, 11:09 PM
Zach Zach is offline
Web Hosting Guru
 
Join Date: Mar 2001
Posts: 290
Curious about this myself.

Thanks
Zach

Reply With Quote
  #3  
Old 10-23-2002, 08:47 AM
EzHost EzHost is offline
WHT Addict
 
Join Date: Jul 2002
Posts: 130
Our account may be setup a bit different since our full gross amount of a sale is deposited into our account...and then at the end of the month our discount rate is taken out in one lump sum.

Our discount rate is entered at the end of the month as an expense, since it is an expense of doing business, just like a bank service charge, advertising, etc.

Reply With Quote
Sponsored Links
  #4  
Old 10-23-2002, 08:59 AM
Jay Suds Jay Suds is offline
Web Hosting Master
 
Join Date: Jun 2001
Location: Denver, CO
Posts: 3,293
Quote:
Originally posted by EzHost
Our account may be setup a bit different since our full gross amount of a sale is deposited into our account...and then at the end of the month our discount rate is taken out in one lump sum.

Our discount rate is entered at the end of the month as an expense, since it is an expense of doing business, just like a bank service charge, advertising, etc.

Ditto. If your merchant account currently takes the discount out of each transaction, call them and see if they can do it just once a month - most have no problems doing this

__________________
Jay Sudowski // Handy Networks LLC // Co-Founder & CTO
AS30475 - Level(3), HE, Telia, XO and Cogent. Noction optimized network.
Offering Dedicated Server and Colocation Hosting from our SSAE 16 SOC 2, Type 2 Certified Data Center.
Current specials here. Check them out.

Reply With Quote
  #5  
Old 10-23-2002, 10:41 AM
dandanfirema dandanfirema is offline
Web Hosting Master
 
Join Date: Apr 2002
Posts: 1,162
Regardless of how the money is deposited, the actual income should be reported and then the fees subtracted by expense.

__________________
*AlphaOmegaHosting.Com* - Hosting since 1998
Managed Dedicated Servers and VPS
Hosted Exchange 2010 Email Service

Reply With Quote
  #6  
Old 10-23-2002, 10:56 AM
peachtreewebworks peachtreewebworks is offline
Web Hosting Guru
 
Join Date: Feb 2001
Location: Atlanta. Georgia
Posts: 252
Agree...

Quote:
Originally posted by dandanfirema
Regardless of how the money is deposited, the actual income should be reported and then the fees subtracted by expense.
I definitely agree... just looking for way to this with Quickbooks in one transaction, instead of having to record a sales receipt for $10 lets say, then enter a seperate register entry in the deposit account for the $.40 fee lets say.

__________________
Peachtree WebWorks, LLC
http://www.peachtreewebworks.com

Reply With Quote
  #7  
Old 10-23-2002, 08:28 PM
EzHost EzHost is offline
WHT Addict
 
Join Date: Jul 2002
Posts: 130
It may be worth just keeping track of your discount rate fees, and just making one entry a month....even if your account is charged as the transaction occurs do you still get a monthly statement that gives an itemization of all the monthly fees?

Reply With Quote
  #8  
Old 10-25-2002, 12:48 PM
SonServer SonServer is offline
Junior Guru Wannabe
 
Join Date: Jan 2002
Posts: 30
I use QB with the Chase merchant account and the online billing. I have credit card, PayPal, and check deposits that are all getting deposited to the same account.

I just go ahead and let QB enter the full deposit not worrying about the discount fees but being careful to not lump deposits of different kinds of payments together. When making the deposits in QB, it helps out later if you change the memo field to "Credit Card", "PayPal", "Check" etc. according to where the deposit came from. When I have my bank and Chase statements, I reconcile my bank account.

During the reconcile, I take the bank statement and look at the date of the last Chase deposit. I mark every "Credit Card" deposit before that date as cleared. I then do the same with PayPal deposits.

I then continue as normal clearing the debits and credits that were from checks that show on the bank statement.

Provided there are no errors, when done, my reconciliation is off by an amount that is the amount of the discount fees, PayPal fees, and merchant monthly fee. I let QB make an "adjustment" and it enters that in the register. I then open the register and change the account that the adjustment was enterd to as an expense: "Merchant Fees" (or whatever account you set up for that).

This is not too scientific but I've not yet had a problem with doing it that way. After a few months, I got a feel for about what the total amount of the fees should be. If the adjustment is out of the normal range, then I go look for an error somewhere.

You do have to make sure that you allow for your QB register and your actual bank balance being off by that adjustment amount at the end of the month. If your normal total merchant fees are around $40, just be sure to keep at least more than that showing in your QB register and you will be fine.

Hope that helps.

Reply With Quote
  #9  
Old 10-25-2002, 01:28 PM
peachtreewebworks peachtreewebworks is offline
Web Hosting Guru
 
Join Date: Feb 2001
Location: Atlanta. Georgia
Posts: 252
Thanks...

Seems like a lot of "little work" to be done, but it makes sense. I may just end up doing it that way as well.

Thanks!

__________________
Peachtree WebWorks, LLC
http://www.peachtreewebworks.com

Reply With Quote
Reply

Related posts from TheWhir.com
Title Type Date Posted
Magento to Shut Down Two Ecommerce Solutions Aimed at Smaller Merchants Web Hosting News 2014-07-03 14:46:29
BurstNET Informs Colocation Customers of Higher Prices, Location Change Web Hosting News 2014-05-01 08:34:05
Web Hosting Sales and Promos Roundup - January 17, 2014 Web Hosting News 2014-05-23 15:42:32
OpenSRS Reduces Pricing on EV SSL Certificates, Introduces UC/SAN Option Web Hosting News 2012-09-20 16:39:20
Web hosting provider Infinitely Virtual Offers Unbundled Microsoft Office Suite Products Web Hosting News 2012-08-14 18:22:53


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?