2 Riscko debtor schedule as at 31 May 20XX correction task You are Joan Jacks and you are an Accountant who works for Riskco, a reputable risk management consultancy company. You are checking the debtor's ledger for the 31st 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. 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) Balance outstanding Debtor Nella Pty Ltd Aban Pty Ltd Gan Pty Ltd Nena Pty Ltd Jan Pty Ltd Total $1,250 $1,350 $450 $240 $1,200 $4,490 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 0-30 days $350 $200 $240 $790 4 31-60 days $500 $230 $730 61-90+ days $400 $230 $450 $1,200 $2,280