The following are some common items in the general ledger of foreign trade import and export finance:
Date: Record the date of each transaction.
Counterparty: the name of the partner or customer who records the transaction.
Transaction Type: indicates whether it is an import transaction or an export transaction.
Commodity Description: Describe the commodities or commodities involved in the transaction.
Quantity: record the quantity or unit of goods.
Unit price: record the price of each cargo unit.
Total Amount: Calculate the total amount of each transaction.
Payment method: indicate the payment method, such as letter of credit, remittance, etc.
Payment Date: the date of payment is recorded.
Invoice Number: records the number of the invoice.
Mode of transportation: describe the mode of transportation of goods, such as sea, air and land.
Duties and taxes: record the duties, taxes or other charges related to the transaction.
Exchange rate: if foreign currency transactions are involved, record exchange rate information.
Remittance Bank: records the bank information related to remittance.
Remarks: Provide other important information or opinions about the transaction.
Status: Track the status of the transaction, such as paid, to be paid, shipped, etc.
Salesperson: record the name of the salesperson in charge of this transaction.
You can create your own spreadsheet template according to your specific needs and business processes, and fill in the corresponding information according to each transaction. Such an account book can help you manage your finances, track import and export transactions, and ensure the accuracy and traceability of records. If you need more complex financial ledgers, you may need to ask financial professionals to customize them to meet specific business needs.