Purchase Coasting Sheet
Module Guide: Purchase Costing Sheet
Module Location
Purchasing > Purchase Costing > Purchase Costing
Module Objective
The Purchase Costing Sheet module is used to calculate the total landed cost of goods. This module allows you to add and allocate additional costs (such as transportation, insurance, customs duties) to the value of goods that have been received from a supplier. The goal is to obtain a more accurate inventory value (COGS).
1. Main View (Costing Sheet List)
The main page of this module displays a list of all Purchase Costing Sheet documents that have been created.
View Explanation & Filters
This page is for viewing and managing all additional cost allocation documents.
-
Filters: You can search for a specific document by Purchase Costing Sheet Number or a date range (Date From / Date To).
-
Document List: The table below will display all documents that match the filters, with columns such as Purchase Costing Sheet Number, Purchase Order Number, Payable to, and Total Amount.
Button Functions
-
New: The primary button to create a new Purchase Costing Sheet.
-
Print: To print the details of a selected document.
-
Delete: To delete a selected document.
2. Steps to Create a Purchase Costing Sheet
Step 1: Create a New Document
From the Main View, click the New button to open the Add Purchase Costing Sheet form. 
Step 2: Fill in Additional Cost Details
On the form that appears, fill in the information regarding the additional cost incurred:
-
Document Date: Enter the date the additional cost occurred.
-
Extra Cost: Select the type of additional cost from the dropdown, for example, "Transportation Cost".
-
Amount: Enter the value of the cost.
-
Payable to: Specify to whom this cost must be paid, whether to the same Vendor or to Others.
Step 3: Allocate the Cost to Goods Receipts
-
In the Goods Receipt list box on the right, select one or more Goods Receipt documents to which you want to add the cost.
-
Click the Get Detail button. The system will display the item details from that goods receipt, and you can begin allocating this additional cost to those items.
Step 4: Save and Confirm
After all data is filled in and the cost has been allocated, use the buttons in the bottom-left section:
-
Save: To save the document as a draft.
-
Confirm: To finalize the document. This action will update the inventory value.
-
Cancel: To cancel the entry.
Workflow & Integrated Business Process
-
This process is performed after goods have been received and a Goods Receipt document has been created.
-
A confirmed Costing Sheet will update the inventory value (COGS) of the related items.
-
This document will also create a new payable to the party designated in the Payable to column, which will be processed through the Accounts Payable module.
Tips & Important Notes
-
This module is crucial for an accurate Cost of Goods Sold (COGS) calculation, especially for imported goods that have many additional costs.
-
Ensure you allocate costs correctly to all relevant items in a single shipment to get an accurate COGS value per item.