Cost Centre Allocation In Tally.Prime

Cost Centre Allocation

You can maintain your incomes and expenses, as per different business units, employees, projects, departments, and so on, using the Cost Centre capability in TallyPrime. You can have one or more cost centres in your company, as needed, and allocate the breakup of incomes and expenses to different cost centres. TallyPrime provides reports that help you to view income and expense groups with the cost centre allocations made under each group. Similarly, there are reports displaying list of cost centres along with the corresponding incomes and expenses under each cost centre. You can also allocate the same income or expense to different sets of cost centres in parallel, say employee-wise as well as project-wise, by using Cost Category for the respective Cost Centres.

Create & group cost centres: Like other Masters, such as Stock Group, Stock Category, Godown, and Ledger Group, you can create individual cost centres or multiple cost centres in a hierarchy.

Note: You can use cost centres to create a hierarchy of different business units, and continue to see details of the expenses at the top level as well as at each individual level.

Create cost category: If an expense or income is allocated one cost centre and the same is also allocated to a different cost centre for reporting purposes, you can use the Cost Category feature in TallyPrime. This help for parallel allocation of the same amount across different cost centres and view them accordingly – cost category-wise.

Reports: The Cost Centre Breakup report gives you the view of incomes and expenses incurred for a cost centre. You can also explore other cost centre reports and view allocations cost centre-wise, month-wise, and so on. As in any other report, you can explode and drill down to view the details. At the last level of drill-down, you can alter the contributing transactions, if needed.

 

Use Cost Centres for Allocation of Incomes and Expenses

If you have incomes and expenses, such as staff welfare, projects, employees, payment recovery, conveyance, and so on, and want to maintain them as per business unit, employee, project, department, and so on, create Cost Centre.

In this section

 

Create Cost Centres

If you are creating Cost Centre for the first time, TallyPrime prompts you to enable Cost Centre for the company. These cost centres will be available for allocation while recording transactions.

  1. Gateway of Tally > Create > Cost Centres > press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Cost Centres > press Enter.
    In case the feature is inactive, you will be prompted to activate the Cost Centres feature. Select Yes or press Y to proceed.
  2. Name & alias: Provide a name. As in other masters, you can specify multiple aliases.
  3. Under: Select Primary or an existing cost centre.

    What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options. Alternatively, press Ctrl+I (More Details) to enter any of the values without activating the F12 options.
  4. Accept the Cost Centre master. As always, you can use Ctrl+A to save.
    Click here to see the possible F12 Configurations.

While you are creating a cost centre, if there is a need to create another Master, say a Stock Item or a Bank Ledger, press F10 (Other Masters) and switch to the desired master screen. After creating the other Master, you can continue from the same place on the Cost Centre screen where you had left last.

 

Create multiple cost centres in one-go

You can create multiple cost centres from one screen. Use the multi-master creation and alteration feature for this.

  1. Gateway of Tally > Chart of Accounts > Cost Centres > press  Enter.
  2. Press Alt+H (Multi-Masters) > select Multi Create > and press Enter.
    In case the feature is inactive, you will be prompted to activate the Cost Centres feature. Select Yes or press Y to proceed.
  3. Enter the Name of Cost Centre and select the cost centre under which it is being created. You can also select Primary cost centre.
  4. Accept the Cost Centre master. As always, you can use Ctrl+A to save.

To alter multiple cost centres in one-go, 

  1. Gateway of Tally > Chart of Accounts > Cost Centres > press  Enter.
  2. Press Alt+H (Multi-Masters) > select Multi Alter > select the cost centre or Primary > and press Enter.
  3. Update the details as needed.
  4. Accept the Cost Centre master. As always, you can use Ctrl+A to save.

 

Cost centre allocation in transactions

