Answered step by step
Verified Expert Solution
Question
1 Approved Answer
the first image is my myob entries an d its suppose to match with the entries shown in the right(the assignment) can i someone help
the first image is my myob entries an
d its suppose to match with the entries shown in the right(the assignment) can i someone help where i went wrong in my cash payments and cash receipts.
i will upvote if you can help
AccountRight Plus - [Reconcile Accounts] File Edit Services Help Lists Command Centres Setup Reports Window Cash at bank $87 840.75 New Statement Balance: Calculated stateroert Balance: Out of Balance Account 111110 Last Reconciled Date: Bank Statement Date: 31/07/2021 $77.562.50 $10.278.25 Deposits Withdrawals $2,420.00 $8,239.00 $6,300.00 $4,000.00 $7.300.00 $12,600.00 $605.00 $6,198,50 $4,800.00 $8200.00 $2.400.00 $8.400.00 $1 650.00 $6,500.00 Mark All Deared transactions VS 4150 12/07/2021 Business Premise Rent CR000001 2707/2021 Cash Sales for 00000009 CR000006 2/07/2021 Payment: Sarah Colons 4151 4R07/2021 Sales Commission CR000014 5/07/2021 Payment Karen Rule 4152 6/07/2021 Yasmin's Wool 4153 8/07/2021 Office repairs and maintenance VB CR000002 8207/2021 Cash Sales for 00000012 4154 9/07/2021 Stationary Supplier OR000015 10/07/2021 Payment Jeremy Sky 4155 12/07/2021 Advertising Agency 5 4156 14/07/2021 Wages + PAYG witholding V Bank ST 15/07/2021 Lease Motor Vehicle > CR000009 15/07/2021 Payment: James Smith D4156 16/07/2021 SA Fabrics D4158 17/07/2021 PAYG withholding 4159 18/07/2021 July GST Obligation 4160 20/07/2021 Saber Linens D CR000010 20/07/2021 Telstra Dividend CR000016 20/07/2021 Payment Jerry Brown 5 4161 21/07/2021 Accountants D CR000003 22/07/2021 Cash Sales for 00000016 > 4162 23/07/2021 Reimbursement of Petty Cash CR000071 23/07/2021 Payment. Matthew Lee 4163 25/07/2021 Computer Maintenance CR000004 25/07/2021 Cash Sales for 00000019 CRO00012 25/07/2021 Payment Oliver Queen 4164 28/07/2021 Wages + PAYG withholding Tax 5 CRO00005 28/07/2021 Oliver Queen for 00000026 4165 30/07/2021 Prepaid Rent-August CR000013 30/07/2021 Payment Chanel Toe B 4166 31/07/2021 Telephone - Bank ST 31/07/2021 Bank Charges for July Bank ST 31/07/2021 Interest on Deposits $7.400.00 $3,600,00 $5,000.00 $24.050.00 $1,200.00 $9.000.00 $2.540 00 $8.380.00 $759.00 $8.400.00 $2,148.00 $7.507.50 $4,800.00 $9.300.00 $14.995.75 $2,420.00 $5,500.00 $3,828.00 $110.00 $250.00 27 22 WA File C:/Users/jayde/OneDrive Desktop/a2207 Aut%2022 ANZZZ Bank Business Trading Account Account Name: Case Study Date 1-Jul 3-Jul 4-Jul 5 Jul 6- Jul 7-Jul 7-Jul B-Jul 9-Jul 10-Jul 11-Jul 12-Jul 14-Jul 15-Jul 16-Jul 19-Jul 20-Jul 21-Ju 22-Jul 22-Jul 23-Jul 23-Jul 24-Jul 24-Jul 24-jul 25-Jul 27-Jul 28-Jul 29-Jul 31-Jul 31-Jul 31-Jul The Manager, 01-July-2021 Your Name Clothes Pty Ltd From: Address (Student ID) To: 31 July 2021 Debit Credit Balance Particulars $85,600.00 Opening Balance $8,239.00 $93,839.00 Deposit - Cash & Cheques $6,300.00 $100,139.00 Deposit - Cash & Cheques $2,420.00 $97,719.00 Chq # 4150 Deposit - Cash & Cheques $7,300.00 $105,019.00 Cho # 4151 $4,000.00 $101,019.00 Deposit - Cash & Cheques $6,500.00 $94,919.00 Chg # 4152 $12,600.00 $88,419.00 Deposit - Cash & Cheques $6,198.50 $101,117.50 Chq # 4153 $605.00 $100,512.50 Deposit - Cash & Cheques $8,200.00 $108,712.50 Chg # 4155 $2,400.00 $106,312.50 Chq # 4154 $4,800.00 $101,512.50 Periodic Payment - Lease MV $1,650.00 $99,862.50 Chg # 4157 $7.400.00 $92,462.50 Cha # 4156 $8,400.00 $84,062.50 Direct deposit - AR04 $9,000.00 $93,062.50 Deposit - Cash & Cheques $1,200.00 $94,262.50 Chg # 4160 $5,900.00 $88,362.50 Deposit - Cash & Cheques $6,314.00 $94,676.50 Chg # 4159 $5,000.00 $89,676.50 Deposit - Cash & Cheques $5.813.50 Chg # 4158 $95,490.00 $12,000.00 $83,490.00 Chg # 4161 $1,000.00 Deposit - Cash & Cheques $82,490.00 $8.400.00 Chg #4163 $90,890.00 $800.00 Deposit-Cash & Cheques $90,090.00 $750750 $97 597.50 Chg # 4162 $10,690.50 $108,288.00 $759.00 Deposit - Cash & Chegues $107 529.00 Chg # 4164 $14,547.50 $122,076.50 $9,300.00 $112,776.50 Interest on Deposits $120.00 $112,656.50 $250.00 S112.906-50 Deposit Cash & Cheques Bank Charges 31-Jul Transactions not shown on the Bank Statement are either UNPRESENTED CHEQUES or OUTSTANDING DEPOSITS. Page 8 of 9 Data source - Deposit book (Cash Receipts) Date Transaction Details 2 Jul Customer 003 paid his account as at 1st July amounting to $6,300. 5 Jul Cheque received from C06 for balance owing as at 1st July. 10 Jul Cheque received from 007 for balance owing as at 15 July. 15 Jul Customer C01 paid his account as at 1st July amounting to $6,500. 20 Jul Received Dividend form Telstra amounting to $1,200. 23 Jul Cheque received from C02 for $8,400. 25 Jul Cheque received from C08 for total amount owing as at today's date leaving a nil balance on this account. 30 Jul Cheque received from C05 for total amount owing as at today's date leaving a nil balance on this account. Data source - Cheque book (Cash Payments) Date Chq # Transaction Details 4150 Paid for rent of business premises for the month amounting to $2,420. 4 Jul 4151 Paid June Sales Commission owing as at 1st July $4,000. 6 Jul 4152 Paid s01 $12,600 being the balance owing as at 1st July. 8 Jul 4153 Paid for repairs and maintenance to office $605. 9 Jul 4154 Paid S04 balance owing as at 1st July. 12 Jul 4155 Paid S08 balance owing as at 1st July. 14 Jul 4156 Paid Net wages for the fortnight amounting to $8,400 and recorded PAYG withholding tax of $3,600 to be paid in August 2021. 16 Jul 4157 Paid S02 $7,400 being balance owing as at 1st July. 17 Jul 4158 Paid PAYG withholding payable as at 1st July. This amount was previously accrued (See trial balance as at 1st July). 18 Jul 4159 Paid GST obligation as at 1st July. 20 Jul 4160 Paid S03 balance owing as at 1st July. 21 Jul 4161 Paid S05 balance owing as at 1st July. 23 Jul 4162 Reimbursed petty cash for the following cash expenses incurred: Local Travel - taxi fares $275 General Office Expenses $176 Postage $308 25 Jul 4163 Paid S07 balance owing as at 1st July. 28 Jul 4164 Paid NET wages for the fortnight amounting to $9,300 and recorded PAYG withholding tax of $3,700 to be paid in August 2021. 30 Jul 4165 Prepaid rent for August 2021 amounting to $2,420. 31 Jul 4166 Paid S06 balance owing as at 1st July as well as all purchases for the month leaving a nil balance owing on this supplier's account. Dom Data source - Bank Statement (see page 9) Date 15 Jul 20 Jul Transaction Details Periodic payment for lease on motor vehicles $1,650. Customer C04 deposited $9,000 in the company's bank account being the balance owing as at 1st July. Bank Charges charged $120. Bank credited our account for interest earned on funds in bank account $250. 31 Jul 31 Jul 4 Data source - Notes and Working papers (Month-end Adjustments) Transaction Details Sales commission earned by retail assistants during July but not paid amounted to $3,800. 2 Salaries & Wages accrued at the end of the month amount to $4,600. 3 Computer Equipment is depreciated at 30% per annum (using the Reducing Balance method of depreciation). Depreciation is calculated using the number of days in the month. Prepaid Insurance as at 1st July, $11,205 as per the trial balance represented the balance of the premium paid on the annual policy, which commenced on 1st April 2021. Prepaid insurance is expensed on a monthly basis and the trial balance amount represents the unexpired portion of the policy as at 1st July. 5 Shop Fixtures & Fittings are depreciated at 15% per annum (using the Straight-Line method of depreciation). The company's short, and long-term loans are charged interest at the rate of 6.50% per annum paid quarterly, but accrued daily. Interest needs to be accrued for July (31 days). 7 Other expenses accrued at the end of the month include: Electricity $440 Annual Leave Provision $890 8 Create a Provision for Doubtful Debts equal to 5% of Accounts Receivable as at 31st July. 6 9 On 31st July, after the depreciation charge was made, the company sold some surplus to requirement Computer Equipment that had a written down value of $8,600 at the time of sale, for $8,800 (GST inclusive) cash. The computer equipment had originally costed the company $17,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started