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, 0 added, 12 removed)
- 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,143 +2,120 @@ 1 - 2 2 3 -(% style="text-align: center;" %) 4 -(% style="color:#2980b9; font-size:28px" %)**LINKING OF CONTRIBUTIIONS VIA BANK RECONCILIATION** 2 +**DISCLAIMER** 5 5 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. 6 6 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 -(% style="text-align: center;" %) 9 -(% style="color:#2980b9" %)**BY** 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. 10 10 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"]] 14 14 15 -{{info}} 16 -(% style="text-align: center;" %) 17 -(% style="font-size:22px" %)**TABLE OF CONTENTS** 18 18 19 19 20 -{{toc/}} 21 21 22 - 23 -{{/info}} 24 24 25 25 26 -(% style="text-align: center;" %) 27 -== (% style="color:#2980b9" %)**Confirming receipt of the contribution**(%%) == 19 +**COPYRIGHT** 28 28 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. 29 29 30 - Requesta(% style="color:#2980b9" %)“**ParentBank Statement**”(%%) to check that the contribution amount has been received inthebank account.23 +EBSphere (Pty) Limited 31 31 32 - Completethe required parameters before executingthe batch to generate the statement:25 +P.O. Box 785803 33 33 34 - (% style="color:#2980b9" %)**Amount 1**(%%) Represents the bank statement start number27 +Sandton 35 35 36 - (% style="color:#2980b9" %)**Amount 2** (%%)Represents the bank statement end number29 +2146 37 37 38 -(% style="color:#2980b9" %)**OR** 39 39 40 -(% style="color:#2980b9" %)**Date 1** (%%)Represents the start date 41 41 42 - (%style="color:#2980b9"%)**Date2**(%%)Representstheend date33 +[[image:Linking of Contributions via Bank Reconciliation _html_8cba33b1e8c9fa24.gif||height="96" width="344"]] //Confirming receipt of the contribution// 43 43 44 -[[image:image-20220811143853-1.png||data-xwiki-image-style-alignment="center"]] 45 45 46 - [[image:image-20220811143933-2.png]]36 +Request a “**Parent Bank Statement**” to check that the contribution amount has been received in the bank account. 47 47 38 +Complete the required parameters before executing the batch to generate the statement: 48 48 49 - The reportwillreflect all transactionswithin thecriteria selectedabove:40 +**Amount 1** Represents the bank statement start number 50 50 51 - [[image:image-20220811144007-3.png||data-xwiki-image-style-alignment="center"]]42 +**Amount 2** Represents the bank statement end number 52 52 44 +**OR** 53 53 54 -(% style="text-align: center;" %) 55 -== (% style="color:#2980b9" %)**Linking the contribution**(%%) == 46 +**Date 1** Represents the start date 56 56 48 +**Date 2** Represents the end date 57 57 58 -Go to the Accounts menu and select Bank Reconciliation: 59 59 60 -[[image:image-20220811144040-4.png||data-xwiki-image-style-alignment="center"]] 61 61 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"]] 62 62 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: 64 64 65 -[[image:image-20220811144108-5.png||data-xwiki-image-style-alignment="center"]] 66 66 67 67 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: 69 69 70 -[[image:image-20220811144201-6.png||data-xwiki-image-style-alignment="center"]] 71 71 59 +The report will reflect all transactions within the criteria selected above: 72 72 73 - A doublescreenwilldisplay. The left-handsideistheBankStatemententries;therigh-handside isthe Cash Book entries:61 +[[image:Linking of Contributions via Bank Reconciliation _html_14b74882710910f0.png||height="183" width="630"]] 74 74 75 -[[image:image-20220811144226-7.png||data-xwiki-image-style-alignment="center"]] 76 76 64 +//Linking the contribution// 77 77 78 - The user will be required tofilter the date rangeontheCash Book side byupdatingthedaterangeandclickingonthe(% style="color:#2980b9" %)“**Search**” (%%)button:66 +Go to the Accounts menu and select Bank Reconciliation: 79 79 80 -[[image:i mage-20220811144246-8.png||data-xwiki-image-style-alignment="center"]]68 +[[image:Linking of Contributions via Bank Reconciliation _html_ccc36c158be48a3e.png||height="141" width="182"]] 81 81 82 - Items reflectingin (% style="color:#2980b9"%)**green**(%%)havebeenreconciled. Those in (% style="color:#2980b9"%)**black **(%%)muststill be reconciled. The contributionamountmaynothavebeen receiptedin Everestas yet,andmaythereforenot reflecton theCash Bookside. Inthisinstanceselect the(% style="color:#2980b9" %)“**Next**”(%%)button at the bottom of the page.70 +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 “**Next**” button at the bottom of the page: 83 83 72 +[[image:Linking of Contributions via Bank Reconciliation _html_4ba97f29d2ddd052.png||height="146" width="630"]] 84 84 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. 86 86 87 -[[image:image-20220811144322-9.png||data-xwiki-image-style-alignment="center"]] 88 88 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. 90 90 91 91 92 -Double click on the (% style="color:#2980b9" %)__select __(%%)hyperlink to proceed in creating the receipt and linking the item. 93 93 94 -[[image:image-20220811144419-10.png]] 95 95 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: 96 96 97 -Complete the require variables and click on the (% style="color:#2980b9" %)“**Add**”(%%) button: 98 98 99 -[[image:i mage-20220811144437-11.png||data-xwiki-image-style-alignment="center"]]83 +[[image:Linking of Contributions via Bank Reconciliation _html_4c6aa526d5b8e0fc.png||height="163" width="630"]] 100 100 85 +A double screen will display. The left-hand side is the Bank Statement entries; the righ-hand side is the Cash Book entries: 101 101 102 - (% style="color:#2980b9" %)**Options**(%%)Select (% style="color:#2980b9"%)“**ContributionAmount**” (%%)fromthedropdown.87 +[[image:Linking of Contributions via Bank Reconciliation _html_7a9b8db66c3954b.png||height="82" width="630"]] 103 103 104 - (%style="color:#2980b9"%)**Client**(%%)Select therelevant Clientthat thecontributionisinrespectof.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: 105 105 106 - (% style="color:#2980b9" %)**Paypoint**(%%)Selectthe relevantPaypointthis money is inrespectof. (% style="color:#2980b9" %)**(This fieldis mandatory, evenif the paymentwasmadein respect of thewholeClient)**91 +[[image:Linking of Contributions via Bank Reconciliation _html_f9fd5232b5ad836e.png||height="15" width="630"]] 107 107 108 - A batchscreenwillopen.Alltheinformation thatwascapturedontheprevious screenis populated here.Select(%style="color:#2980b9"%)“**Execute**”(%%)to runthe batch andupdatethesystem.This alsolinksthebankentry: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. 109 109 110 - [[image:image-20220811144509-12.png||data-xwiki-image-style-alignment="center"]]95 +The “**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 “**Next**” button at the bottom of the page. 111 111 97 +[[image:Linking of Contributions via Bank Reconciliation _html_c7875f5b5711f051.png||height="101" width="596"]] 112 112 113 -(% style="text-align: center;" %) 114 -== (% style="color:#2980b9" %)**Disclaimer and Copyright**(%%) == 115 115 116 116 117 -(% style="color:#2980b9" %)**DISCLAIMER** 118 118 119 - Pleasenote,whilstcareistakentoillustrate numerousscenarios,itisimpossible todetailallinstancesandthereforethisdocumentshouldmerelyserveas aguideforthepurposesofdemonstratingsystemfunctionalityand conductingemployeetraining.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. 120 120 121 - In accordance with the above paragraph, this training manual is publishedand distributedon thebasis that EBSphere (Pty) Ltd is not responsible/accountablefor anyactions takenby usersofinformationcontained inthis trainingmanualnorforanyerrorinor omissionfromthismanual.104 +Double click on the __select __hyperlink to proceed in creating the receipt and linking the item. 122 122 123 - EBSphere (Pty)Ltddoesnot acceptanyresponsibility whatsoever for a misrepresentationperformedby any personin respect ofclaims,losses or damage or any othermatter, either direct or consequential arising out of or inrelationto the useandreliance,whether wholly or partially, upon anyinformationcontained or products referredtointhis manual.106 +[[image:Linking of Contributions via Bank Reconciliation _html_5cb8b7740f175d8b.gif||alt="Shape3"]] [[image:Linking of Contributions via Bank Reconciliation _html_a5ccfb88911a7465.png||height="90" width="630"]] 124 124 125 - Further,thecontents of this training manualaresubjectto changewithout any noticeandfurtherhighlight the needfor this training manualtoserve only as a guide.108 +Complete the require variables and click on the “**Add**” button: 126 126 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"]] 127 127 112 +**Options** Select “**Contribution Amount**” from the dropdown. 128 128 129 - (%style="color:#2980b9"%)**COPYRIGHT**114 +**Client** Select the relevant Client that the contribution is in respect of. 130 130 131 - Thisdocumentationandthesoftwaredescribed in it istheexclusivepropertyofEBSphere(Pty) Ltd.This manual orthe software maynot becopiedinwholeorpart,withouttheexpress writtenconsent ofEBSphere (Pty) Ltd. Under thelaw, copying includestranslating into another language or format.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)** 132 132 133 - EBSphere(Pty)Limited118 +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: 134 134 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"]] 120 +[[image:Linking of Contributions via Bank Reconciliation _html_542e1cdeaa6d82e8.png||height="179" width="353"]]
- image-20220811143853-1.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -63.4 KB - Content
- image-20220811143933-2.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -69.7 KB - Content
- image-20220811144007-3.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -149.2 KB - Content
- image-20220811144040-4.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -35.4 KB - Content
- image-20220811144108-5.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -55.1 KB - Content
- image-20220811144201-6.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -109.5 KB - Content
- image-20220811144226-7.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -180.2 KB - Content
- image-20220811144246-8.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -13.0 KB - Content
- image-20220811144322-9.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -68.2 KB - Content
- image-20220811144419-10.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -85.6 KB - Content
- image-20220811144437-11.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -110.0 KB - Content
- image-20220811144509-12.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.megank - Size
-
... ... @@ -1,1 +1,0 @@ 1 -68.9 KB - Content