An import-export trader's expenses fall into shipment costs, money costs and running costs. Track each shipment as its own small account: goods, freight, insurance, port and agent charges, and the bank charges on the payment. Add the general overheads separately. That way you see what each consignment really cost, not just the month's total.
Why should costs be tracked by shipment?
A trader can have goods leaving in one month, being paid for in another and costing more than expected in a third. A month-wise total hides that. A shipment-wise sheet, with one row per cost, shows which consignment earned and which one quietly lost money.
Give each shipment a short reference, such as the buyer's initials and the month. Write that reference in the narration whenever you pay a cost, so you can pull the lines together later.
What are the cost lines of a consignment?
- Goods: purchase from the supplier or, for exports, the cost of what you shipped.
- Packing, labelling and loading at your end.
- Freight and insurance, as billed by the forwarder or carrier.
- Port, terminal and handling charges, and customs broker fees.
- Duties or levies paid, in the amount shown on the official document, with the document kept.
- Bank charges, remittance fees and the exchange loss or gain on the payment.
- Inland transport at either end.
How do currencies fit in?
Foreign invoices are in dollars, euros or another currency, while your bank statement shows rupees. Record the foreign amount, the rate on the day you paid or received, and the rupee amount that actually moved. The rate differs from day to day, so use the figure on your bank advice rather than a general rate.
The same applies to money you receive as an exporter. The buyer's invoice may say one amount in a foreign currency, while the credit in your account is slightly different after intermediary bank charges. Record both the invoice value and the credit received, and write the difference as a bank or forex line, so it does not look like a short payment.
Samples deserve their own row too. Sending samples to a buyer is a real cost, usually paid in cash or by a courier account, and it rarely appears on any shipment invoice. Add it under the shipment it was meant to win, or under a general samples line when it led nowhere.
What category list works for a trader?
| Category | What goes in it |
|---|---|
| Goods purchased | Supplier invoices |
| Freight and insurance | Forwarder and carrier bills |
| Port and handling | Terminal, storage, loading, unloading |
| Customs and agent | Broker fees, duties as paid |
| Bank and forex | Remittance charges, rate differences |
| Inland transport | Trucking at origin and destination |
| Warehouse | Rent, storage, fumigation |
| Samples and travel | Courier of samples, trade fair costs |
| Office and software | Phone, internet, tools |
| Drawings | Personal withdrawals, kept separate |
What does a hypothetical shipment look like?
Say goods cost 3,00,000. Packing and loading are 8,000, freight and insurance 40,000, port and agent charges 12,000, and bank charges 3,500. These figures are invented for the example.
Total cost of the consignment: 3,00,000 + 8,000 + 40,000 + 12,000 + 3,500 = 3,63,500. If the buyer pays the equivalent of 4,10,000, the gap is 46,500 before overheads and the exchange rate difference. Doing this for each consignment shows where to push back on a forwarder or a supplier.
What is a monthly routine?
- Import the bank statements and mark each foreign-currency entry.
- Attach each cost to its shipment reference.
- Add the cash and small costs: sample couriers, trade fair, tips.
- Check every open shipment for a missing bill.
- Note any rate difference between invoice and payment.
SpendixAI lets each expense carry its own currency and shows totals in your base currency, using the rate saved with each transaction, plus a foreign-currency spend report. Choose the base currency before importing, because it cannot be changed after transactions exist.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
