Old MathJax webview

Old MathJax webview

need to record the cash payments and cash reciepts into the bank deposit the cash payments journal and cash reciepts journal and than the cash book balance

D 1 Bank Reconciliation for Food Boss Pty Ltd 2 3 Closing credit balance as per Bank Statement 4 Add outstanding deposits S 5 6 7 S 8 Sub-total 9 Sub-tract unpresented Cheques 10 Supplier's Name Cheque Number Amount 11 12 13 14 15 16 17 Closing Cash Book Balance 18 Cash Payments details: Date 1/10/2018 Cheque 21898 Payee My Real Estate Details Monthly Rent Amount $1,375 Dissection General Expense GST Paid $ $ $ 1,250.00 125.00 1,375.00 Cheque total Date Date 7/10/18 21900 Cash Cheque Payee Details Amount 3/10/18 21899 The Chronicle Advertising $137.50 Cheque Payee Details Wages $300 Amount Dissection 300.00 $ Dissection General expense GST Paid 125.00 General Expense 0.00 $ $ $ $ 12.50 300.00 GST Paid $ 137.50 Cheque total Cheque total Bank Statement page 20 The Accounting Bank Limited as at 31 October 2018 Statement For Food Boss Pty Ltd Balance Withdrawals Deposits Date 01 1,375.00 05 Details Balance b/f Cheque 21898 Deposit Cheque 21900 Bank fee 2,035.00 5,000.00 3,625.00 5,660.00 5,360.00 5,336.00 5,336.00 07 300.00 10 24.00 Cr 31 31 Statement Closing Balance Cash receipts details: 3/10/2018 001 Date Receipt No Received from: Details 6/10/2018 002 Date Receipt No 7/10/2018 003 Date Receipt No Received from: Details T Clare Sales P Carter Sales Received from: Details Cash sales Sales Cheque Amount Bank Branch $ 605.00 $ 770.00 WBC Camden Cheque Amount Bank Branch 660.00 CBA Picton Dissection Sales GST Total Denomination Value $100 200 $50 150 $20 100 $10 120 $5 25 Coin 10 Total 605 $ $ 700.00 70.00 770.00 Dissection Sales GST Total $ $ $ 600.00 60.00 660.00 Dissection Sales GST Total $ 550.00 $ 55.00 $ 605.00 You will need to use the excel answer template for points 1 - 5. Point 6 will require the use of MYOB software and the MYOB data file located within the assessment information icon. 1. Batch the following receipts into the bank deposit slip for the 7th October Details on the Bank deposit are Account No 801060 at the Narellan branch of The Accounting Bank Limited. Account Name should be Food Boss Pty Ltd. 2. Record the receipts into the Cash Receipts Journal. 3. Record the payments into the Cash Payments Journal. 4. Balance the cashbook as at 31 October. On the 1 October the cash book should show an opening balance of $5,000. 5. Reconcile the cashbook balance with the bank statement. 6. You are now required to enter the cash receipts and cash payments into MYOB. Refer to the OLS within the assessment information icon for further instructions on MYOB. a. Open MYOB b. Open the company file Ass2Foodboss C. Enter your name in the business address field (From Setup drop-down menu - Company information). d. Go to the banking command centre and use spend money to enter the payments. Then use receive money to enter the cash receipts. You will need to prepare a bank deposit on 7.10.18. e. Next reconcile the bank account. Don't forget to add the bank fee. f. Print the bank reconciliation report at 31.10.18 and include with your submission