Trading Services between Customers and Vendors
Author: Doug Sleeter Created: Tue May 16 17:20:38 2006
If you buy services or products from your customers, you might want to “trade” services instead of paying each other. If you don’t exchange money, but instead exchange credits against what each other owes, you’ll need to record a few special transactions in QuickBooks to ensure that all your reports are accurate.
For example, if you sell the customer taxable Items, or if you buy inventory Items in the trade, you want to make sure your accounting is accurate even though no cash changes hands.
Use the following method of accounting for trades when either of the following occurs:
You owe money to one of your customers and they owe money to you. You pay the customer by issuing a credit on their account. They, in turn, issue a credit for an equal amount on your account to pay you.
You owe money to one of your vendors and they owe money to you. You pay the vendor by issuing a credit to their account. They, in turn, issue a credit for an equal amount on your account to pay you.
For each customer you trade services with, set up a Customer record in the Customer Center, and a Vendor record in the Vendor Center. The Customer and the Vendor are actually the same company, but in order to track both purchases and sales in QuickBooks, you need a Customer and a Vendor for the same company.
- Create an Other Current Asset account called “Trade Clearing” as shown in Figure 1-56.
- Create an Other Charge Item called “Vend/Cust Credit” that posts to the Trade Clearing account as shown in Figure 1-57.
- When you buy from this customer/vendor, enter a Bill from the vendor Smith & Smith-V normally, and use whichever accounts or items to which the bill should apply. Enter a Bill recording the purchase of five 104 Sliders (an Inventory Part) from Smith & Smith as shown in Figure 1-58.
- When you sell products or services to this customer/vendor, create an Invoice to Smith & Smith-C. Enter the Items you sell just like on any other normal invoice. Enter an Invoice recording the sale of 20 hours of Design Services to Smith & Smith as shown in Figure 1-59.
- After they received the Invoice shown in Figure 1-59, Smith & Smith offered Academy Glass a credit to their account in lieu of payment. To record the credit from Smith & Smith enter a Bill Credit as shown in Figure 1-60. In the body of the Bill-Credit, use the “Vend/Cust Credits” Item shown in Figure 1-57.
The Accounting Behind the Scenes
The “Vend/Cust Credits” Item is associated with the Trade Clearing Account, so this transaction decreases (credits) the balance in Trade Clearing and decreases (debits) Accounts Payable.
- Since the Bill Credit shown in Figure 1-60 is in lieu of payment, you need to reduce the amount that Smith & Smith owes you for the Invoice shown in Figure 1-59. Enter a Credit Memo for the Customer "Smith & Smith-C." In the body of the Credit Memo, use the Vend/Cust Credits Item.
The Accounting Behind the Scenes
The “Vend/Cust Credits” item posts to the Trade Clearing account, so the Credit Memo shown in Figure 1-61 increases (debits) the balance in Trade Clearing and decreases (credits) the balance in Accounts Receivable.
- When you save the credit memo, you will see the Available Credit window (see Figure 1-62). Click Apply to an invoice and the click OK.
- The Apply Credit to Invoices window (Figure 1-63) already has invoice 2006-101 selected. Click Done to apply the Credit Memo to apply the credit to the Invoice.
- Next, apply the Bill Credit to the open Bill for the Smith & Smith-V vendor using the Pay Bills screen. Select the Bill and click Set Credit to apply the Bill Credit. Notice that Academy Glass owes Smith & Smith $300 since the Bill from Smith & Smith was $300 more than the Invoice they sent to Smith & Smith.
- Click Pay & Close. QuickBooks creates a Bill Payment for the $300 difference.
This article is an excerpt from The QuickBooks Consultant's Reference Guide. Visit our Online Store to order your copy. Available in printed book, CD-ROM (PDF ebook) or downloadable PDF
Copyright © 2002 - 2008 The Sleeter Group, Inc. All rights reserved.