Report in USD. Invoice in CAD. FX handles itself.
Businesses that report in one currency but transact in two don't need two accounting systems - they need one system that converts automatically, posts FX gains and losses without journal entries, and keeps the P&L clean in the base currency. Here's exactly how MurrCloud handles it.
Reading time: 9 min | Best for: cross-border distributors, importers, multichannel sellers operating in USD and CAD | Setup time: 1-2 hours (one-time)
Two currencies. One P&L that has to make sense.
Take Apex Industrial Supply - a distributor that reports in USD but invoices Canadian customers in CAD, pays Canadian freight forwarders and contractors in CAD, and runs Canadian payroll through an external provider in CAD.
Without the right setup, every CAD transaction is either ignored, converted manually at the wrong rate, or posted in the wrong currency. The result is a P&L that mixes currencies, FX differences that sit unreconciled, and month-end that involves a lot of manual journal entries nobody enjoys writing.
When a CAD invoice is paid weeks later at a different rate, the gain or loss needs to land somewhere - or it silently disappears.
Unpaid CAD invoices and bills have an unrealised FX position that changes every day the rate moves.
Without dedicated FX accounts, gains and losses hide in revenue or expense, making channel margin hard to read cleanly.
USD as the base. CAD as the transaction currency. Nothing else needed.
All financial reporting - P&L, balance sheet, channel margin - runs in USD. CAD is used wherever the transaction partner is Canadian. MurrCloud handles the conversion at the point of each transaction using daily exchange rates.
| Currency | Role | Used for |
|---|---|---|
| USD | Base currency | All financial reporting. US customer invoices. Overseas supplier bills (invoiced in USD). US freight and vendor bills. Amazon.com settlements. US payroll. |
| CAD | Transaction currency | Canadian customer invoices across all sales channels. Canadian freight forwarder and customs broker bills. Canadian contractor bills. Canadian payroll journal entries. |
Eight steps, configured once.
Everything below is a one-time configuration. After setup, daily exchange rate updates run automatically, and every CAD transaction converts, posts, and reconciles without manual intervention.
CAD customer invoices - from order to reconciled payment.
When a Canadian customer is invoiced in CAD, MurrCloud converts to USD at the ECB rate on the invoice date for the journal entry. If the rate moves before payment arrives, the difference posts automatically - no manual entry required.
| Invoice issued 1 CAD = 0.74 USD | CAD 10,000 | USD 7,400 -> Dr A/R / Cr Revenue |
| Payment received 1 CAD = 0.72 USD | CAD 10,000 | USD 7,200 -> Dr Bank / Cr A/R |
| FX Loss - rate moved against USD | - | USD 200 -> Dr 720000 FX Loss / Cr A/R |
CAD vendor bills - freight, customs, and contractors.
The AP workflow mirrors the AR side exactly. When a Canadian freight forwarder, customs broker, or contractor submits a bill in CAD, MurrCloud converts at the bill date, and any rate movement between the bill date and the payment date posts automatically.
Currency follows the customer's country - across every channel.
Fiscal position (which routes revenue to the correct channel GL) and currency (CAD or USD) are set independently on the customer record. Together they ensure every invoice for a Canadian customer lands in CAD with revenue posting to the right channel account in USD equivalent.
| Sales channel | Customer location rule | Invoice currency | Revenue GL |
|---|---|---|---|
| Industrial | Canada -> CAD / US -> USD | CAD or USD | 400100 |
| Direct-to-Consumer | Canada -> CAD / US -> USD | CAD or USD | 400200 |
| Marketplace (Amazon) | Amazon.ca -> CAD / Amazon.com -> USD | CAD or USD | 400300 |
| Retail | Canada -> CAD / US -> USD | CAD or USD | 400400 |
| Automotive | Canada -> CAD / US -> USD | CAD or USD | 400500 |
| Cash Sales | Canada -> CAD / US -> USD | CAD or USD | 400600 |
Amazon.com settles in USD. Amazon.ca settles in CAD. Both handled.
The two Amazon marketplaces have fundamentally different currency flows, and the MurrCloud Amazon connector handles each correctly - as long as marketplace-level invoice currency is configured before go-live.
Orders and settlements in USD. Standard flow: order syncs via connector -> invoice in USD -> posts to channel revenue at face value.
Amazon settles to a CAD bank account. The connector creates invoices in CAD, linked to the Canadian marketplace fiscal position. Revenue posts to 400300 in USD equivalent at ECB rate on invoice date. FX gain/loss on settlement auto-posts.
External providers handle deductions. MurrCloud records the net entry.
US and Canadian payroll are processed by separate external providers - MurrCloud records only the resulting net payroll journal entry. It does not calculate deductions, issue T4s or W-2s, or remit to CRA or IRS.
| Worker type | Payroll provider | MurrCloud entry | FX? |
|---|---|---|---|
| US employee | External US payroll provider - handles federal/state tax, W-2, direct deposit. All USD. | Import net payroll journal entry in USD: Dr Payroll Expense / Cr Bank (USD). | None - base currency |
| Canadian employee | External Canadian payroll provider - handles CPP, EI, income tax, T4, ROE, CRA remittance. All CAD. | Import net payroll journal entry in CAD: Dr Payroll Expense / Cr Bank (CAD). MurrCloud converts to USD at ECB rate on journal entry date. | FX auto-posts |
| Canadian contractor | No payroll provider. Contractor submits invoice in CAD and handles own CPP, income tax, and GST/HST. | Standard vendor bill in CAD -> coded to expense GL -> paid in CAD -> FX auto-reconciled on payment. | FX auto-posts |
Realised FX posts automatically. Unrealised FX needs one month-end action.
Two types of FX differences arise in a multi-currency setup - and they're handled differently.
MurrCloud calculates the difference between the invoice-date rate and the payment-date rate and posts to 710000 or 720000 automatically. No manual action required.
Open CAD invoices, bills, and the CAD bank account balance are revalued at the closing rate. Run: Accounting -> Accounting -> Actions -> Unrealised Currency Gains/Losses. The entry reverses automatically at the start of the next period.
Every FX-relevant account and its role.
| Account | Code | Role in FX |
|---|---|---|
| Channel Revenue | 400xxx | Revenue in USD equivalent. CAD invoices converted at ECB rate on invoice date. |
| Cost of Goods Sold | 500000 | COGS in USD only. No FX involved - AVCO is maintained in the base currency. |
| Channel Cost Accounts | 510xxx | Channel costs (marketplace fees, rebates). USD bills at face value. CAD bills converted at ECB rate on bill date. |
| Foreign Exchange Gain | 710000 | Auto-posted when CAD payments are received or made at a more favourable rate than the invoice date rate. |
| Foreign Exchange Loss | 720000 | Auto-posted when CAD payments are received or made at a less favourable rate than the invoice date rate. |
| Landed Costs Clearing | 145000 | Interim account for freight/duty allocation. CAD landed cost bills converted at ECB rate on bill date before allocation. |
What needs attention, and how often.
- Daily ECB exchange rate updates pull automatically - no manual action needed once configured.
- Each transaction Confirm currency on each document matches the customer or vendor country. Canadian customers and vendors default to CAD from their contact record.
- On payment Record payment in the currency actually received or sent - CAD for Canadian, USD for US. MurrCloud posts FX gain/loss automatically.
- US payroll Import US payroll journal entry in USD. No FX impact.
- CA payroll Import Canadian payroll journal entry in CAD. MurrCloud converts to USD at ECB rate. Reconcile against CAD bank payment.
- Month-end Run Accounting -> Accounting -> Actions -> Unrealised Currency Gains/Losses to revalue all open CAD balances - AR, AP, and the CAD bank account - at the closing rate.
- Month-end Review 710000 FX Gain and 720000 FX Loss balances. Large or unexpected amounts may indicate a payment recorded in the wrong currency.
- Year-end Confirm with your accountant whether unrealised FX positions on open AR/AP need to be held for tax purposes - treatment may differ between US and Canadian filing requirements.
Run USD and CAD in one system - without the manual work.
Book a 30-minute walkthrough and we'll map your currency setup, FX accounts, and customer defaults into MurrCloud.
Book a Demo Read: Automatic COGS