Multi Currency Accounting preview
Transactions ledger sheet with columns for date, currency, original amount, booking and settlement FX rates, booked and settlement USD, FX difference, and reconciliation status. 1/4

About this multi-currency accounting spreadsheet template

This multi-currency accounting template helps finance teams track transactions across multiple currencies with automatic FX conversion and reconciliation. The Transactions sheet records source-currency amounts with booking and settlement rates, the FX Exceptions queue flags unreconciled differences by priority, and the FX Dashboard summarizes exposure by currency.

Every sheet is fully editable in WPS Office, Microsoft Excel, or Google Sheets. Replace the synthetic sample data with your own transactions, update currency labels and number formats for your market, and adjust the control rules to match your accounting workflow.

4 structured sheets

Transactions, FX Exceptions, FX Dashboard, and Lists & Guide cover the full multi-currency workflow.

FX rate conversion built in

Booking and settlement rate columns with automatic FX difference calculation for each transaction.

Exception tracking queue

Priority-ranked FX exception log with status, cleared flag, and action column for reconciliation.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Multi Currency Accounting template is designed for finance and accounting teams to record multi-currency transactions, track FX rate differences between booking and settlement, and reconcile currency exposure. Customize the sample data, currency labels, and control rules in WPS Office for your own organization.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the transaction structure and control rules in a Notion database; for branded financial reports, adapt the dashboard content in Adobe Express.
Download the template, open it in WPS Office, and replace the synthetic sample transactions, currency labels, FX rates, and control rules with your own data. Update cell number formats and currency symbols for your target market.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for international transaction tracking, FX exposure reporting, month-end reconciliation, and multi-currency ledger management. It is available for personal and commercial projects, subject to the applicable template license.