About Prorating by Cost

If you prorate by cost, the program determines the additional cost for each item detail by calculating the cost amount cumulatively for each detail, then subtracting the amounts already prorated to previous details. Use this method, for example, to process brokerage fees for shipping and handling. More...

For example, assume that a receipt contains the following items and costs:

Item # Quantity Unit Cost Extended Cost
A1-010 10 10.00 $100.00
A1-320 5 25.00 125.00
A2-240 2 40.00 80.00
Subtotal $305.00
Vendor 1—Packaging 40.00
Vendor 2—Freight 80.00
Allocated Tax on Additional Costs 25.00
Total $450.00

When you enter the item costs and the additional costs (packaging, freight, and associated allocated taxes) from the preceding receipt information, the costs are apportioned as shown in the following table.

Item # Extended Cost Additional Cost Calculation Total Prorated Prorated/Unit (rounded)
A1-010 $100.00 100.00 x 145.00 - 0

305.00

$47.54 $4.75
A1-320 125.00 225.00 x 145.00 - 47.54

305.00

59.43 11.87
A2-240 80.00 305.00 x 145.00 - 106.97

305.00

38.03 19.02
Total $305.00   $145.00  

The additional costs apportioned to the items in the preceding example add up to $145.00, the total amount of the additional costs for packaging, freight, and associated allocated taxes in the sample receipt.

The following general ledger journal entry would be created for the above proration during Day End Processing.

General Ledger Account Debit Credit
Inventory Control (item A1-010) 47.54  
Inventory Control (item A1-320) 59.43  
Inventory Control (item A2-240) 38.03  
…Payables Clearing   145.00

Prorating by Cost on Zero-Amount Receipts

If you post a receipt for a zero amount, and prorate additional costs by cost, the additional costs are apportioned evenly to all items on the receipt.

Note: For non-inventory items, you must choose No Proration.

Using Manual Proration

Select the Prorate Manually to prorate additional costs to receipt details using a formula that does not assign the amounts proportionally.

Example: When you are charged duty on imported items, the amount normally depends on the type of item and is an identifiable cost of purchasing the item.

Select Prorate Manually, double-click the Distribute Proration column to display the Distribute Proration screen, and then enter the amount the you want to allocate to each receipt detail (including allocated tax).

Make sure the prorated amounts equal the total additional cost amount, plus allocated taxes.

Note: You cannot post a receipt if total additional costs and prorated additional costs do not balance.

Tip: You can check the total amount you have manually prorated (from more than one vendor) on the Totals tab.