cis
agsbwuq1
PracticeExam1.xlsxSales
| DAILY FOOD SALES | |||||||||
| Invoice Number | Date | Name | Amount of Sale | Tax | Shipping | Total Sale | Totals | ||
| 00115 | December 31, 2007 | Peter Lynch | 842.40 | 56.86 | 5.00 | Sale | |||
| 00116 | December 31, 2007 | Nancy Smith | 597.78 | 40.35 | 5.00 | Tax | |||
| 00117 | December 31, 2007 | Jacklyn Jones | 779.33 | 52.60 | 5.00 | Shipping | |||
| 00118 | December 31, 2007 | Barry Turko | 997.41 | 67.32 | 5.00 | ||||
| 00119 | December 31, 2007 | Samuel Patter | 647.03 | 43.67 | 5.00 | ||||
| 00120 | December 31, 2007 | Jerry Gerald | 181.65 | 12.26 | 3.00 | ||||
| 00121 | January 1, 2008 | Kurry Hirray | 22.37 | 1.51 | 3.00 | ||||
| 00122 | January 1, 2008 | Nurnak Rumold | 758.20 | 51.18 | 5.00 | ||||
| 00123 | January 1, 2008 | Stan Williams | 293.73 | 19.83 | 3.00 | ||||
| 00124 | January 1, 2008 | Jennifer Lewis | 75.48 | 5.10 | 3.00 | ||||
| 00125 | January 1, 2008 | Sharon Jeeves | 975.94 | 65.88 | 5.00 | ||||
| 00126 | January 1, 2008 | Willie White | 152.04 | 10.26 | 3.00 |
Ledger
| Bank Transactions | ||||||
| Date | Account # | Name | Expense | Amount | Summary Data | |
| 2/1/05 | 4-985-767 | Condon, Karen | Rent | $ 300.00 | Number of rent expenses | |
| 2/2/05 | 4-985-767 | Condon, Karen | Medicine | $ 21.00 | Number of expenses on or before 2/28/05 | |
| 2/3/05 | 4-985-767 | Condon, Karen | Clothing | $ 100.00 | ||
| 3/1/05 | 4-985-767 | Condon, Karen | Rent | $ 300.00 | Total rent paid | |
| 3/1/05 | 4-985-767 | Condon, Karen | Doctor | $ 45.00 | Total expenses on or after 3/1/05 | |
| 3/2/05 | 4-985-767 | Condon, Karen | Cab Fare | $ 3.00 | ||
| 3/3/05 | 4-985-767 | Condon, Karen | Clothing | $ 100.00 | ||
| 2/2/05 | 8-123-311 | Cox, Fred | Rent | $ 310.00 | Average Transactions | |
| 2/3/05 | 8-123-311 | Cox, Fred | Cab fare | $ 20.00 | Before or on 2/28/2005 | |
| 3/2/05 | 8-123-311 | Cox, Fred | Books | $ 8.00 | On or after 3/1/2005 | |
| 3/3/05 | 8-123-311 | Cox, Fred | Rent | $ 310.00 | ||
| 3/4/05 | 8-123-311 | Cox, Fred | Medicine | $ 10.00 | ||
| 2/1/05 | 8-124-422 | Gerard, Herman | Rent | $ 290.00 | ||
| 2/2/05 | 8-124-422 | Gerard, Herman | Laundry | $ 17.00 | ||
| 2/3/05 | 8-124-422 | Gerard, Herman | Gift | $ 10.00 | ||
| 3/1/05 | 8-124-422 | Gerard, Herman | Rent | $ 290.00 | ||
| 3/1/05 | 8-124-422 | Gerard, Herman | Clothing | $ 33.00 | ||
| 3/2/05 | 8-124-422 | Gerard, Herman | Medicine | $ 22.00 | ||
| 3/3/05 | 8-124-422 | Gerard, Herman | Clothing | $ 15.00 | ||
| 2/1/05 | 7-223-541 | Mishaw, Renee | Doctor | $ 45.00 | ||
| 2/2/05 | 7-223-541 | Mishaw, Renee | Clothing | $ 25.00 | ||
| 2/3/05 | 7-223-541 | Mishaw, Renee | Rent | $ 280.00 | ||
| 2/3/05 | 7-223-541 | Mishaw, Renee | Doctor | $ 50.00 | ||
| 3/1/05 | 7-223-541 | Mishaw, Renee | Furniture | $ 75.00 | ||
| 3/2/05 | 7-223-541 | Mishaw, Renee | Doctor | $ 43.00 | ||
| 3/2/05 | 7-223-541 | Mishaw, Renee | Doctor | $ 4.00 | ||
| 3/3/05 | 7-223-541 | Mishaw, Renee | Rent | $ 280.00 | ||
| 3/4/05 | 7-223-541 | Mishaw, Renee | Cab Fare | $ 5.00 | ||
| 3/4/05 | 7-223-541 | Mishaw, Renee | Doctor | $ 50.00 | ||
| 2/1/05 | 6-754-533 | Perez, Isabel | Furniture | $ 175.00 | ||
| 2/3/05 | 6-754-533 | Perez, Isabel | Rent | $ 365.00 | ||
| 3/1/05 | 6-754-533 | Perez, Isabel | Medicine | $ 25.00 | ||
| 3/3/05 | 6-754-533 | Perez, Isabel | Rent | $ 365.00 | ||
| 3/3/05 | 6-754-533 | Perez, Isabel | Gift | $ 12.00 | ||
| 2/1/05 | 6-735-442 | Polilli, Robert | Clothing | $ 65.00 | ||
| 2/3/05 | 6-735-442 | Polilli, Robert | Rent | $ 250.00 | ||
| 3/1/05 | 6-735-442 | Polilli, Robert | Clothing | $ 65.00 | ||
| 3/3/05 | 6-735-442 | Polilli, Robert | Rent | $ 250.00 | ||
| 3/3/05 | 6-735-442 | Polilli, Robert | Tickets | $ 25.00 | ||
| 2/2/05 | 3-049-581 | Powell, Gilda | Rent | $ 225.00 | ||
| 3/2/05 | 3-049-581 | Powell, Gilda | Medicine | $ 15.00 | ||
| 3/3/05 | 3-049-581 | Powell, Gilda | Rent | $ 225.00 | ||
| 2/1/05 | 5-867-577 | Rodriguez, Damon | Rent | $ 325.00 | ||
| 2/2/05 | 5-867-577 | Rodriguez, Damon | Cab fare | $ 10.00 | ||
| 2/3/05 | 5-867-577 | Rodriguez, Damon | Clothing | $ 25.00 | ||
| 3/1/05 | 5-867-577 | Rodriguez, Damon | Rent | $ 325.00 | ||
| 3/1/05 | 5-867-577 | Rodriguez, Damon | Gift | $ 4.00 | ||
| 3/2/05 | 5-867-577 | Rodriguez, Damon | Clothing | $ 44.00 | ||
| 3/3/05 | 5-867-577 | Rodriguez, Damon | Clothing | $ 66.00 | ||
| 2/1/05 | 6-041-182 | Smith, Bonnie | Rent | $ 375.00 | ||
| 2/2/05 | 6-041-182 | Smith, Bonnie | Clothing | $ 50.00 | ||
| 2/3/05 | 6-041-182 | Smith, Bonnie | Books | $ 15.00 | ||
| 2/3/05 | 6-041-182 | Smith, Bonnie | Gift | $ 5.00 | ||
| 2/3/05 | 6-041-182 | Smith, Bonnie | Cab Fare | $ 4.00 | ||
| 3/1/05 | 6-041-182 | Smith, Bonnie | Rent | $ 375.00 | ||
| 3/1/05 | 6-041-182 | Smith, Bonnie | Cab Fare | $ 5.00 | ||
| 3/2/05 | 6-041-182 | Smith, Bonnie | Doctor | $ 33.00 | ||
| 3/4/05 | 6-041-182 | Smith, Bonnie | Medicine | $ 14.00 | ||
| 2/1/05 | 7-564-599 | Wallace, Marc | Rent | $ 300.00 | ||
| 2/2/05 | 7-564-599 | Wallace, Marc | Clothing | $ 90.00 | ||
| 3/1/05 | 7-564-599 | Wallace, Marc | Rent | $ 300.00 | ||
| 3/1/05 | 7-564-599 | Wallace, Marc | Cab Fare | $ 5.00 | ||
| 3/2/05 | 7-564-599 | Wallace, Marc | Medicine | $ 31.00 | ||
