• Admin
  • About
  • Ask / Request A Screen Cast
  • Consulting / Training
  • Get Help
  • Nerd’s Affiliates
    • Shoeboxed.com – Get rid of your receipt headahces!
QuickBooks, Excel, Cash Flow and Technology! Nerd's Blog
  • Main Site
  • Business
  • Knowledge Store
  • MS Excel Help
  • QuickBooks Help
  • Social Media
  • Technology
  • Events
  • RSS Feed
  • Twitter
  • Facebook

QuickBooks Tutorial – What Happens When My Customer Pays My Vendor?

By
Nerd
– May 24, 2011Posted in: Accounts Payable, Accounts Receivable, Customers & Accounts Receivable, Journal Entries, QuickBooks Help, Tips and Tricks, Transactions
  • FacebookFacebook
  • TwitterTwitter
  • DeliciousDelicious
  • DiggDigg
  • StumbleUponStumbleUpon
  • Add to favoritesAdd to favorites
  • RSSRSS
  • PDFPDF
  • PosterousPosterous
  • BloggerBlogger

What Happens If My Customer Pays My VendorWhen does this come up / why would my customer pay my vendor?

More often than I would expect, I am asked about how to account in QuickBooks for the situation where a company’s customer pays its vendor directly. Most often this is because the vendor will not work with that company otherwise, and usually this is due to issues of payment in the past. So the vendor in order to conduct business going forward will require a company’s customer to pay them directly. Regardless of the reason it comes up and we need to know how to handle this properly in QuickBooks.

The question then becomes, how do I record the payment from my customer to my vendor in QuickBooks?

What NOT to do

Normally I would record a customer’s payment, deposit the money and then pay my bill to my vendor. That’s not going to work in this case. You could enter all of that info, and record the deposit and bill payment so that it washes through your checking account, but I am not even going to show you how to do that because it just isn’t clean. It’s messy / sloppy bookkeeping and if someone were reviewing your books to determine whether they wanted to provide financing and they saw this kind of thing it could have an adverse affect on your chances of getting funding because it ruins the integrity of your books. Simply put, there should not be a deposit recorded in your bank account unless money was actually deposited into your bank account and there should not be a payment recorded in your books unless you’ve actually made one.

The right way

The very simple and direct way to deal with this is through a journal entry, reducing the customer’s receivable and reducing the vendor’s payable.

The problem

QuickBooks will not let you post to more than 1 accounts receivable or accounts payable account in the same transaction.

The solution

You have to break up your entry into two separate entries, and use a clearing account. Clearing accounts must ALWAYS zero out. The video will show you exactly what this looks like in terms of how to record a payment that was made directly from your customer to your vendor in QuickBooks.

YouTube Preview Image

Want the QuickBooks File used in the video so you can drill into the transactions?

Download it for $0.99
Add to Cart

Tweet
Tags: clearing account, customer pays vendor, Customers, Journal Entries, QuickBooks Tutorials, vendors

About Nerd

I started Nerd Enterprises, Inc. in 2003 and continue to work with individuals and companies to cure their financial headaches. Writing, Blogging, Social Media and generally building communities around these areas as well as technology has become another passion of mine.

