Need help to create an excel spreadsheet

profilenxlewis
Jan5thruFeb52019.xlsx
Home>Business & Finance homework help>Accounting homework help>Need help to create an excel spreadsheet

Table 1

January 05, 2019 through February 05, 2019
01/07 Remote Online Deposit 1 700.00
01/07 Card Purchase 01/03 IN N Out Burger 175 Corona CA Card 7111 -16.59
01/07 Card Purchase 01/04 5389 El Pollo Loco Corona CA Card 7111 -23.23
01/07 Card Purchase 01/04 Koreana Grill Bbq Buffe Riverside CA Card 7111 -21.48
01/07 Card Purchase With Pin 01/04 Macy's 536 3500 T Riverside CA Card 7111 -90.18
01/07 Card Purchase 01/05 5910 El Pollo Loco Riverside CA Card 7111 -15.18
01/07 01/05 Online Payment 7821333109 To Bac Home Loans -2,524.73
01/07 Card Purchase 01/05 Koreana Grill Bbq Buffe Riverside CA Card 7111 -30.17
01/07 Card Purchase With Pin 01/05 Mail Service And More Corona CA Card 7111 -30.00
01/07 Card Purchase 01/05 American Air00172961035 Fort Worth TX Card 7111 -254.20
01/07 Card Purchase 01/05 American Air00172759841 Fort Worth TX Card 7111 -254.20
01/07 Card Purchase 01/05 Eros Tours And Travel 213-9559695 CA Card 7111 -6.00
01/07 Card Purchase With Pin 01/06 Macy's 536 3500 T Riverside CA Card 7111 -328.32
01/07 01/07 Online Payment 7772647002 To Verizon Wireless -338.72
01/07 01/07 Online Domestic Wire Transfer Via: Charlotte St Bk Tr/067013179 A/C: Gabriel Kirchberger Port Charlotte FL 33948 US Ref: Mortage Payment Villa 6 Jan 2019/Bnf/Mortage Payment Villa 3 Belize Imad: 0107B1Qgc06C002500 Trn: 4344400007Es -8,920.15
01/07 Card Purchase With Pin 01/07 Mail Service And More Corona CA Card 7111 -13.25
01/07 Check # 319 -25.00
01/07 Online Domestic Wire Fee -25.00
01/08 Card Purchase Return 01/05 American Air00172961035 Fort Worth TX Card 7111 254.20
01/08 Card Purchase 01/06 Koreana Grill Bbq Buffe Riverside CA Card 7111 -30.17
*end*transaction detail
TRANSACTION DETAIL (continued)
01/08 Card Purchase With Pin 01/08 The Home Depot #0601 Corona CA Card 7111 -8.58
01/08 Card Purchase With Pin 01/08 Costco Gas #0432 Corona CA Card 7111 -29.09
01/08 Card Purchase With Pin 01/08 Costco Whse #0432 Corona CA Card 7111 -47.90
01/09 Card Purchase 01/07 Koreana Grill Bbq Buffe Riverside CA Card 7111 -22.47
01/09 Card Purchase 01/08 5389 El Pollo Loco Corona CA Card 7111 -17.22
01/09 Card Purchase 01/08 Lucky Greek Corona CA Card 7111 -22.63
01/09 Card Purchase With Pin 01/09 Target T- 1290 Hamner Norco CA Card 7111 -145.38
01/10 Card Purchase 01/08 Pho Bambu Noodle And Rancho Cucamo CA Card 7111 -40.85
01/10 ATM Withdrawal 01/10 2633 E Riverside DR Ontario CA Card 7111 -20.00
01/11 Card Purchase 01/09 Koreana Grill Bbq Buffe Riverside CA Card 7111 -21.47
01/11 Card Purchase 01/10 Fonda Don Chon Resta Rancho Cucamo CA Card 7111 -19.68
01/11 01/11 Online Payment 7836209570 To Edison -225.56
01/11 ATM Withdrawal 01/11 360 N Mckinley St Corona CA Card 7111 -140.00
01/14 Card Purchase 01/11 5587 El Pollo Loco Riverside CA Card 7111 -20.41
01/14 Card Purchase 01/11 Koreana Grill Bbq Buffe Riverside CA Card 7111 -39.93
01/14 Card Purchase 01/11 Kp Rx01118 Riverside CA Card 7111 -30.00
01/14 Card Purchase 01/11 91 Express Lanes Rebil 800-6009191 CA Card 7111 -30.00
01/14 Card Purchase 01/12 5389 El Pollo Loco Corona CA Card 7111 -12.69
01/14 Card Purchase 01/12 Koreana Grill Bbq Buffe Riverside CA Card 7111 -30.17
01/14 Card Purchase With Pin 01/13 Costco Gas #0678 Rancho Cucamo CA Card 7111 -30.79
01/14 Card Purchase With Pin 01/13 Costco Whse #0432 Corona CA Card 7111 -70.45
01/14 Check # 318 -120.00
01/14 Card Purchase With Pin 01/14 Petsmart # 0126 Corona CA Card 7111 -54.92
01/15 Card Purchase 01/13 Pho Bambu Noodle And Rancho Cucamo CA Card 7111 -42.20
01/15 Card Purchase 01/14 5389 El Pollo Loco Corona CA Card 7111 -10.97
01/15 01/15 Payment To Chase Card Ending IN 3611 -300.00
01/15 Card Purchase With Pin 01/15 Nordstrom-Rack # 5537 Chino CA Card 7111 -186.18
01/15 Card Purchase With Pin 01/15 Food4Less 0304 Corona CA Card 7111 -26.42
01/16 Card Purchase 01/11 Freelancer.Com London Card 7111 -204.90
01/16 Card Purchase 01/14 Pho Bambu Noodle And Rancho Cucamo CA Card 7111 -22.93
01/16 Card Purchase 01/15 5389 El Pollo Loco Corona CA Card 7111 -17.22
01/16 Card Purchase 01/15 Lucky Greek Corona CA Card 7111 -11.31
01/17 Card Purchase 01/12 Freelancer.Com Wii Card 7111 -1.39
01/17 Card Purchase 01/12 Freelancer.Com Wii Card 7111 -101.18
01/17 Card Purchase 01/16 Olive Garden 00044917 Chino CA Card 7111 -65.95
01/18 Card Purchase 01/13 Freelancer.Com Wii Card 7111 -30.99
01/18 Card Purchase 01/16 Koreana Grill Bbq Buffe Riverside CA Card 7111 -21.47
*end*transaction detail
TRANSACTION DETAIL (continued)
01/18 Card Purchase 01/16 Mcdonald's F11642 Corona CA Card 7111 -13.65
01/18 ATM Withdrawal 01/18 360 N Mckinley St Corona CA Card 7111 -40.00
01/22 Card Purchase Return 01/11 Freelancer.Com London Card 7111 204.90
01/22 Remote Online Deposit 1 800.00
01/22 Card Purchase 01/17 Koreana Grill Bbq Buffe Riverside CA Card 7111 -21.47
01/22 Card Purchase 01/18 5587 El Pollo Loco Riverside CA Card 7111 -19.09
01/22 Card Purchase 01/18 Lucky Greek Corona CA Card 7111 -13.47
01/22 Card Purchase 01/18 Nordstrom #0325 Riverside CA Card 7111 -832.36
01/22 Card Purchase 01/18 Nordstrom #0325 Riverside CA Card 7111 -56.55
01/22 Card Purchase 01/19 5910 El Pollo Loco Riverside CA Card 7111 -6.94
01/22 01/19 Check # 321 -168.00
01/22 Card Purchase 01/19 Koreana Grill Bbq Buffe Riverside CA Card 7111 -30.17
01/22 01/19 Withdrawal -3,500.00
01/22 Card Purchase With Pin 01/19 Costco Gas #0432 Corona CA Card 7111 -32.86
01/22 Card Purchase 01/19 American Air00106403165 Fort Worth TX Card 7111 -65.61
01/22 Card Purchase 01/20 3519 El Pollo Loco Corona CA Card 7111 -8.93
01/22 Card Purchase 01/20 Lerose Nails & Spa Corona CA Card 7111 -24.00
01/22 Card Purchase With Pin 01/20 Target T- 1290 Hamner Norco CA Card 7111 -24.76
01/22 Card Purchase 01/21 Subway 04492922 Corona CA Card 7111 -5.99
01/22 Card Purchase 01/20 Jack IN The Box 5340 Corona CA Card 7111 -2.79
01/22 ATM Withdrawal 01/20 360 N Mckinley St Corona CA Card 7111 -20.00
01/22 Card Purchase With Pin 01/20 Target T- 1290 Hamner Norco CA Card 7111 -48.48
01/22 Card Purchase 01/21 Mcdonald's F31310 Grapevine TX Card 7111 -11.08
01/22 Card Purchase 01/21 Maya Island Air Limited Belize Card 7111 Bz Dollar 134.00 X 0.5044030 (Exchg Rte) -67.59
01/22 Foreign Exch Rt ADJ Fee 01/21 Maya Island Air Limited Belize Card 7111 -2.02
01/22 01/22 Online Payment 7844056107 To Honda Financial Services (Ahfc) -142.52
01/23 Card Purchase 01/20 American Air00126095852 Fort Worth TX Card 7111 -220.00
01/23 Card Purchase 01/22 Smart San Pedro Card 7111 Bz Dollar 237.38 X 0.5044233 (Exchg Rte) -119.74
01/23 Foreign Exch Rt ADJ Fee 01/22 Smart San Pedro Card 7111 -3.59
01/23 Card Purchase 01/22 Elvis Kitchen San Pedro Card 7111 Bz Dollar 58.88 X 0.5044158 (Exchg Rte) -29.70
01/23 Foreign Exch Rt ADJ Fee 01/22 Elvis Kitchen San Pedro Card 7111 -0.89
01/24 01/24 Online Payment 7834987463 To AT&T U-Verse (Sm) -223.32
01/25 Card Purchase 01/23 American Air00123327938 Fort Worth TX Card 7111 -384.93
01/25 Card Purchase 01/23 The Firehearth Resta San Pedro Tow Card 7111 Bz Dollar 43.00 X 0.5044186 (Exchg Rte) -21.69
01/25 Foreign Exch Rt ADJ Fee 01/23 The Firehearth Resta San Pedro Tow Card 7111 -0.65
*end*transaction detail
TRANSACTION DETAIL (continued)
01/25 Card Purchase 7111 01/23 American Air00106405570 Fort Worth TX Card -20.16
01/25 Card Purchase 01/24 Harmouche Store San Pedro Card 7111 Bz Dollar 450.00 X 0.5044222 (Exchg Rte) -226.99
01/25 Foreign Exch Rt ADJ Fee 01/24 Harmouche Store San Pedro Card 7111 -6.80
01/25 Card Purchase 01/24 Castillo's Hardware CO. San Pedro Card 7111 Bz Dollar 166.97 X 0.5044020 (Exchg Rte) -84.22
01/25 Foreign Exch Rt ADJ Fee 01/24 Castillo's Hardware CO. San Pedro Card 7111 -2.52
01/28 Card Purchase 01/24 Caramba Restaurant San Pedro Card 7111 Bz Dollar 63.00 X 0.5044444 (Exchg Rte) -31.78
01/28 Foreign Exch Rt ADJ Fee 01/24 Caramba Restaurant San Pedro Card 7111 -0.95
01/28 Card Purchase 01/24 Super Buy San Pedro Card 7111 Bz Dollar 185.35 X 0.5043971 (Exchg Rte) -93.49
01/28 Foreign Exch Rt ADJ Fee 01/24 Super Buy San Pedro Card 7111 -2.80
01/28 Card Purchase 01/24 Coconut Cafe Limited San Pedro Card 7111 Bz Dollar 43.50 X 0.5043678 (Exchg Rte) -21.94
01/28 Foreign Exch Rt ADJ Fee 01/24 Coconut Cafe Limited San Pedro Card 7111 -0.65
01/28 Card Purchase 01/25 The Firehearth Resta San Pedro Tow Card 7111 Bz Dollar 51.00 X 0.5045098 (Exchg Rte) -25.73
01/28 Foreign Exch Rt ADJ Fee 01/25 The Firehearth Resta San Pedro Tow Card 7111 -0.77
01/28 Card Purchase 01/25 Caye Supplies San Pedro Card 7111 Bz Dollar 24.75 X 0.5042424 (Exchg Rte) -12.48
01/28 Foreign Exch Rt ADJ Fee 01/25 Caye Supplies San Pedro Card 7111 -0.37
01/28 Card Purchase 01/25 Castillo's Hardware CO. San Pedro Card 7111 Bz Dollar 38.25 X 0.5043137 (Exchg Rte) -19.29
01/28 Foreign Exch Rt ADJ Fee 01/25 Castillo's Hardware CO. San Pedro Card 7111 -0.57
01/28 Card Purchase 01/26 Elvis Kitchen San Pedro Card 7111 Bz Dollar 54.14 X 0.5044330 (Exchg Rte) -27.31
01/28 Foreign Exch Rt ADJ Fee 01/26 Elvis Kitchen San Pedro Card 7111 -0.81
01/28 Card Purchase 01/26 D Sprout - Love Belize Belize Card 7111 Bz Dollar 69.00 X 0.5043478 (Exchg Rte) -34.80
01/28 Foreign Exch Rt ADJ Fee 01/26 D Sprout - Love Belize Belize Card 7111 -1.04
01/28 Non-Chase ATM Withdraw 01/27 ATM San Pedro Belize Card 7111 Bz Dollar 1000.00 X 0.5044100 (Exchg Rte) -504.41
01/28 Foreign Exch Rt ADJ Fee 01/27 ATM San Pedro Belize Card 7111 -15.13
01/28 Check # 322 -400.00
01/28 Navient Navi Debit PPD ID: 3520974271 -159.09
01/28 Paypal Inst Xfer 1004808465255 Web ID: Paypalsi77 -78.00
01/28 Non-Chase ATM Fee-With -5.00
*end*transaction detail
(continued)
01/29 Card Purchase 01/26 Super Buy San Pedro Card 7111 Bz Dollar 0
142.53 X 0.5043850 (Exchg Rte)
01/29 Foreign Exch Rt ADJ Fee 01/26 Super Buy San Pedro Card 7111 -2.15
01/29 Card Purchase 01/27 Weyu Baya San Pedro Card 7111 Bz Dollar 36.00 X 0.5044444 (Exchg Rte) -18.16
01/29 Foreign Exch Rt ADJ Fee 01/27 Weyu Baya San Pedro Card 7111 -0.54
01/29 Card Purchase 01/28 Tropic Air Ltd San Pedro Card 7111 Bz Dollar 191.50 X 0.5044386 (Exchg Rte) -96.60
01/29 Foreign Exch Rt ADJ Fee 01/28 Tropic Air Ltd San Pedro Card 7111 -2.89
01/29 Card Purchase 01/28 Mirab's Furniture Galle Freetown Card 7111 Bz Dollar 4030.75 X 0.5044148 (Exchg Rte) -2,033.17
01/29 Foreign Exch Rt ADJ Fee 01/28 Mirab's Furniture Galle Freetown Card 7111 -60.99
01/29 01/29 Online Payment 7844054181 To Corona Promenade Comm Assn -288 -82.50
01/30 Card Purchase 01/28 Sahara Grill Freetown Card 7111 Bz Dollar 104.00 X 0.5044231 (Exchg Rte) -52.46
01/30 Foreign Exch Rt ADJ Fee 01/28 Sahara Grill Freetown Card 7111 -1.57
01/30 Card Purchase 01/29 Mirab's Furniture Galle Freetown Card 7111 Bz Dollar 4000.00 X 0.5044150 (Exchg Rte) -2,017.66
01/30 Foreign Exch Rt ADJ Fee 01/29 Mirab's Furniture Galle Freetown Card 7111 -60.52
01/31 Card Purchase 01/29 Caramba! Restaurant San Pedro Card 7111 Bz Dollar 54.00 X 0.5044444 (Exchg Rte) -27.24
01/31 Foreign Exch Rt ADJ Fee 01/29 Caramba! Restaurant San Pedro Card 7111 -0.81
01/31 Card Purchase 01/29 Coconut Cafe Limited San Pedro Card 7111 Bz Dollar 36.45 X 0.5045267 (Exchg Rte) -18.39
01/31 Foreign Exch Rt ADJ Fee 01/29 Coconut Cafe Limited San Pedro Card 7111 -0.55
01/31 Card Purchase 01/30 Mirab's Furniture Galle Freetown Card 7111 Bz Dollar 2430.00 X 0.5044156 (Exchg Rte) -1,225.73
01/31 Foreign Exch Rt ADJ Fee 01/30 Mirab's Furniture Galle Freetown Card 7111 -36.77
01/31 01/31 Online Payment 7844048403 To Capital One -300.00
01/31 01/31 Online Payment 7844046528 To The Gas Company -33.58
01/31 Non-Chase ATM Withdraw 01/31 ATM San Pedro Belize Card 7111 Bz Dollar 1000.00 X 0.5044100 (Exchg Rte) -504.41
01/31 Foreign Exch Rt ADJ Fee 01/31 ATM San Pedro Belize Card 7111 -15.13
01/31 Non-Chase ATM Fee-With -5.00
02/01 Card Purchase 01/26 My Secret Deli San Pedro Card 7111 Bz Dollar 21.50 X 0.5041860 (Exchg Rte) -10.84
02/01 Foreign Exch Rt ADJ Fee 01/26 My Secret Deli San Pedro Card 7111 -0.32
02/01 Card Purchase 01/30 Harmouche Store San Pedro Card 7111 Bz Dollar 247.25 X 0.5044287 (Exchg Rte) -124.72
02/01 Foreign Exch Rt ADJ Fee 01/30 Harmouche Store San Pedro Card 7111 -3.74
TRANSACTION DETAIL
02/01 Card Purchase 7111 01/30 The Firehearth Resta San Pedro Tow Card -22.70
Bz Dollar 45.00 X 0.5044444 (Exchg Rte)
02/01 Foreign Exch Rt ADJ Fee 01/30 The Firehearth Resta San Pedro Tow Card 7111 -0.68
02/04 Card Purchase 01/31 Caramba Restaurant San Pedro Card 7111 Bz Dollar 91.13 X 0.5044442 (Exchg Rte) -45.97
02/04 Foreign Exch Rt ADJ Fee 01/31 Caramba Restaurant San Pedro Card 7111 -1.37
02/04 Card Purchase 02/01 Caramba Restaurant San Pedro Card 7111 Bz Dollar 94.63 X 0.5043855 (Exchg Rte) -47.73
02/04 Foreign Exch Rt ADJ Fee 02/01 Caramba Restaurant San Pedro Card 7111 -1.43
02/04 Card Purchase 02/01 Castillo's Hardware CO. San Pedro Card 7111 Bz Dollar 224.41 X 0.5044338 (Exchg Rte) -113.20
02/04 Foreign Exch Rt ADJ Fee 02/01 Castillo's Hardware CO. San Pedro Card 7111 -3.39
02/04 02/02 Online Payment 7902863297 To Capital One -300.00
02/04 02/02 Online Payment 7902865886 To Corona Promenade Comm Assn -288 -82.50
02/04 02/02 Online Payment 7902870973 To Rex Bullock D.D.S., Inc. -99.00
02/04 Card Purchase 02/02 Elvis Kitchen San Pedro Card 7111 Bz Dollar 61.58 X 0.5043845 (Exchg Rte) -31.06
02/04 Foreign Exch Rt ADJ Fee 02/02 Elvis Kitchen San Pedro Card 7111 -0.93
02/04 Non-Chase ATM Withdraw 02/02 ATM/San Pedro Belize Card 7111 Bz Dollar 1000.00 X 0.5044100 (Exchg Rte) -504.41
02/04 Foreign Exch Rt ADJ Fee 02/02 ATM/San Pedro Belize Card 7111 -15.13
02/04 02/04 Online Domestic Wire Transfer Via: Charlotte St Bk Tr/067013179 A/C: Gabriel Kirchberger Port Charlotte FL 33948 US Ref: Mortage Payment Villa 3 Dospalapas Feb 2019/Bnf/Mortage Payment Villa 3 Belize Imad: 0204B1Qgc08C002233 Trn: 3934300035Es -8,920.15
02/04 Ameriprise Ins Prem PPD ID: 1391173498 -231.72
02/04 Online Domestic Wire Fee -25.00
02/04 Non-Chase ATM Fee-With -5.00
02/05 Card Purchase 02/03 Caramba! Restaurant San Pedro Card 7111 Bz Dollar 74.25 X 0.5043771 (Exchg Rte) -37.45
02/05 Foreign Exch Rt ADJ Fee 02/03 Caramba! Restaurant San Pedro Card 7111 -1.12
02/05 Card Purchase 02/03 Coconut Cafe Limited San Pedro Card 7111 Bz Dollar 30.38 X 0.5042791 (Exchg Rte) -15.32
02/05 Foreign Exch Rt ADJ Fee 02/03 Coconut Cafe Limited San Pedro Card 7111 -0.45
02/05 Card Purchase 02/04 Castillo's Hardware CO. San Pedro Card 7111 Bz Dollar 236.90 X 0.5044323 (Exchg Rte) -119.50
02/05 Foreign Exch Rt ADJ Fee 02/04 Castillo's Hardware CO. San Pedro Card 7111 -3.58
TRANSACTION DETAIL
02/05 Non-Chase ATM Withdraw 02/05 ATM San Pedro Belize Card 7111 Bz Dollar -504.41
1000.00 X 0.5044100 (Exchg Rte)
02/05 Foreign Exch Rt ADJ Fee 02/05 ATM San Pedro Belize Card 7111 -15.13
02/05 Non-Chase ATM Fee-With -5.00
Ending Balance
disclosure message area                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
This Page Intentionally Left Blank