NEED SOMEONE EXTREMELY PROFICIENT WITH MICROSOFT EXCEL
hbggiwsm2
ex_h-4.xlsx
Invoice
| Invoice
Number | Order Date | Company | Type | Address | City | State | Zip | Amount | Sales Tax
(7.5%) | Total |
| 23698 | 6/1/16 | Pratt | Residential | 1 Main St. | Montview | MA | 01723 | $26.47 | $1.99 | $28.46 |
| 23699 | 6/1/16 | Uptak | Commercial | 2 South St. | Andover | MA | 01810 | $122.95 | $9.22 | $132.17 |
| 23700 | 6/1/16 | Northside | Commercial | 27 Round St. | Danvers | MA | 01923 | $524.41 | $39.33 | $563.74 |
| 23701 | 6/2/16 | Allenhurst | Residential | 14 Bayside Rd. | Brookline | MA | 01883 | $42.25 | $3.17 | $45.42 |
| 23702 | 6/2/16 | Bailey | Residential | 25 Pond St. | Amesbury | MA | 01725 | $33.14 | $2.49 | $35.63 |
| 23703 | 6/4/16 | Brown | Commercial | 1 Port St. | Merrimack | MA | 01753 | $156.41 | $11.73 | $168.14 |
| 23704 | 6/5/16 | Pratt | Residential | 1 Main St. | Montview | MA | 01723 | $37.55 | $2.82 | $40.37 |
| 23705 | 6/8/16 | Uptak | Commercial | 2 South St. | Andover | MA | 01810 | $237.52 | $17.81 | $255.33 |
| 23706 | 6/9/16 | Northside | Commercial | 27 Round St. | Danvers | MA | 01923 | $321.52 | $24.11 | $345.63 |
| 23707 | 6/10/16 | Allenhurst | Residential | 14 Bayside Rd. | Brookline | MA | 01883 | $52.22 | $3.92 | $56.14 |
| 23708 | 6/11/16 | Bailey | Residential | 25 Pond St. | Amesbury | MA | 01725 | $21.87 | $1.64 | $23.51 |
| 23709 | 6/13/16 | Brown | Commercial | 1 Port St. | Merrimack | MA | 01753 | $362.12 | $27.16 | $389.28 |
| 23710 | 6/15/16 | Pratt | Residential | 1 Main St. | Montview | MA | 01723 | $36.52 | $2.74 | $39.26 |
| 23711 | 6/15/16 | Uptak | Commercial | 2 South St. | Andover | MA | 01810 | $512.01 | $38.40 | $550.41 |
| 23712 | 6/19/16 | Northside | Commercial | 27 Round St. | Danvers | MA | 01923 | $124.87 | $9.37 | $134.24 |
| 23713 | 6/20/16 | Allenhurst | Residential | 14 Bayside Rd. | Brookline | MA | 01883 | $62.14 | $4.66 | $66.80 |
| 23714 | 6/22/16 | Bailey | Residential | 25 Pond St. | Amesbury | MA | 01725 | $52.44 | $3.93 | $56.37 |
| 23715 | 6/24/16 | Brown | Commercial | 1 Port St. | Merrimack | MA | 01753 | $15.87 | $1.19 | $17.06 |
| 23716 | 6/26/16 | Pratt | Residential | 1 Main St. | Montview | MA | 01723 | $23.54 | $1.77 | $25.31 |
| 23717 | 6/28/16 | Uptak | Commercial | 2 South St. | Andover | MA | 01810 | $425.10 | $31.88 | $456.98 |
| 23718 | 6/29/16 | Northside | Commercial | 27 Round St. | Danvers | MA | 01923 | $52.31 | $3.92 | $56.23 |
| 23719 | 6/30/16 | Allenhurst | Residential | 14 Bayside Rd. | Brookline | MA | 01883 | $13.65 | $1.02 | $14.67 |
| 23720 | 6/30/16 | Bailey | Residential | 25 Pond St. | Amesbury | MA | 01725 | $15.87 | $1.19 | $17.06 |
| 23721 | 6/30/16 | Brown | Commercial | 1 Port St. | Merrimack | MA | 01753 | $425.11 | $31.88 | $456.99 |
| Amount | Order Date | | | | | Invoice # | Total | | Order Date | Number
of Invoices |
Subtotals
| Invoice
Number | Order Date | Company | Type | Address | City | State | Zip | Amount | Sales Tax
(7.5%) | Total |
| 23698 | 6/1/16 | Pratt | Residential | 1 Main St. | Montview | MA | 01723 | $26.47 | $1.99 | $28.46 |
| 23699 | 6/1/16 | Uptak | Commercial | 2 South St. | Andover | MA | 01810 | $122.95 | $9.22 | $132.17 |
| 23700 | 6/1/16 | Northside | Commercial | 27 Round St. | Danvers | MA | 01923 | $524.41 | $39.33 | $563.74 |
| 23701 | 6/2/16 | Allenhurst | Residential | 14 Bayside Rd. | Brookline | MA | 01883 | $42.25 | $3.17 | $45.42 |
| 23702 | 6/2/16 | Bailey | Residential | 25 Pond St. | Amesbury | MA | 01725 | $33.14 | $2.49 | $35.63 |
| 23703 | 6/4/16 | Brown | Commercial | 1 Port St. | Merrimack | MA | 01753 | $156.41 | $11.73 | $168.14 |
| 23704 | 6/5/16 | Pratt | Residential | 1 Main St. | Montview | MA | 01723 | $37.55 | $2.82 | $40.37 |
| 23705 | 6/8/16 | Uptak | Commercial | 2 South St. | Andover | MA | 01810 | $237.52 | $17.81 | $255.33 |
| 23706 | 6/9/16 | Northside | Commercial | 27 Round St. | Danvers | MA | 01923 | $321.52 | $24.11 | $345.63 |
| 23707 | 6/10/16 | Allenhurst | Residential | 14 Bayside Rd. | Brookline | MA | 01883 | $52.22 | $3.92 | $56.14 |
| 23708 | 6/11/16 | Bailey | Residential | 25 Pond St. | Amesbury | MA | 01725 | $21.87 | $1.64 | $23.51 |
| 23709 | 6/13/16 | Brown | Commercial | 1 Port St. | Merrimack | MA | 01753 | $362.12 | $27.16 | $389.28 |
| 23710 | 6/15/16 | Pratt | Residential | 1 Main St. | Montview | MA | 01723 | $36.52 | $2.74 | $39.26 |
| 23711 | 6/15/16 | Uptak | Commercial | 2 South St. | Andover | MA | 01810 | $512.01 | $38.40 | $550.41 |
| 23712 | 6/19/16 | Northside | Commercial | 27 Round St. | Danvers | MA | 01923 | $124.87 | $9.37 | $134.24 |
| 23713 | 6/20/16 | Allenhurst | Residential | 14 Bayside Rd. | Brookline | MA | 01883 | $62.14 | $4.66 | $66.80 |
| 23714 | 6/22/16 | Bailey | Residential | 25 Pond St. | Amesbury | MA | 01725 | $52.44 | $3.93 | $56.37 |
| 23715 | 6/24/16 | Brown | Commercial | 1 Port St. | Merrimack | MA | 01753 | $15.87 | $1.19 | $17.06 |
| 23716 | 6/26/16 | Pratt | Residential | 1 Main St. | Montview | MA | 01723 | $23.54 | $1.77 | $25.31 |
| 23717 | 6/28/16 | Uptak | Commercial | 2 South St. | Andover | MA | 01810 | $425.10 | $31.88 | $456.98 |
| 23718 | 6/29/16 | Northside | Commercial | 27 Round St. | Danvers | MA | 01923 | $52.31 | $3.92 | $56.23 |
| 23719 | 6/30/16 | Allenhurst | Residential | 14 Bayside Rd. | Brookline | MA | 01883 | $13.65 | $1.02 | $14.67 |
| 23720 | 6/30/16 | Bailey | Residential | 25 Pond St. | Amesbury | MA | 01725 | $15.87 | $1.19 | $17.06 |
| 23721 | 6/30/16 | Brown | Commercial | 1 Port St. | Merrimack | MA | 01753 | $425.11 | $31.88 | $456.99 |