Consider the example of staff members – Staff A and Staff B – travelling across the country to conduct events, such as training and demo sessions at the client location. The expenses incurred by the Staff A and Staff B are: Travel expenses of Rs. 15,000 and Rs. 20,000; purchase of stationery items worth Rs. 6,000 for Rs. 4,000; and advertisement expenses of Rs. 11,000 and Rs. 9,000, respectively. These expenses can be recorded by allocating the amounts to the cost centres – Staff A, Staff B. At the same time, the company also received commission as income of Rs. 15,000. Allocate Rs. 9,000 to Staff A and Rs. 6,000 to Staff B. Similarly, you can create more than one cost centre group, as needed to allocate expenses and incomes and view the bifurcation of the total amount cost centre-wise.

Before recording a transaction, ensure that the option Cost Centres are applicable is set to Yes in the corresponding ledgers. By default, this option is set to Yes in the income and expense ledgers, whereas it is set to No in the asset and liability ledgers.

Once you create a cost centre, TallyPrime will prompt you to allocate your incomes or expenses to the relevant cost centres when recording transactions. You will need to allocate the total expenses or incomes against one or more cost centres. You can also allocate cost centres to party ledger, sales account, and so on. The payment voucher with cost centre allocation, appears as shown below:

What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options. Alternatively, press Ctrl+I (More Details) to enter any of the values without activating the F12 options.

The receipt voucher with cost centre allocation, appears as shown below:

 

Use Cost Centre Groups to View Business Unit-wise Allocation

As always, you can create multiple cost centres in a hierarchy to get a consolidated view of the allocation made to each business unit, employee, project, department, and so on.

To get a hierarchy of cost centres as in the sample for Staff A and Staff B:

  • Create the cost centre Staff.
  • In the cost centre alteration screen, select Staff in the Under field for Staff A and Staff B.
  • Similarly, if you need to create cost centres next time under Staff B, in the field Under, select Staff B.

 

Track Income and Expenses Incurred Cost Centre-Wise

The Cost Centre Breakup report gives you the income and expense allocated to the selected cost centre. As in any other report, you can explode and drill down to view the details. At the last level of drill-down, you can alter the contributing transactions, if needed.

In the section

 

Breakup of Cost Centre

Press Alt+G (Go To) > type or select Breakup of Cost Centre.

Alternatively, Gateway of Tally > Display More Reports > Statements of Accounts > Cost Centres > Cost Centre Break-up.

The Cost Centre Breakup report, gives you the ledger-group-wise view of incomes and expenses incurred and allocated to the selected cost centre.

What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options and F11 (Features) to enable or disable features.

 

Explode/Collapse

  • You can press Shift+Enter to see the next level of data for the selected line on the same screen. You can also move to any of the lines in the next level and further explode the selected line using Shift+Enter.
  • To view the details of all the groups in one-go, press Alt+F5 (Detailed). Further, use F12 (Configure) > Expand all levels in Detailed format to see all levels of data for the same cost centres. You can toggle between the Detailed and Condensed formats of the reports using Alt+F5 (Detailed).

    What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options and F11 (Features) to enable or disable features.
  • Press Enter on the selected line to show the next level of data on a new screen.

    What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options and F11 (Features) to enable or disable features.
  • With further drill-down, you can press Enter to open the monthly summary report.

 

Compare Business Data

You can compare the cost centre details by adding columns. For example, if you want to compare the ledger-wise details of Staff A and Staff B, open the Cost Centre Breakup report for Staff A, press Alt+C (New Column) and select Staff B.

What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options and F11 (Features) to enable or disable features.

  • Press Alt+N (Auto Column) to repeat the columns of the current report based on the selected option.
  • If you want to compare data of more than one company using auto column button, select Company as the type. The Company option is available when more than one company is open.
  • Additionally, you can alter the columns using Alt+A (Alter Column) and delete columns using Alt+D (Delete Column).

 

Cost Centre Summary

Press Alt+G (Go To) > type or select Cost Centre Summary.

Alternatively, Gateway of Tally > Display More Reports > Statements of Accounts > Cost Centres > Cost Centre Summary.

