Create Bad Debt Accounts:
Before writing off a foreign currency invoice, create the necessary accounts:
Create a Bad Debt Clearing Account:
- On the left side-menu, select Accountant > Chart of Accounts.
- Click 'New Account' in the top right corner.
- In the Account Type drop-down, select Customer Prepayments and Customer Credits.
- Name the account Bad Debt Clearing.
- Click 'Save'.
Create a Bad Debt Expense Account:
- On the left side-menu, select Accountant > Chart of Accounts.
- Click 'New Account' in the top right corner.
- In the Account Type drop-down, select Operating Expense.
- Name the account Bad Debt Expense.
- Click 'Save'.
Record the Payment for the Foreign Currency Invoice:
- On the left-side menu, select Sales > Invoices.
- Select the invoice you need to write off.
- In the bottom right corner of the invoice, find and note the exchange rate.
- Click 'Save' to exit the invoice details.
Record the Payment:
- On the invoice details page, click 'Record a payment' manually.
- In the Payment Method drop-down, select the payment method (e.g., Refund).
- In the Payment Account drop-down, choose the Bad Debt Clearing account.
- Change the exchange rate to the rate you wrote down.
- The amount in your business currency will match the amount shown on the invoice. Take note of this amount. - Click 'Submit' to complete the payment recording.
Create an Expense Transaction:
To record the bad debt as an expense, create an expense transaction:
- On the left-side menu, select Purchases > Expenses
- Click 'New Expense'.
- Enter a description (e.g., "Bad Debt Write-off").
- Choose the same date as the payment you just recorded.
- In the Account drop-down, select the Bad Debt Clearing account.
- For the Amount, enter the same amount as shown on the invoice (in your business currency).
- In the Category drop-down, select the Bad Debt Expense account.
- Click 'Save' to complete the expense transaction.
Verify the Write-Off:
To ensure that the invoice has been successfully written off:
- Go to Reports > General Ledger.
- Filter for the dates of the transactions.
- Check that:
- The invoice balance in Accounts Receivable is now zero.
- The Sales and Bad Debt Expense accounts offset each other.
- There is no gain or loss on foreign exchange.