cancel
Showing results for 
Search instead for 
Did you mean: 
Awayout2020
Level 1

Daily Sales Summary

Hi.  I am using the sales receipt function to track all my daily retail sales and payments.   At the end of the day when I run my POS system reports and enter purchases paid by credit card/debit card I am entering the total $ amount of those sales.  But then a few days later the credit card clearing house/processing makes deposits to my checking account for those transactions.  So if my credit cards purchases for today are $2,100.00, in a few days the deposit into my checking account will be $1,900.00.  How do I account for the fees from the credit card clearing house?   Do I just set up a finance charge or service charge expense account and post the charges there?  What's the best way to do this so that my bank reconciliation is accurate each month?

Thanks.

3 Comments 3
ReymondO
QuickBooks Team

Daily Sales Summary

I'll help you record these transactions in QuickBooks, @Awayout2020.
 

Finance charge is usually set up if you collect late fees or interest on unpaid balances. You'll want to set up a service charge expense account where you can post the credit card fees. Let me show you how:

First, let's set up an expense account.

 

  1. Go to Lists, then select Chart of Accounts.
  2. Click the Account drop-down at the bottom, then choose New to create a new account.
  3. Select Expense account, then Continue.
  4. Enter the account details.
  5. Select Save & Close.

 

Once done, create an expense transaction to record the service charge.

In addition, you can run the Expenses by Vendor Summary report to view the expenditures to vendors that were coded to income and expense type accounts. Just to go Reports and select Company & Financial. Then, click Expenses by Vendor Summary.


I'm always here to help if you have any other concerns or questions. Just tag my name in the comment section and I'll get back to you as soon as I can.

Awayout2020
Level 1

Daily Sales Summary

Thanks for your help!  How does this affect my bank reconciliation though?  If I post the credit card charges to my checking account as a service fee this won't match my bank account when it comes time to reconcile each month.   When I'm creating my sales receipt, should I not deposit the credit card sales and then once I know the actual deposit amount I'm receiving from the bank should I alter the un-deposited funds amount in Quickbooks?

Thanks!

Anna S
QuickBooks Team

Daily Sales Summary

Welcome to the Community, @Awayout2020.

 

I hope you're having a beautiful day so far. 

 

Based on the information you provided, I recommend making the expense account that you created using the steps above a sub-account of your checking account. This will allow you to reflect on the processing fees in your expense account and your checking account. You will then be able to reconcile your account correctly because the credit card charges and fees will both be reflected in one account. I've included the steps below to show you how:

 

  1. Navigate to the Lists tab and select Chart of Accounts.
  2. Find the Expense account you created for the fees, left-click on it, and hit Edit Account.
  3. Change the account type to Banking.
  4. Check the box beside the Sub-account of box, then choose the bank account that contains your credit card charges.
  5. Press Save and close.

 

Please note: before you consider this as an option, I strongly suggest consulting with an accountant to make sure these are accounted for correctly for your particular business type. 

 

I'm only a reply away if you have any other questions. Enjoy the rest of your day!

Need to get in touch?

Contact us