3 Comments

  1. Gail Reeves
    Posted July 11, 2012 at 1:44 PM

    This is almost the scenario that I have. Here is what we do on certain large dollar orders and need to know how to account correctly.

    1.) We invoice the customer and the payment address is our vendor’s lock box.
    2.) the Vendor deposits the customer’s check.
    3.) the Vendor then mails us a check minus the amount we owe them for the product.

    We have an accountant who gets confused each time we have one of these orders. She says she fixes it. I need to know how as I do not want to wait every quarter when she comes in to have the deposits recorded so I am now doing them. Please help.

  2. Nerd
    Posted July 15, 2012 at 9:22 AM

    Hi! Sorry this took a few days to get to :)
    Seems to me that you post the payment in it’s entire amount (as if the check you received was for the full amount of the invoice) and let it go into undeposited funds. Then when you record the deposit you add a line item into the deposit posting to accounts payable (enter the vendor name in the received from column to associate the transaction with that vendor) and the amount is negative, reducing the funds received in the deposit to the correct amount. Then go into “Pay Bills” and there will be a credit available to be applied to that vendor’s bill so you can show it as paid.

  3. Gaurav Bhatnagar
    Posted September 4, 2012 at 6:31 AM

    My vendor billed my customer, my customer paid me, & I paid my vendor.

    I entered the payment in my regular bank account received as normal and the customers a/c showed a negative balance

    I entered the payment made vide a cheque (with Accounts payable) from my regula bank account to my vendor

    I entered a journal entry to transfer the excess Accounts Receivable balance to a clearing account (bank – named 3rd party payments). i.e. Credit 3rd party payments, Debit Accounts Receivable while mentioning the name of the customer in both the rows under Name column.

    I entered a journal entry to transfer the effects to Accounts Payable by Debiting the 3rd party payments and crediting Accounts payable while mentioning the name of the vendor in both rows under the Name column.

    It looks clean on the surface. However, please let me know if I got it right.

    Regards,
    Gaurav Bhatnagar

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • Categories
  • Click To Call Me For Help!
  • Want to set up a private training?
    Check out my QuickBooks Support options at QuickBooks Answers
  • Weekly Newsletter
    Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Get Nerd's Words
    For Email Newsletters you can trust
  • Watch My Live Broadcasts on Bambuser
  • Get e-mails when I post!

    Enter your email address:

    Delivered by FeedBurner

    • Latest
    • Comments
    • Featured
    • Tags
    • ..I thought I would incorporate QuickBooks, Excel, Cash Flow, and Technology into the new site We’ve Moved!!!!
      27 May 2012 8:01 AM | No Comments
    • Hey the bottom line is it doesn’t cost me anything extra to do this and it can only help! Maybe it can help you too! Using Excel and Evernote Digital Scrap Paper
      23 April 2012 12:42 PM | 3 Comments
    • First you have to create the component inventories. So in this video we are going to have a bit of fun building an airplane.. QuickBooks Inventory With Some Assembly Required
      17 April 2012 6:46 AM | No Comments
    • Your Items tab is the key to getting inventory on the books. How to record your inventory purchases in QuickBooks
      14 March 2012 11:56 AM | 8 Comments
    • The classic mistake that inexperienced bookkeepers make is that they book the net payroll as payroll expense and the taxes all go to the employer’s tax expense. How To Enter Payroll Into QuickBooks
      12 March 2012 6:27 AM | 5 Comments
    • Tweet Managing and Tracking Your Inventory With QuickBooks Segment 1 – How to set up inventory parts
      07 March 2012 7:00 AM | 4 Comments
    • Facebook Timeline for business is now here and if you haven't already updated and published you don't worry. You will be forced to on March 30, 2012! How To Use Facebook Timeline For Business
      05 March 2012 12:28 PM | 4 Comments
    • The site is getting tons of traffic so it makes sense that you should be using this for your business. How To Use Pinterest For Your Business
      27 February 2012 11:50 PM | 4 Comments
    • Nerd
      How to customize your QuickBooks Invoice Template
    • Nerd
      How to record your inventory purchases in QuickBooks
    • christine
      How to customize your QuickBooks Invoice Template
    • Mathew Nix
      How to record your inventory purchases in QuickBooks
    • Nerd
      QuickBooks Undeposited Funds Account Demystified
    • Nerd
      QuickBooks – How To Correct A Reconciled Deposit With A Customer Payment
    • Nerd
      How to write off a customer balance in QuickBooks
    • QuickBooks Tip – How To Record Payment Processing Fees « Nerd Enterprises, Inc.
      QuickBooks Undeposited Funds Account Demystified
    • ..I thought I would incorporate QuickBooks, Excel, Cash Flow, and Technology into the new site We’ve Moved!!!!
      27 May 2012 8:01 AM | No Comments
    • Hey the bottom line is it doesn’t cost me anything extra to do this and it can only help! Maybe it can help you too! Using Excel and Evernote Digital Scrap Paper
      23 April 2012 12:42 PM | 3 Comments
    • First you have to create the component inventories. So in this video we are going to have a bit of fun building an airplane.. QuickBooks Inventory With Some Assembly Required
      17 April 2012 6:46 AM | No Comments
    • Your Items tab is the key to getting inventory on the books. How to record your inventory purchases in QuickBooks
      14 March 2012 11:56 AM | 8 Comments
    • The classic mistake that inexperienced bookkeepers make is that they book the net payroll as payroll expense and the taxes all go to the employer’s tax expense. How To Enter Payroll Into QuickBooks
      12 March 2012 6:27 AM | 5 Comments
    • Tweet Managing and Tracking Your Inventory With QuickBooks Segment 1 – How to set up inventory parts
      07 March 2012 7:00 AM | 4 Comments
    • Facebook Timeline for business is now here and if you haven't already updated and published you don't worry. You will be forced to on March 30, 2012! How To Use Facebook Timeline For Business
      05 March 2012 12:28 PM | 4 Comments
    • The site is getting tons of traffic so it makes sense that you should be using this for your business. How To Use Pinterest For Your Business
      27 February 2012 11:50 PM | 4 Comments
    Balance Sheet Business Calendar Cash Flow For Business Content Customer Service data E-mail efficiency Empire Avenue evernote Excel Facebook financial statements Getting Organized Google Plus inspiration inventory LinkedIn loans marketing ms excel MS Excel Help Pivot Tables productivity Profit and Loss QuickBooks for inventory QuickBooks Help QuickBooks Inventory QuickBooks Tips QuickBooks Tutorial Reports running a business Sales Sales Reps Sales Reps & Commissions small business social media Statement of Cash Flows tasks technology time management Twitter Undeposited Funds YouTube
  • Nerd Enterprises, Inc.
    Nerd Is The Word
  • Nerd’s E-books

    Additional E-books can be purchased in my
    Knowledge Center
  • Nerd's Stuff
    • Accounting For Real Estate Book
    • AnalystsOnline.Com
    • Focus.com
    • Knowledge Center
    • Nerd Enterprises, Inc.
    • Seth David
    • The Bottom Line
    • Toolbox For Finance Blog
  • Nerd’s TFWD

About Arras WordPress Theme

Copyright Nerd\\\'s Blog. All Rights Reserved.