{"id":674,"date":"2019-02-21T16:59:55","date_gmt":"2019-02-21T16:59:55","guid":{"rendered":"http:\/\/sagefinancialsknowhow.com\/?p=674"},"modified":"2019-02-22T11:26:28","modified_gmt":"2019-02-22T11:26:28","slug":"foreign-supplier-payments-fx-account","status":"publish","type":"post","link":"https:\/\/sagefinancialsknowhow.com\/foreign-supplier-payments-fx-account\/","title":{"rendered":"Foreign currency Supplier Payments using a Foreign Currency bank account"},"content":{"rendered":"<h2>Reconcile Supplier Payments with no bank charges<\/h2>\n<p>The scenario is:<\/p>\n<ul>\n<li>You add a Purchase Invoice for $3,540.67 in Jan when the exchange rate is 1.20<\/li>\n<li>You pay the supplier in full,\u00a0$3,540.67, in Feb when the exchange rate is 1.30<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div class=\"bg-margin-for-link\"><input type='hidden' bg_collapse_expand='66107a229cac96042154626' value='66107a229cac96042154626'><input type='hidden' id='bg-show-more-text-66107a229cac96042154626' value='Show More'><input type='hidden' id='bg-show-less-text-66107a229cac96042154626' value='Show Less'><a id='bg-showmore-action-66107a229cac96042154626' class='bg-showmore-plg-link bg-arrow '  style=\" color:inherit;;\" href='#'>Show More<\/a><div id='bg-showmore-hidden-66107a229cac96042154626' ><\/p>\n<p>Payments without Bank Charges follows exactly the same procedure and with bank charges but you do not have to add the [New Journal] to account for the charges.<\/p>\n<p><\/div><\/div>\n<p>&nbsp;<\/p>\n<h2>Reconcile Supplier Payments WITH bank charges<\/h2>\n<p>The scenario is:<\/p>\n<ul>\n<li>You add a Purchase Invoice for $3,531.00 in Jan when the exchange rate is 1.20<\/li>\n<li>You pay the supplier in Feb when the exchange rate is 1.30 but the bank adds $9.60 in bank charges<\/li>\n<\/ul>\n<div class=\"bg-margin-for-link\"><input type='hidden' bg_collapse_expand='66107a229cbd39008165206' value='66107a229cbd39008165206'><input type='hidden' id='bg-show-more-text-66107a229cbd39008165206' value='Show More'><input type='hidden' id='bg-show-less-text-66107a229cbd39008165206' value='Show Less'><a id='bg-showmore-action-66107a229cbd39008165206' class='bg-showmore-plg-link bg-arrow '  style=\" color:inherit;;\" href='#'>Show More<\/a><div id='bg-showmore-hidden-66107a229cbd39008165206' ><\/p>\n<h3><strong>Payment<\/strong><\/h3>\n<p>From your list of Unpaid Invoices you decide to pay ACME and you make the payment using your internet banking facility. When you are ready you can mark the invoice as paid:<\/p>\n<ul>\n<li>Identify the invoice and choose [Pay] from the pick-list menu:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-676\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseFxC1.jpg\" alt=\"\" width=\"1695\" height=\"545\" \/><\/p>\n<p>This will open the Payment pane:<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-677\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseFxC2.jpg\" alt=\"\" width=\"768\" height=\"557\" \/><\/p>\n<ul>\n<li>Date: date you will make the payment<\/li>\n<li>Reference: something to help with matching to the bank statement<\/li>\n<li>Exchange Rate: this will default to the prevailing exchange rate for the month and can be left as it is<\/li>\n<li>Payment Journal Type: &#8216;Payment to Suppliers GB&#8217;<\/li>\n<li>Bank Account: your Foreign Currency bank account<\/li>\n<li>Payment Type can be whatever you choose (but not a Cash type)<\/li>\n<li>Amount would normally be the full amount in dollars, but you can choose to part pay.<\/li>\n<li>Click [Pay] to create the Journal<\/li>\n<\/ul>\n<p>If you refresh\u00a0\u00a0<img loading=\"lazy\" class=\"alignnone size-full wp-image-588\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/RefreshListView.jpg\" alt=\"\" width=\"31\" height=\"31\" \/>\u00a0 the 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 &#8216;Purchases- SUPPLIER PAYMENTS&#8217; and check the journal has been posted.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-678\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseFxC3.jpg\" alt=\"\" width=\"599\" height=\"95\" \/><\/p>\n<h3>The Postings<\/h3>\n<p>If you inspect the posting generated for the Invoice you can see the necessary postings to Bank Account, Control Account and currency adjustments have been posted.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-679\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseFxC4.jpg\" alt=\"\" width=\"1701\" height=\"517\" \/><\/p>\n<h3>Reconciliation<\/h3>\n<p>In the next day or so the payment will appear in Bank Rec:<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-651\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseGBP6.jpg\" alt=\"\" width=\"1313\" height=\"427\" \/><\/p>\n<p>To Reconcile the bank transaction click on [Match]<\/p>\n<ul>\n<li>Select Journal type: &#8216;Supplier Payments GB&#8217;<\/li>\n<li>This will list all unreconciled Supplier Payments<br \/>\nMake sure the &#8216;Filter by Date&#8217; goes far enough back to see the Supplier Payments. If you navigate to &#8216;Purchases &#8211; SUPPLIER PAYMENTS&#8217; in another tab, you can filter the List View to find the journal number you need.\u00a0You can then use &#8216;Filter by other words&#8217; to find the right journal item to match.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-680\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseFxC6.jpg\" alt=\"\" width=\"1289\" height=\"607\" \/><\/p>\n<ul>\n<li>Identify the Journal Item you want to match and tick the checkbox.<\/li>\n<li>This is added to the list of &#8216;Selected Item to Match&#8217; leaving a Remaining Balance of $9.67<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-683\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseFxC7a.jpg\" alt=\"\" width=\"1231\" height=\"206\" \/><\/p>\n<h3>Bank Charges<\/h3>\n<ul>\n<li>To account for the $9.67 bank charges click on [New Journal] shown above<\/li>\n<li>This opens the New Journal pane:<\/li>\n<\/ul>\n<h3><img loading=\"lazy\" class=\"alignnone size-full wp-image-684\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseFxC8.jpg\" alt=\"\" width=\"1187\" height=\"535\" \/><\/h3>\n<ul>\n<li>Journal Type: Bank Rec Money OUT<\/li>\n<li>Date: the date of the bank transaction<\/li>\n<li>Check the Bank Account(\u00a0 (this can default to the wrong bank)<\/li>\n<li>Add a suitable Reference<\/li>\n<li>Note the Currency is in USD<\/li>\n<li>Exchange Rate: this will default to the prevailing exchange rate for the month and can be left as it is<\/li>\n<li>Leave Name blank<\/li>\n<\/ul>\n<p>A list of Payment Numbers is displayed, but just scroll down to the list of Journal Items and click on the\u00a0<img loading=\"lazy\" class=\"alignnone size-full wp-image-492\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/01\/Plus.gif\" alt=\"\" width=\"31\" height=\"26\" \/>\u00a0icon to add a Journal Item line:<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-685\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/BankRecFxPurchaseFxC9.jpg\" alt=\"\" width=\"1193\" height=\"535\" \/><\/p>\n<ul>\n<li>Choose Bank Charges for the Ledger Account<\/li>\n<li>The Remaining Amount is now zero so you can [Save] to complete the reconciliation<\/li>\n<\/ul>\n<p><\/div><\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Reconcile Supplier Payments with no bank charges The scenario is: You add a Purchase Invoice for $3,540.67 in Jan when the exchange rate is 1.20 You pay the supplier in full,\u00a0$3,540.67, in Feb when the exchange rate is 1.30 &nbsp; &nbsp; Reconcile Supplier Payments WITH bank charges The scenario is: You add a Purchase Invoice <a href=\"https:\/\/sagefinancialsknowhow.com\/foreign-supplier-payments-fx-account\/\" rel=\"nofollow\"><span class=\"sr-only\">Read more about Foreign currency Supplier Payments using a Foreign Currency bank account<\/span>[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"_links":{"self":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/674"}],"collection":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/comments?post=674"}],"version-history":[{"count":0,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/674\/revisions"}],"wp:attachment":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media?parent=674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/categories?post=674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/tags?post=674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}