From the Bank Rec you see the money has come in:
Click on [New Journal] for the appropriate transaction line:
- Select Journal type: ‘Customer Receipt’
- This will list all Unpaid Sales Invoices.
Unfortunately you cannot search for the Invoice Number, but you can open up another Tab to display unpaid invoices so you can get the right Invoice Number. You can filter by date and amount.
- Journal Type: Customer Receipt
- Date: the date of the bank transaction
- Check the Bank Account is correct
- Receipt Type: whatever you want (but not a Cash type)
- Payment Adjustment Type: ‘Bank Charges’
This is very important as this makes the journal take into account the bank charges
- Currency: GBP
- Exchange Rate: Leave blank to pickup the exchange rate for the month, setup in ‘Currencies’
- Leave Customer and Name blank
Identify the correct Sales Invoice and tick the check box:
This adds a Journal Item, allowing for bank charges:
This Remaining Amount is zero so you can [Save] the Journal.
If you refresh the List View you will see that the invoice has been fully paid. If it has not reduced the Outstanding amount, navigate to ‘Sales – CUSTOMER RECEIPTS’ 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.
Please Note: There is no currency adjustment in this transaction, ‘Bank Charges’ includes both the Fx transaction fees and the gain/loss from currency variation.