What Is a Kitty Ledger? Simple Guide for Jewellers

A member walks up to your counter and asks a simple question. How many months has she paid, and how much is left? Your staff opens the register and starts turning pages. Her payments are there, but they are scattered across three months of entries, mixed with every other member. She waits. The customer behind her waits too.

The register is not wrong. It is just the wrong book for this question. The book that answers it is the kitty ledger, and many shops either do not keep one or keep it badly.

What is a kitty ledger in simple words?

A kitty ledger is a record sorted by slot instead of by date. Each slot in the kitty gets one page, and every payment for that slot is written on that page, month by month. When a member asks where she stands, you open one page and read the answer. Nothing else is on that page.

A quick word on names. Many shops use "register" and "ledger" for the same book. In this guide they are two books, because they do two different jobs.

If the kitty itself is new to you, start with our guide on how a gold kitty and its monthly draw work. For schemes without a draw, the pillar guide explains what a gold saving scheme is from joining to redemption. The ledger idea is the same for both.

What does one kitty ledger page look like?

One kitty ledger page has a heading and eight columns. The heading carries the member number, the member name and the slot number. The columns are month, due date, paid on, amount, mode, receipt number, total so far and taken by. Every month of the kitty has its own line, paid or not.

The drawing below shows one page for one member. The names, numbers and dates are examples.

Read the page from left to right.

• Month. Which instalment this line is for. Month 1, Month 2 and so on.
• Due date. The date the payment should arrive. Write it on the first day, for every month.
• Paid on. The date the money really came. In the drawing, Month 2 came early and Month 3 came four days late.
• Amount. What was paid on that date.
• Mode. Cash, UPI, card or bank transfer.
• Receipt no. The number on the receipt you gave the member. This is the link back to the register.
• Total so far. Everything paid on this slot up to this line.
• Taken by. The staff member who took the payment, so a question can be answered the same day.

Now look at Month 4. The due date is written, and the rest of the line is empty. That empty line is the most useful thing on the page. In a register, a missed payment is invisible, because nothing was written. In a ledger, a missed payment is a gap you can see from across the counter.

One page per slot, not one page per member

This is the detail most shops get wrong. A member who holds three slots makes three payments a month. Each slot may have its own place in the draw. If you keep all three on one page, a missed payment on one slot hides behind the other two.

So open one page for each slot, and write the same member number at the top of each. When the member visits, you pull her three pages together. When the draw comes, you check each slot on its own.

What is the difference between a kitty ledger and a register?

The register records every payment in the order the money arrives, with all members on the same page. The kitty ledger sorts the same payments by slot, one page each. The register answers "what did we collect today?" The ledger answers "where does this member stand?" They hold the same payments, sorted two ways.

The chart below puts the two side by side.

Start with the register. It has one line for every payment, written in the order money arrives. All members share the same page. You check it against cash and UPI every day, because it is your record of the day. Our guide on keeping a gold scheme register with the right columns covers that book in full.

Now the ledger. It has one page for every slot, written month by month for that slot. One member is on the page, and nobody else. You check it against the register every week.

Neither book replaces the other. With only a register, you can close the day but you cannot answer a member quickly. With only a ledger, you can answer the member but you cannot match the cash drawer. Skip one book and the missing job gets done from memory.

How do you write a kitty ledger, step by step?

Open one page per slot, write every month and due date on the first day, and copy each payment from the register to its page on the day it arrives. Update the total so far on every line. Check the ledger against the register once a week, and close the page in writing at maturity.

1. Number everything. Give every member a number and every slot a number. Names repeat. Numbers do not.
2. Open one page per slot. Write the member number, name and slot number at the top.
3. Write all the months on day one. Fill the Month and Due date columns for the whole kitty before the first payment. This is what makes a missed month show up as an empty line.
4. Copy from the register the same day. Before the shop closes, take the day's register and copy each payment to its ledger page. Accountants call this posting.
5. Update the total so far. Add the new payment to the last total. Do it on every line, not at the month end.
6. Check every week. Use the two book check described below.
7. Close the page. At maturity, write the final total, the bill number and the date, and let the member sign.

Step four is where most paper ledgers fail. The register gets filled because money is changing hands. The ledger gets filled "later", and later becomes the month end.

A worked example: one slot over four months

Here is the page from the drawing, with amounts filled in. Every amount is an example, chosen to keep the sums easy. The kitty in this example runs for fifteen months at Rs 3,000 a month per slot.

1. Customer A joins and takes slot 21. You open a page and write Month 1 to Month 15, each with the 5th as the due date.
2. Month 1 is paid in cash on 05 April. Receipt R-0107. Total so far is Rs 3,000.
3. Month 2 is paid by UPI on 03 May, two days early. Receipt R-0168. Total so far is Rs 6,000.
4. Month 3 is paid in cash on 09 June, four days late. Receipt R-0231. Total so far is Rs 9,000.
5. Month 4 is due on 05 July. The line is empty.

Now the member calls and asks where she stands. You open one page and tell her: three months paid, Rs 9,000 so far, Month 4 is due. If she doubts Month 2, you read out the receipt number and the date. The call is short, and she trusts you a little more than before.

