Tools and templates

Small business templates for billing, stock, dues, and workshop records.

This page collects the CSV templates used most often by owner-led shops and service businesses. Each template is designed to help one business process become consistent before the team moves to full software.

Last updated: April 24, 2026

Templates are useful when a business already knows what it wants to record but has not yet standardized the format. They are not magic files. A sheet works only when the owner or assigned staff member knows what each column means, when the sheet should be updated, and who will review it. That is why every template on Rangpo Store is linked to a guide. The guide explains the business logic. The CSV simply makes the format repeatable.

For example, a daily cash closing file is not just a list of numbers. It is a routine for matching opening cash, sales, UPI, card payments, expenses, refunds, and the final difference. A stock audit sheet is not just a count list. It is a control process for comparing system quantity with physical quantity and then recording the reason for the difference. The same principle applies to customer due tracking, workshop job cards, and supplier payment review.

How these templates work

Each file is provided as CSV because the format opens in spreadsheet software without special tools. The best way to use a template is to keep one blank master copy and create a new dated working copy whenever you run the process. That makes review easier later because old records stay frozen and the owner can compare one week or month with another.

Use the smallest possible file first. If your shop has trouble matching cash at day end, do not begin by filling five different sheets. Begin with the daily cash closing template. If the main pain is credit customers, use the customer due tracker first. If the main pain is workshop disputes, begin with the job card template. A sheet should solve the biggest current problem, not add new clerical work everywhere.

Use cases by business type

Retail shop: use daily cash closing, stock audit, and customer due tracker.
Hardware or electrical store: use stock audit, invoice control, and supplier payment tracking together.
Repair workshop: use job card, customer due tracking, and parts or stock review.
Distributor or wholesaler: use supplier payment tracking and daily accounting discipline.

Before you download

Answer three questions first. What exactly will this sheet help you check? Who will update it? How often will it be reviewed? If these answers are not clear, the team will fill rows for a few days and then stop. That creates the appearance of control without real improvement. A practical template must fit the normal working rhythm of the business.

Keep the file simple. Avoid adding unnecessary columns just because a sheet can hold more data. A shop does not become more organized because the spreadsheet looks complicated. It becomes more organized because staff can complete the important columns correctly while the day is still busy.

Available downloads

Daily Cash Closing Template

Use for cash, UPI, card, refunds, expenses, and final difference review.

Stock Audit Template

Use for physical stock, system quantity, difference reason, and approval notes.

Customer Due Tracker Template

Use for invoice balances, partial payments, due dates, and reminder status.

Workshop Job Card Template

Use for complaint, diagnosis, parts, labor, approval, and delivery status.

Supplier Payment Tracker Template

Use for supplier bills, payment history, due dates, and next follow-up.

How to choose the first template without creating extra work

A common mistake is downloading every file on the same day and expecting the team to keep all of them updated. That usually fails because nobody owns the process. A better method is to begin with the one sheet linked to the biggest daily problem. If the drawer does not match at night, begin with daily cash closing. If staff keep saying stock should be there but cannot find it, begin with stock audit. If customers keep paying partially and no one knows the real balance, begin with the due tracker.

Once one sheet becomes part of the routine, the business can decide whether to keep using spreadsheets or move to software. The template is a test of process maturity. If the team cannot complete the important columns on a simple CSV, software alone will not fix the discipline problem. If the team can complete them consistently, software comparison becomes much easier because the owner already knows what fields and reports matter most.

When templates are enough and when they are not

Templates are enough when one or two people handle the process, the volume is still manageable, and the owner mainly wants clarity and consistency. Templates are no longer enough when multiple staff members need simultaneous access, approvals must be controlled by role, reminder workflows need automation, or the business wants reports without manual sheet review. At that point, the template still remains valuable because it shows the exact structure the future software must support.