German LLCs books show a cash book balance of OMR 5,445 on September 30, 2021. The bank statement for the period shows a balance of OMR4,115. A detailed examination of Companys records and bank statement revealed the following information:

1. Bank collected a 3 month note OMR xx and charged a collection fee OMR xx.
2. Company cheque for OMR 676 dated on September 12 to settle an account payable, was cleared on September 20. The company recorded this cheque for OMR 667.
3. A cheque received from a customer, returned by the bank as NSF OMR xx.
4. An EFT (Electronic Fund Transfer) receipt for the dividend earned OMR xx on the investment made, not included in the books.
5. A review of bank statement revealed that a cheque written by Gerund LLC for OMR xx is incorrectly drawn against German LLC.
6. As per the bank statement it is shown that a note for OMR xx with OMR xx interest has been collected by the bank. This transaction is not seen in the companys statement.

Required:

Prepare a bank reconciliation statement for German LLC for the month of September 2021.

Note: Fill the highlighted fields with imaginary amounts before you begin. Make sure that the adjusted cash balance and bank balances are same after reconciliation.

Please solve it on table step-by-step