Food importer accounting: landed costs, stock and margins

1. Separate the questions you are trying to answer

Before building a spreadsheet, identify its purpose. You might want to compare suppliers, review a product margin, understand the cash required for a shipment or support the year-end accounts. Those questions overlap, but they do not necessarily use identical cost definitions.

A commercial margin report may include delivery and handling assumptions chosen for pricing decisions. Financial accounts need the treatment required by the applicable reporting framework. VAT records have their own evidence and reporting requirements. Label the purpose of each calculation so that a management estimate is not mistaken for a final accounting value.

Agree the intended output with the person preparing the records. A product-level report needs more detail than a broad category review. If that information is not available, begin with a level the records can support and identify the gaps. A precise-looking unit cost is not useful when the allocation behind it cannot be explained.

2. Give each shipment a consistent reference

Create a reference that connects the purchase order, supplier invoice, shipment records and related cost documents. Use it in the document filenames and cost schedule. The aim is to find the complete transaction history without relying on the memory of the person who arranged the import.

A shipment may contain several products, multiple supplier invoices or split deliveries. Record those details clearly. If one freight invoice covers more than one shipment, keep the connection and proposed allocation visible. Do not force a document into a single shipment merely because the spreadsheet has one available column.

The reference can also help with later credits, damaged-goods claims and stock questions. When a supplier adjustment arrives after the goods have been sold, the original shipment history provides the context. This continuity is useful for both margin review and the accountant's understanding of the records.

3. Capture the purchase terms and quantities

Record the goods ordered, quantities, currency, supplier price and any discounts or credits. Explain the unit of measurement. A price per pallet, carton or individual item can create misleading comparisons if it is carried into a report without conversion.

Check the quantity actually received against the purchase information. A shortage, substitution or damaged delivery affects the commercial picture and may need separate documentation. Keep the delivery record and the supplier correspondence rather than silently adjusting the quantity in the cost sheet.

Retain the agreed purchase terms and identify which costs the supplier's price includes. You do not need to interpret every commercial term alone, but the relevant documents should be available for discussion with the appropriate advisers. Understanding the price boundary helps avoid adding a charge twice or omitting a cost that the importer still has to meet.

4. Build a cost map with evidence

A shipment cost map can show the supplier purchase, transport, handling and other directly connected items. For each line, record the document, amount, currency, date and reason it belongs to the shipment. Separately identify estimates or amounts still awaiting confirmation.

Where FRS 102 applies, Section 13 describes the inventory cost principles, including relevant purchase costs and the treatment of recoverable taxes. See the FRC's published standard. The applicable framework and facts must be assessed before the management cost map is used as a financial-accounts value.

For commercial review, keep the structure understandable. A schedule with ten unexplained “other cost” rows is difficult to use. Describe the service or charge and link it to evidence. This makes it easier to distinguish a repeatable cost pattern from an unusual event that should not automatically be built into every future price.

5. Explain currency information rather than hiding it

If the supplier invoices in a foreign currency, record both the original amount and the information used to translate or settle it. The invoice date, payment date and bank conversion can tell different parts of the story. Discuss the accounting treatment with the accountant rather than treating the final bank amount as a complete explanation.

For a management comparison, use a clearly stated basis. A forecast purchase cost may use an assumption for future exchange rates, while a completed shipment uses actual transaction information. Label the difference. Otherwise, an apparent improvement in supplier pricing may simply reflect a different conversion assumption.

Keep fees and currency movements identifiable in the evidence. If they are buried inside the purchase amount, the owner may not see why two similar shipments have different cash costs. A transparent schedule lets the accountant and management reviewer consider the relevant components without guessing how a total was produced.

6. Choose a defensible management allocation

Shared freight or handling costs need an allocation if the management report compares individual products. Possible bases include quantities, weight, volume or value, depending on the nature of the cost and the information available. The appropriate method should be considered rather than selected only because it creates the preferred margin.

