A B C D E F G H 1 Customer A/R Balance Confirm Received Customer Statement/Exception 2 3 A un 17,000 YES Paid $10,000 on Dec 27 4 C 55,000 YES Received $11,000 of Goods on Jan 3 5 F $ 38,000 YES Paid Full Amount on Dec 27 6 H 15,000 YES Returned $4,000 on Dec 29 - u 22,000 YES Paid Full Amount with 1% Discount on Jan 2 8A26 X V fx 12/29/2020 A B C D E F G H J Shipping Date Customer Shipping Terms Cost Sales Price W N P 23-Dec B Destination 5,000 11,000 23-Dec G Shipping Point 15,000 31,000 23-Dec Shipping Point 18,000 35,000 23-Dec Q Destination 20,000 47,000 23-Dec W Shipping Point 3,000 5,000 23-Dec Shipping Point 22,000 40,000 27-Dec P Shipping Point 12,000 20,000 10 27-Dec Shipping Point 5,000 11,000 11 27-Dec Shipping Point 7,000 14,000 12 27-Dec Shipping Point 12,000 25,000 13 27-Dec Shipping Point 12,000 25,000 14 27-Dec Destination 66,000 130,000 15 27-Dec Shipping Point 20,000 44,000 16 27-Dec Shipping Point 3,000 5,000 17 28-Dec Shipping Point 5,000 10,000 18 28-Dec G Shipping Point 44,000 80,000 19 28-Dec N Shipping Point 12,000 20,000 20 28-Dec m Shipping Point 31,000 60,000 21 28-Dec Shipping Point 8,000 15,000 22 28-Dec R Destination 9,000 17,000 23 28-Dec X Shipping Point 24,000 40,000 24 29-Dec G Shipping Point 21,000 44,000 25 29-Dec r Destination 4,000 9,000 26 29-Dec C Shipping Point 5,000 11,000 27 29-Dec G Shipping Point 8,000 15,000 28 29-Dec D Shipping Point 20,000 45,000 29 29-Dec E Shipping Point 18,000 35,000 30 29-Dec D Shipping Point 30,000 55,000 31 29-Dec T Shipping Point 14,000 32 33 END OF YEAR 34 25\fA2 X V fx A B C D E F G Date Customer Sales Returned Reason for Return 29-Dec B 6,000 Wrong Item Shipped, Replaced in January 5-Jan D 4,000 Customer Ordered Too Many, Returned Extras O V O UAWNH 9-Jan H 4,000 Customer Ordered Too Many, Returned Extras 17-Jan S 9,000 Wrong Item Ordered, Replaced in January