• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Ask the Expert Event   Ask the Expert: Jim Savage (Archived)  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
11177
aIWkEAFl4qllvkab8P4pmk
Subscribe RSS
ShopinSR
ShopinSR
Questions asked: 1
Questions answered: 0
Points earned: 0
ShopinSR
ShopinSR
Questions asked: 1
Questions answered: 0
Points earned: 0
New Member
04/17/09 9:38am PDT

Recording receipt and sale of consignment goods

US QuickBooks Premier

Our non-profit gift shop takes some merchandise on consignment How do we record the receipt of inventory and then record the subsequent sale of the consignment goods?

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
4 Replies
BizMaker
BizMaker
Questions asked: 2
Questions answered: 6
Points earned: 3
New Member
11/12/10 10:20am PST

I am looking to do the same.  However, it seems that this explanation leaves out accounting practices that could misstate the books.  If you create another account called Consignment Inventory, any transactions to it still records these transactions as posted to the financial statements and consequently misstates the Balance Sheet.

Consignment goods are actually non-posting inventory items until they are sold at which point the transaction classifies to revenue and COGS. 

In Enterprise 11, my client wants to be able to track consignment inventory for multiple locations.  However, when she posts consignment items to inventory, the offset will either be the cash account or accounts receivable.  By this double entry, the transaction indicates that ownership has transpired.  However, under consignment, ownership has not been transacted.  Only the receipt of consigned inventory has been acknowledged.  However, placing the consigned items on the Balance Sheet makes it an asset, which is not really true.

My client wants to be able to track used time on phone cards at multiple locations. The company buys the phone cards and activates them.  However, the stored cards for inventory purposes are only worth $.05 each activated until the time on the cards are used.  At that point the company receives an invoice from the vendor for the used time.  However, she gives the cards to stores at no costs (on "consignment") and does not recognize any revenue until the store to whom she resells the cards sells them and then pays her. 

Given this scenario, how then would you track the inventory items?

If they do not truly belong to the company, they cannot be assets on the company's Balance Sheet.   The other problem is the offsetting entry. 

So, what if you use the Class and Sales Order for initially recognizing a consignment item?  The item would be a non-inventory or Other Charge item.  The Sales Order is a non-posting transaction and would not be a transaction on the books.  To show multiple locations on reports, the company would have two options.  Set up a custom field and supply the name for each location in the custom field or use the Class feature (if it is not reserved for another type).  Set up the Class as a location. If the Class is used for some other type, set up a Customer called Consignment - Location #1.  For each job under the Consignment customer, set up the real customer to whom the consigned items are sold.   This allows tracking by inventory location. by the Customer "Consignment" or through Sales Order reporting.

Would this work as a work-around?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
BizMaker
BizMaker
Questions asked: 2
Questions answered: 6
Points earned: 3
BizMaker
BizMaker
Questions asked: 2
Questions answered: 6
Points earned: 3
New Member
11/12/10 10:23am PST
Latest post

I think Jim Savage may have left out a few steps crucial for reporting.  My explanation for a fix I have is below.

I am looking to do the same. However, it seems that this explanation leaves out accounting practices that could misstate the books. If you create another account called Consignment Inventory, any transactions to it still records these transactions as posted to the financial statements and consequently misstates the Balance Sheet.

Consignment goods are actually non-posting inventory items until they are sold at which point the transaction classifies to revenue and COGS.

In Enterprise 11, my client wants to be able to track consignment inventory for multiple locations. However, when she posts consignment items to inventory, the offset will either be the cash account or accounts receivable. By this double entry, the transaction indicates that ownership has transpired. However, under consignment, ownership has not been transacted. Only the receipt of consigned inventory has been acknowledged. However, placing the consigned items on the Balance Sheet makes it an asset, which is not really true.

My client wants to be able to track used time on phone cards at multiple locations. The company buys the phone cards and activates them. However, the stored cards for inventory purposes are only worth $.05 each activated until the time on the cards are used. At that point the company receives an invoice from the vendor for the used time. However, she gives the cards to stores at no costs (on "consignment") and does not recognize any revenue until the store to whom she resells the cards sells them and then pays her.

