- Data Export for QuickBooks import
- Direct Integration
- Profit-Loss Reports
- Financial Statements
- BCSS Basics Video
- View this video (-->)
Merchandise placed on consignment with a reseller can be entered, tracked and sold using QuickBooks but as this discussion will bear out, QuickBooks is not a consignment-software program and as such makes the business of managing and selling consignments complex and confusing.
Enabling inventory tracking in QuickBooks Online Plus allows for consignments to be batch entered and edited. QuickBooks Online Plus tracks item quantity, sales and cost of goods sold.Activate inventory tracking with quantity on hand:
Print the Physical Inventory Worksheet for a physical inventory at your shop. Access the report under 'Manage Products and Inventory' on the Reports page.
Open the 'Products and Services page': Gear icon > List > Products and Services.
The Products and Services page displays all inventory quantities, costs, selling prices and so on.
Add individual items using the 'New' button or import from Excel (New > Import).
On the Product/Service information window, you may select one of the four types of items: Inventory, Non-inventory, Service and Bundle.
Consignment is the placing of new or used merchandise in the custody of is person or entity in the business of reselling others' belongings. Ownership of the properties remains with the owners who retain the inherent risks of property ownership but the responsibility for consignments may fall upon the consignee if a signed legal agreement doesn't stipulate to the contrary.
With QuickBooks Online Plus use the built-in inventory feature instead of tracking consignment sales manually. The program tracks consignment sold, payouts to consignors and produces reports. QuickBook users have reported that because this program is not a true 'consignment software', setup and use can be quite cumbersome.
There are five prerequisites for configuring QuickBooks to record consignment sales:
QuickBooks doesn't know about 'consignments' like dedicated consignment software does. It separates purchases and sales so there is no way to link a purchase with a sales order showing consigned items.
With consignment software, When an item is sold, the consignor and store are credited for their respective shares of the sales proceeds. Such programs have a great degree of flexibility and useful features like assigning a consignor percentage to each consignor and each consignment.
It's necessary to create two accounts in the Chart of Accounts to sell others' merchandise for a share of the sales proceeds.
As a developer of consignment software this design appears to be very complex and confusing. Take a look at consignment software below.
Consignments can be set up after other accounts are in place:
Price labels and hang tags can be printed from these pages: inventory, transfer slips, Price-Change-Reminders, Price-Manager and Physical-Inventory, and from purchase and receiving documents.
QuickBooks can 'handle' consignment but cumbersomely.
Business owners who own more than one shop and/or more than one business might find combining all businesses in QuickBooks useful but most consignment-software programs are complete inventory-sales-accounting programs, making QuickBooks and other 3rd-party accounting systems largely unnecessary.
The down side to the 'consignment software industry' is that there is no Microsoft or Intuit - a major software developer - providing consignment software, so the 'industry' is adulterated individual programmers mostly attempting to give the appearances of longevity and reliability.The fact is most consignment-software programs do the same basic things and if this page conveys nothing else: There is no software program for resellers that warrants $1,200+ up front ($100/month) and any software requiring an 'annual support fee' doesn't deserve a second look. For a good start and a solid basis for comparison, download the Best Consignment Shop Software demo and take advantage of the free live demo. During the demo you can verify:
Afterward, look further if you like. You'll find individual programmers trying to get as much as they can from every consignment shop that uses 'his' software. And for the love of money, don't bother with 'Consign-pro'.
The 'consignee' is the entity taking possession (not ownership) of the property of others for the purpose of reselling it and splitting the sales proceeds for a 'commission'.
The 'consignor' is the owner of merchandise who places his or her or its property with a reseller and who agrees to pay the seller a commission (only when sales are made).
Call 888-427-5779 for a free live demo prior to purchase to assure that all needed features are available and that the software works properly. The demo can be performed remotely and please note that this is not a 'sales call' but a software demonstration. Here's a video overview.