Changes for page Linking of Contributions via Bank Reconciliation
Last modified by Megan Kahl on 2022/08/11 12:46
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
-
Attachments (0 modified, 13 added, 0 removed)
- Linking of Contributions via Bank Reconciliation _html_8cba33b1e8c9fa24.gif
- image-20220811143853-1.png
- image-20220811143933-2.png
- image-20220811144007-3.png
- image-20220811144040-4.png
- image-20220811144108-5.png
- image-20220811144201-6.png
- image-20220811144226-7.png
- image-20220811144246-8.png
- image-20220811144322-9.png
- image-20220811144419-10.png
- image-20220811144437-11.png
- image-20220811144509-12.png
Details
- Page properties
-
- Content
-
... ... @@ -1,120 +1,143 @@ 1 + 1 1 2 -**DISCLAIMER** 3 +(% style="text-align: center;" %) 4 +(% style="color:#2980b9; font-size:28px" %)**LINKING OF CONTRIBUTIIONS VIA BANK RECONCILIATION** 3 3 4 -Please note, whilst care is taken to illustrate numerous scenarios, it is impossible to detail all instances and therefore this document should merely serve as a guide for the purposes of demonstrating system functionality and conducting employee training. 5 5 6 -In accordance with the above paragraph, this training manual is published and distributed on the basis that EBSphere (Pty) Ltd is not responsible/accountable for any actions taken by users of information contained in this training manual nor for any error in or omission from this manual. 7 7 8 -EBSphere (Pty) Ltd does not accept any responsibility whatsoever for a misrepresentation performed by any person in respect of claims, losses or damage or any other matter, either direct or consequential arising out of or in relation to the use and reliance, whether wholly or partially, upon any information contained or products referred to in this manual. 8 +(% style="text-align: center;" %) 9 +(% style="color:#2980b9" %)**BY** 9 9 10 -Further, the contents of this training manual are subject to change without any notice and further highlight the need for this training manual to serve only as a guide. 11 11 12 12 13 +[[image:Linking of Contributions via Bank Reconciliation _html_8cba33b1e8c9fa24.gif||data-xwiki-image-style-alignment="center" height="128" width="465"]] 13 13 15 +{{info}} 16 +(% style="text-align: center;" %) 17 +(% style="font-size:22px" %)**TABLE OF CONTENTS** 14 14 15 15 20 +{{toc/}} 16 16 22 + 23 +{{/info}} 17 17 18 18 19 -**COPYRIGHT** 26 +(% style="text-align: center;" %) 27 +== (% style="color:#2980b9" %)**Confirming receipt of the contribution**(%%) == 20 20 21 -This documentation and the software described in it is the exclusive property of EBSphere (Pty) Ltd. This manual or the software may not be copied in whole or part, without the express written consent of EBSphere (Pty) Ltd. Under the law, copying includes translating into another language or format. 22 22 23 - EBSphere (Pty)Limited30 +Request a(% style="color:#2980b9" %) “**Parent Bank Statement**”(%%) to check that the contribution amount has been received in the bank account. 24 24 25 - P.O.Box78580332 +Complete the required parameters before executing the batch to generate the statement: 26 26 27 - Sandton34 +(% style="color:#2980b9" %)**Amount 1**(%%) Represents the bank statement start number 28 28 29 -2 14636 +(% style="color:#2980b9" %)**Amount 2** (%%)Represents the bank statement end number 30 30 38 +(% style="color:#2980b9" %)**OR** 31 31 40 +(% style="color:#2980b9" %)**Date 1** (%%)Represents the start date 32 32 33 - [[image:Linkingof Contributionsvia Bank Reconciliation _html_8cba33b1e8c9fa24.gif||height="96"width="344"]]//Confirmingreceiptofthecontribution//42 +(% style="color:#2980b9" %)**Date 2** (%%)Represents the end date 34 34 44 +[[image:image-20220811143853-1.png||data-xwiki-image-style-alignment="center"]] 35 35 36 - Request a “**Parent Bank Statement**” to check that thecontribution amount has been received in the bank account.46 +[[image:image-20220811143933-2.png]] 37 37 38 -Complete the required parameters before executing the batch to generate the statement: 39 39 40 - **Amount1**Represents thebankstatementstart number49 +The report will reflect all transactions within the criteria selected above: 41 41 42 - **Amount 2** Represents the bankstatementend number51 +[[image:image-20220811144007-3.png||data-xwiki-image-style-alignment="center"]] 43 43 44 -**OR** 45 45 46 -**Date 1** Represents the start date 54 +(% style="text-align: center;" %) 55 +== (% style="color:#2980b9" %)**Linking the contribution**(%%) == 47 47 48 -**Date 2** Represents the end date 49 49 58 +Go to the Accounts menu and select Bank Reconciliation: 50 50 60 +[[image:image-20220811144040-4.png||data-xwiki-image-style-alignment="center"]] 51 51 52 -[[image:Linking of Contributions via Bank Reconciliation _html_77e70a7fa2e9845d.gif||alt="Shape2"]] [[image:Linking of Contributions via Bank Reconciliation _html_77e70a7fa2e9845d.gif||alt="Shape1"]] [[image:Linking of Contributions via Bank Reconciliation _html_c762b6d0e009c774.png||height="181" width="630"]] [[image:Linking of Contributions via Bank Reconciliation _html_5d12ee8a9e4a38a3.png||height="183" width="630"]] 53 53 63 +Select either the Bank Statement number that the contribution reflects on, or the date range in which the contribution reflects in the bank account. Select the (% style="color:#2980b9" %)“**Next**”(%%) button at the bottom of the page: 54 54 65 +[[image:image-20220811144108-5.png||data-xwiki-image-style-alignment="center"]] 55 55 56 56 68 +The next screen will display all the Bank Statement transactions for the date range selected. Select the “Next” button at the bottom of the page: 57 57 70 +[[image:image-20220811144201-6.png||data-xwiki-image-style-alignment="center"]] 58 58 59 -The report will reflect all transactions within the criteria selected above: 60 60 61 - [[image:LinkingofContributionsviaBankReconciliation_html_14b74882710910f0.png||height="183"width="630"]]73 +A double screen will display. The left-hand side is the Bank Statement entries; the righ-hand side is the Cash Book entries: 62 62 75 +[[image:image-20220811144226-7.png||data-xwiki-image-style-alignment="center"]] 63 63 64 -//Linking the contribution// 65 65 66 - Go to theAccountsmenuandselectBankReconciliation:78 +The user will be required to filter the date range on the Cash Book side by updating the date range and clicking on the (% style="color:#2980b9" %)“**Search**” (%%)button: 67 67 68 -[[image: Linkingof Contributions viaBank Reconciliation_html_ccc36c158be48a3e.png||height="141" width="182"]]80 +[[image:image-20220811144246-8.png||data-xwiki-image-style-alignment="center"]] 69 69 70 - SelecteithertheBankStatementnumberthat the contributionreflectson,orthedate range inwhichthecontribution reflectsin thebankaccount.Select the “**Next**” button at the bottom of the page:82 +Items reflecting in (% style="color:#2980b9" %)**green**(%%) have been reconciled. Those in (% style="color:#2980b9" %)**black **(%%)must still be reconciled. The contribution amount may not have been receipted in Everest as yet, and may therefore not reflect on the Cash Book side. In this instance select the (% style="color:#2980b9" %)“**Next**”(%%) button at the bottom of the page. 71 71 72 -[[image:Linking of Contributions via Bank Reconciliation _html_4ba97f29d2ddd052.png||height="146" width="630"]] 73 73 85 +The(% style="color:#2980b9" %) “**Tab Errors**”(%%) screen will reflect any bank statement entries that have been linked incorrectly. These items will need to be addressed before the month end management accounts are produced, but is not required to be addressed in this process. Click on the (% style="color:#2980b9" %)“**Next**” (%%)button at the bottom of the page. 74 74 87 +[[image:image-20220811144322-9.png||data-xwiki-image-style-alignment="center"]] 75 75 89 +The (% style="color:#2980b9" %)“**Unlinked**”(%%) screen shows any items that have not been linked to a cashbook entry. Linking contributions at this step will create the Cash Book and link the entry to the bank statement item at the same time. 76 76 77 77 92 +Double click on the (% style="color:#2980b9" %)__select __(%%)hyperlink to proceed in creating the receipt and linking the item. 78 78 94 +[[image:image-20220811144419-10.png]] 79 79 80 -The next screen will display all the Bank Statement transactions for the date range selected. Select the “Next” button at the bottom of the page: 81 81 97 +Complete the require variables and click on the (% style="color:#2980b9" %)“**Add**”(%%) button: 82 82 83 -[[image: Linkingof Contributions viaBank Reconciliation_html_4c6aa526d5b8e0fc.png||height="163" width="630"]]99 +[[image:image-20220811144437-11.png||data-xwiki-image-style-alignment="center"]] 84 84 85 -A double screen will display. The left-hand side is the Bank Statement entries; the righ-hand side is the Cash Book entries: 86 86 87 - [[image:LinkingofContributionsvia Bank Reconciliation_html_7a9b8db66c3954b.png||height="82"width="630"]]102 +(% style="color:#2980b9" %)**Options**(%%) Select (% style="color:#2980b9" %)“**Contribution Amount**” (%%)from the dropdown. 88 88 89 - Theuser willberequiredtofilterthedaterange ontheCash Book sideby updatingthedaterangeandclickingon the“**Search**” button:104 +(% style="color:#2980b9" %)**Client**(%%) Select the relevant Client that the contribution is in respect of. 90 90 91 - [[image:LinkingofContributionsviaBankReconciliation_html_f9fd5232b5ad836e.png||height="15"width="630"]]106 +(% style="color:#2980b9" %)**Paypoint**(%%) Select the relevant Paypoint this money is in respect of. (% style="color:#2980b9" %)**(This field is mandatory, even if the payment was made in respect of the whole Client)** 92 92 93 - Itemsreflectingin **green**have been reconciled.Thosein**black **must stillbe reconciled. Thecontributionamountmay nothavebeen receiptedinEverestasyet, andmaythereforenot reflectonthe Cash Book side. Inthis instance selectthe“**Next**”button at thebottom ofthepage.108 +A batch screen will open. All the information that was captured on the previous screen is populated here. Select (% style="color:#2980b9" %)“**Execute**”(%%) to run the batch and update the system. This also links the bank entry: 94 94 95 - The “**Tab Errors**” screen will reflectany bank statement entries thathave been linkedincorrectly. Theseitems will need to beaddressed beforethemonth end managementaccounts areproduced, but isnotrequired to be addressed in this process. Click on the “**Next**” button at the bottom of the page.110 +[[image:image-20220811144509-12.png||data-xwiki-image-style-alignment="center"]] 96 96 97 -[[image:Linking of Contributions via Bank Reconciliation _html_c7875f5b5711f051.png||height="101" width="596"]] 98 98 113 +(% style="text-align: center;" %) 114 +== (% style="color:#2980b9" %)**Disclaimer and Copyright**(%%) == 99 99 100 100 117 +(% style="color:#2980b9" %)**DISCLAIMER** 101 101 102 - The“**Unlinked**”screenshowsanyitemsthathave notbeenlinkedtoacashbookentry.LinkingcontributionsatthisstepwillcreatetheCashBookandlinktheentrytothebankstatementitem at thesame time.119 +Please note, whilst care is taken to illustrate numerous scenarios, it is impossible to detail all instances and therefore this document should merely serve as a guide for the purposes of demonstrating system functionality and conducting employee training. 103 103 104 - Doubleclickon the__select__hyperlinktoproceedincreatingthereceipt andlinkingthe item.121 +In accordance with the above paragraph, this training manual is published and distributed on the basis that EBSphere (Pty) Ltd is not responsible/accountable for any actions taken by users of information contained in this training manual nor for any error in or omission from this manual. 105 105 106 - [[image:LinkingofContributionsviaBankReconciliation_html_5cb8b7740f175d8b.gif||alt="Shape3"]][[image:Linking ofContributionsviaBankReconciliation_html_a5ccfb88911a7465.png||height="90"width="630"]]123 +EBSphere (Pty) Ltd does not accept any responsibility whatsoever for a misrepresentation performed by any person in respect of claims, losses or damage or any other matter, either direct or consequential arising out of or in relation to the use and reliance, whether wholly or partially, upon any information contained or products referred to in this manual. 107 107 108 - Complete therequirevariables andclickon the“**Add**”button:125 +Further, the contents of this training manual are subject to change without any notice and further highlight the need for this training manual to serve only as a guide. 109 109 110 -[[image:Linking of Contributions via Bank Reconciliation _html_8b89b550a1df11dc.gif||alt="Shape4"]] [[image:Linking of Contributions via Bank Reconciliation _html_e4a40fdb6281c5b1.png||height="216" width="630"]] 111 111 112 -**Options** Select “**Contribution Amount**” from the dropdown. 113 113 114 - **Client**Selectthe relevant Client that thecontributionis in respect of.129 +(% style="color:#2980b9" %)**COPYRIGHT** 115 115 116 - **Paypoint**Select the relevantPaypointthismoneyisinrespect of.**(This field is mandatory,evenifthe payment wasmadeinrespect of the wholeClient)**131 +This documentation and the software described in it is the exclusive property of EBSphere (Pty) Ltd. This manual or the software may not be copied in whole or part, without the express written consent of EBSphere (Pty) Ltd. Under the law, copying includes translating into another language or format. 117 117 118 - A batch screen will open. All theinformation that was capturedontheprevious screen is populated here. Select “**Execute**” to run the batch and update the system. This also linksthebank entry:133 +EBSphere (Pty) Limited 119 119 120 -[[image:Linking of Contributions via Bank Reconciliation _html_542e1cdeaa6d82e8.png||height="179" width="353"]] 135 +P.O. Box 785803 136 + 137 +Sandton 138 + 139 +2146 140 + 141 + 142 + 143 +[[image:Linking of Contributions via Bank Reconciliation _html_8cba33b1e8c9fa24.gif||data-xwiki-image-style-alignment="center" height="128" width="465"]]
- Linking of Contributions via Bank Reconciliation _html_8cba33b1e8c9fa24.gif
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +38.2 KB - Content
- image-20220811143853-1.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +63.4 KB - Content
- image-20220811143933-2.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +69.7 KB - Content
- image-20220811144007-3.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +149.2 KB - Content
- image-20220811144040-4.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +35.4 KB - Content
- image-20220811144108-5.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +55.1 KB - Content
- image-20220811144201-6.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +109.5 KB - Content
- image-20220811144226-7.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +180.2 KB - Content
- image-20220811144246-8.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +13.0 KB - Content
- image-20220811144322-9.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +68.2 KB - Content
- image-20220811144419-10.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +85.6 KB - Content
- image-20220811144437-11.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +110.0 KB - Content
- image-20220811144509-12.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.megank - Size
-
... ... @@ -1,0 +1,1 @@ 1 +68.9 KB - Content