This report displays the summary of incomes and expenses allocated to different cost centres.

The detailed view (press Alt+F5) of the report appears as shown:

What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options and F11 (Features) to enable or disable features.

If you have been using cost centres without creating any cost category, TallyPrime considers all cost centres under an internal category called Primary Cost Category.

 

Cost Centre Monthly Summary

Press Alt+G (Go To) > type Cost Centre Monthly Summary.

Alternatively, you can drill-down from the Cost Centre Summary report.

You can view the monthly breakup of income and expense details along with the closing balance for the selected cost centre.

What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options and F11 (Features) to enable or disable features.

Select the required month and press Enter, to view the Cost Centre Vouchers report.

 

Use Cost Category for Parallel Allocation

If you allocate the same incomes and expenses to parallel sets of cost centres, create cost categories for parallel allocation.

For example, as explained earlier for cost centres, the expenses incurred by Staff A and Staff B can be allocated in parallel for the purpose of training and demo. Create Head Office as a Cost Category for the cost centres Staff A and Staff B. Similarly, create Events as the Cost Category, with Training and Demo as cost centres. While recording the travel expense of Rs. 35,000 (as per the earlier example), allocate Rs. 15,000 to Staff A and Rs. 20,000 to Staff B under the category Head Office. In parallel, allocate the same Rs. 35,000 for Training (Rs. 23,000) and Demo (Rs. 12,000). Similarly, you can do parallel allocation for stationery and advertisement expenses or commission For Stationary of Rs. 10,000, allocate Rs. 6,000 for Staff A and Rs. 4,000 for Staff B (under Head Office), and in parallel allocate Rs. 7,000 for Training and Rs. 3,000 for Demo (under Events).

TallyPrime considers all cost centres under an internal category called Primary Cost Category. When you create another cost category, all your earlier transactions will reflect under it.

You can rename the Primary Cost Category any time. As in the case of other masters, if you alter anything in Cost Category Masters, the changes will reflect in corresponding transactions and reports. You can delete a cost category if no cost centres have been grouped under it.

Note that after you have created another cost category, you can group the cost centres under the cost category of your choice, including the default Primary Cost Category.

 

Create Cost Category

When you create a Cost Category in TallyPrime for the first time, you are prompted to alter the existing internal Primary Cost Category that has all the Cost Centres grouped.

  1. Gateway of Tally >Create > type or select Cost Category > press Enter. You can also create Cost Category from Gateway of Tally > Chart of Accounts.
    Alternatively, press Alt+G (Go To) > Create Master > type or select Cost Category > press Enter.
    When only the Primary Cost Category is available, you will be prompted to create new Cost Category or alter the existing Primary Cost Category. Select Create or press C to create a new cost category.
  2. Name & alias: As in other masters, you can specify multiple aliases.
  3. Allocate Revenue Items & Allocate Non-revenue items – Ensure that one of these options is set to Yes.
    Note: Revenue items are all your expenses and incomes and non-revenue items are assets and liabilities. TallyPrime provides the flexibility to group cost centres for non-revenue items under cost category, if needed.

    What you see on the screen can vary based on your choices. PressF12 (Configure) to change the options. Alternatively, press Ctrl+I (More Details) to enter any of the values without activating the F12 options.
    Fields on the Cost Category master will appear or disappear based on the changes you make using F12 (Configure). You can try different F12 (Configure) options to suit your business needs. Disabling an option will not impact your business data in any way.
  4. Accept the Cost Category screen. As always, you can use Ctrl+A to save.

 

Create multiple cost categories in one-go

You can create multiple cost centres from one screen. Use the multi-master creation and alteration feature for this.

  1. Gateway of Tally > Chart of Accounts > Cost Categories > press  Enter.
    In case the feature is inactive, you will be prompted to activate the Cost Category feature. Select Yes or press Y to proceed.
  2. Press Alt+H (Multi-Masters) > select Multi Create > and press Enter.
  3. Enter the Name of Cost Category and allocate it to Revenue Items or Non-Revenue Items as needed.
  4. Accept the Cost Category master. As always, you can use Ctrl+A to save.

