Question: Instructions: This task invloves some detective work but it is the kind of detective work that goes on in acounts offices all the time. Given

 Instructions: This task invloves some detective work but it is the

Instructions: This task invloves some detective work but it is the kind of detective work that goes on in acounts offices all the time. Given below one of the customers' account statement from the period 01 Jan 2019 to 30 Apr 2019. Over the last four months, the payments from this customer has been received every month. However, there is an outstanding balance of 389.00. Now a cheque of amount 291.00 has been received and this does not match up. So, you need to find out which invoices have been paid and which have not. Once you have identified the invoices unpaid, you should be able to work out what the #291.00 is for. Along the bottom of the statement you will see a row filled in yellow marked as 12 Days, 90 Days, 60 Days, 30 Days and Current. This is called Aged Debtor analysis. The purpose is to provide information on how old debts are. If April invoices are "Current" and March invoices are "30 Days", then put respective values in each of the cells in the yellow row. The total debt according to the statement is $389.00, and therefore you should ensure that the sum of boxes in yellow equals 389.00 BLACK STAGE RECREATION CLUB Customer Name: Heinz Limited STATEMENT 30-04-2019 Ref. No. XYZ020 Cr. Date Reference Description Dr. Balance 14938 15029 15389 15789 132.00 110.00 225.00 66.00 160.00 74.00 84.00 01-01-2019 01-05-2019 15-01-2019 20-01-2019 02-02-2019 15-02-2019 02-05-2019 18-02-2019 21-02-2019 27-02-2019 03-03-2019 03-09-2019 03-12-2019 26-03-2019 29-03-2019 04-04-2019 04-10-2019 25-04-2019 15992 16119 16303 16592 242.00 Balance blfwd Invoice Invoice Invoice Invoice Payment Invoice Invoice Credit Note Invoice Payment Invoice Invoice Invoice Invoice Credit Note Invoice Payment 52.00 210.00 160.00 292.00 402.00 627.00 693.00 533.00 607.00 691.00 449.00 501.00 291.00 325.00 381.00 591.00 674.00 640.00 738.00 389.00 Total 389.00 16843 17002 17449 17601 17753 18020 34.00 56.00 210.00 83.00 34.00 98.00 349.00 120 Days 90 Days 60 Days 30 Days Current

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!