The page also tells you something she did not ask. She paid early once and late once. If Month 4 stays empty past your grace days, this is a member to remind gently, not to chase hard. For the full method, see our guide on stopping late payments before they become a habit.

What if slot 21 wins the draw?

What you write depends on your own kitty rules, so check them first. Draw rules also differ by state, and you should confirm yours with your own adviser. In the kitty format our product follows, a winning slot stops being billed, the shop covers its remaining instalments, and the slot still redeems its full value at maturity.

If your kitty works that way, do not leave the remaining months empty. Write "Covered by shop" on each line. An empty line means a missed payment. A marked line means a promise kept. Six months later, nobody should have to remember which one it was.

Ledger words explained

Ledger language comes from accounting, and it can sound harder than it is. Here are the words you will meet, in shop terms.

Two of these deserve a closer look. "Posting" is simply copying a payment from the register to the ledger page. It is the step that takes the most time by hand, and the step where most mistakes enter. "Correction entry" is a rule as much as a word. You fix a mistake by adding a new line, and the old line stays readable.

The two book check you can do every week

This is a check you can start this week. It needs no software.

1. Register to ledger. Pick any five receipts from this week's register. Find each one on its ledger page. The date, the amount and the receipt number must match.
2. Ledger to register. Pick any three ledger pages. Take the last entry on each and find it in the register.
3. Count the gaps. Turn through the ledger and note every slot with an empty line past its due date. That is your follow up list for the week.

If every check passes, your two books agree. If one fails, you have found a mistake while it is a few days old. Found by the customer, the same mistake is a dispute.

This kind of slip is one of the quiet ways a scheme loses money. We have listed the others in our breakdown of where a manual gold scheme leaks money.

Common mistakes in a kitty ledger

• One page for a member with many slots. The slots blur together. Keep one page per slot.
• Writing months only when they are paid. Then a missed month leaves no mark. Write every month and due date on day one.
• Filling the ledger at the month end. The work piles up and the mistakes pile up with it. Copy from the register daily.
• No receipt number on the line. Without it, you cannot trace the entry back to the register or to the member's own receipt.
• Erasing or overwriting. A page that has been scratched out looks like something is being hidden. Strike through once, write a correction entry, and initial it.
• Only one person can read the book. If the ledger makes sense to one staff member only, it is a private diary, not a shop record.

Where does a paper or Excel ledger stop working?

A hand kept ledger stops working when copying from the register takes more time than your staff can give. Every payment is written twice, once in each book, and every copy is a chance for a mistake. The work grows with every new slot, and the ledger cannot remind anyone or show the member her own page.

These are the limits I saw while building scheme software with a working jewellery store.

• Payments in different places. Cash is in the drawer, UPI is in the bank app, card slips are by the machine. Each has to be found before it can be copied.
• The member cannot see it. Her proof is a card or a slip. Yours is a book behind the counter. When they differ, there is nothing neutral to settle it.
• The book cannot speak. It shows you the empty line only when you open the page. Someone still has to call or send a WhatsApp message.

Excel removes some of this. A filter can turn your payments sheet into a ledger view in seconds, so nothing is copied by hand. But a shared file brings its own risks, which we cover in our guide on whether Excel is safe for your gold scheme.

Software removes the double writing fully. A payment is entered once, and it appears in the day's list and on the slot's page at the same moment. If you are curious about the steps, read how to move a running scheme from paper to software before you speak to any vendor.

When is a separate ledger not worth it?

A separate ledger is not worth the effort for a very small kitty where one person takes every payment and knows every member. If you can answer any member from the register within a minute, and your gaps are few enough to remember, a well kept register and a numbered receipt book are enough for now.

Ask yourself three questions to decide.

• Can you tell any member her total and her pending months while she stands at the counter?
• Can you list every slot that is overdue today without reading the whole register?
• Could another staff member do both if you were away for a week?

If all three answers are yes, stay as you are. If one is no, start a paper ledger this week using the page format above. It costs you a notebook. If the paper ledger then takes more hours than you can spare, that is the time to look at software, not before.

Software also has limits. It will not fix unclear kitty rules or staff who do not enter cash payments, and it has a running cost every year, not only a price on the first day.

Our take

The software does not run the scheme. Trust does. A kitty ledger is where that trust is written down, one slot at a time. When a member asks where she stands and you answer from one page, with a receipt number for every line, you have turned a promise into a record nobody can argue with.

We built GoldKitty hand in hand with a working jewellery store, and the ledger was one of the first things that store asked for. Every slot has its own ledger and statement. Cash, counter UPI and in app payments land in one list, so a payment is entered once and reaches the right slot. Members see their history with numbered receipts in the app. Those without the app get receipts and reminders on WhatsApp. It is white label, which means members see your shop's name and not ours.

It is also modular. It is set up for each shop according to its country and its offer, so your kitty rules are configured for you, and payments run through local payment gateways that follow the banking guidelines of your market.

If you would like to see your own kitty's pages inside it, you can book a private demo of our kitty software. You can also look through the other products we have built. If your paper ledger passes the two book check every week, keep it. A ledger that agrees with its register is doing its job, whatever it is written on.

Frequently asked questions