Income and work

Cash and UPI sales for a family shop: a daily tally

Daily sales tally for a shop with cash and UPI: a simple template with card and credit sales, plus an evening check against the till and the UPI app.

Editorial illustration for Cash and UPI sales for a family shop: a daily tally

A daily sales tally has one job: at closing time, the money you think you earned should match the money you can see. Write sales by mode (cash, UPI, card, credit), count the till, check the UPI app's day total, and note any difference before you go home.

What columns does the tally need?

One row per day is enough for a small shop. Rows go down the page, one for each date; columns are below.

If two people share the counter, add an initials column and count the till at every change of shift, so a difference points to a shift and not to the whole day. On a day you open late or close early, still fill the row, with a note, so the gaps in the sheet mean something.

ColumnWhat it holds
DateThe trading day
Opening cashFloat left in the till from yesterday
Cash salesMoney taken in notes and coins
UPI salesTotal received by UPI that day
Card salesCard machine total for the day
Credit sales (udhaar)Sold today, not yet paid
Credit recoveredOld udhaar paid today, in cash or UPI
Cash paid outTea, small supplier payments, delivery from the till
Closing cash countedWhat you physically count

How do I do the evening check?

Two checks, both quick. First the till. Expected cash = opening cash + cash sales + credit recovered in cash - cash paid out. Count the till and compare. Second the UPI app: open your own UPI app's transaction history for the day and add up the money received, and compare with your UPI column. The way each app shows its daily totals differs, so check your own.

A worked day

Say the day's sales were cash ₹14,200, UPI ₹9,650, card ₹3,100 and udhaar ₹2,400. Total sales = 14,200 + 9,650 + 3,100 + 2,400 = ₹29,350.

  • Opening float: ₹5,000.
  • Old udhaar recovered in cash: ₹1,500.
  • Cash paid out: tea ₹150 and a small supplier payment ₹2,000, so ₹2,150.
  • Expected cash = 5,000 + 14,200 + 1,500 - 2,150 = ₹18,550.
  • Counted: ₹18,500, so the till is ₹50 short.

A ₹50 difference is small, but write it down. If it is ₹50 short every day, it is a pattern, not a rounding error. If it is ₹2,000 one day, you know the day to look at.

Why separate credit recovered from sales?

Because money recovered today was sold on an earlier day. If you add it to today's sales you count the same sale twice and your daily figure looks higher than it really was. Keep new udhaar in the sales columns and recoveries in their own column, and keep a separate list of who owes what.

  • Keep a second page for udhaar with the customer's name, the date, the amount sold and the amount received so far.
  • When a customer pays, tick it off there and enter the amount in the credit recovered column that day.
  • Once a month, add up what is still owed and compare it with the same figure a month ago. If it keeps growing, you are lending more than you are collecting.

What about the household cash that comes from the till?

Write it as a draw, not a shop cost, and not in cash paid out. Otherwise your daily numbers hide what the home is taking. At the end of the month, add up the draws and compare with profit.

Does SpendixAI belong here?

Only for the home side. The daily shop tally belongs in your own sheet or book. If you upload your personal account's statement to SpendixAI, you can see how the draw you take from the shop gets spent, with cash spending added by hand.

Closing routine

  1. Count the till twice before writing the number.
  2. Total the UPI and card receipts and compare with the apps.
  3. Fill the row, note any difference, and initial it.
  4. Set aside the next day's float before taking money out.
  5. Once a week, total the month so far and keep the sheet with your stock records.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports