Acct #Date
Trans Type Invoice #
B12133
3/3/2023
Invoice
1004319
$825.00
B12133
3/3/2023
Invoice
S061217852
$255.45
B12133
3/3/2023
Invoice
S061216890
B12133
3/6/2023
Credit Memo 1004774
($188.00)
B12133
3/6/2023
Credit Memo 1004891
($203.00)
B12133
3/9/2023
Invoice
S101222070
$317.20
B12133
3/21/2023
Credit Memo S061232509
($166.60)
A34995
2/3/2023
Credit Memo S101182990
($242.76)
A34995
2/6/2023
Credit Memo 991218
($630.00)
A34995
2/16/2023
Invoice
$207.90
A34995
2/28/2023
Credit Memo 1002631
($220.00)
A34995
3/9/2023
Invoice
S101220964
$156.10
A6277
1/19/2023
Invoice
S131173296
A6277
2/3/2023
Credit Memo 990339
($456.00)
A6277
2/7/2023
Invoice
S111191808
$350.00
A6277
2/9/2023
Invoice
993750
$800.00
A6277
2/14/2023
Credit Memo 995338
($742.00)
A6277
3/29/2023
Credit Memo S131241661
($260.40)
A35293
1/18/2023
Invoice
S071171948
$275.00
A35293
2/24/2023
Credit Memo S061211090
($470.00)
A6259
3/30/2023
Credit Memo S131243489
($253.64)
A6259
3/30/2023
Credit Memo S131243295
($253.64)
B13765
2/3/2023
Credit Memo S061184609
($116.00)
A13644
3/6/2023
Invoice
A13644
3/9/2023
Credit Memo 1007240
B9941
1/17/2023
Invoice
S101168373
$255.00
B9941
1/24/2023
Credit Memo S111175602
($1,800.00)
B9941
2/20/2023
Invoice
S101204921
$196.00
B9941
3/1/2023
Invoice
S101211447
$153.30
B9941
3/2/2023
Credit Memo S101215405
($196.00)
B9941
3/6/2023
Invoice
S101217751
$200.00
A37580
3/1/2023
Credit Memo S011209965
($265.00)
A37580
3/1/2023
Credit Memo S011201380
($45.00)
A37580
3/1/2023
Credit Memo S011190486
($50.00)
B13555
2/22/2023
Invoice
S061208897
$167.96
B13555
3/9/2023
Invoice
S081222939
$112.88
A21090
3/2/2023
Invoice
S131206817
$580.72
A20593
1/16/2023
Invoice
S061168225
$869.04
A20593
1/24/2023
Invoice
S061179270
$214.88
A20593
2/23/2023
Invoice
S061205527
$212.80
A20593
2/27/2023
Credit Memo S131212652
($443.36)
A20593
2/28/2023
Credit Memo S131210962
($445.40)
B11218
3/6/2023
Invoice
A36970
2/24/2023
Credit Memo 1000974
A30902
2/3/2023
Invoice
S111182615
$290.00
A30902
2/20/2023
Invoice
S111199710
$470.00
S101202025
S101218615
S131219944
Amount
$287.95
$193.80
$88.40
($2,250.00)
$108.50
($1,010.00)
A21615
3/29/2023
Credit Memo 1016920
($960.00)
B7871
4/3/2023
Credit Memo S011231227
($193.90)
X4725
1/4/2023
Invoice
S011149572
$221.68
X4725
2/15/2023
Invoice
996110
$140.00
X4725
2/22/2023
Invoice
999684
$988.00
X4725
2/24/2023
Invoice
S071206236
$245.70
X4725
2/27/2023
Invoice
S111208512
$245.70
X4725
3/3/2023
Invoice
S011212226
$101.85
X4725
3/7/2023
Invoice
S011215920
$177.80
X4725
3/9/2023
Invoice
1007059
$788.10
X4725
3/15/2023
Credit Memo 1009520
($48.10)
B13152
1/3/2023
Invoice
S071156321
$100.64
B13152
1/10/2023
Invoice
S061164302
$960.00
B13152
1/12/2023
Invoice
S071164495
B13152
1/13/2023
Invoice
979642
$2,744.00
B13152
1/16/2023
Invoice
980897
$305.00
B13152
1/17/2023
Credit Memo S131168451
($462.30)
B13152
1/17/2023
Invoice
S061167242
$252.96
B13152
1/20/2023
Invoice
983800
B13152
1/20/2023
Invoice
S061174412
$191.95
B13152
1/23/2023
Invoice
S071177475
$80.92
B13152
2/6/2023
Invoice
S061188728
$854.76
B13152
2/7/2023
Invoice
992077
B13152
2/8/2023
Invoice
S061190233
B13152
2/13/2023
Invoice
995081
B13152
2/22/2023
Invoice
S061208364
$139.40
B13152
2/24/2023
Invoice
S081210946
$104.30
B13152
2/27/2023
Credit Memo 1001443
B13152
3/8/2023
Invoice
S081223289
$116.28
B13152
3/9/2023
Invoice
S061215519
$100.10
A12240
2/7/2023
Credit Memo 991974
($355.00)
A12240
3/7/2023
Invoice
1005790
$390.00
A18345
2/13/2023
Credit Memo 994868
($334.00)
B5793
1/13/2023
Invoice
980111
$770.00
B5793
2/15/2023
Credit Memo 996018
($770.00)
B12073
3/1/2023
Invoice
S061214684
$506.10
B12073
3/2/2023
Invoice
S061212468
$60.00
B12073
3/6/2023
Invoice
S061215780
$154.70
A19506
1/31/2023
Invoice
S111177984
$264.75
A15346
2/16/2023
Invoice
996806
$583.00
A15346
2/16/2023
Credit Memo 996809
($490.00)
A15346
2/21/2023
Invoice
998893
$417.00
A15346
3/15/2023
Credit Memo 1009923
($583.00)
B13141
1/16/2023
Invoice
980640
$220.00
B13141
1/17/2023
Invoice
S061166108
$177.48
B13141
1/23/2023
Invoice
984454
$485.00
B13141
1/30/2023
Invoice
987632
$540.00
$176.12
$4,000.00
$1,200.00
$202.84
$2,373.00
($1,375.00)
B13141
1/31/2023
Invoice
S061182532
$316.20
B13141
2/7/2023
Invoice
992047
$630.00
B13141
2/7/2023
Invoice
S061184006
$109.48
B13141
2/8/2023
Invoice
S061192481
$120.36
B13141
2/27/2023
Invoice
S061201012
$158.90
B13141
3/7/2023
Invoice
S061211061
$170.80
B18508
3/1/2023
Invoice
S111215807
$562.80
A31024
1/16/2023
Credit Memo 980469
($845.00)
A6831
2/21/2023
Credit Memo 998972
($960.00)
A6831
3/31/2023
Credit Memo S071243072
($420.00)
Below is a list of invoice numbers.
Using data set provided, do a V-Look up in Column B to pull in date of invoice and amount.
Please format answers so that credits are red and all amounts have dollar signs.
Invoice #
1004319
S061217852
S061216890
1004774
1004891
S101222070
S061232509
S101182990
991218
S101202025
1002631
S101220964
S131173296
990339
S111191808
993750
995338
S131241661
S071171948
S061211090
S131243489
S131243295
S061184609
S101218615
1007240
S101168373
S111175602
S101204921
S101211447
S101215405
S101217751
S011209965
S011201380
S011190486
S061208897
S081222939
S131206817
S061168225
S061179270
S061205527
Date of Invoice
Amount
S131212652
S131210962
S131219944
1000974
S111182615
S111199710
1016920
S011231227
S011149572
996110
999684
S071206236
S111208512
S011212226
S011215920
1007059
1009520
S071156321
S061164302
S071164495
979642
980897
S131168451
S061167242
983800
S061174412
S071177475
S061188728
992077
S061190233
995081
S061208364
S081210946
1001443
S081223289
S061215519
991974
1005790
994868
980111
996018
S061214684
S061212468
S061215780
S111177984
996806
996809
998893
1009923
980640
S061166108
984454
987632
S061182532
992047
S061184006
S061192481
S061201012
S061211061
S111215807
980469
998972
S071243072
Using data set provided, run a filter to isolate transactions from February 2023 and copy and past data below.
Acct #
Date
Trans Type Invoice #
Amount
past data below.
Using data set provided, create a pivot table showing:
Account Number
Number of Open Transactions
Net Balance
Place Pivot Table Below
Using data set provided, create two lists by transaction type in this spreadsheet.
Fist list will be all transactions that are invoices.
Data sort aplhabetically by account number -A to Z. highest to lowest and calculate total invoice amounts and place answer in
Calculate total invoice amounts and place answer in box.
Using conditional formatting, identify how many invoices were greater then $500.00.
Second list will be all transactions that are credit memos.
Data sort by date – oldest to newest.
Calculate total credit memo amount and place answer in box.
Using conditional formatting, identify how many credit memos were less then $500.00
Invoice Total:
# of invoices greater than $500.00
Acct #
Date
Trans Type
Credit Memo Total:
# of credit memos less than
Invoice #
Amount
Acct #
amounts and place answer in box.
Credit Memo Total:
# of credit memos less than $500.00
Date
Trans Type
Invoice #
Amount
$0.00
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
