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)
Details
- Page properties
-
- Content
-
... ... @@ -1,120 +1,138 @@ 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: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"]] 35 35 36 -Request a “**Parent Bank Statement**” to check that the contribution amount has been received in the bank account. 37 37 38 - Complete the requiredparametersbeforeexecutingthebatch to generatethestatement:47 +The report will reflect all transactions within the criteria selected above: 39 39 40 - **Amount1**Representsthebankstatement startnumber49 +[[image:Linking of Contributions via Bank Reconciliation _html_14b74882710910f0.png||height="183" width="630"]] 41 41 42 -**Amount 2** Represents the bank statement end number 43 43 44 -**OR** 52 +(% style="text-align: center;" %) 53 +== (% style="color:#2980b9" %)**Linking the contribution**(%%) == 45 45 46 -**Date 1** Represents the start date 47 47 48 - **Date2** Representstheenddate56 +Go to the Accounts menu and select Bank Reconciliation: 49 49 58 +[[image:Linking of Contributions via Bank Reconciliation _html_ccc36c158be48a3e.png||height="141" width="182"]] 50 50 51 51 52 - [[image:Linkingof ContributionsviaBankReconciliation_html_77e70a7fa2e9845d.gif||alt="Shape2"]][[image:Linkingof Contributionsvia Bank Reconciliation_html_77e70a7fa2e9845d.gif||alt="Shape1"]][[image:LinkingofContributionsviaBankReconciliation_html_c762b6d0e009c774.png||height="181"width="630"]][[image:Linking of ContributionsviaBank Reconciliation_html_5d12ee8a9e4a38a3.png||height="183" width="630"]]61 +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: 53 53 63 +[[image:Linking of Contributions via Bank Reconciliation _html_4ba97f29d2ddd052.png||height="146" width="630"]] 54 54 55 55 66 +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: 56 56 68 +[[image:Linking of Contributions via Bank Reconciliation _html_4c6aa526d5b8e0fc.png||height="163" width="630"]] 57 57 58 58 59 - The reportwillreflectalltransactionswithin thecriteria selectedabove:71 +A double screen will display. The left-hand side is the Bank Statement entries; the righ-hand side is the Cash Book entries: 60 60 61 -[[image:Linking of Contributions via Bank Reconciliation _html_ 14b74882710910f0.png||height="183" width="630"]]73 +[[image:Linking of Contributions via Bank Reconciliation _html_7a9b8db66c3954b.png||height="82" width="630"]] 62 62 63 63 64 - //Linking the contribution//76 +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: 65 65 66 - Gotothe Accounts menuandselectBank Reconciliation:78 +[[image:Linking of Contributions via Bank Reconciliation _html_f9fd5232b5ad836e.png||height="15" width="630"]] 67 67 68 - [[image:LinkingofContributionsviaBankReconciliation_html_ccc36c158be48a3e.png||height="141"width="182"]]80 +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. 69 69 70 - SelecteithertheBankStatementnumber thatthecontribution reflectson,or thedaterangeinwhichthecontribution reflects in thebankaccount.Selectthe“**Next**” button at the bottom of the page:82 +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. 71 71 72 -[[image:Linking of Contributions via Bank Reconciliation _html_ 4ba97f29d2ddd052.png||height="146" width="630"]]84 +[[image:Linking of Contributions via Bank Reconciliation _html_c7875f5b5711f051.png||height="101" width="596"]] 73 73 74 74 87 +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. 75 75 89 +Double click on the (% style="color:#2980b9" %)__select __(%%)hyperlink to proceed in creating the receipt and linking the item. 76 76 91 +[[image:Linking of Contributions via Bank Reconciliation _html_a5ccfb88911a7465.png||height="90" width="630"]] 77 77 93 +Complete the require variables and click on the (% style="color:#2980b9" %)“**Add**”(%%) button: 78 78 95 +[[image:Linking of Contributions via Bank Reconciliation _html_e4a40fdb6281c5b1.png||height="216" width="630"]] 79 79 80 - Thenextscreen will displayall theBank Statement transactions for the date rangeselected.Select the “Next”buttonatthe bottomofthe page:97 +(% style="color:#2980b9" %)**Options**(%%) Select (% style="color:#2980b9" %)“**Contribution Amount**” (%%)from the dropdown. 81 81 99 +(% style="color:#2980b9" %)**Client**(%%) Select the relevant Client that the contribution is in respect of. 82 82 83 - [[image:LinkingofContributionsviaBankReconciliation_html_4c6aa526d5b8e0fc.png||height="163"width="630"]]101 +(% 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)** 84 84 85 -A doublescreen willdisplay.Theleft-handside istheBankStatemententries;therigh-handsideistheCashBook entries:103 +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: 86 86 87 -[[image:Linking of Contributions via Bank Reconciliation _html_ 7a9b8db66c3954b.png||height="82" width="630"]]105 +[[image:Linking of Contributions via Bank Reconciliation _html_542e1cdeaa6d82e8.png||height="179" width="353"]] 88 88 89 -The user will be required to filter the date range on the Cash Book side by updating the date range and clicking on the “**Search**” button: 90 90 91 -[[image:Linking of Contributions via Bank Reconciliation _html_f9fd5232b5ad836e.png||height="15" width="630"]] 108 +(% style="text-align: center;" %) 109 +== (% style="color:#2980b9" %)**Disclaimer and Copyright**(%%) == 92 92 93 -Items reflecting in **green** have been reconciled. Those in **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 “**Next**” button at the bottom of the page. 94 94 95 - The“**Tab Errors**” screen will reflectanybank statement entries that have beenlinked incorrectly. These items will need tobe addressedbeforethe month end management accounts are produced, but is not required to be addressed in this process. Click on the “**Next**” button at the bottom of the page.112 +(% style="color:#2980b9" %)**DISCLAIMER** 96 96 97 - [[image:LinkingofContributionsviaBankReconciliation_html_c7875f5b5711f051.png||height="101"width="596"]]114 +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. 98 98 116 +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. 99 99 118 +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. 100 100 120 +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. 101 101 102 -The “**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. 103 103 104 -Double click on the __select __hyperlink to proceed in creating the receipt and linking the item. 105 105 106 - [[image:Linkingof Contributionsvia Bank Reconciliation _html_5cb8b7740f175d8b.gif||alt="Shape3"]] [[image:Linking of Contributions via Bank Reconciliation _html_a5ccfb88911a7465.png||height="90"width="630"]]124 +(% style="color:#2980b9" %)**COPYRIGHT** 107 107 108 - Completethe requirevariables andclickon the“**Add**”button:126 +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. 109 109 110 - [[image:Linking of Contributions viaBank Reconciliation _html_8b89b550a1df11dc.gif||alt="Shape4"]] [[image:Linkingof Contributionsvia Bank Reconciliation _html_e4a40fdb6281c5b1.png||height="216" width="630"]]128 +EBSphere (Pty) Limited 111 111 112 - **Options**Select “**ContributionAmount**” from the dropdown.130 +P.O. Box 785803 113 113 114 - **Client**Select the relevantClient that the contribution is in respect of.132 +Sandton 115 115 116 - **Paypoint** Select the relevant Paypoint this money is in respect of. **(This field is mandatory, even if the payment was made in respect of the whole Client)**134 +2146 117 117 118 -A batch screen will open. All the information that was captured on the previous screen is populated here. Select “**Execute**” to run the batch and update the system. This also links the bank entry: 119 119 120 -[[image:Linking of Contributions via Bank Reconciliation _html_542e1cdeaa6d82e8.png||height="179" width="353"]] 137 + 138 +[[image:Linking of Contributions via Bank Reconciliation _html_8cba33b1e8c9fa24.gif||data-xwiki-image-style-alignment="center" height="128" width="465"]]