Wiki source code of Linking of Contributions via Bank Reconciliation
Last modified by Megan Kahl on 2022/08/11 12:46
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
19.1 | 1 | |
| |
2.1 | 2 | |
| |
19.1 | 3 | (% style="text-align: center;" %) |
| 4 | (% style="color:#2980b9; font-size:28px" %)**LINKING OF CONTRIBUTIIONS VIA BANK RECONCILIATION** | ||
| |
2.1 | 5 | |
| 6 | |||
| 7 | |||
| |
19.1 | 8 | (% style="text-align: center;" %) |
| 9 | (% style="color:#2980b9" %)**BY** | ||
| |
2.1 | 10 | |
| 11 | |||
| 12 | |||
| |
19.1 | 13 | [[image:Linking of Contributions via Bank Reconciliation _html_8cba33b1e8c9fa24.gif||data-xwiki-image-style-alignment="center" height="128" width="465"]] |
| |
2.1 | 14 | |
| |
19.1 | 15 | {{info}} |
| 16 | (% style="text-align: center;" %) | ||
| 17 | (% style="font-size:22px" %)**TABLE OF CONTENTS** | ||
| |
2.1 | 18 | |
| 19 | |||
| |
19.1 | 20 | {{toc/}} |
| |
2.1 | 21 | |
| |
19.1 | 22 | |
| 23 | {{/info}} | ||
| |
2.1 | 24 | |
| 25 | |||
| |
19.1 | 26 | (% style="text-align: center;" %) |
| 27 | == (% style="color:#2980b9" %)**Confirming receipt of the contribution**(%%) == | ||
| |
2.1 | 28 | |
| 29 | |||
| |
19.1 | 30 | Request a(% style="color:#2980b9" %) “**Parent Bank Statement**”(%%) to check that the contribution amount has been received in the bank account. |
| |
2.1 | 31 | |
| |
19.1 | 32 | Complete the required parameters before executing the batch to generate the statement: |
| |
2.1 | 33 | |
| |
19.1 | 34 | (% style="color:#2980b9" %)**Amount 1**(%%) Represents the bank statement start number |
| |
2.1 | 35 | |
| |
19.1 | 36 | (% style="color:#2980b9" %)**Amount 2** (%%)Represents the bank statement end number |
| |
2.1 | 37 | |
| |
19.1 | 38 | (% style="color:#2980b9" %)**OR** |
| |
2.1 | 39 | |
| |
19.1 | 40 | (% style="color:#2980b9" %)**Date 1** (%%)Represents the start date |
| |
2.1 | 41 | |
| |
19.1 | 42 | (% style="color:#2980b9" %)**Date 2** (%%)Represents the end date |
| |
2.1 | 43 | |
| |
20.1 | 44 | [[image:image-20220811143853-1.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 45 | |
| |
20.1 | 46 | [[image:image-20220811143933-2.png]] |
| |
2.1 | 47 | |
| |
20.1 | 48 | |
| |
19.1 | 49 | The report will reflect all transactions within the criteria selected above: |
| |
2.1 | 50 | |
| |
20.1 | 51 | [[image:image-20220811144007-3.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 52 | |
| 53 | |||
| |
19.1 | 54 | (% style="text-align: center;" %) |
| 55 | == (% style="color:#2980b9" %)**Linking the contribution**(%%) == | ||
| |
2.1 | 56 | |
| 57 | |||
| |
19.1 | 58 | Go to the Accounts menu and select Bank Reconciliation: |
| |
2.1 | 59 | |
| |
20.1 | 60 | [[image:image-20220811144040-4.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 61 | |
| 62 | |||
| |
19.1 | 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: |
| |
2.1 | 64 | |
| |
20.1 | 65 | [[image:image-20220811144108-5.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 66 | |
| 67 | |||
| |
19.1 | 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: |
| |
2.1 | 69 | |
| |
20.1 | 70 | [[image:image-20220811144201-6.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 71 | |
| 72 | |||
| |
19.1 | 73 | A double screen will display. The left-hand side is the Bank Statement entries; the righ-hand side is the Cash Book entries: |
| |
2.1 | 74 | |
| |
20.1 | 75 | [[image:image-20220811144226-7.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 76 | |
| 77 | |||
| |
19.1 | 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: |
| |
2.1 | 79 | |
| |
20.1 | 80 | [[image:image-20220811144246-8.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 81 | |
| |
19.1 | 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. |
| |
2.1 | 83 | |
| |
20.1 | 84 | |
| |
19.1 | 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. |
| |
2.1 | 86 | |
| |
20.1 | 87 | [[image:image-20220811144322-9.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 88 | |
| |
19.1 | 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. |
| |
2.1 | 90 | |
| |
20.1 | 91 | |
| |
19.1 | 92 | Double click on the (% style="color:#2980b9" %)__select __(%%)hyperlink to proceed in creating the receipt and linking the item. |
| |
2.1 | 93 | |
| |
20.1 | 94 | [[image:image-20220811144419-10.png]] |
| |
2.1 | 95 | |
| |
20.1 | 96 | |
| |
19.1 | 97 | Complete the require variables and click on the (% style="color:#2980b9" %)“**Add**”(%%) button: |
| |
2.1 | 98 | |
| |
20.1 | 99 | [[image:image-20220811144437-11.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 100 | |
| |
20.1 | 101 | |
| |
19.1 | 102 | (% style="color:#2980b9" %)**Options**(%%) Select (% style="color:#2980b9" %)“**Contribution Amount**” (%%)from the dropdown. |
| |
2.1 | 103 | |
| |
19.1 | 104 | (% style="color:#2980b9" %)**Client**(%%) Select the relevant Client that the contribution is in respect of. |
| |
2.1 | 105 | |
| |
19.1 | 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)** |
| |
2.1 | 107 | |
| |
19.1 | 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: |
| |
2.1 | 109 | |
| |
20.1 | 110 | [[image:image-20220811144509-12.png||data-xwiki-image-style-alignment="center"]] |
| |
2.1 | 111 | |
| 112 | |||
| |
19.1 | 113 | (% style="text-align: center;" %) |
| 114 | == (% style="color:#2980b9" %)**Disclaimer and Copyright**(%%) == | ||
| |
2.1 | 115 | |
| 116 | |||
| |
19.1 | 117 | (% style="color:#2980b9" %)**DISCLAIMER** |
| |
2.1 | 118 | |
| |
19.1 | 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. |
| |
2.1 | 120 | |
| |
19.1 | 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. |
| |
2.1 | 122 | |
| |
19.1 | 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. |
| |
2.1 | 124 | |
| |
19.1 | 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. |
| |
2.1 | 126 | |
| 127 | |||
| 128 | |||
| |
19.1 | 129 | (% style="color:#2980b9" %)**COPYRIGHT** |
| |
2.1 | 130 | |
| |
19.1 | 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. |
| |
2.1 | 132 | |
| |
19.1 | 133 | EBSphere (Pty) Limited |
| |
2.1 | 134 | |
| |
19.1 | 135 | P.O. Box 785803 |
| |
2.1 | 136 | |
| |
19.1 | 137 | Sandton |
| |
2.1 | 138 | |
| |
19.1 | 139 | 2146 |
| |
2.1 | 140 | |
| 141 | |||
| |
19.1 | 142 | |
| 143 | [[image:Linking of Contributions via Bank Reconciliation _html_8cba33b1e8c9fa24.gif||data-xwiki-image-style-alignment="center" height="128" width="465"]] |