For example, allocating transport equally across units may be a poor comparison where one product is much heavier or occupies substantially more space. Conversely, a value-based allocation may not describe a charge driven by physical volume. Record the reason for the chosen basis and apply it consistently.

Review the method when the product mix or shipment arrangement changes. A basis that was sensible for a uniform shipment may become less useful for mixed loads. The management report should explain the choice, while the accountant separately considers the applicable financial reporting treatment. These are related tasks with different responsibilities.

7. A simplified landed-cost illustration

Suppose a fictional importer buys 1,000 identical units for £5,000. For a simplified management calculation, assume £800 of connected freight and handling and £200 of another applicable purchase-related charge. The illustrative total is £6,000, or £6 per unit, before any separate selling-cost analysis.

If the selling price used for comparison is £8 per unit on the same VAT-exclusive basis, the simplified gross difference is £2. Dividing £2 by £8 gives a 25% margin, while dividing £2 by the £6 cost gives approximately 33.3% markup. The distinction matters when somebody describes a target as “30%”. The example demonstrates arithmetic, not a recommended price or confirmed accounting treatment.

8. Look beyond the first gross difference

A product can appear attractive before the costs of selling and servicing customers are considered. Local delivery, storage, picking, payment fees and agreed commercial discounts may affect the management contribution. Decide which of those costs the report is intended to include.

Keep fixed overhead and transaction-related costs distinguishable. A cost that changes with each sale behaves differently from a monthly expense that continues regardless of volume. That distinction can help management understand the effect of larger orders or different delivery patterns without pretending that a simple product report is a complete profit forecast.

Do not compare products using inconsistent definitions. If one margin includes delivery and another does not, the ranking can be misleading. State the common basis, the costs included and any important exclusions. A shorter report with clear definitions can support better decisions than a long report containing several incompatible versions of “profit”.

9. Make wastage and stock condition visible

Food stock can be affected by expiry, damage, returns and handling losses. Keep records of the quantities involved, the reason and the action taken. The physical event and its commercial consequence need to be understood before an adjustment is made.

A margin review should not assume that every unit purchased will be sold at the original price. If a batch includes goods that cannot be sold normally, explain that condition and how it affects the review. Distinguish a recurring pattern from a one-off incident rather than spreading every loss silently across future purchasing assumptions.

For financial accounts, valuation depends on the applicable reporting requirements and evidence. Under FRS 102, inventory measurement considers cost and estimated selling price less relevant completion and selling costs. Discuss the actual position with the accountant. A note that goods are “old” is less useful than batch details, quantities, condition and evidence about expected realisation.

10. Keep import VAT separate from the commercial estimate

Import VAT and its recovery or reporting arrangements need separate consideration. Eligible UK VAT-registered importers may use postponed VAT accounting, subject to the conditions described in HMRC's eligibility guidance. Do not assume that every shipment or importer has the same arrangement.

Keep the relevant import documents and statements connected to the shipment records. HMRC's import VAT return guidance explains the reporting evidence. The accounting review needs to distinguish the purchase and related costs from the VAT information rather than allowing one all-inclusive bank amount to stand for everything.

This separation is also useful for cash planning. A cost report and a payment forecast may show different movements because of how taxes, supplier terms and other obligations are handled. Explain the differences. The practical objective is a consistent evidence trail that supports the appropriate accounting and VAT work.

11. Avoid blanket assumptions about food VAT

Not every food or drink product has the same VAT treatment. Product characteristics and the circumstances of the supply can matter. Use HMRC's food-products guidance and discuss the actual product information rather than assuming “food” means a single rate.

Maintain descriptions that identify the products sufficiently for review. A generic category such as “grocery stock” may be convenient for a broad sales report but inadequate for resolving a particular VAT question. Keep product specifications and supplier information where they are relevant to the accounting engagement.

When reviewing a selling margin, ensure that the price and cost comparison uses a consistent basis. Do not compare a VAT-inclusive selling amount with a VAT-exclusive cost and then describe the resulting percentage without explanation. The accountant can help discuss the correct treatment while the management report clearly states the basis used.

12. Connect the shipment to its cash requirements

