Add Additional Cost of Purchase on Stock Items in TallyPrime
When you purchase stock items in your business, you pay the price quoted by the vendor. In some cases, you also pay the additional charges, quoted in lump-sum for one or more stock items. So, you will want to know the additional cost of purchase on the stock items that also includes the amount spent on transportation expense, extra packaging charges, labor expense, or any other additional cost applicable to the stock item.
You will want to mention the expenditure on each item in the purchase voucher along with the additional cost of purchase in TallyPrime.
Subsequently, you will be able assess the exact selling price or value of a stock item that includes the additional cost of purchase.
In such cases, you will first need to configure your purchase ledger or the purchase voucher type, based on the the mode of transaction (voucher or invoice) used in your business. Thereafter, you can account for the additional cost of purchase on stock items in a purchase voucher.
Purchase Voucher with Additional Cost of Purchase on Stock Items (Invoice Mode)
In your business, you may be using the Invoice mode while recording a transaction. In such a case, you will need to configure the additional cost ledger before recording transactions with the additional cost of purchase.
Configure additional cost ledger to set Method of Appropriation for Invoice mode
To configure your purchase ledger made under Expense (Indirect or Direct) with the method of appropriation to be used in purchase voucher, follow the steps given below.
- Press Alt+G (Go To) > Alter Master > type or select Ledger and press Enter > type or select the name of the purchase or expense ledger and press Enter.
Alternatively, Gateway of Tally > Alter > type or select Ledger and press Enter > type or select the name of the purchase or expense ledger and press Enter.
The Ledger Alteration screen appears. - Method of appropriation in purchase invoice: Appropriate by Qty or Appropriate by Value, based on your business practice.
If you do not see this option, then press F12 (Configure) > Select Appropriation Methods to allocate Additional Costs: Yes.Note: Based on the Method of appropriation in purchase invoice chosen by you, the additional cost of purchase will be divided between the stock items accordingly. For instance, if you choose Appropriate by Qty, then the additional amount will be divided by the quantity of stock items in the voucher. On the contrary, if you choose Appropriate by Value, then the additional cost will get allocated to each stock item based on the ratio of values or rate of the items.
- Press Ctrl+A to save.
Create Purchase voucher with additional cost of purchase on Stock Items in Invoice mode
When you create a purchase voucher in the Item Invoice mode, you can specify the quantity and rate for the stock items and then the amount gets automatically calculated for each stock item. To record a purchase entry in the Invoice mode with the additional cost of purchase, follow the steps given below.
- Press Alt+G (Go To) > Create Voucher and press F9.
Alternatively, Gateway of Tally > Vouchers and press F9. - Provide the voucher details.
- Purchase No.: purchase voucher number, as applicable.
If the Method of voucher numbering for the Purchase voucher type is set to Automatic or Multi-user Auto, then you will not be able to change the voucher number. - Press F2 (Date) and enter the Date of Voucher and Effective Date, as applicable.
- Supplier Invoice No.: voucher number of the invoice provided by your supplier.
- Purchase No.: purchase voucher number, as applicable.
- Specify the party and related details.
- Under To, select the party from the List of Ledgers.
The Receipt Details screen appears. - Specify the details in the Receipt Details screen.
The Party Details screen appears. - Enter the details in the Party Details screen, as applicable.
- Under Credit, enter the amount to be paid to the party.
The Bill-wise Details for: the specified party screen appears. - Enter the Bill-wise Details for the specified party, as applicable.
- Under To, select the party from the List of Ledgers.
- Enter the stock item details.
- Select the stock item from the List of Stock Items and press Enter.
- Enter Quantity and Rate.
The Amount will get calculated automatically. - Select End of List and press Enter once you have select all the stock items for the transaction.
- Add the additional expense ledger and the Rate in %-age.
The Amount will get calculated.
You can directly add the Amount, if you do not follow the practice of specifying Rate in %-age. - Enter Narration, if needed.
A sample purchase voucher appears as shown below. - Press Ctrl+A to save, as in other transactions.
Purchase Voucher with Additional Cost of Purchase on Stock Items (Voucher Mode)
In your business, you may be using the Voucher mode to record transactions. In such a case, you will need to configure the Purchase Voucher Type so that you can track the additional cost of stock items in the Voucher mode.
Configure Purchase Voucher Type to Track Additional Cost for Voucher Mode
To configure the purchase voucher type so that you can track additional cost spend on each stock item enter in a purchase voucher, follow the steps given below.
- Press Alt+G (Go To) > Alter Master > type or select Voucher Type and press Enter > type or select Purchase and press Enter.
Alternatively, Gateway of Tally > Alter > type or select Voucher Type and press Enter > type or select Purchase and press Enter. - Track Addition Cost for Purchases: Yes.
- Press Ctrl+A to save, as in other masters.
Create Purchase voucher with additional cost of purchase on Stock Items
In the Voucher mode, you can provide the purchase value against the purchase ledger and then specify the details such as quantity and rate of the stock items as inventory allocations for the ledger. Thereafter, you can account for the additional charges in the Additional Cost of Details for the stock item screen.
- Open purchase voucher in the Voucher mode.
- Press Alt+G (Go To) > Create Voucher and press F9.
Alternatively, Gateway of Tally > Vouchers and press F9. - Press Ctrl+H (Change Mode) > As Voucher and press Enter.
- Press Alt+G (Go To) > Create Voucher and press F9.
- Provide the voucher details.
- Purchase No.: purchase voucher number, as applicable.
If the Method of voucher numbering for the Purchase voucher type is set to Automatic or Multi-user Auto, then you will not be able to change the voucher number. - Press F2 (Date) and enter the Date of Voucher and Effective Date, as applicable.
- Supplier Invoice No.: voucher number of the invoice provided by your supplier.
- Purchase No.: purchase voucher number, as applicable.
- Specify the party and related details.
- Under To, select the party from the List of Ledgers.
The Receipt Details screen appears. - Specify the details in the Receipt Details screen.
The Party Details screen appears. - Enter the details in the Party Details screen, as applicable.
- Under Credit, enter the amount to be paid to the party.
The Bill-wise Details for: the specified party screen appears. - Enter the Bill-wise Details for the specified party, as applicable.
- Under To, select the party from the List of Ledgers.
- Under By, select the purchase ledger configured with the Method of appropriation in purchase invoice, as per your business practice.
To know how to do it, refer to the Configure Purchase Ledger to Set Method of Appropriation section.
The Inventory Allocations for: the ledger screen appears. - Enter the Stock Item, Quantity, and Rate against each stock item and the Amount gets calculated automatically.
Once you enter the details of the stock item, the Additional Cost of Details for: the stock item screen appears. - Specify details of the additional cost.
- Select the ledger(s) from the List of Ledger Accounts, as applicable.
- Add the %-age, as per the cost of the stock item and the Amount gets calculate.
You may directly enter the Amount, if you do not follow the practice of entering %-age. - Select End of List, once you specify all the additional cost for purchase of stock item.
The Inventory Allocations for: the ledger screen appears in which you can specify more stock items.
- Enter Narration, if needed.
A sample purchase voucher appears as shown below. - Press Ctrl+A to save, as always.
Know Total Value of Stock Items Including Additional Cost of Purchase
You may want to know the exact value of the stock items including the additional cost of purchase on stock items entered in the purchase vouchers recorded in TallyPrime.
Stock Summary in TallyPrime provides the Rate and Value of stock items after considering the additional cost of stock items.
- Press Alt+G (Go To) > type or select Stock Summary and press Enter.
A sample Stock Summary report appears as shown below.
Value of Copper Wire in Stock Summary (considering the additional cost of purchase on stock items) = INR 15,06,119.98.
Value of Copper Wire in the Stock Item ledger = INR 15,00,000 as shown below.
Total additional cost of purchase for the stock item = INR (15,06,119.98 – 15,00,000) = INR 6,119.
This provides you an idea of the actual value of an item. Thereafter, you can decide the selling price of the stock item.