Skip to content
Tutorials Center
My learning

Topics

Lesson 34 of 38 ยท Advanced Features

Cost Centres, Budgets and Multi-Currency in Tally Prime

Track income and expenses by department with cost centres, set budgets and compare them with actuals, and record foreign currency invoices with exchange rates.

Ledgers tell you what a business spends and earns, not who or where. Three advanced Tally Prime features add that detail: cost centres (split entries by department, project or branch), budgets (planned amounts to compare against actuals) and multi-currency (invoices in dollars, euros and others with exchange-rate gains and losses).

Tally is a desktop product, so the screens are described, and Python stand-ins reproduce the arithmetic. All names and amounts are invented.

Cost centres and cost categories

A cost centre is a label attached to part of a voucher. A cost category groups centres in parallel dimensions (for example "Department" and "Project"), so a single entry can be split two ways. They only apply to ledgers flagged Cost centres are applicable = Yes (usually income and expense ledgers).

Set up:

  1. F11 > Accounting Features > Maintain cost centres / Use multiple cost categories (wording varies).
  2. Create > Cost Centre, for example Sales Dept, Admin, Project Alpha, optionally under a cost category.
  3. In the expense ledger master, answer Yes to Cost centres are applicable.
  4. In a voucher, after you enter the ledger and amount, Tally shows a Cost Centre Allocation screen where you split the amount:
Voucher line Amount Allocation
Salaries 100,000 Sales Dept 60,000; Admin 40,000
Electricity 12,000 Sales Dept 4,000; Admin 8,000
Python Stand-in: total expense per cost centre

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Reports: Cost Centre Break-up, Cost Centres - Category Summary and the Ledger Break-up show totals, and you can drill into vouchers. Cost centres show P&L by department without creating a separate company.

Budgets

A budget records planned amounts for ledgers or groups over a period. Create one with Create > Budget: name, Period, Under (a parent budget), and for each ledger or group the budget type (On Closing Balance or On Nett Transactions) and the amount. Enable Budgets and controls in features first.

Compare actual and budget in Display More Reports > Budget & Controls > Budget Variance (or the P&L with a Budget column): it shows the budget, actual and variance per group, and you can drill down.

Python Stand-in: budget variance

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

For expense ledgers a positive variance means overspend. Voucher classes and budget controls let Tally warn or block when an entry pushes spending past the budget.

Multi-currency

Enable F11 > Company Features > Maintain multiple currencies (a company-level switch in some releases: Allow multiple currencies / Use multi-currency).

Setup:

  1. Create > Currency: symbol ($), formal name (US Dollar), ISO code (USD), decimal places and the conversion details.
  2. Set the base currency (for example INR) in company features.
  3. Enter exchange rates: Alter > Exchange Rates lists per-currency rates by date, with separate standard, selling and buying rates.
  4. In the party ledger (for example a foreign customer), choose the Currency of ledger.

Entering a foreign sale

In the sales voucher the foreign amount appears with the rate of exchange; Tally converts to the base currency and records both. If you receive payment later at a different rate, the difference is posted as forex gain or loss by a journal voucher that records the difference, or through the Forex Gain/Loss ledger you create. Without this adjustment, outstanding foreign balances stay at the old rate.

Python Stand-in: forex gain or loss on settlement

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The printed result is a forex gain of 1500.0, because the dollar rose between the invoice and the receipt.

Putting the features together

A consulting firm might bill a US client in dollars (multi-currency), record staff cost by project (cost centres) and compare quarterly cost against plan (budgets). Each feature adds one prompt to vouchers, so enable only what you will actually analyse.

Common mistakes

  1. Turning on cost centres for every ledger, which forces allocation prompts on every entry.
  2. Forgetting to update exchange rates, so conversions use stale rates.
  3. Budgeting by closing balance for a flow item such as sales, where nett transactions is the right basis.
  4. Not posting forex adjustments, leaving gains and losses buried.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What is a cost centre used for?

    Cost centres let you analyse entries by department, branch or project.
  2. 2. A budget shows 15,000 for Electricity and the actual is 12,000. The variance is:

    Actual minus budget is -3,000, an underspend.
  3. 3. You invoice $1,000 at 82.50 and receive at 84.00. What is the result?

    You received 84,000 against 82,500 booked, a gain of 1,500.
  4. 4. Which ledgers normally have cost centres applicable?

    Cost centres are used on profit and loss ledgers to analyse where costs and income arise.

Summary

  • Cost centres and categories split entries by department, project or branch.
  • Budgets store planned amounts; the variance report compares plan with actual.
  • Multi-currency keeps foreign amounts, exchange rates and forex gain/loss.
  • Enable only the features you will analyse; each adds prompts.
  • Keep exchange rates current and post forex adjustments.

Next: Security, backup and data management