FNSACC312 Performance Task 1.2 Having troubles with this task. Any one able to help?

10:49 pm Thu 29 Jun . . . 77% mciinstitute. learnlogin.com Unit home V Project Performance Task 1 Performance Task 2 Performance Task 3 Performance Task 4 Learning resource Assessment Performance Task 5 Performance Task 6 Supporting info Projects 2 Riscko debtor schedule as at 31 May 20XX correction task 9 My notes You are Joan Jacks and you are an Accountant who works for Riskco, a reputable risk management Q Search consultancy company. You are checking the debtor's ledger for the 315t of May prepared by the accounts clerk John Bee. John Bee has recently had a heavy workload, so you are anticipating some errors in his work. Timeline You are required to check the debtors schedule based on the invoice and repayment information below. Using spreadsheet software please produce and amend the report based on your calculations: Riskco debtor schedule 31 May 20XX (prepared by John Bee) Debtor Balance 0-30 days 31-60 days 61-90+ days outstanding Nella Pty Ltd $1,250 $350 $500 $400 Aban Pty Ltd $1,350 $200 $230 $230 Gan Pty Ltd $450 $450 Nena Pty Ltd $240 $240 Jan Pty Ltd $1,200 $1,200 Total $4,490 $790 $730 $2,280 Customer transaction details Nella Pty Ltd Risk management invoice 12 dated 1 May for $350. Risk management invoice 59 dated_1 April for $500 Risk management invoice 32 dated 1 January for $400 Paid invoice 32 on 15 May (full amount) Paid invoice 59 on 14 May (50% of the balance). Aban Pty Ltd Risk management invoice 71 dated 3 May for $350 Risk management invoice 34 dated 1 January for $1,200 Risk management invoice 36 dated 31 December for $1,300 Paid invoice 34 on 10 May (50% of the balance). Gan Pty Ltd Risk management invoice dated 5 May for $200 Risk management invoice dated 2 April for $300 Risk management invoice 14 dated 5 April for $650 Paid invoice 14 on 1 May (50% of the balance) Nena Pty Ltd Risk management invoice 19 dated 1 May for $240. Jan Pty Ltd Risk management invoice 39 dated 31 December for $1,200. Riskco debtor schedule 31 May 20XX (prepared by John Bee and amended by John Jacks) Debtor Balance 0-30 days 31-60 days 61-90+ days outstanding