You manage rental properties in both CAD and USD by keeping one set of books in which every account, entry, and report carries a currency: a Canadian building's rent posts to CAD accounts, an American building's rent posts to USD accounts, and nothing is added across the line. Each currency reconciles to its own bank account, every report shows one section per currency, and converting between them is a year-end reporting step at a published rate, not a bookkeeping one.
The one monthly total you send an owner or an accountant for buildings on both sides of the border is two amounts and a guess. A spreadsheet somewhere turns CAD and USD into that figure at a rate somebody typed in, and it goes out as a number. The Bank of Canada quotes a different US dollar rate every business day, and the total moves with it whether or not a single tenant paid a dollar more.
This is a spoke of Property Management Reports: What Owners Actually Expect, which covers the package an owner receives and the suite behind it. This one covers the two-currency ledger: what has to carry a currency, the setup, how to read reports that section by currency, where conversion belongs, and how Scaalr keeps books in CAD and USD.
What a two-currency ledger is
A multi-currency ledger is one set of books in which every account, every entry, and every report carries a currency, and amounts in different currencies are never added together. A rental business that runs in two currencies has two of everything that holds money: two rent income accounts, two receivables accounts, two bank accounts, two sets of totals, on one chart of accounts under one company. The one thing it keeps out of the books is a third number that combines them, because a Canadian dollar and a US dollar are different units, and any figure that adds them is a currency conversion at whatever rate was used to make it, whether anyone chose that rate or not.
General accounting tools mostly take the other route, a home currency: every foreign amount is translated into it at the day's rate as it is entered, and the difference between that rate and the rate on the day the cash moves is booked as an exchange gain or loss. That model suits a business that settles in one currency. A building in Arizona earns, spends, and pays its owner in US dollars, so translating its rent into CAD on the first of the month creates a gain or loss nobody receives and a profit that changes with the rate. The two-currency ledger keeps each building in the currency it lives in and translates once, for the reader who needs one currency, at a rate that reader chooses.
What has to carry a currency
The table below lists each element of a two-currency ledger, what it carries, and why the currency has to sit there rather than on the company as a whole.
| Element | What it carries | Why it sits there |
|---|---|---|
| Ledger account | One currency, set when the account is created | An account holds one unit; CAD rent income and USD rent income are two accounts |
| Journal entry | One currency for every line | Debits and credits balance in one unit; a mixed entry balances nothing |
| Unit and lease | The rent's currency | Every monthly charge inherits it |
| Rent charge and invoice | The currency of its lease or its invoice | The posting lands on that currency's receivable and revenue accounts |
| Bank account | The currency of the real account | The reconciliation compares like with like |
| Control accounts | One designation per currency for retained earnings, receivables, payables, and cash | The year-end close and the agings read the right account |
| Report | One section per currency | Every total is stated in a unit |
The last row is the one owners and accountants see. A statement with a currency on every section can be read, compared, and translated; a statement with one total in no particular currency cannot be checked by anyone.
How to set up rental properties in both CAD and USD, step by step
Steps 1 through 5 are done once; steps 6 through 8 repeat every month.
- Turn on both currencies for the company. Switch on each currency once, at company level; the order you give them is the order every currency list follows.
- Give each currency its own accounts on one chart. Rent income, receivables, payables, bank, and each expense line exist once per currency, numbered on a convention you keep, so an account and its twin sit side by side. How to build the chart itself is covered in Chart of Accounts for Property Management: How to Build One.
- Designate the control accounts once per currency. Retained earnings, receivables, payables, and cash for CAD, and the same four again for USD.
- Open a bank account in each currency and flag each as a cash account. US dollar rent lands in the US dollar account, Canadian rent in the Canadian one, and each is one cash account in the ledger, in its own currency.
- Set the rent currency on every unit and every lease. The lease's currency is the currency of every charge it raises, so a building's rent posts to the right side from its first month.
- Post the month in the currency each item lives in. Rent charges, invoices, and payments carry their currency with them; a manual entry is one currency from top to bottom. A transfer between the two bank accounts is two entries, one per currency, each at the amount the bank actually moved.
- Reconcile each bank account in its own currency, then close the month. The CAD account against the CAD statement, the USD account against the USD statement, the lock on the period after both; the reconciliation is in Bank Reconciliation for Property Managers: Step by Step.
- Run the reports and read each currency's section on its own. Translate only at the end, for the reader who needs one currency, at a published rate, in a note under the figures rather than in the books.
Step 6 is where the spreadsheet used to live, and it is the step that decides whether the statement at the end carries amounts or estimates.
How to read reports that section by currency
A report from a two-currency ledger is two reports on one page. The income statement shows a CAD section and a USD section, each with its own revenue, expenses, and net; the balance sheet balances inside each currency, and so does the trial balance. Read a building against the other buildings in its currency first, since that comparison needs no rate, and read it per unit, the way Profit and Loss per Property: Which Building Makes Money sets out.
The owner statement follows the owner: buildings in both currencies mean one statement with a section per currency, and buildings in one mean a single-currency statement. How the statement is prepared and checked before it goes out is covered in How to Prepare a Property Owner Statement: Step by Step.
Translation belongs at year end, and it belongs to the reader. The accountant filing the Canadian return needs Canadian dollars, the one filing the American return needs US dollars, and each has a published rate the tax authority accepts; the questions below name both. Because each currency's totals are already closed and reconciled in their own unit, the translation is one multiplication on a finished number, done once, with the rate written beside it.
How Scaalr keeps books in CAD and USD
In Scaalr the currencies a company runs in are set on the Currencies tab of the company settings: add a currency, mark it active, and drag the rows into the order every currency list in the system will follow. Scaalr posts in CAD and USD. Every account on the chart carries a currency chosen when it is created, listed beside its name, and the system accounts every new company starts with come in pairs numbered one apart, Rent Income 4000 in CAD and 4001 in USD, receivables 1200 and 1201, bank 1000 and 1001; the entry templates create their accounts the same way.
The automatic postings resolve by currency: a rent charge posts to the receivable and revenue accounts of its lease's currency, an invoice to the accounts of its own, and a card payment on the invoice link is charged in the invoice's currency and posts to that currency's bank and receivable accounts. A journal entry carries one currency, every line is checked against it before the entry saves and again before it posts, and the CSV import applies the same check to each batch. The accounting configuration panel on the chart of accounts page holds the control accounts per currency, and the year-end close posts one closing entry per currency into that currency's retained earnings account, as Month-End Close Checklist for Property Managers describes.
Bank reconciliation runs per cash account, and each cash account carries its currency, so a reconciliation is a CAD statement against CAD entries or a USD statement against USD entries. Every report in the Reports area groups its figures by currency: one section per currency on screen, headed with the currency code when the company runs more than one, every amount suffixed with its code, one worksheet per currency in Excel, and the same sections in the trial balance, balance sheet, and owner statement PDFs. The subledger reconciliation ties each currency's control accounts to their subledgers, and the signed-in home screen states overdue rent and the collection rate per currency. Each section stands on its own in its own unit; the translation to a single reporting currency is the year-end step your accountant takes at the rate the tax authority accepts. Currencies, the chart of accounts, journal entries, bank reconciliation, and the report suite are on every plan, including Starter.
Key questions
Do I need separate books for my Canadian and US rental properties?
No. One set of books with a currency on every account keeps both countries' buildings under one company, each reconciled to its own bank account and reported in its own section. Separate legal entities are a different question, settled with a cross-border accountant for tax and liability reasons, and an entity that files its own return keeps its own books, in whichever currencies it runs.
Should I convert everything to one currency in my books?
No. Keep each building's books in the currency it earns and spends in, and convert at the end, for the reader who needs one currency. A ledger that translates every rent into a home currency at the day's rate books an exchange gain or loss nobody received, and the same building's profit then moves with the rate. Convert once, at a published rate, in the report that needs it.
What exchange rate do I use to report US rental income in Canada?
The Bank of Canada rate for the day the amount arose. The CRA's Income Tax Folio S5-F4-C1 requires Canadian tax results in Canadian currency and names the Bank of Canada's quoted rate as the relevant spot rate; it adds that the CRA may accept an average rate over a period for certain income items, but not generally when rates fluctuate significantly. The Bank of Canada publishes annual average exchange rates on the last business day of each year.
What exchange rate does the IRS accept for Canadian rental income?
Any posted exchange rate, used consistently. The IRS states on its Foreign currency and currency exchange rates page that it has no official exchange rate, that you use the rate prevailing when you receive, pay, or accrue the item, and that where more than one rate exists you use the one that most properly reflects your income. Its Yearly average currency exchange rates page lists one Canada figure per year for dividing a Canadian-dollar total into US dollars.
Do I need a bank account in each currency?
In practice, yes. Rent paid in US dollars belongs in a US dollar account, so the deposit matches the charge, the statement reconciles in one unit, and no bank converts it on the way in at a rate you did not choose. Each real bank account is one cash account in the ledger, in its own currency, reconciled on its own.
Can one owner statement show both currencies?
Yes, as one statement with a section per currency. An owner whose buildings earn in both gets a CAD section and a USD section on the same statement, each with its own income, expenses, and net in its own unit, and each section closes on its own net. An owner whose buildings earn in one currency gets a single-currency statement. In Scaalr the statement, its PDF, and its print view all section this way.
Does Scaalr convert CAD to USD in my reports?
No. Each currency keeps its own accounts, entries, and report sections, and every figure carries its currency code, so a report in Scaalr reads as two statements side by side rather than one translated total. Converting to a single reporting currency is the year-end step your accountant takes, at the rate the tax authority accepts, on totals that are already closed and reconciled in each currency.
Which Scaalr plan includes multi-currency accounting?
All of them, including Starter. Currencies, the chart of accounts, journal entries, bank reconciliation, and the report suite are on every plan; Starter is free for the first 5 units, then $0.99 a unit a month, and Growth is $99 a month for the first 50 units, then $1.49 per additional unit. Invoices and card payments on the invoice link, which post in the invoice's currency, are Growth and up.