Small Business Bookkeeping Kit — Cash Book, Invoices, Profit & Loss (Excel + Google Sheets)

Your books, done in minutes a week

A complete bookkeeping system for small businesses, freelancers and shops, in one Excel and Google Sheets workbook. Record what comes in and goes out; the kit builds your profit & loss, tracks unpaid invoices and shows your numbers on a dashboard.

What's inside

• Cash book: date, description, category (dropdown), amount and payment mode. Income or expense is detected automatically, with a running cash + bank balance. Up to 1,000 transactions.
• Invoice generator: your business details, client, up to 10 line items, optional tax (GST, VAT or sales tax) and payment details. Print or save as PDF.
• Invoice register: paid, unpaid and partly paid invoices; overdue ones turn red, with days overdue counted for you.
• 12-month profit & loss: income and expenses by category and month, net profit and margin, built automatically from your cash book.
• Dashboard: yearly income, expenses, profit, outstanding and overdue invoices, plus two charts.
• Setup sheet: business name, currency, financial-year start, tax rate, opening balance and your own 30 categories.
• Step-by-step guide inside; formula cells protected against accidental changes.

Works anywhere

Any currency (INR, USD, GBP, AED, EUR…) and any financial-year start month. Tax on invoices is optional, so it suits businesses with or without GST/VAT registration.

Who it's for

Freelancers, consultants, shops, home businesses, small agencies and startups that want clear books without paying for accounting software.

What you need

Microsoft Excel 2010 or later, or a free Google account. No macros, no add-ins, no subscription.

Support

If the file doesn't open or a formula doesn't work as described, email me within 7 days and I'll fix it or refund you in full.

A record-keeping tool, not accounting, tax or legal advice. Confirm tax treatment with a qualified accountant.

Frequently asked questions

Who is it for?

Freelancers, shops, consultants and small businesses that want a simple cash book, invoices and a monthly profit and loss without accounting software.

Does it handle GST or VAT?

You can set a tax name (GST, VAT, Sales Tax) and rate for invoices on the Setup sheet, or leave it at 0%. It does not prepare GST returns.

Can I use my own categories and currency?

Yes. Edit up to 15 income and 15 expense categories and set any currency code on the Setup sheet.

How many transactions can I record?

Up to 1,000 transactions per file. Start a fresh copy each financial year.

Does it replace my accountant?

No. It keeps your records clean and organised so your accountant's work is faster. It is a record-keeping tool, not tax advice.

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. It also works in Microsoft Excel 2010 or later. No macros, no add-ins and no subscription.

I'm not good at Excel. Can I use it?

Yes. You only type in the yellow cells; every formula is already built and protected. A step-by-step guide sheet is inside the file.

Does it work on mobile?

It opens in the Google Sheets and Excel apps, but a laptop or desktop is much easier for regular work.

Is my data safe?

The file stays on your own computer or Google Drive. We never receive or see your data.

How do I pay and get the file?

Pay by PayPal or card worldwide, or by UPI, card or net banking in India. The download link appears instantly and is also emailed to you.

What if the file doesn't work?

If the file doesn't work as described and we can't fix it within 7 days, you get a full refund. Email us through the store's contact page.