A cash sale is paid for at the moment of sale, by cash, UPI or card, so the sale and the money arrive together. A credit sale is invoiced now and paid later, so the sale is recorded today but the money lands in your bank days or weeks afterwards. Keeping the two dates separate in your records is what stops you from mistaking unpaid invoices for money you have.
What is the difference between a cash sale and a credit sale?
- Cash sale: the customer pays on the spot. The sale and the money arrive on the same day, and no one owes you anything afterwards.
- Credit sale: you hand over the goods or finish the work and send a bill. The customer owes you until they pay.
- Part-paid sale: an advance now and the rest later. Record the advance as received and the remainder as still owed.
Despite the name, a UPI payment received at the counter is a cash sale in this sense: the money has already arrived.
Two sales at one shop
Hypothetical example for a hardware shop in November. On 5 November a walk-in customer buys fittings worth ₹4,800 and pays by UPI. On 8 November a contractor takes materials worth ₹12,000 on an invoice with 30 days to pay, and settles it on 8 December.
| Sale | Sale date | Amount | Money in bank on | Status at 30 November |
|---|---|---|---|---|
| Walk-in, UPI | 5 November | ₹4,800 | 5 November | Paid |
| Contractor, on credit | 8 November | ₹12,000 | 8 December | Owed |
In the sales list, November shows ₹4,800 plus ₹12,000, a total of ₹16,800. In the bank, November shows only the ₹4,800. The remaining ₹12,000 reaches the bank in December. Both pictures are correct; they answer different questions.
When is income recognised in your list?
For a sales list, record the sale on the date you bill it, whether or not it has been paid. This is the usual practice in an invoice list, and it is how you see what you have sold. Then add a column for the date paid. A blank paid column means the sale is still owed. Which basis your accounts must follow for tax or GST is a question for your CA, because the rules and timings vary and change.
How do you keep a simple list?
- Number each invoice and note its date, customer and amount.
- Add columns for due date, date paid and amount received.
- Mark cash and UPI sales as paid on the same day.
- Every week, filter to rows where the paid column is empty.
- Chase the oldest first and note each follow-up with a date.
Festival periods tell the story clearly. Before Diwali many shops sell heavily on credit to trade customers and collect weeks later, so October looks excellent on the sales list and thin in the bank. Anyone planning purchases from the sales list alone will overspend; plan them from the bank balance and the due dates.
What about a credit sale that never gets paid?
Do not quietly delete it. Keep it on the list marked unpaid, note your attempts to collect and discuss with your CA how a loss on an unpaid sale should be recorded. Deleting it hides a real problem and removes the evidence.
Where do you check the money side?
Your bank statement shows the date each payment actually landed. Compare it with the due dates on your list. SpendixAI is an expense tracker rather than a sales or invoicing tool, so the sales list stays in your sheet; the statement is simply the source of truth for payment dates.
A weekly check
- Tick off payments received since last week against the list.
- Total what is still owed and compare with last week.
- Look at which customers are past their due date.
- Note any advances taken so they are not billed twice.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

