Maya Bungol
New Member
- Joined
- Aug 2, 2022
- Messages
- 7
- Office Version
- 365
Hi all,
I need help again. I wanna make sure I'm putting the correct formulas. And if anyone can check it that would be perfect! Something is off with my formula because we already have the invoices but the column "Receipts" still shows "Missing".
If there's another formula to use to avoid kicking me out, that would be perfect.
This is the master sheet, where everything shows all the data from other sheets.
This is the statement sheet - the data pulled from here is for the Master sheet (columns C to G ). This is where we base all the transactions.
And this invoice sheet is where we confirm if we received or paid the invoices from the transaction sheet.
If any could help. I really appreciate it!
Thank you!
I need help again. I wanna make sure I'm putting the correct formulas. And if anyone can check it that would be perfect! Something is off with my formula because we already have the invoices but the column "Receipts" still shows "Missing".
If there's another formula to use to avoid kicking me out, that would be perfect.
This is the master sheet, where everything shows all the data from other sheets.
STATEMENT REPORT | |||||||||
Paid | Diverted From Account Number | Post Date | Tran Date | Diverted From Cardholder Name | Amount | Merchant Name | CC ID | Receipts | Status |
552747****2924 | 6/30/2022 | 6/29/2022 | CORI BLOXSOM | 81.00 | SQ *MR. BURRITOS | CCCB01 | Paid | C | |
552747****2924 | 6/30/2022 | 6/29/2022 | CORI BLOXSOM | 63.00 | AMZN Mktp US*M07RB14Q3 | CCCB01 | Missing | O | |
552747****8279 | 6/30/2022 | 6/28/2022 | CHANCE WEIGHT | 21.41 | ALBERTSONS #0009 | CCCW01 | OK | R | |
p | 552747****1574 | 6/30/2022 | 6/28/2022 | SHILOH KERR | 27.28 | ALBERTSONS #0043 | CCSK01 | Paid | C |
552747****2352 | 6/30/2022 | 6/28/2022 | ARIS BATISTA | 9.63 | SAFEWAY #1160 | CCAB02 | Missing | O | |
552747****0831 | 6/30/2022 | 6/28/2022 | TODD OKKEN | 21.98 | LEWISTOWN TRUE VALUE | CCTO01 | Missing | O | |
552747****0831 | 6/30/2022 | 6/28/2022 | TODD OKKEN | 42.97 | LEWISTOWN TRUE VALUE | CCTO01 | Missing | O | |
p | 552747****7075 | 6/30/2022 | 6/28/2022 | MATT BROSSMAN | 18.99 | OLD CHICAGO BOZEMAN | CCMB01 | Paid | C |
p | 552747****9460 | 6/30/2022 | 6/29/2022 | HATTIE REDMON | 54.85 | THE TROUGH | CCHR01 | Paid | C |
This is the statement sheet - the data pulled from here is for the Master sheet (columns C to G ). This is where we base all the transactions.
Tran Date | Merchant Name | Amount | Diverted From Account Number | Diverted From Cardholder Name |
6/29/2022 | SQ *MR. BURRITOS | $81.00 | 552747****2924 | CORI BLOXSOM |
6/29/2022 | AMZN Mktp US*M07RB14Q3 | $63.00 | 552747****2924 | CORI BLOXSOM |
6/28/2022 | ALBERTSONS #0009 | $21.41 | 552747****8279 | CHANCE WEIGHT |
6/28/2022 | ALBERTSONS #0043 | $27.28 | 552747****1574 | SHILOH KERR |
6/28/2022 | SAFEWAY #1160 | $9.63 | 552747****2352 | ARIS BATISTA |
6/28/2022 | LEWISTOWN TRUE VALUE | $21.98 | 552747****0831 | TODD OKKEN |
6/28/2022 | LEWISTOWN TRUE VALUE | $42.97 | 552747****0831 | TODD OKKEN |
6/28/2022 | OLD CHICAGO BOZEMAN | $18.99 | 552747****7075 | MATT BROSSMAN |
6/29/2022 | THE TROUGH | $54.85 | 552747****9460 | HATTIE REDMON |
And this invoice sheet is where we confirm if we received or paid the invoices from the transaction sheet.
Vendor | Vendor Name | Inv Date | Invoice | Amount | Acctg Date | Status |
CCAB02 | CC ARIS BATISTA x2352 | 6/27/2022 | YOK220627 | 8.01 | 7/1/2022 | Fully paid |
CCAB02 | CC ARIS BATISTA x2352 | 6/1/2022 | SAF220601 | 10.97 | 6/1/2022 | Fully paid |
CCAB02 | CC ARIS BATISTA x2352 | 6/14/2022 | MOD220614 | 11.41 | 7/1/2022 | Fully paid |
CCAB02 | CC ARIS BATISTA x2352 | 6/13/2022 | YOK220613 | 14.54 | 7/1/2022 | Fully paid |
CCCB01 | CC CORI BLOXSOM x2924 | 6/21/2022 | RIS220621 | 71.88 | 6/21/2022 | Fully paid |
CCCB01 | CC CORI BLOXSOM x2924 | 6/30/2022 | AMA220630 | 79.99 | 7/1/2022 | Open |
CCCB01 | CC CORI BLOXSOM x2924 | 6/29/2022 | MRB220622 | 81.00 | 6/22/2022 | Fully paid |
CCCB01 | CC CORI BLOXSOM x2924 | 6/21/2022 | CEN220621 | 83.95 | 6/21/2022 | Fully paid |
CCCB01 | CC CORI BLOXSOM x2924 | 6/2/2022 | ROS220602 | 93.31 | 6/2/2022 | Fully paid |
CCCB01 | CC CORI BLOXSOM x2924 | 6/2/2022 | HAM220602 | 105.14 | 6/2/2022 | Fully paid |
CCCB01 | CC CORI BLOXSOM x2924 | 6/9/2022 | MAP220609 | 145.00 | 6/9/2022 | Fully paid |
CCCB01 | CC CORI BLOXSOM x2924 | 6/14/2022 | STA220614 | 163.98 | 6/14/2022 | Fully paid |
If any could help. I really appreciate it!
Thank you!