A profitable shipment can still create a funding gap. The supplier may require a deposit, freight may be payable before delivery and customers may have credit terms. Map those dates separately from the margin calculation.

For each shipment, identify the committed payments, estimated dates and expected customer receipts. Keep confidence levels visible. A confirmed supplier due date is different from an assumed customer payment date. If the stock sells more slowly than expected, the cash recovery may also be delayed.

Use a scenario to consider those movements. What happens if goods arrive late, a customer pays after the expected date or part of the batch needs discounting? These are planning questions, not forecasts of what will happen. They show where the business may need a closer review before placing another substantial order.

13. Compare shipments using a consistent view

A shipment review can compare purchase prices, connected costs, selling outcomes and cash timing across periods. Use the same definitions so that movements can be explained. Highlight where product mix, exchange information or delivery arrangements changed.

Separate volume effects from unit-cost effects. A larger shipment may produce a lower cost per unit while requiring more cash and taking longer to sell. Neither observation, alone, proves that the order was commercially better. The management discussion should consider the whole pattern.

For food importers, compare stock condition and losses as well as the original purchase estimate. If the apparent saving from a supplier was followed by unusually high waste, the purchasing decision needs that context. A meaningful report connects what was expected at order time with what actually happened, including the evidence behind credits and adjustments.

14. Prepare an accountant-ready shipment file

A useful file contains the order and supplier information, quantities, invoice and payment records, relevant freight and import documents, stock movement evidence and any subsequent credits. Add a short index so the reviewer can see what is present and what remains outstanding.

Keep the management cost schedule alongside the original evidence, but label it as a working calculation. Explain allocation assumptions and estimates. That allows the accountant to understand the commercial review without treating every spreadsheet choice as an established financial reporting policy.

Where information is incomplete, state the gap and expected source. A missing document should prompt a targeted request, not an unsupported replacement figure. The practice can then discuss the amount of reconciliation or review work needed. Organised evidence is especially helpful where several shipments and suppliers are being considered together.

15. Introduce a repeatable shipment-review routine

Start with the next shipment rather than attempting to reconstruct every historic product calculation immediately. Assign the reference, collect the documents and build a simple cost map. Review the actual quantities received and keep the question list current.

After the first sales, compare the management estimate with the evidence available. Explain the differences caused by late charges, stock adjustments or selling outcomes. This first review shows which records the routine needs and where responsibilities are unclear.

Apply the improved process to later shipments, with periodic reviews of the allocation basis and product definitions. The routine should remain proportionate to the business. A small importer may need a concise shipment schedule, while a larger operation may need more detailed product reporting. The common aim is the ability to explain costs and margins from evidence.

A practical supplier-review meeting

Choose one completed shipment and compare the original purchase expectation with the final management schedule. Ask which charges were anticipated, which arrived late and whether the received quantities matched the order. Review any credits or stock losses before drawing a conclusion about the supplier.

Then identify the action needed for the next order. It might be a clearer quotation, an earlier freight estimate, better evidence about product condition or a different internal document handover. Keep that action separate from any financial-accounts adjustment that the accountant needs to consider.

This meeting can be short. Its purpose is to improve the evidence behind the next purchasing decision, not to create a score for every supplier without reliable information. A comparison that explains two or three material differences is more useful than a detailed table built from assumptions nobody has checked.

16. Discuss the detail with a specialist accounting team

A reliable landed-cost picture connects purchasing, goods, payments and selling information. It helps management ask better pricing and cash questions, while giving the accountant a stronger basis for the agreed accounts and reporting work.

CRV Gudka & Co specialises in accountancy for wholesalers and food importers. Our dedicated Edgware team can discuss bookkeeping, annual accounts, relevant VAT records and management information around the way your business trades.

Contact the practice with an outline of your suppliers, products, records and the question you want answered. If cash is the main concern, our wholesale working-capital guide is a useful companion. If the year end is approaching, read the stock and accounts preparation checklist. The support can then be scoped around the actual information and decisions involved.