Spreadsheet: 866087d1713021692-need-to-fix-if-and-formula-for-windows-excel-365-mso-version-2308-sample
Sheet: Invoices

Status | FS Notes | Transaction | Account | Original Amount | Remaining Amount | Currency | Days Late | Due Date | Transaction Date | Class | [NAME] | [NAME] | Type | Installment Status | Dispute Amount | Dispute Date | Promised ? | [NAME] | [NAME] | Terms | Primary Salesrep | Do Not Print | Operating Unit | Unpaid Reason | Cash App Notes | IS# | OS# | Discount Amt | Discount Amt Sales Tax | Ship To Code | CM Apply to INV# | Legal Entity
 | customer paid PO on 2/7/22 | 10211194 | H-61050 |  | 8395.68 | USD | 644 | 44657 | 44627 | Invoice | PSEG
 | Customer paid on 7/19/2022 | 10220667 | H-61050 |  | 3867.25 | USD | 514 | 44787 | 44757 | Invoice | PSEG
 | customer paid on 6/7/22 | 10222172 | H-61050 |  | 3355.92 | USD | 490 | 44811 | 44781 | Invoice | PSEG
 | 302.42 sales tax not paid. Remainder of the balance 4262.38 unknown | 10217670 | H-61050 |  | 2387.42 | USD | 558 | 44743 | 44713 | Invoice | PSEG
 | This was part of the Q4 EOY CLEAN UP | 10222029 | H-61050 |  | 2443.2 | USD | 494 | 44807 | 44777 | Invoice | PSEG
 | Paid In Full on SAP 4/22/21 - has $241.93 tax | 10193082 | H-61050 |  | 2213.79 | USD | 899 | 44402 | 44372 | Invoice | PSEG
 | This was part of the Q4 EOY CLEAN UP | 10178753 | H-61050 |  | 2041.03 | USD | 1063 | 44238 | 44208 | Invoice | PSEG
 | There is tax which is the shortage | 10219791 | H-61050 |  | 1997.31 | USD | 528 | 44773 | 44743 | Invoice | PSEG
 | customer paid on 7/12/2022 | 10220387 | H-61050 |  | 1851.22 | USD | 516 | 44785 | 44755 | Invoice | PSEG
 | 1742.70 UNPAID TAX 182.40 UNKNOWN SHORTAGE | 10218083 | H-61050 |  | 1925.1 | USD | 551 | 44750 | 44720 | Invoice | PSEG
 | Paid in Full on 7/11/24 - has $1,424.00 tax | 10220046 | H-61050 |  | 1626.42 | USD | 522 | 44779 | 44749 | Invoice | PSEG
 | paid in full 7-15-242- however size 15 boots - misreceipted- full quantity paid for that on 4-26-22 ($464.07 - not in this check-however billed on this invoice) also tax $313.92 | 10220395 | H-61050 |  | 1051.19 | USD | 517 | 44784 | 44754 | Invoice | PSEG
 | 296.34 is tax.  unsure of the remaining balance | 10222015 | H-61050 |  | 966.06 | USD | 494 | 44807 | 44777 | Invoice | PSEG
 | unknown shortage 1467.86 sales tax | 10219473 | H-61050 |  | 1101.12 | USD | 530 | 44771 | 44741 | Invoice | PSEG
 | Tax $863.17 - Paid in full except req created at a lower price due to price increase not reflected. (for example - $50 increase for certain boots-req done at prior price) | 10219098 | H-61050 |  | 863.17 | USD | 536 | 44765 | 44735 | Invoice | PSEG
 | We show customer paid $3,355.98 in total on PO#[PHONE] however we only invoiced $2,903.62. With the miss applications of payments in the past we are including this in the Recon. | 10217895 | H-35570 |  | 842.06 | USD | 553 | 44748 | 44718 | Invoice | PSEGGL
 | paid in full and has tax $204.07 | 10218816 | H-61050 |  | 574.39 | USD | 539 | 44762 | 44732 | Invoice | PSEG
 | PAID IN FULL 1/25/21 NO TAX | 10180222 | H-61050 |  | 551.09 | USD | 1046 | 44255 | 44225 | Invoice | PSEG
 | NO TAX | 10220055 | H-61050 |  | 476.41 | USD | 522 | 44779 | 44749 | Invoice | PSEG
 | PAID IN FULL 8/4/22  NO TAX | 10221851 | H-61050 |  | 470.98 | USD | 496 | 44805 | 44775 | Invoice | PSEG
 | Customer paid 3/4/2022 | 10218815 | H-61050 |  | 368.1 | USD | 539 | 44762 | 44732 | Invoice | PSEG
 | This was part of the Q4 EOY CLEAN UP | 10222174 | H-61050 |  | 309.38 | USD | 490 | 44811 | 44781 | Invoice | PSEG
 | tax 27.12 | 10220134 | H-61050 |  | 277.2 | USD | 521 | 44780 | 44750 | Invoice | PSEG
 | 2.27.24 per Rose invoice was paid in full by PSEG without tax.   Our notes show SHORT PAID DUE TO MISPPLIED PAYMENTS CORRECTLY. UNABLE TO FIND OTHER CASH IDENTIFIED BY CUSTMER TO PAY REMAINDER OF THE BALANCE DUE | 10190852 | H-61050 |  | 299.24 | USD | 923 | 44378 | 44348 | Invoice | PSEG
 | tax | 10222001 | H-61050 |  | 261 | USD | 494 | 44807 | 44777 | Invoice | PSEG
 | PO # is incorrect, PO#[PHONE]. paid on 2/1/21 | 10178198 | H-61050 |  | 259.2 | USD | 1070 | 44231 | 44201 | Invoice | PSEG
 | 2.27.24 Per Rose this is aprice discrepancy when req created $19.20 and $100.81 otherwise Paid in Full 6/6/22---- Our notes say Applied 40.32 to inv.  by cash apps | 10217832 | H-61050 |  | 154.92 | USD | 556 | 44745 | 44715 | Invoice | PSEG
 | 112.14 is sales tax | 10220139 | H-61050 |  | 82.29 | USD | 521 | 44780 | 44750 | Invoice | PSEG
 | Customer paid 2/14/22 | 10221224 | H-61050 |  | 68.8 | USD | 504 | 44797 | 44767 | Invoice | PSEG
 |  |  |  |  | 41080.94
 |  |  |  |  | 29
 |  |  |  |  | 82190.87999999999
 |  |  |  |  | 31