Tally Guide for Freelancers

Freelancers who need a reliable accounting engine often turn to Tally. This guide shows how to install Tally, configure GST, create invoices, track expenses, and avoid the pitfalls that waste time. Follow each step and you’ll have a working Tally system in under an hour.

Table of contents

• Conceptual Overview
• Installation & Initial Setup
• Core Workflows for Freelancers
• Advanced Patterns & Automation
• Common Mistakes & How to Fix Them
• FAQ

Conceptual Overview

Tally is a Windows‑based accounting suite that stores all financial data in a single company file. For freelancers, the most important concepts are:

• Ledger – a record of every account (Bank, Sales, Expenses).
• Voucher – a transaction entry (Invoice, Payment, Receipt).
• Group – a logical bucket that groups similar ledgers (Current Assets, Direct Expenses).
• GST Configuration – mandatory for Indian freelancers after July 2017.

Think of a Tally company file as a digital ledger book. Each voucher you enter updates the ledger balances automatically.

Installation & Initial Setup

1. Choose the right product

Two versions are actively supported:

Product	Cost	Key Features
TallyPrime 2024	₹9,999 (single‑user perpetual)	Modern UI, GST‑ready, multi‑currency, cloud backup
Tally ERP 9 (Trial)	Free for 30 days	Legacy UI, basic invoicing, no built‑in GST reports

Freelancers who need GST compliance should buy TallyPrime. The trial is useful for learning the basics.

2. Install on Windows

1. Download the installer from tallysolutions.com.
2. Run setup.exe and follow the wizard.
3. Choose “Single User” during license activation.
4. Restart the computer.

3. Create a company file

1. Open TallyPrime → Gateway of Tally → F3: Create Company.
2. Enter your freelance name, address, financial year (e.g., 01‑Apr‑2024 to 31‑Mar‑2025), and base currency.
3. Enable GST under “Statutory & Taxation”. Set your GSTIN.
4. Save. You now have FreelanceCo.tally in C:\Tally\Data\.

4. Set up basic ledgers

Use the following starter list. All amounts are in INR.

Ledger Name	Group	Type
Bank – HDFC Savings	Bank Accounts	Asset
Cash on Hand	Cash in Hand	Asset
Client – Acme Corp	Sundry Debtors	Asset
Service Income – Design	Sales Accounts	Income
Internet Expense	Direct Expenses	Expense
GST Payable	Current Liabilities	Liability

Core Workflows for Freelancers

Invoice creation (Sales Voucher)

1. Press F8 → “Sales” → “Invoice”.
2. Select the client ledger (e.g., Client – Acme Corp).
3. Enter item description, rate, and quantity.
4. Tally auto‑calculates SGST/CGST (9% each for standard GST). Verify the total.
5. Press Ctrl+A to accept and print/save as PDF.

Recording a payment (Receipt Voucher)

1. Press F6 → “Receipt”.
2. Choose the bank ledger (e.g., Bank – HDFC Savings) as the “Bank/Cash” account.
3. In the “Against Ref.” field, select the invoice number.
4. Enter the amount received and any bank charges.
5. Accept. The bank balance updates instantly.

Expense tracking (Purchase Voucher)

1. Press F9 → “Purchase”.
2. Select the expense ledger (e.g., Internet Expense).
3. If the expense is GST‑charged, add the tax ledger (e.g., Input CGST).
4. Enter the vendor name and invoice number for audit trail.
5. Accept.

Bank reconciliation

At month‑end, reconcile your bank statement:

1. Go to Gateway of Tally → Display → Bank Reconciliation.
2. Choose the bank ledger and set the statement date.
3. Mark each transaction that appears on the bank statement.
4. If a transaction is missing, create a “Bank Misc” voucher.
5. When the difference shows zero, reconciliation is complete.

Advanced Patterns & Automation

Recurring invoices

Freelancers with retainer clients can automate monthly invoices:

• Open Gateway of Tally → Accounts Info → Voucher Types → Recurring Vouchers.
• Define a template with client, service, rate, and GST.
• Set the recurrence to “Monthly on 1st”. Tally will generate the voucher automatically.

Export to Excel for tax filing

Use Tally’s “Export” feature:

1. Navigate to Display → Statements of Accounts → Ledger.
2. Select the ledger range (e.g., “Service Income – Design”).
3. Press Alt+E → “Export”. Choose “Excel (XLS)”.
4. Save the file and import it into your tax software.

Integrating with payment gateways

While Tally does not have a native API, you can use a CSV import:

• Export payment reports from Razorpay or PayPal as CSV.
• In Tally, go to Gateway of Tally → Import of Vouchers → Excel (CSV).
• Map columns: Date → Date, Amount → Amount, Transaction ID → Narration.
• Run the import. All payments appear as receipt vouchers.

Multi‑currency handling

If you bill overseas clients, enable foreign currency:

1. Activate “Multi‑Currency” in F12: Configure → Features.
2. Create a ledger for the foreign currency (e.g., USD). Set the exchange rate.
3. When invoicing, select the USD ledger. Tally will store the INR equivalent.

Common Mistakes & How to Fix Them

1. Skipping GST setup

Result: Invoices show no tax, leading to compliance penalties.

Fix: Go to Gateway of Tally → F11: Features → Statutory & Taxation. Enable GST, enter your GSTIN, and configure tax rates (9% SGST/CGST for most services).

2. Using default ledger groups

Result: Reports become cluttered, making it hard to see profit margins.

Fix: Create custom groups such as “Freelance Income – Design” and “Freelance Expenses – Software”. Move related ledgers into these groups for clearer Profit & Loss statements.

3. Not backing up daily

Result: Data loss after system crash.

Fix: Set up an automatic backup at F12 → Configure → Backup. Choose “Daily” and store the backup on a cloud folder like Google Drive.

4. Ignoring bank reconciliation

Result: Unmatched entries cause cash‑flow confusion.

Fix: Reconcile at month‑end. If differences persist, investigate duplicate entries or missing fees.

5. Mixing personal and business expenses

Result: Tax deductions become disputed.

Fix: Keep separate ledgers for personal expenses. Use a dedicated bank account for freelance work whenever possible.

FAQ

Do I need TallyPrime or can I use the free Tally ERP 9 trial?

TallyPrime is the current version with a more intuitive UI. The free ERP 9 trial works for basic invoicing but lacks newer features like GST‑compliant dashboards.

Can I run Tally on a Mac?

Tally runs natively only on Windows. Mac users can use Parallels Desktop, Boot Camp, or a cloud Windows VM.

How often should I back up my company data?

Back up daily if you invoice several clients per day. Use Tally’s built‑in backup schedule or a cloud sync service.

Is it safe to use Tally for multiple freelance businesses?

Yes. Create separate company files for each business. Tally lets you switch between them without mixing data.

What are the most common mistakes new freelancers make in Tally?

Skipping GST setup, using default ledger groups, and not reconciling bank statements are the top three errors.

With this guide you now have a working Tally environment, a set of core workflows, and a plan to avoid the usual pitfalls. Keep the backup schedule active and revisit the advanced patterns as your freelance practice grows.