Cost Centre in TallyPrime: How to Track Expenses by Department
Cost Centre in TallyPrime: How to Track Expenses by Department
Learn how to enable, create, and allocate cost categories and cost centres in TallyPrime. Step-by-step tutorial on cost centre reporting.
Who is this for: Step-by-Step Tutorial
As businesses expand, tracking general business expenses under broad heads like "Salaries," "Rent," or "Travel Expenses" is no longer sufficient. Management needs to know exactly which branch, department, marketing campaign, or employee is driving those costs.
Creating separate ledgers for every department (e.g., Salaries - HR, Salaries - Marketing, Salaries - Sales) quickly bloats the Chart of Accounts, making financial audits and reports difficult to parse. TallyPrime solves this issue through Cost Centres. Cost Centres allow you to segment and track financial transactions by project, team, or location without cluttering your general ledger accounts.
Cost Category vs. Cost Centre: Understanding the Difference
Before setting up cost allocations in TallyPrime, it is important to understand the relationship between a Cost Category and a Cost Centre:
- Cost Category: The parent dimension or classification group. It defines the broad segment you want to analyze (e.g., Departments, Projects, Sales Representatives, or Regional Branches).
- Cost Centre: The individual sub-units or nodes belonging to that category. These represent the actual cost collectors (e.g., under the Category "Departments," you would create Cost Centres like HR, Finance, and Marketing).
Step-by-Step: Configuring Cost Centres in TallyPrime
Follow these steps to set up department-wise expense tracking in your business:
Step 1: Enable the Cost Centre Feature
From the Gateway of Tally, press F11 (Features). Under the Accounting column, set Enable Cost Centres to Yes. Press Ctrl+A to save.
Step 2: Create a Cost Category
Go to Gateway of Tally > Create. Under the Master menu, click Show More, then select Cost Category.
Select Create New. Enter the category name (e.g., Projects). Set Allocate Revenue Items to Yes (this allows allocating sales/expenses). Set Allocate Non-Revenue Items to Yes if you also want to allocate capital assets or liabilities. Save.
Step 3: Create Cost Centres
Go to Gateway of Tally > Create > Cost Centre.
In the Category field, select the parent category you created in Step 2. In the Name field, enter the name of the cost centre (e.g., Project Delhi). Save the screen. Repeat for other projects or departments.
Step 4: Enable Allocations on Your Expense Ledgers
Go to Gateway of Tally > Alter > Ledger and select your expense ledger (e.g., Office Rent).
Under the ledger settings, set Cost Centres are applicable to Yes. Save. If you don't see this option, press F12 (Configure) inside the ledger alter screen and set "Apply Cost Centres for Ledgers" to Yes.
Recording a Transaction with Cost Centres
Now, when you enter a transaction that involves the configured expense ledger, TallyPrime will prompt you to allocate the cost:
- Go to Gateway of Tally > Vouchers. Open a Payment Voucher (F5).
- Debit the expense ledger (e.g., Office Rent A/c) and enter the total amount (e.g., Rs. 50,000). Press Enter.
- A Cost Allocations sub-screen will instantly pop up.
- Select the Cost Category (e.g., Projects).
- In the name field, select the specific Cost Centre (e.g., Project Delhi) and enter the amount allocated to it (e.g., Rs. 30,000).
- On the next line, select a second Cost Centre (e.g., Project Mumbai) and allocate the remaining Rs. 20,000.
- Press Enter to exit the sub-screen. Credit your bank or cash ledger, write a narration, and save.
Advanced Automation: Cost Centre Classes
If your business has pre-determined cost allocation percentages (e.g., rent is always split 60% to Sales and 40% to Administration), manually entering these splits during every transaction is tedious. TallyPrime offers Cost Centre Classes to automate this:
- Press F11 (Features) > set Enable Cost Centres to Yes > press F12 (Configure). Set Enable Cost Centre Class to Yes.
- Go to Gateway of Tally > Alter > Cost Centre Class (or define it during F11 configuration).
- Name the class (e.g., Standard Split).
- Assign the Cost Centres and specify their allocation percentages.
- When recording a voucher, select the Cost Centre Class at the top of the screen. Tally will automatically split the expense behind the scenes without prompting you.
Analyzing Cost Centre Reports
To view detailed break-ups of how your departments or projects are performing:
Go to Gateway of Tally > Display More Reports > Statements of Accounts > Cost Centres.
- Category Summary: Provides a high-level view of all cost categories and their net debit/credit totals.
- Cost Centre Break-up: Shows a list of all transactions allocated to a specific cost centre, giving you a project-wise Profit & Loss view.
- Ledger Break-up: Displays how a single ledger (e.g., Salaries) was distributed across various cost centres.
Simplify Vendor Bill Ingestion with TrulyInvoice
Using Cost Centres is incredibly powerful for financial analysis, but it significantly increases data entry complexity when combined with manual typing. TrulyInvoice simplifies this by automating the ingestion of your vendor bills.
TrulyInvoice reads the supplier name, invoice details, items, rates, and tax calculations automatically, pushing clean voucher payloads to Tally Prime. By combining TrulyInvoice's automated voucher creation with Tally's native Cost Centre Classes, you eliminate manual ledger typing and automate department allocations simultaneously.
Chartered Accountant & Accounting Automation Specialist