To alter multiple cost centres in one-go, 

  1. Gateway of Tally > Chart of Accounts > Cost Categories > press  Enter.
  2. Press Alt+H (Multi-Masters) > select Multi Alter > and press Enter.
  3. Update the details as needed.
  4. Accept the Cost Category master. As always, you can use Ctrl+A to save.

 

Use Cost Category in Cost Centres

Once you have created a Cost Category, this will appear for selection when you create or alter a cost centre.

  • In the cost centre creation/alteration screen, under Category, select the cost category of your choice.

          Press Backspace on the Name field to place your cursor on the Category field.


What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options. Alternatively, press Ctrl+I (More Details) to enter any of the values without activating the F12 options.

 

Parallel Allocation of Cost Centres in Transactions

Before recording a transaction, in the corresponding ledgers, ensure that the option Cost centres are applicable is set to Yes. By default, this option is set to Yes in the income and expense ledgers, whereas it is set to No in the asset and liability ledgers. In the transaction, the total amount entered for the ledger, for example Travel, must be allocated to the selected cost centres.

When you create more than one cost category and have cost centres under it, the cost categories along with their respective cost centres will appear for selection during parallel allocation of incomes and expenses. A sample Cost Centre Allocations screen appears as shown below:

What you see on the screen can vary based on your choices. PressF12 (Configure) to change the options and F11 (Features) to enable or disable features. Alternatively, press Ctrl+I (More Details) to enter any of the values without activating the F12 options.

 

Cost Category Summary

Press Alt+G (Go To) > type or select Cost Category Summary.

Alternatively, Gateway of Tally > Display More Reports > Statements of Account > Cost Centres > Category Summary.

This report displays the summary of incomes and expenses allocated to parallel set of cost centres.

What you see on the screen can vary based on your choices. Press F12 (Configure) to change the options and F11 (Features) to enable or disable features.

 

Cost Centre Class

You may want to predefine the allocation of incomes and expenses to each cost centres, which can be automatically applied during voucher entry. You can do this in TallyPrime using the cost centre class. While recording the voucher, the allocation will be automatically done as per the details defined for the cost centre class.

In this section

 

Create Cost Centre Class

You can create the required cost centre structure and define the cost centre class.

  1. Press F11 (Features) > Ctrl+I (More Details) > type or select Cost Centre Class.
    In case the feature is inactive, you will be prompted to activate the Cost Centres Class feature. Select Yes or press Y to proceed.
  2. Type the Class Name, and select the Categories and the respective cost centres. Specify the percentage of allocation.

In the above example, the cost centres (Export, Retail, Finance and Marketing) are allocated at predefined percentages for:

  • Cost centre classes – Exports, Wholesale, Retail and Marketing Expenses.
  • Cost categories – Divisions (with cost centres Export, and Retail) and Departments (with cost centres Finance and Marketing).

 

Use Cost Centre Class

Let us use the cost centre class, Export in the sales invoice.

  1. Press Alt+G (Go To) > Create Voucher > F8 (Sales).
  2. Press F12 (Configure) > set Select Cost Centre/Class and to Yes.
  3. Select one of the Cost Centre Class, for example, Exports.
  4. Select the sales ledger and provide stock item details.
  5. Accept the voucher.
  6. Press Page Up > Ctrl+H (Change Mode) > select As Voucher. The cost centre allocation appears.


Similarly, record a payment voucher.

  1. Press Alt+G (Go To) > Create Voucher > F5 (Payment).
  2. Select the cost centre class, for example, Marketing Expenses.
  3. Accept the payment voucher.
  4. Press Page Up to open the voucher in alteration mode. The cost centre allocation will be displayed.

Did you find this article useful?