1
   

Bookkeeping for consignment sales?

 
 
Reply Sun 20 Jun, 2004 06:09 pm
Hi,
I have a few items at two different consignment-type stores.

I need help doing the proper business bookkeeping for these transactions.

Store #1: I have free booth space, but pay the store 40% of each sale. So, let's say that store sells $100 from my booth. The store writes me a check for $60.

How do I put this in Quickbooks?

I have inventory items set up for each item I sell. This includes my cost for the item and my standard Retail Price.

Here's my problem: When I receive my monthy check for items sold at this store, I have to enter a Cash Sale which itemizes the items sold. But then, I don't know how to account for the 40% the Merchant gets.

Store #2: I pay a monthly rent for booth space, plus 8% commission on items sold. I receive a weekly report on my sales. The report starts with a negative $1,000 for rent. Then, as sales are made, the merchant takes his 8% cut, then applies the balance against the rent. Oh, if a customer buys with a credit card, an additional 2.5% is taken off those affected items.

Thus, $100 in sales, less 8% commission leaves $92. $1,000 - $92=$908.

If we don't sell enough to turn a profit, we write the store a check for the remaining negative balance. If we do turn a profit, the merchant writes us a check for the positive balance.

So here's the other bookkeeping problem. How do we account for the cost of the booth and the sale of the product as separate transactions when we actually only write or receive one check?

Thanks,

General Tsao
PS: We're using Quickbooks Basic 2004
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 5,605 • Replies: 4
No top replies

 
roger
 
  1  
Reply Sun 20 Jun, 2004 09:38 pm
I mostly know peachtree, but I'm sure a major program like Quickbooks will let you specify a different expense code for each separate cost. In Peach, each entry is on a separate line, whether you are recording a current expense and payment, or establishing a payable.

On the 40% commission, you just may have to do a general journal entry.

Cash $60.00
Sales discount $40.00
Sales $100.00

Cash and Sales Discounts being the debit entries, and Sales being the credit entry.

I'm sure I could handle this better if I'd ever used Quickbooks, but I'm sure they both have the same potential.
0 Replies
 
roger
 
  1  
Reply Sun 20 Jun, 2004 09:39 pm
Well, convention would have the Sales entry indented to indicate a credit entry, but it doesn't work when you post it.
0 Replies
 
cicerone imposter
 
  1  
Reply Sun 20 Jun, 2004 09:51 pm
Here's the first one:
The general ledger entries: DR CR
Dr Cash $ 60.00
Cr Inventory $ 10.00
Dr Cost of goods sold (inv) 10.00
Dr Selling cost 40.00
Cr Sales 100.00

Total of Dr & Cr must always equal
Therefore Dr = $ 110.00 and Cr = $ 110.00

The first two entries affects your balance sheet. The last three entries affects your income statement. Sorry, but A2K will not format correctly.
0 Replies
 
cicerone imposter
 
  1  
Reply Sun 20 Jun, 2004 10:00 pm
Here's the second one:
Dr or Cr Cash If you rec $, Dr If you pay, Cr
Cr Inventory
Dr Rent $1,000.00
Dr Sales commission *whatever the 8%
Dr Credit card expense $ XX.XX
Cr Sales
0 Replies
 
 

Related Topics

Spiegel Banner Ads - Discussion by cjhsa
Cartoons - Discussion by gollum
What is celebrity endorsement? - Discussion by LA girl1994
Is misleading advertizing a crime? - Question by Rickoshay75
Brand names for Solar products? - Question by kittycat94
Make some friends - Discussion by moody003
fob with t/t payment - Question by mjn
Logo design -- offensive or not? - Question by boomerang
 
  1. Forums
  2. » Bookkeeping for consignment sales?
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.07 seconds on 12/21/2024 at 08:18:42