Tech1News Business Khata – Complete Excel Pack

Manage Your Business Accounts Smarter! Small Business Accounting Excel

Are you still maintaining your business accounts in notebooks or multiple spreadsheets?

Introducing Tech1News Business Khata – Complete Excel Pack, a smart and organized Excel bookkeeping solution designed for small business owners, shopkeepers, freelancers, consultants, traders and service providers.

Manage your daily business transactions, cash and bank balances, invoices, sales, purchases, expenses, stock and optional GST calculations in one convenient Excel workbook.

No complicated accounting software. No monthly subscription. Just one organized Excel toolkit for your business.

16 Smart Sheets & Tools Included

1. User Guide

Step-by-step instructions with practical examples explaining how to use the workbook, record transactions, calculate GST and prepare invoices.

2. Invoice Maker

Create professional customer invoices with:

• Business and customer details
• Invoice number and dates
• Item descriptions and quantities
• Rate and taxable value
• Optional GST rate selection
• Automatic GST calculation
• Invoice total and balance due
• A4 printable invoice layout

3. Smart Dashboard

View important business figures in one place:

• Cash closing balance
• Bank closing balance
• Total available balance
• Sales and purchase totals
• Expense total
• Estimated net profit
• Indicative GST summary
• Receivables and payables

4. Business Settings

Enter your business name, financial year, opening cash and bank balances, optional GSTIN and GST rate settings.

5. Day Book

Maintain daily business transactions with voucher number, party name, transaction type, payment mode, debit, credit and narration.

6. Cash Book

Track cash receipts, cash payments and automatic running cash balance.

7. Bank Book

Maintain bank deposits, withdrawals, payments and running bank balance.

8. Sales Register

Record customer sales, invoice numbers, item details, quantities, rates, taxable amounts, GST, invoice totals, received payments and outstanding balances.

9. Purchase Register

Manage supplier purchases, bills, item quantities, purchase values, GST calculations, payments and outstanding amounts.

10. Expense Tracker

Record business expenses with expense categories, taxable amounts, optional GST, total amounts and payment details.

11. Party Ledger

View customer and supplier transactions by entering the exact party name.

12. Receivable & Payable Tracker

Track customer outstanding amounts and supplier payments with due dates and automatic pending/overdue status.

13. Stock Register

Manage item codes, opening stock, purchases, sales, closing quantities, stock values and reorder alerts.

14. Profit & Loss

Get a simplified business performance summary covering:

• Sales
• Purchases
• Gross profit
• Expenses
• Estimated net profit

15. GST Summary

View an indicative summary of:

• Sales Output GST
• Purchase Input GST
• Expense Input GST
• Indicative Net GST

16. Trial Balance

Use the manual trial balance working sheet to record and review account-wise debit and credit balances.

Optional GST Calculation System

GST is optional. You can choose the applicable GST rate for individual sales, purchase and expense entries.

Available dropdown rates:

• 0%
• 0.1%
• 0.25%
• 3%
• 5%
• 12%
• 18%
• 28%

If you do not want GST calculated for a transaction, select 0%.

The workbook automatically calculates the GST amount and total value.

Example:

Important: Selecting 0% only makes the workbook calculate zero GST. It does not automatically establish that a supply is legally exempt or nil-rated.

Professional Invoice Maker

Create and print invoices directly from the Invoice Maker sheet.

• Enter seller and customer details
• Add up to 10 invoice line items
• Select GST rate for each item
• Calculate taxable value and GST automatically
• Calculate invoice grand total
• Enter received amount
• Calculate outstanding balance
• Print using A4 page layout

Why Choose Tech1News Business Khata?

• Ready-to-use Excel workbook
• 16 organized sheets and tools
• Automatic formulas and calculations
• Separate Cash and Bank tracking
• Optional GST calculation system
• Professional printable invoice maker
• Customer and supplier management
• Business expense tracking
• Stock and inventory management
• PDF user guide with practical examples
• One-time purchase
• Lifetime download access

Who Can Use This Excel Pack?

• Small business owners
• Shopkeepers and retailers
• Freelancers
• Consultants and service providers
• Traders and distributors
• Startups and entrepreneurs
• Small offices and businesses

Product Information

Important Notes & Limitations

1. This is a digital product. No physical item will be shipped.
2. Microsoft Excel or a compatible spreadsheet application is required. Microsoft Excel is recommended.
3. The workbook includes optional GST calculations and an indicative GST summary. It is not GST return filing software.
4. GST rates, exemptions, place of supply, input tax credit eligibility and statutory invoice requirements must be verified separately.
5. Profit & Loss is a simplified management estimate and does not automatically account for all stock adjustments, depreciation, salaries and other accounting adjustments.
6. Trial Balance is a manual working paper and is not automatically generated from every register.
7. The workbook is a bookkeeping aid, not a replacement for professional accounting software or a qualified accountant.
8. Lifetime download access means access to the purchased download through your account, subject to website availability and applicable account terms.

Get Started Today!

Stop maintaining scattered business records.

Organize your cash, bank, invoices, sales, purchases, expenses, stock and business reports with one smart Excel toolkit.

Get Tech1News Business Khata – Complete Excel Pack today for just ₹149!

• Business Accounting Excel Template

• GST Excel Template

• Cash Book Excel Format

• Bank Book Excel Format

• Printable Invoice Maker Excel

• Sales and Purchase Register

• Expense Tracker Excel

• Stock Management Excel

• Profit and Loss Excel

• Small Business Bookkeeping

• Customer Supplier Ledger

• Business Khata Software Alternative