Reconcile Supplier Payments with no bank charges
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,104.00, in Feb and are quoted an exchange rate of 1.30134 by the bank.
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’
- Bank Account: VERY IMPORTANT set this to ‘Bank Clearing Account’
NB: This is not available until you choose a suitable Payment Type - 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 List View you will see that the invoice has been fully paid. If it has not reduced the Outstanding amount, try refreshing 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 ‘Bank Clearing Account’. You can also see the $5340.70 has been posted to the Clearing Account as £4104.00.
Reconciliation
In the next day or so the payment will appear in Bank Rec:
To Reconcile the bank transaction click on [New Journal]
- Select Journal type: ‘Bank Rec Money OUT’
- This will list all unreconciled ‘Payment Numbers’.
Unfortunately very little information is displayed about the the Journal you are trying to match to. If you navigate to ‘Purchases – SUPPLIER PAYMENTS’ you can filter the List View and this shows the ‘Payment Number’ you need to match to. You cannot filter on the Payment Number, but you can filter by Amount and use the browser search if you extend the number of listed records.
- Journal Type: Bank Rec Money OUT
- Date: the date of the bank transaction
- Check the Bank Account
- Note the Currency is in GBP so the Exchange Rate is not needed
- Leave Name blank
Now identify the correct Payment Number and tick the check box:
This adds a Journal Item, but you need to fill in the Ledger Account to choose the Clearing Bank:
This ‘Remaining Amount’ is zero so you can [Save] the Journal and the reconciliation is complete.
The Clearing Account
You can check the posting in the Clearing Account by navigating to ‘Ledger – LEDGER ACCOUNT STATEMENT’ and you will see both a Credit and a Debit leaving a balance of zero.
Reconcile Supplier Payments WITH bank charges
The scenario is:
- You add a Purchase Invoice for $5,328.34 in Jan when the exchange rate is 1.20
- You pay the supplier in Feb when the exchange rate of 1.30 which equates to £4,098.72 but the bank charges you £5.28 transaction fees giving a total on the bank statement of £4,104.00
Payment
From your list of Unpaid Invoices you decide to pay Amazon 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: this will default to the prevailing exchange rate for the month and can be left as it is
- Payment Journal Type: ‘Payment to Suppliers GB’
- Bank Account: VERY IMPORTANT set this to ‘Bank Clearing Account’
NB: This is not available until you choose a suitable Payment Type - 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 List View you will see that the invoice has been fully paid. If it has not reduced the Outstanding amount, try to refresh 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 ‘Bank Clearing Account’. You can also see the $5328.34 has been posted to the Clearing Account as £4098.72.
Reconciliation
In the next day or so the payment will appear in Bank Rec:
To Reconcile the bank transaction click on [New Journal]
- Select Journal type: ‘Bank Rec Money OUT’
- This will list all unreconciled ‘Payment Numbers’.
Unfortunately very little information is displayed about the the Journal you are trying to match to. If you navigate to ‘Purchases – SUPPLIER PAYMENTS’ you can filter the List View and this shows the ‘Payment Number’ you need to match to. You cannot filter on the Payment Number, but you can filter by Amount and use the browser search if you extend the number of listed records.
- Journal Type: Bank Rec Money OUT
- Date: the date of the bank transaction
- Check the Bank Account
- Note the Currency is in GBP so the Exchange Rate is no needed
- Leave Name blank
Now identify the correct Payment Number and tick the check box:
This adds a Journal Item, but you need to fill in the Ledger Account, choosing the ‘Bank Clearing Account’. Note that the Remaining Amount shows £5.28, being the Bank Charges
To account for the Bank Charges click on the icon to add another Journal Item line. This time choose ‘Bank Charges’ as the Ledger Account
This ‘Remaining Amount’ is zero so you can [Save] the Journal and the reconciliation is complete.
The Clearing Account
You can check the posting in the Clearing Account by navigating to ‘Ledger – LEDGER ACCOUNT STATEMENT’ and you will see both a Credit and a Debit leaving a balance of zero.