Skip to main content

How to reconcile SEK & PLN settlements in Xero

What to do when you receive SEK or PLN settlements in Euros when your home currency is GBP

Written by Donna Walker

There is a limitation within Xero & QuickBooks that doesn't allow you to match foreign currency invoices or bills to a 3rd foreign currency.
​
SEK and PLN settlements are being converted by Amazon into EUR but then your home currency is in GBP, that's where the issue occurs.

Your EUR account can only match against entries in EUR.

Since these settlements are sent over in SEK/PLN they cannot be matched with anything other than SEK/PLN bank accounts or your home currency GBP bank accounts.

Long term, if possible you should instead use your GBP account for SEK/PLN payments or set up a SEK/PLN bank account (using something like Wise) to receive your SEK/PLN funds into.

Short term, one option we have seen others take in the same situation is to set up a clearing account in SEK or PLN in Xero to overcome this issue.

IMPORTANT - We recommend that you seek advice from your accountant before actioning the steps below.

Create a suspense account within your Chart of Accounts

Within Xero you want to go to the Accounting menu within the top menu and select Advanced Accounting

You will need to select Chart of accounts:

This screenshot shows a section titled

Then Add Account:

This screenshot displays a horizontal menu bar from an accounting software interface, showing several buttons:

Finally create a new current asset account. Make sure you enable payments to this account via the tick box:

This image displays a detailed form for creating or editing an account within an accounting system, specifically showing the setup for a

Allocate the bank receipt to the Suspense account:

This screenshot displays a bank reconciliation screen in accounting software, likely Xero. The top navigation shows

Create a credit note

You will need to create a credit note in the same currency as the invoice to clear the invoice from the Aged Receivables balance.

You can see in the example below that the invoice we are trying to match against is in PLN.

This screenshot displays the

Create credit note with the same date, same currency and same amount as the invoice you are matching against.

(You may want to include a narrative about moving the balance to a suspense account for an audit trail)

The credit note will need to be allocated to the Suspense account to match against the receipt that was earlier allocated there.

This screenshot displays the

Match the credit note against the invoice

Once the credit note has been approved you can allocate the balance against the original invoice:

This image displays the

Create journal to clear the suspense account

IMPORTANT - Manual journals are usually recommended for accountants/bookkeepers and those that are experienced at managing the general ledger. You may not have the option to post a manual journal within your user settings.

Once the credit note and payment have been allocated to the suspense account there will be a small difference - this will be a foreign exchange gain/loss that is to be realised.

In this example there is a 29p difference sat on the balance sheet

This is a screenshot of a financial report, specifically a Balance Sheet, as of

To clear that from the balance sheet you need to create a manual journal.

You can see below that the accounting entry is

Debit

Credit

Currency Gain/Loss

(Profit & Loss)

£0.29

Suspense Account

(Balance Sheet)

£0.29

(If the balance was a negative amount within Current Assets the balance would be a liability and the journal would be the other way around)

This screenshot displays the

Check the Suspense account balances off to nil

Here you can see that the suspense account has balanced off to nil. You can see the credit note that was posted (dated the original invoice date), the receipt received and the currency gain/loss.

This image displays a clean, minimalist table illustrating a financial transaction's impact on different account types. The table has three columns: the first for the account name, the second labeled
Did this answer your question?