| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DATE OF SALE | INVOICE NUMBER | NAME | ADDRESS | SALE PRICE | Import from QB | TYPE OF SALE | UV SPLIT SALE PRICE DEDUCTION | NET SALES AMOUNT TO PAY INSTALL | MAX PAY % | CURRENTLY PAID AMOUNT OVERALL | CURRENTLY PAID % OVERALL | MAX PAY AMOUNT OVERALL | USER ENTERS DATA | AUTOFILLS | TOTAL SALES REV | ||||||||||||||
2 | 12/01/2022 | 194063 | name placeholder | address placeholder | $ 2,000 | SIAQ | UV LIGHT | $ 2,000 | 0% | $ - | 0.00% | $ - | $ 1,687,417 | |||||||||||||||||
3 | 12/01/2022 | 193984 | name placeholder | address placeholder | $ 3,780 | SPIAQ | PREMIUM ADC | $ 3,780 | 11% | $ - | 0.00% | $ 415.80 | ||||||||||||||||||
4 | 12/01/2022 | 193860 | name placeholder | address placeholder | $ 11,467 | SEQU | EQU | $ 11,467 | 9% | $ - | 0.00% | $ 1,032.03 | ||||||||||||||||||
5 | 12/01/2022 | 194126 | name placeholder | address placeholder | $ 28,589 | SEQU | EQU | $ 28,589 | 9% | $ - | 0.00% | $ 2,573.01 | ||||||||||||||||||
6 | 12/02/2022 | 193401 | name placeholder | address placeholder | $ 2,000 | SADC | BASIC ADC | $ 2,000 | 11% | $ - | 0.00% | $ 220.00 | ||||||||||||||||||
7 | 12/02/2022 | 193691 | name placeholder | address placeholder | $ 2,134 | SIAQ | UV LIGHT | $ 2,134 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
8 | 12/02/2022 | 194013 | name placeholder | address placeholder | $ 2,187 | SIAQ 5/2 | UV LIGHT | $ 2,187 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
9 | 12/02/2022 | 193862 | name placeholder | address placeholder | $ 3,689 | SEQU 10/1 | EQU | $ 3,689 | 9% | $ - | 0.00% | $ 332.01 | ||||||||||||||||||
10 | 12/02/2022 | 194265 | name placeholder | address placeholder | $ 3,898 | SEQU 10/1 Q/UV | EQU | 2000 | $ 1,898 | 9% | $ - | 0.00% | $ 170.82 | |||||||||||||||||
11 | 12/02/2022 | 193830 | name placeholder | address placeholder | $ 5,374 | SPIAQ 2UV | PREMIUM ADC | $ 5,374 | 11% | $ - | 0.00% | $ 591.14 | ||||||||||||||||||
12 | 12/02/2022 | 193402 | name placeholder | address placeholder | $ 13,500 | SEQU | EQU | $ 13,500 | 9% | $ - | 0.00% | $ 1,215.00 | ||||||||||||||||||
13 | 12/02/2022 | 193230 | name placeholder | address placeholder | $ 17,737 | SEQU | EQU | $ 17,737 | 9% | $ - | 0.00% | $ 1,596.33 | ||||||||||||||||||
14 | 12/05/2022 | 194066 | name placeholder | address placeholder | $ 3,472 | SEQU | EQU | $ 3,472 | 9% | $ - | 0.00% | $ 312.48 | ||||||||||||||||||
15 | 12/05/2022 | 193232 | name placeholder | address placeholder | $ 6,275 | SPIAQ 2ADC,1UV | PREMIUM ADC | $ 6,275 | 11% | $ - | 0.00% | $ 690.25 | ||||||||||||||||||
16 | 12/05/2022 | 193233 | name placeholder | address placeholder | $ 7,858 | SEQU | EQU | $ 7,858 | 9% | $ - | 0.00% | $ 707.22 | ||||||||||||||||||
17 | 12/05/2022 | 194128 | name placeholder | address placeholder | $ 10,472 | SEQU | EQU | $ 10,472 | 9% | $ - | 0.00% | $ 942.48 | ||||||||||||||||||
18 | 12/05/2022 | 193707 | name placeholder | address placeholder | $ 12,798 | SEQU | EQU | $ 12,798 | 9% | $ - | 0.00% | $ 1,151.82 | ||||||||||||||||||
19 | 12/05/2022 | 194254 | name placeholder | address placeholder | $ 13,000 | SEQU | EQU | $ 13,000 | 9% | $ - | 0.00% | $ 1,170.00 | ||||||||||||||||||
20 | 12/05/2022 | 194054 | name placeholder | address placeholder | $ 17,804 | SEQU | EQU | $ 17,804 | 9% | $ - | 0.00% | $ 1,602.36 | ||||||||||||||||||
21 | 12/06/2022 | 193234 | name placeholder | address placeholder | $ 2,092 | SIAQ | UV LIGHT | $ 2,092 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
22 | 12/06/2022 | 193921 | name placeholder | address placeholder | $ 2,163 | SIAQ | UV LIGHT | $ 2,163 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
23 | 12/06/2022 | 193406 | name placeholder | address placeholder | $ 3,987 | SPIAQ | PREMIUM ADC | $ 3,987 | 11% | $ - | 0.00% | $ 438.57 | ||||||||||||||||||
24 | 12/06/2022 | 194068 | name placeholder | address placeholder | $ 5,400 | SPIAQ | PREMIUM ADC | $ 5,400 | 11% | $ - | 0.00% | $ 594.00 | ||||||||||||||||||
25 | 12/06/2022 | 194214 | name placeholder | address placeholder | $ 11,200 | SREDUCT | REDUCT | $ 11,200 | 15% | $ - | 0.00% | $ 1,680.00 | ||||||||||||||||||
26 | 12/07/2022 | 193235 | name placeholder | address placeholder | $ 2,000 | SIAQ | UV LIGHT | $ 2,000 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
27 | 12/07/2022 | 194396 | name placeholder | address placeholder | $ 5,574 | SEQU | EQU | $ 5,574 | 9% | $ - | 0.00% | $ 501.66 | ||||||||||||||||||
28 | 12/07/2022 | 193867 | name placeholder | address placeholder | $ 5,836 | SEQU | EQU | $ 5,836 | 9% | $ - | 0.00% | $ 525.24 | ||||||||||||||||||
29 | 12/07/2022 | 194434 | name placeholder | address placeholder | $ 12,586 | SEQU | EQU | $ 12,586 | 9% | $ - | 0.00% | $ 1,132.74 | ||||||||||||||||||
30 | 12/07/2022 | 194132 | name placeholder | address placeholder | $ 17,638 | SEQU | EQU | $ 17,638 | 9% | $ - | 0.00% | $ 1,587.42 | ||||||||||||||||||
31 | 12/08/2022 | 192981 | name placeholder | address placeholder | $ 1,900 | SIAQ | UV LIGHT | $ 1,900 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
32 | 12/08/2022 | 194380 | name placeholder | address placeholder | $ 4,100 | SPIAQ | PREMIUM ADC | $ 4,100 | 11% | $ - | 0.00% | $ 451.00 | ||||||||||||||||||
33 | 12/09/2022 | 193240 | name placeholder | address placeholder | $ 3,250 | SPIAQ | PREMIUM ADC | $ 3,250 | 11% | $ - | 0.00% | $ 357.50 | ||||||||||||||||||
34 | 12/09/2022 | 194366 | name placeholder | address placeholder | $ 4,659 | SEQU | EQU | $ 4,659 | 9% | $ - | 0.00% | $ 419.31 | ||||||||||||||||||
35 | 12/09/2022 | 193239 | name placeholder | address placeholder | $ 6,347 | SEQU | EQU | $ 6,347 | 9% | $ - | 0.00% | $ 571.23 | ||||||||||||||||||
36 | 12/09/2022 | 194074 | name placeholder | address placeholder | $ 6,907 | SEQU W/UV | EQU | 2000 | $ 4,907 | 9% | $ - | 0.00% | $ 441.63 | |||||||||||||||||
37 | 12/12/2022 | 194514 | name placeholder | address placeholder | $ 1,200 | SADC | BASIC ADC | $ 1,200 | 11% | $ 132.00 | 11.00% | $ 132.00 | ||||||||||||||||||
38 | 12/12/2022 | 194513 | name placeholder | address placeholder | $ 2,387 | SIAQ | UV LIGHT | $ 2,387 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
39 | 12/12/2022 | 194402 | name placeholder | address placeholder | $ 3,900 | SEQU | EQU | $ 3,900 | 9% | $ - | 0.00% | $ 351.00 | ||||||||||||||||||
40 | 12/12/2022 | 193412 | name placeholder | address placeholder | $ 4,200 | SPIAQ | PREMIUM ADC | $ 4,200 | 11% | $ - | 0.00% | $ 462.00 | ||||||||||||||||||
41 | 12/12/2022 | 191608 | name placeholder | address placeholder | $ 13,883 | SEQU | EQU | $ 13,883 | 9% | $ - | 0.00% | $ 1,249.47 | ||||||||||||||||||
42 | 12/12/2022 | 193241 | name placeholder | address placeholder | $ 16,043 | SREDUCT | REDUCT | $ 16,043 | 15% | $ - | 0.00% | $ 2,406.45 | ||||||||||||||||||
43 | 12/12/2022 | 194368 | name placeholder | address placeholder | $ 25,360 | SEQU 16S (pay chop) | EQU | $ 25,360 | 8% | $ - | 0.00% | $ 2,028.80 | ||||||||||||||||||
44 | 12/13/2022 | 194499 | name placeholder | address placeholder | $ 2,287 | SIAQ | UV LIGHT | $ 2,287 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
45 | 12/13/2022 | 191268 | name placeholder | address placeholder | $ 4,600 | SEQU | EQU | $ 4,600 | 9% | $ - | 0.00% | $ 414.00 | ||||||||||||||||||
46 | 12/14/2022 | 194518 | name placeholder | address placeholder | $ 4,121 | SEQU | EQU | $ 4,121 | 9% | $ - | 0.00% | $ 370.89 | ||||||||||||||||||
47 | 12/15/2022 | 194373 | name placeholder | address placeholder | $ 3,898 | SEQU | EQU | $ 3,898 | 9% | $ - | 0.00% | $ 350.82 | ||||||||||||||||||
48 | 12/15/2022 | 194521 | name placeholder | address placeholder | $ 4,000 | SWTRHTR 10P/1L | WATER HEATER | $ 4,000 | 10% | $ - | 0.00% | $ 400.00 | ||||||||||||||||||
49 | 12/15/2022 | 192980 | name placeholder | address placeholder | $ 8,537 | SPIAQ 5/2 w/dehum | PREMIUM ADC | $ 8,537 | 11% | $ - | 0.00% | $ 939.07 | ||||||||||||||||||
50 | 12/15/2022 | 191272 | name placeholder | address placeholder | $ 10,000 | SMC 7/1 ERSA 2YR | MOISTURE CONTROL | $ 10,000 | 11% | $ - | 0.00% | $ 1,100.00 | ||||||||||||||||||
51 | 12/15/2022 | 193418 | name placeholder | address placeholder | $ 15,000 | SREDUCT W/PIAQ | REDUCT | $ 15,000 | 15% | $ 942.00 | 6.28% | $ 2,250.00 | ||||||||||||||||||
52 | 12/15/2022 | 194374 | name placeholder | address placeholder | $ 15,398 | SMC & ADC | MOISTURE CONTROL | $ 15,398 | 11% | $ 770.00 | 5.00% | $ 1,693.78 | ||||||||||||||||||
53 | 12/15/2022 | 193246 | name placeholder | address placeholder | $ 22,455 | SEQU W/UVx2&wty evap | EQU | 4000 | $ 18,455 | 9% | $ - | 0.00% | $ 1,660.95 | |||||||||||||||||
54 | 12/16/2022 | 193250 | name placeholder | address placeholder | $ 2,789 | SIAQ | UV LIGHT | $ 2,789 | 0% | $ - | 0.00% | $ - | ||||||||||||||||||
55 | 12/16/2022 | 191323 | name placeholder | address placeholder | $ 3,898 | SEQU | EQU | $ 3,898 | 9% | $ - | 0.00% | $ 350.82 | ||||||||||||||||||
56 | 12/16/2022 | 193248 | name placeholder | address placeholder | $ 8,578 | SPIAQ HUMIDIFER 5/2 | PREMIUM ADC | $ 8,578 | 11% | $ - | 0.00% | $ 943.58 | ||||||||||||||||||
57 | 12/16/2022 | 191275 | name placeholder | address placeholder | $ 11,867 | SEQU | EQU | $ 11,867 | 9% | $ - | 0.00% | $ 1,068.03 | ||||||||||||||||||
58 | 12/16/2022 | 194670 | name placeholder | address placeholder | $ 13,500 | SEQU | EQU | $ 13,500 | 9% | $ 1,099.00 | 8.14% | $ 1,215.00 | ||||||||||||||||||
59 | 12/17/2022 | 193423 | name placeholder | address placeholder | $ 5,687 | SPIAQ | PREMIUM ADC | $ 5,687 | 11% | $ 240.00 | 4.22% | $ 625.57 | ||||||||||||||||||
60 | 12/17/2022 | 194522 | name placeholder | address placeholder | $ 10,799 | SREDUCT | REDUCT | $ 10,799 | 15% | $ 783.00 | 7.25% | $ 1,619.85 | ||||||||||||||||||
61 | 12/17/2022 | 191276 | name placeholder | address placeholder | $ 17,643 | SEQU | EQU | $ 17,643 | 9% | $ 496.00 | 2.81% | $ 1,587.87 | ||||||||||||||||||
62 | 12/18/2022 | 191338 | name placeholder | address placeholder | $ 7,200 | SPIAQ W/ REPAIR 5/2 | PREMIUM ADC | $ 7,200 | 11% | $ 792.00 | 11.00% | $ 792.00 | ||||||||||||||||||
63 | 12/18/2022 | 194523 | name placeholder | address placeholder | $ 20,000 | SEQU | EQU | $ 20,000 | 9% | $ - | 0.00% | $ 1,800.00 | ||||||||||||||||||
64 | 12/19/2022 | 193872 | name placeholder | address placeholder | $ 8,089 | SEQU | EQU | $ 8,089 | 9% | $ 174.00 | 2.15% | $ 728.01 | ||||||||||||||||||
65 | 12/19/2022 | 194736 | name placeholder | address placeholder | $ 3,773 | EQU | EQU | $ 3,773 | 9% | $ - | 0.00% | $ 339.57 | ||||||||||||||||||
66 | 12/19/2022 | 191288 | name placeholder | address placeholder | $ 8,629 | EQU | EQU | $ 8,629 | 9% | $ 296.00 | 3.43% | $ 776.61 | ||||||||||||||||||
67 | 12/19/2022 | 194921 | name placeholder | address placeholder | $ 9,567 | EQU W/UV | EQU | 2000 | $ 7,567 | 9% | $ - | 0.00% | $ 681.03 | |||||||||||||||||
68 | 12/19/2022 | 194679 | name placeholder | address placeholder | $ 12,567 | EQU | EQU | $ 12,567 | 9% | $ - | 0.00% | $ 1,131.03 | ||||||||||||||||||
69 | 12/19/2022 | 194441 | name placeholder | address placeholder | $ 5,499 | EQU | EQU | $ 5,499 | 9% | $ 250.00 | 4.55% | $ 494.91 | ||||||||||||||||||
70 | 12/19/2022 | 193249 | name placeholder | address placeholder | $ 9,437 | EQU | EQU | $ 9,437 | 9% | $ - | 0.00% | $ 849.33 | ||||||||||||||||||
71 | 12/20/2022 | 194436 | name placeholder | address placeholder | $ 9,999 | EQU | EQU | $ 9,999 | 9% | $ - | 0.00% | $ 899.91 | ||||||||||||||||||
72 | 12/20/2022 | 194874 | name placeholder | address placeholder | $ 1,487 | ADC | BASIC ADC | $ 1,487 | 11% | $ 163.00 | 10.96% | $ 163.57 | ||||||||||||||||||
73 | 12/20/2022 | 191609 | name placeholder | address placeholder | $ 16,702 | REDUCT | REDUCT | $ 16,702 | 15% | $ 1,670.00 | 10.00% | $ 2,505.30 | ||||||||||||||||||
74 | 12/20/2022 | 193874 | name placeholder | address placeholder | $ 15,218 | EQU | EQU | $ 15,218 | 9% | $ - | 0.00% | $ 1,369.62 | ||||||||||||||||||
75 | 12/20/2022 | 193251 | name placeholder | address placeholder | $ 14,223 | EQU W/ UV | EQU | 2000 | $ 12,223 | 9% | $ - | 0.00% | $ 1,100.07 | |||||||||||||||||
76 | 12/20/2022 | 191292 | name placeholder | address placeholder | $ 10,067 | EQU | EQU | $ 10,067 | 9% | $ - | 0.00% | $ 906.03 | ||||||||||||||||||
77 | 12/20/2022 | 194873 | name placeholder | address placeholder | $ 2,687 | ADC W/RETURN | BASIC ADC | $ 2,687 | 11% | $ - | 0.00% | $ 295.57 | ||||||||||||||||||
78 | 12/20/2022 | 191277 | name placeholder | address placeholder | $ 10,586 | EQU | EQU | $ 10,586 | 9% | $ - | 0.00% | $ 952.74 | ||||||||||||||||||
79 | 12/21/2022 | 191294 | name placeholder | address placeholder | $ 11,237 | SEQU 10/5 ENSA 1H1A(HP) W/UV | EQU | 2000 | $ 9,237 | 9% | $ 75.00 | 0.81% | $ 831.33 | |||||||||||||||||
80 | 12/21/2022 | 193254 | name placeholder | address placeholder | $ 8,906 | SEQU 10/5 ENSA 2YR W/UV | EQU | 2000 | $ 6,906 | 9% | $ - | 0.00% | $ 621.54 | |||||||||||||||||
81 | 12/21/2022 | 194857 | name placeholder | address placeholder | $ 7,123 | SEQU 10/5 | EQU | $ 7,123 | 9% | $ - | 0.00% | $ 641.07 | ||||||||||||||||||
82 | 12/21/2022 | 194905 | name placeholder | address placeholder | $ 5,174 | SEQU 12/12 ENSA*2* 2YR 1H?A(2) | EQU | $ 5,174 | 9% | $ - | 0.00% | $ 465.66 | ||||||||||||||||||
83 | 12/21/2022 | 194524 | name placeholder | address placeholder | $ 3,500 | SPIAQ ENSA ?H?A | PREMIUM ADC | $ 3,500 | 11% | $ - | 0.00% | $ 385.00 | ||||||||||||||||||
84 | 12/22/2022 | 193255 | name placeholder | address placeholder | $ 3,397 | SPIAQ 5/2 ERSA | PREMIUM ADC | $ 3,397 | 11% | $ - | 0.00% | $ 373.67 | ||||||||||||||||||
85 | 12/22/2022 | 194738 | name placeholder | address placeholder | $ 2,187 | SIAQ 5/2 ERSA SOLD UV | PREMIUM ADC | $ 2,187 | 11% | $ - | 0.00% | $ 240.57 | ||||||||||||||||||
86 | 12/23/2022 | 194684 | name placeholder | address placeholder | $ 17,874 | SEQU 12/12 ENSA | EQU | $ 17,874 | 9% | $ - | 0.00% | $ 1,608.66 | ||||||||||||||||||
87 | 12/23/2022 | 193256 | name placeholder | address placeholder | $ 16,023 | 12YR P&L ENSA | EQU | $ 16,023 | 9% | $ - | 0.00% | $ 1,442.07 | ||||||||||||||||||
88 | 12/23/2022 | 194943 | name placeholder | address placeholder | $ 14,987 | SEQU 10YR P 5YR L ERSA | EQU | $ 14,987 | 9% | $ 258.00 | 1.72% | $ 1,348.83 | ||||||||||||||||||
89 | 12/23/2022 | 194734 | name placeholder | address placeholder | $ 12,598 | SEQU 10YP 5YL | EQU | $ 12,598 | 9% | $ 70.00 | 0.56% | $ 1,133.82 | ||||||||||||||||||
90 | 12/23/2022 | 194528 | name placeholder | address placeholder | $ 3,987 | SEQU | EQU | $ 3,987 | 9% | $ 248.00 | 6.22% | $ 358.83 | ||||||||||||||||||
91 | 12/23/2022 | 194529 | name placeholder | address placeholder | $ 3,472 | SEQU 10/1 ENSA*2 | EQU | $ 3,472 | 9% | $ - | 0.00% | $ 312.48 | ||||||||||||||||||
92 | 12/24/2022 | 191281 | name placeholder | address placeholder | $ 9,917 | SEQU 10P1L ENSA | EQU | $ 9,917 | 9% | $ 297.00 | 2.99% | $ 892.53 | ||||||||||||||||||
93 | 12/24/2022 | 194967 | name placeholder | address placeholder | $ 4,219 | SEQU 10/1 PNL ENSA | EQU | $ 4,219 | 9% | $ - | 0.00% | $ 379.71 | ||||||||||||||||||
94 | 12/25/2022 | 188699 | name placeholder | address placeholder | $ 16,587 | SEQU 10P1L ENSA | EQU | $ 16,587 | 9% | $ - | 0.00% | $ 1,492.83 | ||||||||||||||||||
95 | 12/25/2022 | 194737 | name placeholder | address placeholder | $ 4,400 | SEQU 10P1L | EQU | $ 4,400 | 9% | $ - | 0.00% | $ 396.00 | ||||||||||||||||||
96 | 12/26/2022 | 194900 | name placeholder | address placeholder | $ 15,714 | SEQU 10P5L ENSA 2 YRS W/UV&ELE UPG | EQU | 5300 | $ 10,414 | 9% | $ 1,092.00 | 10.49% | $ 937.26 | |||||||||||||||||
97 | 12/26/2022 | 188701 | name placeholder | address placeholder | $ 14,239 | SEQU 10P1L ERSA*2 | EQU | $ 14,239 | 9% | $ 40.00 | 0.28% | $ 1,281.51 | ||||||||||||||||||
98 | 12/26/2022 | 193260 | name placeholder | address placeholder | $ 13,917 | SEQU 10/1 PNL ENSA 2 YRS | EQU | $ 13,917 | 9% | $ - | 0.00% | $ 1,252.53 | ||||||||||||||||||
99 | 12/26/2022 | 194764 | name placeholder | address placeholder | $ 12,198 | SEQU 10P5L SASC | EQU | $ 12,198 | 9% | $ - | 0.00% | $ 1,097.82 | ||||||||||||||||||
100 | 12/26/2022 | 190732 | name placeholder | address placeholder | $ 11,000 | SEQU 10P1L ERSA | EQU | $ 11,000 | 9% | $ 110.00 | 1.00% | $ 990.00 |