Invoicing Status - SAMPLE

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Client Name	Rate	Hours	Total Invoice	Invoice Actual	Hours Converted	min	sec	Hours Total Balance	Carried Over Notes	New Notes	Generated Report?	Sent?	Received?	paid out?	payout amount
2	Client1	80	11:04:00	$1,000.00	$1,000.00	11.00	4	0	11.07	retainer		yes	yes	yes	yes	$700.00
3	Client2	70	12:15:00	$1,500.00	$1,500.00	12.00	15	0	12.25	retainer		yes	yes			$1,050.00
4	Client3	100	24:00:00	$2,400.00	$2,400.00	24.00	0	0	24.00	retainer		yes	yes			$1,680.00
5	Client4	25	1:00:00	$25.00	$25.00	1.00	0	0	1.00			yes	yes	yes	yes	$17.50
6	Client5	70	2:00:00	$140.00	$140.00	2.00	0	0	2.00			yes	yes			$98.00
7	Client6	80	1:00:00	$80.00	$80.00	1.00	0	0	1.00			yes	yes	yes	yes	$56.00
8	Client7	100	1:20:00	$133.33	$133.33	1.00	20	0	1.33							$93.33
9							total hours		52.65
10
11
12										payout 1 Client1	700	3/24/2020
13										payout 2 Client4	17.5	3/26/2020
14										payout 3 Client6	56	3/27/2020
15			total invoicing	$5,278.33
16			total payout	$3,694.83
17
18				remaining	$2,921.33
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100