Given this scenario, how then would you track the inventory items?

If they do not truly belong to the company, they cannot be assets on the company's Balance Sheet. The other problem is the offsetting entry.

So, what if you use the Class and Sales Order for initially recognizing a consignment item? The item would be a non-inventory or Other Charge item. The Sales Order is a non-posting transaction and would not be a transaction on the books. To show multiple locations on reports, the company would have two options. Set up a custom field and supply the name for each location in the custom field or use the Class feature (if it is not reserved for another type). Set up the Class as a location. If the Class is used for some other type, set up a Customer called Consignment - Location #1. For each job under the Consignment customer, set up the real customer to whom the consigned items are sold. This allows tracking by inventory location. by the Customer "Consignment" or through Sales Order reporting.

Would this work?
 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
BizMaker
BizMaker
Questions asked: 2
Questions answered: 6
Points earned: 3
New Member
11/12/10 10:21am PST

I am looking to do the same. However, it seems that this explanation leaves out accounting practices that could misstate the books. If you create another account called Consignment Inventory, any transactions to it still records these transactions as posted to the financial statements and consequently misstates the Balance Sheet.

Consignment goods are actually non-posting inventory items until they are sold at which point the transaction classifies to revenue and COGS.

In Enterprise 11, my client wants to be able to track consignment inventory for multiple locations. However, when she posts consignment items to inventory, the offset will either be the cash account or accounts receivable. By this double entry, the transaction indicates that ownership has transpired. However, under consignment, ownership has not been transacted. Only the receipt of consigned inventory has been acknowledged. However, placing the consigned items on the Balance Sheet makes it an asset, which is not really true.

My client wants to be able to track used time on phone cards at multiple locations. The company buys the phone cards and activates them. However, the stored cards for inventory purposes are only worth $.05 each activated until the time on the cards are used. At that point the company receives an invoice from the vendor for the used time. However, she gives the cards to stores at no costs (on "consignment") and does not recognize any revenue until the store to whom she resells the cards sells them and then pays her.

Given this scenario, how then would you track the inventory items?

If they do not truly belong to the company, they cannot be assets on the company's Balance Sheet. The other problem is the offsetting entry.

So, what if you use the Class and Sales Order for initially recognizing a consignment item? The item would be a non-inventory or Other Charge item. The Sales Order is a non-posting transaction and would not be a transaction on the books. To show multiple locations on reports, the company would have two options. Set up a custom field and supply the name for each location in the custom field or use the Class feature (if it is not reserved for another type). Set up the Class as a location. If the Class is used for some other type, set up a Customer called Consignment - Location #1. For each job under the Consignment customer, set up the real customer to whom the consigned items are sold. This allows tracking by inventory location. by the Customer "Consignment" or through Sales Order reporting.

Would this work?
 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
savagejim
savagejim
Questions asked: 0
Questions answered: 101
Points earned: 205
Intuit Solution Provider
Intuit Solution Provider
Intuit has teamed with a network of Intuit Solution Providers to deliver the personalized and professional services growing businesses need. Get help with finding the right solution, implementation, customization, integration, education, IT and accounting
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
savagejim
savagejim
Questions asked: 0
Questions answered: 101
Points earned: 205
Contributor
04/17/09 3:18pm PDT

In your Vendors list, create a new vendor for each consignment vendor.

Create an income account called Consignment Sales to track the consignment sales separately from the rest of the products you sell.

Create an other asset account called Inventory on Consignment to track the inventory of the consignment products you sell.

Set up consignment items for each consignment product (or group of products) you sell.

Create or customize form templates to record all of your consignment sales. Include the Consignor column on the customized sales receipt or invoice.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
eaton
53 secs ago
eaton
replied to
why is there is no option t...
Ampli899
23 mins ago
Ampli899
replied to
Why does quick books shut d...
QNE19638
23 mins ago
QNE19638
posted
error
Ampli899
29 mins ago
Ampli899
replied to
Wifi or 3G
Heidi4538
34 mins ago
Heidi4538
posted
Why does quick books shut d...
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business