lamp.
ResourcesPricingAbout
5 min readBy

How to set up invoice-to-cash for a small business

Invoice-to-cash is the path from finishing a job to having the money matched in the bank. This guide shows how a small business can set up that path from scratch, with a few records and clear owners. It matters because a business can be busy and profitable on paper and still run short of cash if bills go out late or payments are never followed up.

Why this matters

Take a signage and printing firm in Jaipur with twelve staff and about sixty active customers. Jobs are finished in the shop, the owner sends bills when she has time, and payments arrive in the bank with only a name or a number. Some customers pay in ten days and others in ninety, and nobody can say who owes what without a long search. Setting up a simple routine means bills go out within a day, terms are known in advance and every rupee received has an invoice against it.

Before you start

  • A list of customers with contact person, phone, address and any tax registration details they have given you.
  • An agreed template for invoices with a numbering series that never repeats.
  • A customer ledger, where each customer has a page or section showing invoices, receipts and balance.
  • A promise log for payment follow-up.
  • Access to the bank statement, either online or a monthly copy.

Step by step

  1. The accounts receivable clerk raises the invoice from approved work only, for instance a signed job card or a delivery note. The invoice shows the job reference, the quantity, the rate and the date, and is issued within a day of completion so the customer still remembers the job.
  2. The sales manager records the payment terms and method in the customer ledger when the customer is first set up: how many days, which bank account, whether an advance is needed. For new customers the terms are agreed before the first job, not after the first bill.
  3. The owner reviews the bills above an agreed amount and sends them, with the payment details or a payment link from the bank, to the customer's accounts contact. The reply or payment advice from the customer is saved with the invoice.
  4. The accounts receivable clerk goes through the ledger every week and lists invoices that are due or past due. For each one the clerk contacts the customer, notes what was agreed in the promise log with a date, and sets the next check.
  5. When money arrives, the sales manager matches the receipt to the invoice using the bank reference, the amount and the customer name. If a customer pays several invoices together, the receipt is split against each one.
  6. The sales manager closes each invoice only when its balance is zero, and writes a note if anything was short, deducted or adjusted. Unmatched receipts are put on a short list and cleared by asking the customer.
  7. Each month the owner and the sales manager review the oldest invoices, decide which customers need changed terms, and agree what to do about any account that regularly pays late.

Invoices for taxable supplies must carry certain details and follow a fixed numbering pattern under indirect tax rules, and the rules can change. Check the current rule on the official portal or with your CA before acting.

Who does what

RoleWhat they doRecord they own
Accounts receivable clerkRaises invoices, runs the weekly overdue review, logs promisesInvoice and promise log
Sales managerSets terms, matches receipts, closes invoicesCustomer ledger and bank reference
OwnerSends or approves large bills, reviews late payersPayment advice and monthly review

Common mistakes

  • Sending the bill a week or two after the job, when the customer has already moved on.
  • Agreeing terms by phone and not writing them in the ledger, so a dispute has nothing to rest on.
  • Letting the person who sells also decide to write off a bad debt without anyone else seeing it.
  • Matching receipts by amount alone, which goes wrong when two invoices have the same value.
  • Chasing only the biggest customers while many small overdue bills add up unnoticed.

How to tell it is working

  • Days overdue. For each open invoice that is past due, subtract the due date from today and take the average. Track the number at the end of each month. A rising number means follow-up is slipping or terms are too generous.
  • Unmatched receipts. Count the receipts in the bank statement that have no invoice linked to them at month end. Divide by total receipts. The share should be small and should clear within a week.
  • Broken promises. Divide the promises with a passed date and no payment by all the promises made in the month. If the figure stays high for the same customer, change the terms or ask for advance payment.

Questions people ask

Who owns invoice to cash?

The sales manager owns the stream from terms to close, because that role holds the customer relationship. The accounts receivable clerk runs the daily work and the owner reviews. In a very small firm one person may do all of it, but the owner should still look at the ledger each month.

What is the minimum record for invoice to cash?

A numbered invoice, a customer ledger with terms, a promise log and the bank reference for each receipt. With these you can say what each customer owes, what was agreed and what has been paid.

When should a case stop?

An invoice stops when it is fully paid and matched, when a credit note settles the difference, or when the owner approves a write-off in writing. A customer who keeps ignoring reminders should be put on hold for new work rather than left in the chase list indefinitely.

Can a spreadsheet support this stream?

Yes, for a small customer base. Use one sheet for invoices with a status column, one for the ledger by customer and one for promises. Protect the invoice number column and agree who may edit each sheet.

What should the owner review?

The owner should look at the total outstanding, the oldest invoices, the broken promises and the receipts that have not been matched. A fifteen-minute review each week is better than a long one each quarter.

Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →