Monthly income statement for a demi-fine jewelry store: the 12 lines that matter

Monthly income statement for a demi-fine jewelry store: the 12 lines that matter

Friday, seven p.m., counter at the Herreira retail store in Goiania. The salesperson closes the register: sixteen sales for the day, average ticket of R$ 420, gross total close to R$ 6,800. One client requested a return for a piece bought on Wednesday. Another paid in ten installments. The card terminal shows two debit transactions, eight credit installments, four Pix payments, and two cash. At month's end, this small day enters a spreadsheet that looks simple — revenue minus costs equals profit — but hides traps that quietly drag down a good store.

Most of the demi-fine jewelry resellers I know, especially those who opened in the last five years, do not have an income statement. They have a bank statement, an expense spreadsheet, and the feeling that the month was good because they sold well. The difference between knowing the month was good and merely having sold well is the income statement (DRE), in its monthly simplified version. This lesson delivers the twelve lines that matter for a demi-fine jewelry store up to R$ 500,000 per month — and shows three real scenarios for you to compare with your own store.

Counterintuitive thesis

Stores that grow in sales and shrink in profit are the norm, not the exception. The IBGE Monthly Trade Survey (PMC 2024) shows that jewelry and personal-use items grew 14.5 percent in sales in May 2024 versus the same month in 2023. But Sebrae Retail (2024) records that roughly three out of four micro and small fashion retail businesses end the year with EBITDA below their rent plus payroll. Without a DRE, you discover too late that the growth was in revenue, not profit.

Learning objectives

By the end of this lesson, the learner will be able to:

• Distinguish gross revenue, net revenue, gross margin, and contribution margin in the operation of a demi-fine jewelry store.
• Calculate the twelve lines of the simplified monthly DRE using data from the cash register.
• Assess whether the store generates operating cash or consumes cash, month by month.
• Diagnose which line is dragging down profitability — COGS, variable expense, fixed expense, or financial.
• Build personal benchmarks for the three typical demi-fine jewelry store sizes in Brazil.

Foundations: the 12 lines of the monthly DRE

A DRE is not a magic spreadsheet. It is the organized reading of what came in, what it cost, and what was left — in layers. The top layer addresses how much the store sold and how much of that it actually kept. The middle layer covers what it costs to put the piece in the showcase and in the client's bag. The bottom layer covers rent, payroll, banking, and taxes, which run the same each month even if the store sells nothing.

#### The three layers

The simplified DRE of a demi-fine jewelry store has twelve lines distributed in three blocks:

Block 1 — net revenue

1. Gross sales revenue — total recorded at the register before any deduction.
2. Returns and exchanges with cash out — pieces returned to inventory while the money went back to the client.
3. Tax deductions — Simples Nacional, ICMS substitution, ISS on services (stone setting, repair). In a Simples Nacional retail store, this typically runs between 4 percent and 11.2 percent of gross revenue, depending on the bracket.
4. Net revenue — line 1 minus lines 2 and 3.

Block 2 — operating margin

1. COGS (Cost of Goods Sold) — sum of acquisition cost of pieces sold during the month. In an 18k gold-plating demi-fine jewelry reseller, typical COGS sits between 35 and 45 percent of net revenue when buying directly from a factory like Herreira; it climbs to 50–58 percent when the store buys from an intermediary distributor.
2. Gross margin — net revenue minus COGS. In premium 18k gold-plated demi-fine jewelry, healthy gross margin is 55 to 65 percent of net revenue (Brazilian Jewelry Yearbook 2023, independent retail bracket).
3. Variable expenses — card fees, salesperson commission, outbound shipping, packaging. Runs between 7 and 11 percent of net revenue in a store with typical payment mix (BCB 2024 shows that installment credit weighs heavier in this mix).
4. Contribution margin — gross margin minus variable expenses. This is the line the manager watches to know whether each sale, on its own, pays its share of the rent.

Block 3 — bottom line

1. Fixed operating expenses — rent, condominium, prorated property tax, store payroll, payroll charges, electricity, internet, management software, maintenance. Does not change with sales volume.
2. EBITDA — contribution margin minus fixed expenses. It is the operating cash of the month before banking and before depreciation.
3. Depreciation and amortization — store renovation, showcase, fixtures, software (one-time investment spread out). Money does not leave the account this month, but it cost money one day.
4. Financial result — interest paid on receivables advancement, account maintenance fees, working-capital interest from Sebrae lines, IOF tax. In a store that advances a lot of receivables, this line becomes the difference between profit and loss.

Net profit = EBITDA minus depreciation minus financial result minus income tax owed on profit (under Simples it is already in the deductions, so usually zero here).

#### Three typical scenarios

The table below shows three real scenarios I know from Herreira resellers and partners, with rounded numbers for readability. Percentages refer to net revenue.

Notice three things. First, contribution margin in percentage is almost the same across the three sizes — those operating with a factory mix like Herreira preserve that percentage. Second, what changes dramatically across sizes is the leverage of fixed expenses: in the R$ 60,000 store, fixed expenses devour 80 percent of the contribution margin; in the R$ 500,000 store, they devour 56 percent. Third, financial result eats away percentage-wise more in the small store, which advances receivables more often to balance flow.

Step-by-step mechanism: how to build your DRE in four hours

This is the sequence I recommend for those who do not yet have a monthly DRE:

1. Hour 1 — Revenue. Export from the management system (or from the card terminal + Pix received + cash from the cash book) the total gross sold during the month. Separate exchanges with cash out from the total. Sum.
2. Hour 2 — COGS. Take each piece sold during the month and find its acquisition cost. In a system with proper records this comes ready. In a manual spreadsheet, do it from supplier reports and inbound invoices. Do not estimate. Sum.
3. Hour 3 — Expenses. Open the bank statement and the store's credit card invoice. Classify each entry as variable (card fee, commission, outbound shipping, packaging) or fixed (rent, payroll, electricity, internet, software). Group taxes paid during the month into the deductions line. Group banking interest and fees into the financial line.
4. Hour 4 — Analysis. Compute each percentage and compare against the table above. The line furthest from the benchmark is your first problem to attack the following month.

Personal decision — Patricia

At Herreira, I look at the factory DRE and the retail-store DRE separately every fifth day of the month, with my accountant beside me. I do not delegate. When gross margin drops two points, the first thing I do is open the SKU sales report — almost always it is a promotion that stretched too far or a batch I bought poorly. When financial result weighs more than two percent of net revenue, I stop advancing receivables and have a conversation with the bank about structured working capital. DRE for me is the car dashboard: you do not drive a store without watching it.

The client never sees the DRE. But she feels it when the store does not have cash to restock the piece she wants. She feels it when the salesperson is stressed because payroll was late. She feels it when the showcase has the same piece as last month because the owner does not have capital to rotate the mix. A well-built DRE is silent service to the client.

Practical next step

1. Before the next lesson, download the bank statement and card terminal invoice for the most recent closed month and classify every entry into the twelve lines.
2. Calculate the percentages and compare against the table for the size closest to your store. Note the three lines most outside the benchmark.
3. Schedule a one-hour meeting with your accountant or financial partner to review those three lines and define one action per line for the following month.