In: Accounting
Tamarisk, Inc. includes the following account among its trade
receivables.
|
Hopkins Co. |
|||||||||
| 1/1 | Balance forward | 854 | 1/28 | Cash (#1710) | 1,342 | ||||
| 1/20 | Invoice #1710 | 1,342 | 4/2 | Cash (#2116) | 1,647 | ||||
| 3/14 | Invoice #2116 | 1,647 | 4/10 | Cash (1/1 Balance) | 187 | ||||
| 4/12 | Invoice #2412 | 2,082 | 4/30 | Cash (#2412) | 1,220 | ||||
| 9/5 | Invoice #3614 | 602 | 9/20 | Cash (#3614 and part of #2412) | 968 | ||||
| 10/17 | Invoice #4912 | 1,045 | 10/31 | Cash (#4912) | 1,045 | ||||
| 11/18 | Invoice #5681 | 2,440 | 12/1 | Cash (#5681) | 1,525 | ||||
| 12/20 | Invoice #6347 | 976 | 12/29 | Cash (#6347) | 976 | ||||
Age the balance.
| Hopkins Co. | Balance | ||||||
| 1-Jan | Balance forward | 854 | 10-Apr | Cash (1/1 Balance) | 187 | 667 | |
| 20-Jan | Invoice #1710 | 1,342 | 28-Jan | Cash (#1710) | 1,342 | 0 | |
| 14-Mar | Invoice #2116 | 1,647 | 2-Apr | Cash (#2116) | 1,647 | 0 | |
| 12-Apr | Invoice #2412 | 2,082 | 30-Apr | Cash (#2412) | 1,586 | 496 | |
| 5-Sep | Invoice #3614 | 602 | 20-Sep | Cash (#3614 and part of #2412) | 602 | 0 | |
| 17-Oct | Invoice #4912 | 1,045 | 31-Oct | Cash (#4912) | 1,045 | 0 | |
| 18-Nov | Invoice #5681 | 2,440 | 1-Dec | Cash (#5681) | 1,525 | 915 | |
| 20-Dec | Invoice #6347 | 976 | 29-Dec | Cash (#6347) | 976 | 0 | |
| 2078 | |||||||
| Balance | ||
| 1-Jan | Cash (1/1 Balance) | 667 |
| 12-Apr | Invoice #2412 | 496 |
| 18-Nov | Invoice #5681 | 915 |
| Total | 2078 |
| Aging as on 31 | st Dec | ||||
| Invoice number | 0-30 days | 31-60 days | 61-90 days | 90+ days | Total |
| Cash (1/1 Balance) | 0 | 0 | 0 | 667 | 667 |
| Invoice #2412 | 0 | 0 | 0 | 496 | 496 |
| Invoice #5681 | 0 | 915 | 0 | 0 | 915 |
| Total | 2078 |