Panda ERP

The import file is in a folder, and freight and customs costs never reach product cost

The Foreign Trade module keeps import and export files, service invoices and cost allocation in one record. The same documents as accounting and stock.

Foreign trade
In short

Foreign Trade Management is the Panda ERP module that opens import and export files, attaches proforma, freight, insurance and customs service invoices to the file, allocates those expenses to product cost, and posts the records to accounting and stock. Foreign-currency amounts are tracked at the file rate; the customs declaration and invoices are archived inside the file.

How is this work done today?

  • Import cost is calculated in Excel

    Goods value, freight, insurance and customs costs are on separate invoices; unit cost is allocated by hand in Excel, again for every file.

    1 person × 3 hours / file
  • File documents are in a folder

    Proforma, bill of lading, declaration and invoices are in a physical folder; documents are hunted for at audits.

    1 person × 2 hours / month
  • Foreign-currency debt is not tracked

    The foreign supplier's balance is in foreign currency and the accounting record in TL; the exchange-rate difference arrives as a surprise at month end.

    1 accountant × 4 hours / month

How does Foreign trade work?

  1. 1

    A file is opened

    An import or export file: supplier/customer, proforma, currency, delivery terms and lead time on the file card.

  2. 2

    Documents and service invoices are attached

    Goods invoice, freight, insurance, customs brokerage and warehousing invoices are posted to the file; PDFs sit in the file archive.

  3. 3

    Cost is allocated

    Service invoices are allocated to product lines by amount, weight or quantity ratio; unit cost is written to the stock card.

  4. 4

    Accounting and stock

    Goods receipt brings stock in, invoices go to the account and the accounting voucher; the exchange-rate difference is calculated when the file closes.

See how Foreign trade would work in your business

Tell us briefly about your process and we will walk through the screens with your own example.

  • Reply the same business day
  • 15+ years of experience
  • 90 client businesses

Foreign trade features

Foreign trade: Import file
  • Import file

    Proforma, order, bill of lading, declaration and invoices in one file; status tracking (in transit, at customs, in warehouse).

  • Export file

    Proforma, packing list, export invoice, customs exit information; link to the e-invoice export type.

  • Service cost allocation

    Freight, insurance, customs and warehousing are allocated to lines by amount, weight or quantity.

Foreign trade: Currency tracking
  • Currency tracking

    File rate, supplier foreign-currency balance, exchange-rate difference calculation.

  • Accounting link

    File invoices land as drafts in the account and the journal voucher; allocated cost is posted to stock value.

  • Document archive

    PDFs belonging to the file are on the card; export by file for audits.

  • Reporting

    Cost by file, import-export breakdown by supplier and country; output in Excel and PDF.

What does Panda AI add to Foreign trade?

The Purchasing and Supply Agent is the Panda AI agent that puts incoming quotes into a comparison table and drafts purchase requests for critical stock.

  1. Today Supplier quotes are copied into a table by hand With the agent Incoming quotes are ready in a comparison table
  2. Today Critical stock levels are noticed late With the agent A draft purchase request for critical stock
  3. Today Late orders are chased by phone With the agent Alerts for orders whose delivery date is approaching

Jobs it takes on

  • Collecting and comparing quotes
  • Supplier performance summary
  • Open order and delay tracking
  • Draft purchase requests
  • Price change alerts
  • Draft e-mails to suppliers

The agent prepares, a person approves. Anything that posts a record or sends something outside the company goes through your approval.

Explore Panda AI agents

Frequently asked questions about Foreign trade

How is data shared with the customs broker?

File documents are exported as PDFs; a limited-access user can be opened for the broker, who attaches the declaration and expense invoice to the file.

Do we choose the cost allocation basis?

Yes. For each service invoice an amount, weight, volume or quantity ratio is selected; a default is defined per file.

Is the export e-invoice issued from this module?

The export invoice is opened from the file, and the e-Invoicing module sends it to the tax authority's platform with the export type. The invoice and the file stay on the same record.

Can several currencies be in the same file?

Yes. The goods value and service invoices can be in different currencies; allocation is calculated in a single currency at the file rate.

What does the agent do in foreign trade?

Supplier and carrier PDF invoices are read and matched to the file line by line; the cost allocation is prepared as a draft. A person approves the allocation and the file closing.

Are delivery terms and payment method kept in the file?

Yes. The file card holds delivery terms (Incoterms), payment method (advance, documents against payment, letter of credit) and due date; letter-of-credit documents are added to the file archive. A file whose payment date is near lands as a list with the finance team.

Can inward processing and export commitments be tracked?

The import file is linked to the inward processing permit; export files are matched to the permit when the commitment is closed. The permit's validity and the remaining commitment quantity appear in the report; the list of documents for the closing file is exported.

How is reconciliation done with a foreign supplier?

A foreign-currency account statement is produced as a PDF and sent to the supplier; the statement received is compared with the record line by line. With the e-Reconciliation module on, the comparison is made on the same screen and the difference list goes to accounting.

At what stage are carrier and customs broker invoices entered?

While the file is open, each incoming invoice is posted by linking it to the file; expenses that arrive before the goods enter the warehouse are written to provisional cost, and the final allocation is made when the file closes. A late invoice is added to a closed file with an additional cost voucher.

See Foreign trade with your own data

Describe your process in a few sentences and we will show you the modules that fit.

  • 15+ years of enterprise software experience
  • In the cloud or on your own server
  • Processes compliant with KVKK (Turkey's data protection law)

Last reviewed: · Panda Yazılım product team