Reconcile Foreign currency Supplier Payments using a GBP bank account
The scenario is:
- You add a Purchase Invoice for $5,340.70 in Jan when the exchange rate is 1.20
- You pay the supplier in full, £4,108.23, in Feb and are quoted an exchange rate of 1.3000 by the bank.
- There are additional £5 fx charges applied
Payment
From your list of Unpaid Invoices you decide to pay Dickenson plc and you make the payment using your internet banking facility. When you are ready you can mark the invoice as paid:
- Identify the invoice and choose [Pay] from the pick-list menu:
This will open the Payment pane:
- Date: date you will make the payment
- Reference: something to help with matching to the bank statement
- Exchange Rate: if you leave this blank it will pick up the exchange rate for the month, so if you have been quoted an exact exchange rate, enter that here
- Payment Journal Type: ‘Payment to Suppliers GB’
- Payment Type can be whatever you choose
- Amount would normally be the full amount in dollars, but you can choose to part pay.
- Click [Pay] to create the Journal
If you refresh the Purchase Invoice List View you will see that the invoice has been fully paid. If it has not reduced the Outstanding amount, try again or navigate to ‘Purchases- SUPPLIER PAYMENTS’ and check the journal has been posted.
The Postings
If you inspect the posting generated for the Invoice you can see the necessary currency adjustments have been posted with the payment posted to the bank as £4108.23.
Reconciliation
In the next day or so the payment will appear in Bank Rec, the amount is £4113.23 which includes a £5 fee:
To Reconcile the bank transaction click on [Match]
- Select Journal type: ‘Payment to Suppliers’
- This will list all unreconciled ‘Payment to Suppliers’ Journal Items.
Unfortunately the ‘Filter by other words’ does not work, but you can filter by date. You can also use ‘Filter y Amount’ but you will want to use the ‘Custom amount Range’ option as this amount does not match the payment exactly. - When you have identified the ‘Payment to Suppliers’ Journal Item select it by ticking the check box which will add it to the ‘Selected Items to Match’ list:
The amount in USD and GBP is displayed, along with the ‘Remaining Balance’ of £5 which is the Fx Fee.
To reconcile the Fx Fee, click [New Journal] using a ‘Bank Rec Money OUT’ Journal Type (or similar). Ignore the Payment Number list and click on the icon to add the amount manually:
- Gross is the fee
- Reference: something helpful
- Ledger Account: your Bank Charges account
- Payment Number: leave blank