Customer Tab Ledger: Free Template to Track Store Credit

Every neighbourhood shop runs some version of the tab. The regular who says 'put it on my account', the neighbour who is €12 short and 'will bring it tomorrow', the builder who settles at the end of the month. Informal credit is old, human, and often good business — regulars with tabs are loyal customers. The trouble starts when the tab lives in your memory instead of on paper. This page gives you a free customer credit ledger template, a ten-second method for recording tabs, and — the part most owners actually need — word-for-word scripts for asking people to pay without souring the relationship.

Why unwritten tabs quietly eat your profit

Do a quick, uncomfortable exercise: write down everyone who currently owes you money, and the amounts. Most owners who try this stall after four or five names and a lot of question marks. Now consider what the gaps cost. Say a small grocery runs 15 active tabs averaging €20 each — that is €300 of your money in other people's pockets. On typical corner-shop margins of around 20%, you need roughly €1,500 of fresh sales just to earn that €300 back if it never returns. And unwritten tabs have a way of never returning: not because your customers are dishonest, but because memory is soft on both sides. The customer sincerely remembers €10; you vaguely remember €18; nobody wrote anything down, so the friendlier number wins. Multiply that small, awkward discount by every tab, every month, for years. A written ledger doesn't make you less generous — it makes your generosity a decision instead of an accident.

Download the ledger (print and spreadsheet)

The template is free in two formats. The printable version gives each customer their own page — name and phone number at the top, then dated lines for each purchase and each payment, with a running balance. Shops that use it keep the pages in a small binder under the counter, one flip away. The spreadsheet version (Excel and Google Sheets) has a row per transaction and a summary tab that shows every open balance at a glance, sorted by size and by age — so 'who owes the most' and 'who has owed the longest' are always one look away. The columns in both: date, customer, what they took, amount added, amount paid, and balance. Nothing exotic. The value is not in the columns; it is in the fact that a number written at the moment of sale ends every future argument before it starts.

Recording a tab in ten seconds

• Write it while the customer is still at the counter — this is the golden rule. 'Let me just note that' takes five seconds and feels normal; reconstructing it two hours later is guesswork.
• Say the amount out loud as you write it: 'That's €14.50 on your tab, Rui — you're at €31 total now.' The customer hearing the running balance is half the collection work done for free.
• Record payments with the same care as purchases. A customer who paid €20 and doesn't see it written down loses trust in the whole ledger — and they'd be right to.
• One line per event, always dated. 'Since when' matters as much as 'how much' when you decide who to remind.
• Once a week, glance at the summary: total credit outstanding, and the three oldest balances. Two minutes, every Sunday. That's the whole management system.

Reminder scripts that don't lose you customers

• The gentle nudge (7 to 14 days, small amount): 'Hi Ana, hope all's well! Doing my books this week and I've got you down for €16 from the 3rd. No rush — whenever you're next passing.' Friendly, specific, dated. Specific numbers get paid; vague hints get forgotten.
• The natural moment (when they're in the shop): 'While you're here — want to settle the tab? It's at €23.' Said with a smile at the till, this is the highest-success, lowest-awkwardness reminder that exists.
• The bigger balance (over a month old): 'Hi Carlos, your tab's reached €85 and I try to keep accounts monthly — could you settle this week? Happy to split it in two if that's easier.' Offering the split turns a demand into a favour, and most people take neither offence nor the split.
• The repeat offender (paid late twice before): 'Happy to keep the tab going, but let's clear the current €40 first.' Future credit becomes the incentive to settle the past — no threat needed.
• What never to do: remind someone in front of other customers, guess at an amount, or apologise your way into 'don't worry about it'. You are not asking for a favour; you are collecting your own money, kindly.

Setting limits: when to say no to credit

A ledger tells you what is owed; a policy decides what you can afford to be owed. Three limits cover almost every small shop. A per-customer cap: pick a number you could absorb losing entirely — €30 or €50 for most counters — and pause new credit above it. An age limit: nothing rides past 30 days without at least a conversation, because balances that cross a month start feeling, on both sides, like they were gifts. And a total cap: decide the maximum credit your whole business extends at once — for many small shops around 5% of monthly revenue is survivable — and stop opening new tabs when you hit it. Saying no is easier when it's a rule rather than a judgement: 'Sorry, tab's at the limit — house policy' offends nobody, because it plainly isn't personal. The customers worth keeping accept it instantly. The ones who storm off over a €30 cap were, in accounting terms, never customers — they were slow-motion losses.

Moving tabs from paper to your phone

The paper binder has one honest weakness: it lives in the shop, and tab questions don't. The customer messages you on Sunday evening — 'how much am I at?' — and the binder is locked behind the counter. Your husband serves a regular on your day off and the tab goes unrecorded because he didn't know where the page was. The natural next step is moving the ledger to the device that is always with you: the phone. Some owners photograph the binder pages weekly; some move to the spreadsheet. The lightest version is recording tabs the same way you increasingly record everything else — as a message. 'Maria tab 12.50' typed into a chat takes the same three seconds as the paper line, but it is timestamped, searchable, readable from your sofa, and visible to whoever else works the counter. However you do it, the principle survives every format change: the tab that gets written down gets paid, and the one that doesn't becomes a discount you never meant to give.