51084 - Create a system to prepare payments for bank deposit

For our proprietary software, called OTS, we are building modules to perform various tasks. In this project, we are working on the Accounting Module called the Bookkeeper, and the specific feature of Bank Deposits. This is an incomplete feature that was in development, however our web developer fell ill and now we need this project to be completed. How It Works 1. In our system, we enter payments received from clients on a daily basis. Payments are either by cheque, cash, EFT, or Credit Card. Credit Card payments are processed through our system, and all other payments are entered manually. 2. Currently, when we have payments by cheques, we have to create a ‘Bank Deposit’. This means we create a manual report called the Deposit Summary, that shows the cheque #, client name, and amount. Then we add up the sum total of the cheques and physically bring those to the bank. 3. Our system currently only tracks payments against an invoice, and we do not have a way of actually managing all of the payments in an interface. Note: The flow of payments, irrespective of the payment method, should be as follows: Payment Received > Undeposited Funds > Select Payments from Undeposited Funds > Create Deposit Summary > Deposit to Bank Account Its important to note that when we ‘deposit’ to a bank account, we are not really performing the actual deposit online. For this project, the purpose is to create the deposit summary form automatically rather than doing it manually, and to mark payments received as already having been deposited to our bank.   Scope of Work • Create a table and page, that will enable the user to manage various bank account to which payments will be deposited. • Create a page that will enable the user to review and manage the history of bank deposits. The user must be able to download each Deposit Summary into PDF or Excel format, and print the deposit summary • Create a Dashboard where the user can view payments that are currently in the status of ‘Undeposited Funds’, then select which payment will be deposited to one of the bank accounts, and then create a Deposit Summary. To ensure you have read our requirements, add the word "Hortons" with your bid