Home / Import & Export / Exchange Rate Table
Exchange Rate Table

Exchange Rate Table · The Engine Under Multi-Currency Accounting

Still copying rates from the Bank of China website into Excel every day? SBK auto-syncs the daily BOC quotes (mid-rate / cash-remittance buying / cash-remittance selling / banknote buying / banknote selling) and keeps full historical records. Orders, PIs, contracts, customs declarations and FX collection/payment vouchers all pull rates automatically by "posting date / collection date."

20+
Major FX currencies
5
Quote price types
T+0
Daily auto-sync
Capabilities

From Hand-Copying Rates to Full Automation

Covers 20+ currencies including USD/EUR/GBP/JPY/HKD/AUD/CAD/SGD

🌐 Multi-Currency Support

20+ major currencies: USD/EUR/GBP/JPY/HKD/AUD/CAD/SGD/CHF/THB/INR and more

📅 Daily Auto-Sync

Integrated with the BOC FX quotation API, auto-stored after each daily opening, with 5 years of history searchable

💱 5 Quote Prices

Mid-rate / cash-remittance buying / cash-remittance selling / banknote buying / banknote selling — different prices for different business uses

Manual Entry

Supports custom "internal locked rates" (e.g. hedging at contract signing) that override the BOC price

📈 Historical Rate Lookup

Look up any currency's rate on any date, giving finance solid grounds for rate-conversion audits

🔗 All-Module Linking

Quotations, PIs, contracts, customs, FX collection/payment and rebate filing all pull rates automatically by date

trade.shangbangke.com/exchange-rate/syncSynced
R
Company-Wide Unified Rate Source
ManualSync Now
09:05Today Synced
24Currencies
5 yrsArchived

BOC quote API sync status

PairMid-RateStatus
USD/CNY7.1800OK
EUR/CNY7.8390OK
JPY/CNY0.0476OK

5 Minutes After Daily Opening, the Whole Company Updates in Sync

In the past, different departments each copied rates — finance used one, sales another, procurement yet another. SBK unifies the "rate source" in one place, auto-syncing the BOC quotes every morning so everyone uses the same rate and reconciliation has a common baseline.

  • BOC quotes auto-synced via API
  • Sync failure triggers an alert, prompting manual entry
  • 5 years of historical rates archived and searchable
  • Non-business days reuse the most recent trading day's rate
trade.shangbangke.com/exchange-rate/scenariosScenarios
S
Scenario-Based Rate Selection
CustomSave

USD/CNY rate per scenario (2026-04-18)

ScenarioRate TypePrice
Quote / Contract / PIMid-Rate7.1800
FX CollectionCash Buy7.1420
FX PaymentCash Sell7.2180
Bonded ImportBanknote7.0860

Automatically Pull the Right Price by Business Scenario

Use the mid-rate for quoting, cash-remittance selling for payments, cash-remittance buying for collections, banknote prices for bonded imports… The system already has which price each scenario should use configured, so salespeople don't need to memorize the rules.

  • Quotation / contract / PI: mid-rate by default
  • FX collection settlement: cash-remittance buying rate by default
  • FX payment settlement: cash-remittance selling rate by default
  • Custom rules can override the default configuration
Use Cases

How Different Operations Pull Rates

Locking the Rate When Quoting

When quoting a USD price, convert to CNY cost at the day's mid-rate to calculate gross margin, preventing rate swings from eating into profit.

FX Collection Settlement

When the customer's USD payment arrives, convert to CNY at the receipt-day cash-remittance buying rate, with FX gains/losses auto-accrued.

Rate Locking on Large Contracts

For million-dollar contracts, lock the rate with the customer at signing, overriding the BOC price until settlement to avoid one-sided losses.

Rates for Rebate Filing

The rebate-filing base sheet converts CNY sales at the export-declaration-day mid-rate, aligned with the tax authority's standard.

Related Features

Modules the Exchange Rate Table Links To

Make Exchange Rates No Longer a Copy-Paste Chore

Sign up to try automatic rate syncing for free