Connect with us

David Geller

David Geller: Computer Class

mm

Published

on

David Geller fires up QuickBooks, and shows you the first steps towards organizing your store’s accounts.

{loadposition davidgellerheader}

[h3]Computer Class[/h3]

[dropcap cap=I]t’s time to get down to the nitty-gritty. Last month, we introduced the theory of having separate income and cost of goods accounts in QuickBooks, and explained why this was the best way of keeping track of how well your store was doing. This month, we’re going to help you actually create those accounts.[/dropcap]

Quickbooks

To refresh your memories, for income, your three accounts were:
• Showcase Sales
• Special Order & Memo Sales
• Shop Sales (Repairs)

Advertisement

And for cost of goods, your complementary accounts were:
• Showcase Sales Cost of Goods
• Special Order/Memo Cost of Goods
• Shop Cost of Goods

So let’s make these now. Go into QuickBooks and go to the Chart of Accounts. The easiest way to get this is by typing “Control +A.” At the bottom left of that window is a small box titled “Account.” Click that and choose “new.”(See First Figure)

At the next window, you’ll see a menu called “Type” with the category “Bank” currently selected. Pull down the menu and change the selected category from “Bank” to “Income”. Then, in the “Name” box type “Showcase Sales”. Clicking on the “next” button saves the account you just created. Now that you’ve saved it, start with the next account. (See Second Figure)

Notice that the next window that comes up will automatically come up as an Income Account. Name the next account “Special Order/Memo Sales”. Click “next”, and do the same process for Shop Sales — or you can call it “Repair Sales”.

QuickbooksNow it’s time to create your “Cost of Sales” accounts. After clicking “next”, change the account type from “Income” to “Cost of Goods Sold”. Then, create a new category for “Showcase Cost of Goods”, click next, and create another for “Special Order & Memo COG”. Click next.
Now, it’s time to do our “Shop Cost of Goods”. In this case, we will continue to add sub-accounts under our Shop Costs. After you have created the “Shop Cost of Goods” and clicked “next”, do the following:

Type the name of the first cost of the shop, which is Jewelers Wages. Then right below the name is a small box titled “Subaccount”. Click the box and then the drop down arrow next to it will reveal the “Shop Cost of Goods” category. Choose it. Click “next” and then add the following sub-accounts one by one:
• Jewelers Wages
• Jewelers Matching Taxes
• Jewelers Benefits
• Findings/Gold/Mounting
• Small Shop Stones
• Gas & Oxygen
• Shop Tools

Advertisement

What you have just entered is sub-accounts that cover all the different costs of having a shop. And in the future, instead of choosing “Payroll Expenses” when you have to account for the paycheck of your jeweler, you choose “Shop Cost of Goods Sold: Jeweler’s Wages”

Then when you put all your shop sales in the income area, and all of your shop costs in the costs of goods area, you’ll finally know whether your shop is profitable or not.

QuickbooksOnce finished, your Chart of Accounts should look something like this (See Third Figure).

Next month, we’ll start to show you how to enter your sales into these accounts by using our Point-of-Sale program data and a simple journal entry. (If you don’t own a Point of Sale program, my “QuickBooks for Jewelers” program shows you how to use QuickBooks without a jewelry-specific point-of-sale program, but the simple fact is you’ll run your business better with one than without one. ) QuickBooks on its own is a poor inventory management program. Remember: we aren’t using QuickBooks for inventory management here, we’re using it for money management.

In the meantime, you can start using the “Shop Cost of Goods” we just created. But don’t start using the other income and cost of goods categories yet. Because we’ll have more to teach you on these next month.

Here’s a teaser for you. When you bring inventory into your jewelry store the bill or check is not for “Cost of Goods”. It’s an “Inventory Asset”.

Advertisement

Jewelry is an asset and stays that way until the day it sells. Then, and only then, does it magically transform itself into “Cost of Goods”.  
More next month.

David Geller is an author and consultant to jewelry-store owners on store management and profitability. E-mail him at dgeller@bellsouth.net.

[span class=note]This story is from the March 2005 edition of INSTORE[/span]

Advertisement

SPONSORED VIDEO

Les Georgettes

It’s All About Choices

With beautiful jewelry from Les Georgettes, choice is everything. Choose a design. Change colors. With 30 styles, 3 finishes and 48 stunning leather colors, you’ll never be at a loss for a unique piece of jewelry. Create, mix, stack and collect Les Georgettes by Altesse. Made in France.

Promoted Headlines

David Geller

Here Are a Few Tips You Haven’t Seen to Make the Most of Your Bridal Custom Designs

