ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBN
1
SUBCONTRACTOR PAYMENT TRACKER
2
3
Payment Record IDPayment StatusCustomer NameCustomer Account NumberBilling ContactBilling Contact EmailBilling Contact TelephoneProject NameProject NumberProject ManagerContract / Subcontract NumberPurchase-order NumberOriginal Subcontract AmountApproved Change OrdersRevised Subcontract AmountInvoice NumberPayment Application NumberBilling Period StartBilling Period EndInvoice DateSubmission DateApproval DateDue DatePayment TermsAmount BilledAmount ApprovedAmount CertifiedRetention PercentageRetention WithheldRetention ReleasedNet Amount DueApproved DeductionsBackchargesDisputed AmountCredit Memo AmountPrevious PaymentsCurrent Payment ReceivedTotal Payments ReceivedPayment DatePayment MethodPayment ReferencePromised Payment DateDays OutstandingDays OverdueOutstanding BalanceOverdue BalanceRetention OutstandingFinal Payment?Lien Waiver StatusSupporting Document StatusFollow-up OwnerLast Follow-up DateNext Follow-up DateCollection StatusEscalation StatusCustomer ResponseInternal NotesCloseout DatePayment Completion PercentageContract Billed PercentageContract Paid PercentageAging BucketDuplicate Invoice CheckDuplicate Application CheckMissing Reference CheckData Quality Check
4
------30/12/1899--#REF!----CurrentMissing Required Data
5
------30/12/1899--#REF!----CurrentMissing Required Data
6
------30/12/1899--#REF!----CurrentMissing Required Data
7
------30/12/1899--#REF!----CurrentMissing Required Data
8
------30/12/1899--#REF!----CurrentMissing Required Data
9
------30/12/1899--#REF!----CurrentMissing Required Data
10
------30/12/1899--#REF!----CurrentMissing Required Data
11
------30/12/1899--#REF!----CurrentMissing Required Data
12
------30/12/1899--#REF!----CurrentMissing Required Data
13
------30/12/1899--#REF!----CurrentMissing Required Data
14
------30/12/1899--#REF!----CurrentMissing Required Data
15
------30/12/1899--#REF!----CurrentMissing Required Data
16
------30/12/1899--#REF!----CurrentMissing Required Data
17
------30/12/1899--#REF!----CurrentMissing Required Data
18
------30/12/1899--#REF!----CurrentMissing Required Data
19
------30/12/1899--#REF!----CurrentMissing Required Data
20
------30/12/1899--#REF!----CurrentMissing Required Data
21
------30/12/1899--#REF!----CurrentMissing Required Data
22
------30/12/1899--#REF!----CurrentMissing Required Data
23
------30/12/1899--#REF!----CurrentMissing Required Data
24
------30/12/1899--#REF!----CurrentMissing Required Data
25
------30/12/1899--#REF!----CurrentMissing Required Data
26
------30/12/1899--#REF!----CurrentMissing Required Data
27
------30/12/1899--#REF!----CurrentMissing Required Data
28
------30/12/1899--#REF!----CurrentMissing Required Data
29
------30/12/1899--#REF!----CurrentMissing Required Data
30
------30/12/1899--#REF!----CurrentMissing Required Data
31
------30/12/1899--#REF!----CurrentMissing Required Data
32
------30/12/1899--#REF!----CurrentMissing Required Data
33
------30/12/1899--#REF!----CurrentMissing Required Data
34
------30/12/1899--#REF!----CurrentMissing Required Data
35
------30/12/1899--#REF!----CurrentMissing Required Data
36
------30/12/1899--#REF!----CurrentMissing Required Data
37
------30/12/1899--#REF!----CurrentMissing Required Data
38
------30/12/1899--#REF!----CurrentMissing Required Data
39
------30/12/1899--#REF!----CurrentMissing Required Data
40
------30/12/1899--#REF!----CurrentMissing Required Data
41
------30/12/1899--#REF!----CurrentMissing Required Data
42
------30/12/1899--#REF!----CurrentMissing Required Data
43
------30/12/1899--#REF!----CurrentMissing Required Data
44
------30/12/1899--#REF!----CurrentMissing Required Data
45
------30/12/1899--#REF!----CurrentMissing Required Data
46
------30/12/1899--#REF!----CurrentMissing Required Data
47
------30/12/1899--#REF!----CurrentMissing Required Data
48
------30/12/1899--#REF!----CurrentMissing Required Data
49
------30/12/1899--#REF!----CurrentMissing Required Data
50
------30/12/1899--#REF!----CurrentMissing Required Data
51
------30/12/1899--#REF!----CurrentMissing Required Data
52
------30/12/1899--#REF!----CurrentMissing Required Data
53
------30/12/1899--#REF!----CurrentMissing Required Data
54
------30/12/1899--#REF!----CurrentMissing Required Data
55
------30/12/1899--#REF!----CurrentMissing Required Data
56
------30/12/1899--#REF!----CurrentMissing Required Data
57
------30/12/1899--#REF!----CurrentMissing Required Data
58
------30/12/1899--#REF!----CurrentMissing Required Data
59
------30/12/1899--#REF!----CurrentMissing Required Data
60
------30/12/1899--#REF!----CurrentMissing Required Data
61
------30/12/1899--#REF!----CurrentMissing Required Data
62
------30/12/1899--#REF!----CurrentMissing Required Data
63
------30/12/1899--#REF!----CurrentMissing Required Data
64
------30/12/1899--#REF!----CurrentMissing Required Data
65
------30/12/1899--#REF!----CurrentMissing Required Data
66
------30/12/1899--#REF!----CurrentMissing Required Data
67
------30/12/1899--#REF!----CurrentMissing Required Data
68
------30/12/1899--#REF!----CurrentMissing Required Data
69
------30/12/1899--#REF!----CurrentMissing Required Data
70
------30/12/1899--#REF!----CurrentMissing Required Data
71
------30/12/1899--#REF!----CurrentMissing Required Data
72
------30/12/1899--#REF!----CurrentMissing Required Data
73
------30/12/1899--#REF!----CurrentMissing Required Data
74
------30/12/1899--#REF!----CurrentMissing Required Data
75
------30/12/1899--#REF!----CurrentMissing Required Data
76
------30/12/1899--#REF!----CurrentMissing Required Data
77
------30/12/1899--#REF!----CurrentMissing Required Data
78
------30/12/1899--#REF!----CurrentMissing Required Data
79
------30/12/1899--#REF!----CurrentMissing Required Data
80
------30/12/1899--#REF!----CurrentMissing Required Data
81
------30/12/1899--#REF!----CurrentMissing Required Data
82
------30/12/1899--#REF!----CurrentMissing Required Data
83
------30/12/1899--#REF!----CurrentMissing Required Data
84
------30/12/1899--#REF!----CurrentMissing Required Data
85
------30/12/1899--#REF!----CurrentMissing Required Data
86
------30/12/1899--#REF!----CurrentMissing Required Data
87
------30/12/1899--#REF!----CurrentMissing Required Data
88
------30/12/1899--#REF!----CurrentMissing Required Data
89
------30/12/1899--#REF!----CurrentMissing Required Data
90
------30/12/1899--#REF!----CurrentMissing Required Data
91
------30/12/1899--#REF!----CurrentMissing Required Data
92
------30/12/1899--#REF!----CurrentMissing Required Data
93
------30/12/1899--#REF!----CurrentMissing Required Data
94
------30/12/1899--#REF!----CurrentMissing Required Data
95
------30/12/1899--#REF!----CurrentMissing Required Data
96
------30/12/1899--#REF!----CurrentMissing Required Data
97
------30/12/1899--#REF!----CurrentMissing Required Data
98
------30/12/1899--#REF!----CurrentMissing Required Data
99
------30/12/1899--#REF!----CurrentMissing Required Data
100
------30/12/1899--#REF!----CurrentMissing Required Data