Accounts Receivable spreadsheet
ABC Corporation
Accounts Receivable monitoring
2019
Standard Payment Term:
30 days
Reference Date:
7/30/18
(Sub)total:
$46,000.00
12/20/19
Accounts Receivable Ledger
(Sub)total:
$197,000.00
Payment 1
Invoice Date
Invoice Number
Customer Name
Total Amount
Due Date
Amount Outstanding
Days Overdue
OR Amount
Payment 2
EWT
OR Amount
Payment 3
EWT
6/2/18 0011
ABC Corp.
$120,000.00
7/2/18
$26,000.00
28
$23,571.43
$428.57
$19,642.86
$357.14
6/15/18 0012
DEF Corp.
$50,000.00
7/15/18
$20,000.00
15
$9,821.43
$178.57
$19,642.86
$357.14
6/30/18 0013
GHI Corp.
$15,000.00
7/30/18
$0.00
$2,946.43
$53.57
$11,785.71
$214.29
7/30/18 0014
JKL Corp.
$12,000.00
8/29/18
$0.00
$2,357.14
$42.86
$9,428.57
$171.43
OR Amount
$49,107.14
Payment 4
EWT
$892.86
OR Amount
Payment 5
EWT
OR Amount
EWT