Excel

Date Location Product ID Product Description Amount Cost per Unit Total Cost Bill To Account Cost With Applied Discount Warranty
2017-01-01 GFW 52214 CD Player 1  $         45.00
2017-01-01 GFW 42251 DVD Player 2  $         39.99
2017-01-01 BF 55874 Batteries 5  $           4.25
2017-01-20 GFW 55874 Batteries 12  $           4.25
2017-01-25 GFW 11258 Monitor 1  $       125.00
2017-02-01 LP 11258 Monitor 2  $       125.00
2017-02-01 GFW 88569 Reflecting Screen 2  $         12.99
2017-02-01 GFW 59687 10 Blank CDs 1  $           5.69
2017-02-01 GFW 42251 DVD Player 1  $         39.99
2017-02-01 BF 65887 Mouse 1  $         15.49
2017-02-03 LP 44578 Keyboard 1  $         25.66
2017-02-03 LP 65887 Mouse 1  $         15.49
2017-02-04 BF 88569 Reflecting Screen 2  $         12.99
2017-02-04 GFW 23456 25 Blank DVDs 3  $         29.99
2017-02-04 BF 23457 Mouse Pad 5  $           5.99
2017-02-04 BF 23458 Wireless Router 1  $         49.98
2017-02-04 GFW 23459 10/100 HUB 1  $         54.00
2017-02-04 LP 22145 R45 Cabel 60  $           2.50
2017-02-04 LP 22146 Speakers 2  $       125.00
2017-02-04 LP 22147 TV Tuner Card 3  $         99.99
2017-02-15 GFW 22148 Wireless Mouse 1  $         24.49
2017-02-15 GFW 22149 Wireless Keyboard 1  $         24.49
2017-02-15 GFW 22140 Paper (500 sheets) 10  $         11.99
2017-02-15 BF 22147 TV Tuner Card 1  $         99.99
2017-02-15 LP 22148 Wireless Mouse 1  $         24.49
2017-03-01 LP 22149 Wireless Keyboard 1  $         24.49
2017-03-01 GFW 22140 Paper (500 sheets) 1  $         11.99
2017-03-01 GFW 23456 25 Blank DVDs 2  $         29.99
2017-03-05 GFW 23457 Mouse Pad 3  $           5.99
2017-03-05 LP 23458 Wireless Router 1  $         49.98
2017-03-05 LP 23459 10/100 HUB 1  $         54.00
2017-03-05 LP 22145 R45 Cabel 90  $           2.50
2017-03-05 LP 22146 Speakers 2  $       125.00
2017-03-05 BF 88569 Reflecting Screen 2  $         12.99
2017-03-05 BF 59687 10 Blank CDs 1  $           5.69
2017-03-05 BF 42251 DVD Player 1  $         39.99
2017-03-30 BF 65887 Mouse 1  $         15.49
2017-03-30 LP 44578 Keyboard 1  $         25.66
2017-03-30 GFW 65887 Mouse 1  $         15.49
2017-03-30 GFW 88569 Reflecting Screen 2  $         12.99
2017-03-30 LP 23456 25 Blank DVDs 3  $         29.99
2017-03-30 LP 23457 Mouse Pad 3  $           5.99
2017-04-02 BF 23458 Wireless Router 4  $         49.98
2017-04-02 LP 23459 10/100 HUB 4  $         54.00
2017-04-02 LP 22145 R45 Cabel 900  $           2.50
2017-04-05 BF 22146 Speakers 5  $       125.00
2017-04-05 BF 22147 TV Tuner Card 4  $         99.99
2017-04-05 LP 22148 Wireless Mouse 15  $         24.49
2017-04-05 LP 22149 Wireless Keyboard 15  $         24.49
2017-04-05 GFW 22140 Paper (500 sheets) 50  $         11.99
2017-04-20 GFW 22147 TV Tuner Card 1  $         99.99
2017-04-20 GFW 22148 Wireless Mouse 1  $         24.49
2017-04-20 GFW 22149 Wireless Keyboard 1  $         24.49
2017-04-20 LP 22140 Paper (500 sheets) 2  $         11.99
2017-04-20 BF 23456 25 Blank DVDs 5  $         29.99
2017-04-20 BF 23457 Mouse Pad 7  $           5.99
2017-04-29 LP 23458 Wireless Router 5  $         49.98
2017-04-29 LP 23459 10/100 HUB 2  $         54.00
2017-04-29 LP 22145 R45 Cabel 500  $           2.50
2017-04-29 LP 22146 Speakers 2  $       125.00
2017-05-12 LP 88569 Reflecting Screen 4  $         12.99
2017-05-12 BF 59687 10 Blank CDs 1  $           5.69
2017-05-12 BF 42251 DVD Player 1  $         39.99
2017-05-12 BF 65887 Mouse 1  $         15.49
2017-05-12 GFW 44578 Keyboard 1  $         25.66
2017-05-12 GFW 65887 Mouse 1  $         15.49
2017-05-12 GFW 88569 Reflecting Screen 2  $         12.99
2017-06-01 LP 23456 25 Blank DVDs 1  $         29.99
2017-06-01 BF 23457 Mouse Pad 1  $           5.99
2017-06-01 LP 23458 Wireless Router 1  $         49.98
2017-06-01 LP 23459 10/100 HUB 1  $         54.00
2017-06-01 LP 22145 R45 Cabel 1  $           2.50
2017-06-01 LP 22146 Speakers 1  $       125.00
2017-06-12 GFW 22147 TV Tuner Card 1  $         99.99
2017-06-12 GFW 22148 Wireless Mouse 1  $         24.49
2017-06-12 GFW 22149 Wireless Keyboard 1  $         24.49
2017-06-12 GFW 22140 Paper (500 sheets) 1  $         11.99
2017-06-12 GFW 22147 TV Tuner Card 1  $         99.99
2017-06-12 GFW 22148 Wireless Mouse 1  $         24.49
2017-06-25 BF 22149 Wireless Keyboard 1  $         24.49
2017-06-25 BF 22140 Paper (500 sheets) 1  $         11.99
2017-06-25 BF 23456 25 Blank DVDs 2  $         29.99
2017-06-25 BF 23457 Mouse Pad 5  $           5.99
2017-06-25 BF 23458 Wireless Router 1  $         49.98
2017-06-25 BF 23459 10/100 HUB 5  $         54.00
2017-06-25 LP 22145 R45 Cabel 40  $           2.50
2017-07-02 LP 22146 Speakers 2  $       125.00
2017-07-02 LP 88569 Reflecting Screen 2  $         12.99
2017-07-02 LP 59687 10 Blank CDs 1  $           5.69
2017-07-02 LP 42251 DVD Player 1  $         39.99
2017-07-02 LP 65887 Mouse 1  $         15.49
2017-07-02 BF 44578 Keyboard 1  $         25.66
2017-07-02 GFW 65887 Mouse 1  $         15.49
2017-07-02 GFW 88569 Reflecting Screen 2  $         12.99
2017-07-09 GFW 23456 25 Blank DVDs 1  $         29.99
2017-07-09 GFW 23457 Mouse Pad 1  $           5.99
2017-07-09 GFW 23458 Wireless Router 1  $         49.98
2017-07-09 GFW 23459 10/100 HUB 1  $         54.00
2017-07-30 GFW 22145 R45 Cabel 50  $           2.50
2017-08-02 GFW 22146 Speakers 1  $       125.00
2017-08-02 LP 22147 TV Tuner Card 1  $         99.99
2017-08-02 LP 22148 Wireless Mouse 1  $         24.49
2017-08-02 LP 22149 Wireless Keyboard 1  $         24.49
2017-08-02 LP 22140 Paper (500 sheets) 2  $         11.99
2017-08-15 LP 22147 TV Tuner Card 1  $         99.99
2017-08-16 BF 22148 Wireless Mouse 1  $         24.49
2017-08-16 BF 22149 Wireless Keyboard 1  $         24.49
2017-08-16 BF 22140 Paper (500 sheets) 1  $         11.99
2017-08-23 LP 23456 25 Blank DVDs 1  $         29.99
2017-08-23 LP 23457 Mouse Pad 1  $           5.99
2017-08-23 LP 23458 Wireless Router 1  $         49.98
2017-09-01 LP 23459 10/100 HUB 1  $         54.00
2017-09-01 LP 22145 R45 Cabel 20  $           2.50
2017-09-01 LP 22146 Speakers 2  $       125.00
2017-09-02 GFW 88569 Reflecting Screen 2  $         12.99
2017-09-02 GFW 59687 10 Blank CDs 1  $           5.69
2017-09-02 GFW 42251 DVD Player 1  $         39.99
2017-09-02 LP 65887 Mouse 1  $         15.49
2017-09-15 BF 44578 Keyboard 1  $         25.66
2017-09-15 BF 65887 Mouse 1  $         15.49
2017-09-15 BF 88569 Reflecting Screen 2  $         12.99
2017-09-15 LP 23456 25 Blank DVDs 1  $         29.99
2017-10-02 GFW 23457 Mouse Pad 2  $           5.99
2017-10-02 GFW 23458 Wireless Router 1  $         49.98
2017-10-02 GFW 23459 10/100 HUB 2  $         54.00
2017-10-02 GFW 22145 R45 Cabel 500  $           2.50
2017-10-20 GFW 22146 Speakers 5  $       125.00
2017-10-20 GFW 22147 TV Tuner Card 5  $         99.99
2017-10-20 GFW 22148 Wireless Mouse 5  $         24.49
2017-10-20 GFW 22149 Wireless Keyboard 5  $         24.49
2017-10-20 LP 22140 Paper (500 sheets) 1  $         11.99
2017-10-20 LP 22147 TV Tuner Card 1  $         99.99
2017-10-20 LP 22148 Wireless Mouse 1  $         24.49
2017-10-20 LP 22149 Wireless Keyboard 1  $         24.49
2017-10-22 BF 22140 Paper (500 sheets) 1  $         11.99
2017-10-22 BF 23456 25 Blank DVDs 1  $         29.99
2017-10-22 BF 23457 Mouse Pad 1  $           5.99
2017-10-22 GFW 23458 Wireless Router 1  $         49.98
2017-11-14 GFW 23459 10/100 HUB 1  $         54.00
2017-11-14 GFW 22145 R45 Cabel 20  $           2.50
2017-11-14 LP 22146 Speakers 1  $       125.00
2017-11-14 LP 88569 Reflecting Screen 2  $         12.99
2017-11-14 LP 59687 10 Blank CDs 1  $           5.69
2017-11-14 LP 42251 DVD Player 1  $         39.99
2017-11-20 BF 65887 Mouse 1  $         15.49
2017-12-01 BF 44578 Keyboard 1  $         25.66
2017-12-03 BF 65887 Mouse 1  $         15.49
2017-12-05 GFW 88569 Reflecting Screen 2  $         12.99
2017-12-20 GFW 65887 Mouse 1  $         15.49
2017-12-20 LP 59687 10 Blank CDs 1  $           5.69
2017-12-20 LP 42251 DVD Player 1  $         39.99
Total Items Billed
Total Warranty