Multi-Currency Revaluation Before a QuickBooks Desktop Year-End Lock
Before you lock a QuickBooks Desktop year, verify unrealized gain and loss postings and clear a home currency adjustment account that will not net to zero.
A foreign currency balance is not a number you lock once. It moves with the rate. QuickBooks Desktop posts unrealized gain and loss through a home currency adjustment account, and that account should tell a clean story at year-end. When it does not net to zero, the fix is not to delete entries. It is to prove which postings belong to the period and which are stale.
The right moment to run this playbook
Run it before you set a closing date, not after. It fits a year-end close with open foreign balances. It also fits a restored backup that contains revaluation entries, a change to a currency rate history, or an adjustment account that carries a balance nobody can explain. If the file is already locked, work in a copy and plan the correction for the first open period.
Phase 1: Freeze the file and make a rollback point
Make a full backup (File > Back Up Company) and a portable company file (File > Send Company File > Portable Company File). Open both to prove they restore. Record the home currency and the adjustment account name in Edit > Preferences > Multiple Currencies > Company Preferences. Verify the file (File > Utilities > Verify Data). If Verify fails, stop; currency math on a damaged file will not hold. Our QuickBooks Verify and Rebuild service handles that separately. Rollback point: the backup, plus the portable file if the backup will not open.
Phase 2: Rebuild the currency evidence
Pull four reports to Excel. Start with the home currency Balance Sheet as of the fiscal year-end and the Unrealized Gain/Loss report (Reports > Company & Financial) for the year. Add the adjustment account's General Ledger and a Transaction List by Date filtered to that account. Open the Currency List (Lists > Currency List), select each foreign currency, and review its exchange rate history for the dates in scope. Check for a rate of 1 on a foreign currency, a rate entered backwards, and a rate changed after a transaction posted.
Phase 3: Post the year-end revaluation
Use Company > Manage Currency > Adjust Foreign Currency Balances. Set the date to the last day of the fiscal year. Select the accounts that carry foreign balances and confirm the home currency adjustment account. Before posting, test one account by hand: foreign balance times the year-end rate, compared with its home currency balance. The difference should match the window's calculated gain or loss.
Post the adjustment, then open the journal entry it created. Note the date, amount, and account. Do not assume the entry reverses. Some releases post a single dated entry and leave it; others offer a reversal option in the same window. We use the entry as the evidence, not the window's label. If a reversing entry exists, it should be dated the first day of the new year and match the original. If it does not exist, plan the reversal as a separate journal entry before the lock, not after.
Phase 4: Clear an adjustment account that will not net to zero
Run the adjustment account's General Ledger for all dates. Group the postings by date, source, and amount. Look for a duplicate revaluation for the same date, a manual journal entry, a posting into a closed prior year, and a deleted or recreated transaction. Reconcile the total postings to the change in the Unrealized Gain/Loss report between periods, plus any reversal. A residual usually means one of those four.
Do not delete the original entry. Post a correcting journal entry in the first open period and reference the stale entry in the memo. Use retained earnings for a prior-period offset unless the amount truly belongs to the current year's unrealized gain or loss. Then rerun the General Ledger and confirm the account nets to the report, not to a remembered number.
Phase 5: Prove the close before you lock
Run the Balance Sheet as of year-end in home currency and accrual basis. The adjustment account balance must equal the year-end Unrealized Gain/Loss report total, or zero if the reversal is dated in the new year. Check that no revaluation entry sits in a closed period. Run Verify again, and Rebuild only if Verify reports damage. Set the closing date and password in Edit > Preferences > Accounting > Company Preferences. Rollback point: restore the Phase 1 backup and repeat from Phase 3; do not patch a locked file.
The clean outcome
The adjustment account tells one story. Every posting traces to a revaluation, a reversal, or a documented correction. The year-end balance agrees to the Unrealized Gain/Loss report. The first open period starts with either a clean zero or the reversal that clears it. Verify passes on the locked file. If any of those checks fail, the lock waits.