They’re simple yet brilliant.

mm

Published

on

IT’S 2019, AND it’s not your daddy’s jewelry store anymore. No more high margins on diamonds. Where’s the money now? The mounting.

Keystone is the goal, and many get it on the mounting, but comparison shopping can make it difficult. That said, the really big problem with selling from the showcase is the amount of inventory you must carry.

Video: How to Get Rid of Negative Thoughts in Your Work as a Jeweler
Jimmy Degroot

Video: How to Get Rid of Negative Thoughts in Your Work as a Jeweler

Video: How to Generate More Referrals for Your Jewelry Business
Jim Ackerman

Video: How to Generate More Referrals for Your Jewelry Business

Video: How to Show Your Jewelry Customers That You Truly Care
Jimmy Degroot

Video: How to Show Your Jewelry Customers That You Truly Care

On the other hand, custom designing an engagement ring has many advantages:

  • Higher profit margins
  • You pay for the item after you’ve collected money from the customer.
  • The customer feels like they are directing the process rather than being “sold.”
  • If you share the process of designing their ring with the customer, they will likely share with their friends and family. It’ll be on social media, texts and emails.
  • You can adjust which components go into the ring to more fit their budget.
  • Selling from the showcase has a closing ratio of 30 percent in most stores, but custom design has a closing ratio of 70-80 percent.

The downside? Someone must know how to design the ring, how it comes together and pricing. Training is essential, or having someone specific to sell the ring and lead the customer through the process. Figuring out how to price the item requires particular skills.

Here are some additional tips to make the most of your custom design process:

  • While designing the ring, if you use CAD/CAM, take a snapshot of the model on the screen and send it to the customer, saying something like, “Well, Jim has gotten started on your beautiful design.” If you hand-carve the wax or mill it, take a picture and send by text or email. Same goes for the casting process and another of the jeweler finishing up the ring.
  • When appropriate, send out a handwritten thank-you note.
  • Go to Office Depot and buy a pack of 100 sheets of do-it-yourself business cards. Make yourself a master blank company business card with no logo, just everything else about your store. Take a good picture of their new ring and paste it on the card, then print a sheet of 10 and have it in the envelope when you deliver the ring.

After they “ooh and aah” over the ring, tell them, “I’m glad you love it. You know, we have more customers come in from referrals than anything else and would love for you to refer family and friends. Here are some of our cards.”

Then plop them down on the showcase face up.

They will be so excited that they will not only place one on their refrigerator door, they’ll give them out to friends and show everyone how their ring is on “my jeweler’s business card.”

Isn’t this a fun business?

Continue Reading

David Geller

Close More Sales, Courtesy of David Geller’s Uncle Irv

These four “tricks” from an old sales pro will help you make more money in your store.

mm

Published

on

MY UNCLE IRV WAS the No. 1 car salesperson for every single dealership he ever worked for. When he retired in 1987, he was the No. 1 Jaguar salesman in the United States. Here are some tips I learned from Uncle Irv that will help you make more sales today.

TRICK 1

My Uncle Irv had a Rolodex, and while the salesmen on the floor waited for a “hot one,” Uncle Irv was calling his previous customers to see if:

  • They had friends looking for a car.
  • Their lease was up and it was time to buy.
  • They were getting tired of the older model he sold them years ago.

He made appointments while the rest sat around and waited.

Tip from Uncle Irv: Call your customers twice a year to just say “hi.” Contact them or their spouse about milestone dates for gift ideas.

TRICK 2

Uncle Irv fought in the Philippines, and at age 26, he was considered an “old soldier.” He told me they were preparing to go to battle and a 19 year-old started to cry. The sergeant came to the private and asked, “What’s wrong?”

“I’m scared, Sarge. I don’t want to go.”

The sergeant replied, “You don’t have to go, son. You just can’t stay here!”

In the 80s, I almost went bankrupt. Uncle Irv told me this story and said, “David, you just can’t stay here where you are now.” So, I got up enough gumption, fired half of my 16 employees, started over, developed the price book, and a year later, started to make it back.

Tip from Uncle Irv: You can’t keep doing things the way you have been. Times are changing and you must change, too.

TRICK 3

When Uncle Irv was the sales manager of a big Chevy dealership here, he had to motivate and train the sales staff, but also give them confidence when times were tough. You’ve had the same feeling: it’s getting close to having to make payroll, funds are low and you’ll take any price to get money into the bank account. Uncle Irv didn’t want to have the salesmen look at a walk-in customer as their last meal ticket and give away the farm.

