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
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.
Well, convention would have the Sales entry indented to indicate a credit entry, but it doesn't work when you post it.
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.
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