Out of his own pocket, he gave each salesman three $100 bills to carry around at all times. He wanted them to feel like they didn’t need the sale, so that they wouldn’t discount so much.

Tip from Uncle Irv: In one way or another, throw money and jewels at your sales staff. Make them feel and look richer, and they will sell better. I used to let my staff buy or custom-make any piece of jewelry at 10 percent above our cost and take it out of their paycheck over six payroll periods.

TRICK 4

Uncle Irv told me that many salespeople are afraid of silence. He said, “Tell the customer the price and then shut the hell up!”

Scenario: You tell the customer $1,495 for the ring, and then there’s silence. Twenty seconds go by and you’re thinking “OMG, they aren’t saying anything. They are going to bolt or go online. Maybe I should give them a discount; I need this sale.”

Meanwhile, the customer is thinking, “Hmm, let me see — rent is due Friday, car note next week, summer camp dues in three weeks. No — I’m OK, I can do this.”

The first person who breaks the silence will give up their money to the person on the other side of the showcase.

Uncle Irv also brought his lunch every day. He told me, “I can’t afford a $500 hamburger.” (You’ll get it.)

Continue Reading

David Geller

Here’s How To Calculate How Much Your Jewelry Salespeople Should Earn

But that also requires that you let them make sales.

mm

Published

on

A JEWELER EMAILED ME this question: “I have always heard that a jewelry sales associate should sell 10 times what they make as a gross wage. Do you think it is still true today? What about associates with other responsibilities who aren’t always on the sales floor?”

Here’s your answer: 10 times sales as salary (or being paid 10 percent of what you sell) is “sort of correct.”

Podcast: Wisconsin Salesperson Uses Life Savings to Live Her Dream of Jewelry Store Ownership
JimmyCast

Podcast: Wisconsin Salesperson Uses Life Savings to Live Her Dream of Jewelry Store Ownership

Podcast: Making the World a Better Place in Steps Both Big and Small
Over the Counter

Podcast: Making the World a Better Place in Steps Both Big and Small

Podcast: From Tanzanite to Greenland Ruby, Hayley Henning Loves Selling Color
The Barb Wire

Podcast: From Tanzanite to Greenland Ruby, Hayley Henning Loves Selling Color

The number is actually between 8 to 13 times their pay. If they sell 8 times (or cost you 8 percent of their sales), they are very efficient. If their cost is closer to 13 percent, they are inefficient.

So if a salesperson is paid $35,000 a year, they should sell between $270,000 to $437,000.

But here’s the question: How much do you personally sell out of total sales of the store? That includes product sales, appraisals, repair and custom.

If the store does $700,000 in sales and you only wait on diamond customers and your sales are $500,000, then that leaves a remaining $200,000 available for sales staff to sell. So the salesperson is physically unable to sell even the minimum of $270,000, much less the higher end.

Take your sales away from the total and see what’s left for staff to sell.

Don’t tell me what they could do to bring in more sales. That’s an excuse. Why? Because you have to be the sales trainer.

You’d have to train them to:

  • Increase their average dollar sale.
  • Try to add on to what is sold to each customer. Goal would be add on to 25 percent of their sales.
  • Keep a client book of some type, keeping track of birthdays and anniversaries and contacting customers to remind them to buy something for these events. This starts with sending thank-you cards after every single sale.

If you’re too busy to be a sales manager, then don’t complain that they don’t sell enough.

What about employees who have other duties? That makes it impossible to sell 10 times their pay if they are only on the floor 15 hours a week out of 40. They would be considered “fill in.” Just pay a salary or wage and be done with it.

But if you wanted to pay them some type of bonus or commission plan, you’d figure out what percent of the week they are on the floor. So in this example, if the employee is on the floor 15 hours out of 40, then 38 percent of his workweek is selling. If he makes $35,000 a year, 38 percent of it is equal to $13,000 of his pay to be on the floor selling. Divide $13,000 by 0.08 and 0.13, and his sales should be $100,000 to $162,000.

There are many ways to compensate for excellence in selling. When I was a store owner, I paid straight percent of sales. You can pay a percentage of the gross profit, which ensures that the more they discount, the lower the percent of profit you pay. There are spiffs: sell these things over here and I’ll give you a set amount of money. There is share: if we all reach a goal amount this month, I will give everyone an amount of money. Or you can give things: sell so much or a particular item, and I’ll give you tickets to a show/fancy dinner out/day off/spa day.

All salespeople come to work with their car radio set to WIIFM: “What’s In It For Me.”

Continue Reading

Most Popular