Spreadsheet: 860045d1708278660-power-query-extracting-from-multiple-columns-into-a-new-column-transaction-detail-report-sample
Sheet: Table1

Transaction Date | Description | Account Name | Account Number | Transaction Type | Amount | Cr/Dr | Type | Credit Amount | Debit Amount | Customer Reference | Bank Reference | REMARK 01 | Reference | REMARK 05 | REMARK 06 | REMARK 07 | REMARK 08 | REMARK 09 | REMARK 10 | REMARK 11 | REMARK 12 | REMARK 13 | REMARK 14 | REMARK 15 | Merged | Transaction Number
2024-02-08 00:00:00 | 36 TREAS 310 | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 3335.93 | CR | ACH | 3335.93 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240208 | 36 TREAS 310 | ORIG ID=XXXXXXXX | DESC DATE=020824 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CTX | ENTRY DESCR=MISC PAY |  |  |  |  |  | 123456789101112 1234567899TC ENTRY DATE=240208 IND ID NO=XXXXXXXXXX ORIG CO NAME=36 TREAS 310 ORIG BANK=XXXXXXX ORIG ID=XXXXXXXX DESC DATE=020824 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CTX ENTRY DESCR=MISC PAY
2024-02-08 00:00:00 | STATE OF MARYLAN | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 33739.6 | CR | ACH | 33739.6 |  | TEXT | 1234567899TC | ENTRY DATE=240208 | STATE OF MARYLAN | ORIG ID=NXXXXXXXX | DESC DATE=240206 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | TEXT 1234567899TC ENTRY DATE=240208 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=STATE OF MARYLAN ORIG BANK=MARYLAND NATIONAL BANK ORIG ID=NXXXXXXXX DESC DATE=240206 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-07 00:00:00 | BCBS ILLINOIS | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 436.08 | CR | ACH | 436.08 |  | C123456789 | 1234567899TC | ENTRY DATE=240207 | BCBS ILLINOIS | COMPANY DATA=PAYABLE | ORIG BANK=NORTHERN TRUST CO | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | C123456789 1234567899TC ENTRY DATE=240207 IND ID NO=C123456789 REMARK=TRN*1*CXXXXXXXXXXXXXX* ORIG CO NAME=BCBS ILLINOIS COMPANY DATA=PAYABLE ORIG BANK=NORTHERN TRUST CO ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | CXXXXXXXXXXXXXX
2024-02-05 00:00:00 | FIDELIS CARE | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 26872.04 | CR | ACH | 26872.04 |  | 123456789 | 1234567899TC | ENTRY DATE=240205 | FIDELIS CARE | ORIG BANK=MARINE MIDLAND BANK | ORIG ID=XXXXXXXX | DESC DATE=240130 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240205 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXXXXXXXX* ORIG CO NAME=FIDELIS CARE ORIG BANK=MARINE MIDLAND BANK ORIG ID=XXXXXXXX DESC DATE=240130 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXX
2024-02-07 00:00:00 | AETNA AS01 | ACCOUNT NAME 2 | XXXXXXXX2 | EFT CREDIT | 8593.58 | CR | ACH | 8593.58 |  | 123456789 | 1234567899TC | ENTRY DATE=240207 | AETNA AS01 | ORIG BANK=Bank of America | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240207 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXXXXXXXX* ORIG CO NAME=AETNA AS01 ORIG BANK=Bank of America ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | Testt Company AB | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 539.98 | CR | ACH | 539.98 |  | S1D0XXX7YXRXWXS | 1234567899TC | ENTRY DATE=240209 | Testt Company AB | ORIG BANK=GOLDMAN SACHS BANK USA | ORIG ID=GSXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=NETSWEEP |  |  |  |  |  | S1D0XXX7YXRXWXS 1234567899TC ENTRY DATE=240209 IND ID NO=S1D0XXX7YXRXWXS REMARK=TRN*1*CMXXXXXXXXXXXXXXXX*NetOf110200Minus56202* ORIG CO NAME=Testt Company AB ORIG BANK=GOLDMAN SACHS BANK USA ORIG ID=GSXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=NETSWEEP | CMXXXXXXXXXXXXXXXX
2024-02-07 00:00:00 | [NAME] | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 1860 | CR | ACH | 1860 |  | [NAME] | 1234567899TC | ENTRY DATE=240207 | [NAME] | ORIG ID=IXXXXXXXX | DESC DATE=240206 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | [NAME] 1234567899TC ENTRY DATE=240207 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=[NAME] ORIG BANK=BANK OF AMERICA, N.A. ORIG ID=IXXXXXXXX DESC DATE=240206 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-06 00:00:00 | AETNA A04 | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 6202.8 | CR | ACH | 6202.8 |  | XXXXXXXXXX | 1234567899TC | ENTRY DATE=240206 | AETNA A04 | ORIG BANK=CITIBANK | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | XXXXXXXXXX 1234567899TC ENTRY DATE=240206 IND ID NO=XXXXXXXXXX REMARK=TRN*1*XXXXXXXXXXXXXXXX* ORIG CO NAME=AETNA A04 ORIG BANK=CITIBANK ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | CIGNA | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 5538 | CR | ACH | 5538 |  | XXXXXXXXXX | 1234567899TC | ENTRY DATE=240209 | CIGNA | ORIG BANK=WELLS FARGO BANK NA | ORIG ID=XXXXXXXX | DESC DATE=020624 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | XXXXXXXXXX 1234567899TC ENTRY DATE=240209 IND ID NO=XXXXXXXXXX REMARK=TRN*1*XXXXXXXXXXXXXXXX* ORIG CO NAME=CIGNA ORIG BANK=WELLS FARGO BANK NA ORIG ID=XXXXXXXX DESC DATE=020624 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | InstaMed | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1917.13 | CR | ACH | 1917.13 |  | XXXXXXXXXX | 1234567899TC | ENTRY DATE=240209 | InstaMed | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=PROUD MARYS |  |  |  |  |  |  | XXXXXXXXXX 1234567899TC ENTRY DATE=240209 IND ID NO=XXXXXXXXXX ORIG CO NAME=InstaMed ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=PROUD MARYS
2024-02-09 00:00:00 | HEALTHFIRST PHSP | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 441.72 | CR | ACH | 441.72 |  | [NAME] | 1234567899TC | ENTRY DATE=240209 | HEALTHFIRST PHSP | ORIG BANK=21127445 | ORIG ID=XXXXXXXX | DESC DATE=240207 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | [NAME] 1234567899TC ENTRY DATE=240209 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=HEALTHFIRST PHSP COMPANY DATA=HEALTHFIRST HIX ORIG BANK=21127445 ORIG ID=XXXXXXXX DESC DATE=240207 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-09 00:00:00 | Amerigroup GA5C | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1089.36 | CR | ACH | 1089.36 |  | 987654321 | 1234567899TC | ENTRY DATE=240209 | Amerigroup GA5C | COMPANY DATA=EDI PAYMENT | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 987654321 1234567899TC ENTRY DATE=240209 IND ID NO=987654321 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=Amerigroup GA5C COMPANY DATA=EDI PAYMENT ORIG BANK=BANK OF AMERICA, N.A. ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-09 00:00:00 | BLUE CROSS GA5C | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 4699.88 | CR | ACH | 4699.88 |  | 987654321 | 1234567899TC | ENTRY DATE=240209 | BLUE CROSS GA5C | COMPANY DATA=EDI PAYMENT | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=AXXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 987654321 1234567899TC ENTRY DATE=240209 IND ID NO=987654321 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=BLUE CROSS GA5C COMPANY DATA=EDI PAYMENT ORIG BANK=BANK OF AMERICA, N.A. ORIG ID=AXXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-09 00:00:00 | ANTHEM BLUE VA5C | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 202.75 | CR | ACH | 202.75 |  | 987654321 | 1234567899TC | ENTRY DATE=240209 | ANTHEM BLUE VA5C | COMPANY DATA=EDI PAYMENT | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 987654321 1234567899TC ENTRY DATE=240209 IND ID NO=987654321 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=ANTHEM BLUE VA5C COMPANY DATA=EDI PAYMENT ORIG BANK=BANK OF AMERICA, N.A. ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-09 00:00:00 | VERA-FUND LLC | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 33270.43 | CR | ACH | 33270.43 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240209 | VERA-FUND LLC | ORIG BANK=BANK OF NEW YORK MELLON | ORIG ID=XXXXXXXX | DESC DATE=240208 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=COF CREDIT |  |  |  |  | 123456789101112 1234567899TC ENTRY DATE=240209 IND ID NO=123456789101112 ORIG CO NAME=VERA-FUND LLC COMPANY DATA=COF00000000009141248 ORIG BANK=BANK OF NEW YORK MELLON ORIG ID=XXXXXXXX DESC DATE=240208 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=COF CREDIT
2024-02-09 00:00:00 | CIGNA EDGE TRANS | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 15786.2 | CR | ACH | 15786.2 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240209 | CIGNA EDGE TRANS | COMPANY DATA=HCCLAIMPMT | ORIG BANK=24207175 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789101112 1234567899TC ENTRY DATE=240209 IND ID NO=123456789101112 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=CIGNA EDGE TRANS COMPANY DATA=HCCLAIMPMT ORIG BANK=24207175 ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-09 00:00:00 | MVP HEALTH PLAN | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 740 | CR | ACH | 740 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | MVP HEALTH PLAN | ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK | ORIG ID=XXXXXXXX | DESC DATE=240207 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240209 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXXXXXXXX* ORIG CO NAME=MVP HEALTH PLAN ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK ORIG ID=XXXXXXXX DESC DATE=240207 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | National Grid | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 426 | CR | ACH | 426 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | National Grid | ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK | ORIG ID=XXXXXXXX | DESC DATE=240207 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240209 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* ORIG CO NAME=National Grid ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK ORIG ID=XXXXXXXX DESC DATE=240207 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | HUMANA GOVT BUSI | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2792.08 | CR | ACH | 2792.08 |  | [PHONE] | 1234567899TC | ENTRY DATE=240209 | HUMANA GOVT BUSI | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=XXXXXXXX | DESC DATE=020724 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | [PHONE] 1234567899TC ENTRY DATE=240209 IND ID NO=[PHONE] REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=HUMANA GOVT BUSI ORIG BANK=BANK OF AMERICA, N.A. ORIG ID=XXXXXXXX DESC DATE=020724 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-09 00:00:00 | LOYALEHLTH SV9T | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 6817.15 | CR | ACH | 6817.15 |  | [NAME] XXX | 1234567899TC | ENTRY DATE=240209 | LOYALEHLTH SV9T | ORIG ID=XXXXXXXX | DESC DATE=240208 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=PPD | ENTRY DESCR=XXXXXXXX |  |  |  |  |  | [NAME] XXX 1234567899TC ENTRY DATE=240209 ORIG CO NAME=LOYALEHLTH SV9T COMPANY DATA=XXXXXXXXXXX ORIG BANK=24207175 ORIG ID=XXXXXXXX DESC DATE=240208 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=PPD ENTRY DESCR=XXXXXXXX
2024-02-09 00:00:00 | Testt Company Li | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 920.68 | CR | ACH | 920.68 |  | AXR1QXQXX3XXRXY | 1234567899TC | ENTRY DATE=240209 | Testt Company Li | ORIG BANK=GOLDMAN SACHS BANK USA | ORIG ID=GSXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=NETSWEEP |  |  |  |  |  | AXR1QXQXX3XXRXY 1234567899TC ENTRY DATE=240209 IND ID NO=AXR1QXQXX3XXRXY REMARK=TRN*1*UH123456789XXXXXXXXXXX*NetOf187894Minus95826* ORIG CO NAME=Testt Company Li ORIG BANK=GOLDMAN SACHS BANK USA ORIG ID=GSXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=NETSWEEP | UH123456789XXXXXXXXXXX
2024-02-09 00:00:00 | HNB - ECHO | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 8269.2 | CR | ACH | 8269.2 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | HNB - ECHO | ORIG BANK=[NAME] | ORIG ID=XXXXXXXX | DESC DATE=240209 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240209 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=HNB - ECHO ORIG BANK=[NAME] ORIG ID=XXXXXXXX DESC DATE=240209 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-09 00:00:00 | UNITED BEHAVIORA | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 5038.44 | CR | ACH | 5038.44 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | UNITED BEHAVIORA | ORIG BANK=12438487 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240209 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXXXXXXXX* ORIG CO NAME=UNITED BEHAVIORA ORIG BANK=12438487 ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | VSHP VOL II FUND | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2937.62 | CR | ACH | 2937.62 |  | 1234567 | 1234567899TC | ENTRY DATE=240209 | VSHP VOL II FUND | COMPANY DATA=CLAIM PYMT | ORIG BANK=First Horizon Bank | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 1234567 1234567899TC ENTRY DATE=240209 IND ID NO=1234567 REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* ORIG CO NAME=VSHP VOL II FUND COMPANY DATA=CLAIM PYMT ORIG BANK=First Horizon Bank ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | UMR | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 958.35 | CR | ACH | 958.35 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | UMR | ORIG BANK=12438487 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240209 IND ID NO=123456789 REMARK=TRN*1*CE1234567890XXXXXXXXXXXXX* ORIG CO NAME=UMR ORIG BANK=12438487 ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | CE1234567890XXXXXXXXXXXXX
2024-02-09 00:00:00 | UMR State of Nev | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 219.43 | CR | ACH | 219.43 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | UMR State of Nev | ORIG BANK=12438487 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240209 IND ID NO=123456789 REMARK=TRN*1*CE1234567890XXXXXXXXXXXXX* ORIG CO NAME=UMR State of Nev ORIG BANK=12438487 ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | CE1234567890XXXXXXXXXXXXX
2024-02-09 00:00:00 | VSHP TN CARE SEL | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 360.61 | CR | ACH | 360.61 |  | 1234567 | 1234567899TC | ENTRY DATE=240209 | VSHP TN CARE SEL | COMPANY DATA=CLAIM PYMT | ORIG BANK=First Horizon Bank | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 1234567 1234567899TC ENTRY DATE=240209 IND ID NO=1234567 REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* ORIG CO NAME=VSHP TN CARE SEL COMPANY DATA=CLAIM PYMT ORIG BANK=First Horizon Bank ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | CIGNA HLTH LIFE | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2012 | CR | ACH | 2012 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240209 | CIGNA HLTH LIFE | ORIG BANK=CITIBANK | ORIG ID=XXXXXXXX | DESC DATE=240209 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789101112 1234567899TC ENTRY DATE=240209 IND ID NO=123456789101112 REMARK=TRN*1*XXXXXXXXXXXXXXXX* ORIG CO NAME=CIGNA HLTH LIFE ORIG BANK=CITIBANK ORIG ID=XXXXXXXX DESC DATE=240209 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | OXFORD HEALTH IN | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 293.24 | CR | ACH | 293.24 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | OXFORD HEALTH IN | ORIG BANK=PNC BANK | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240209 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=OXFORD HEALTH IN ORIG BANK=PNC BANK ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-08 00:00:00 | Wellpoint TN5C | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1052.8 | CR | ACH | 1052.8 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240208 | Wellpoint TN5C | COMPANY DATA=EDI PAYMENT | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789101112 1234567899TC ENTRY DATE=240208 IND ID NO=123456789101112 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=Wellpoint TN5C COMPANY DATA=EDI PAYMENT ORIG BANK=BANK OF AMERICA, N.A. ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-08 00:00:00 | UNITEDHEALTHCARE | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 732.7 | CR | ACH | 732.7 |  | 123456789 | 1234567899TC | ENTRY DATE=240208 | UNITEDHEALTHCARE | ORIG BANK=12438487 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240208 IND ID NO=123456789 REMARK=TRN*1*1TZXXXXXXXX* ORIG CO NAME=UNITEDHEALTHCARE ORIG BANK=12438487 ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | 1TZXXXXXXXX
2024-02-08 00:00:00 | BCBST OF TN | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 15855.14 | CR | ACH | 15855.14 |  | 1234567 | 1234567899TC | ENTRY DATE=240208 | BCBST OF TN | COMPANY DATA=CLAIM PYMT | ORIG BANK=First Horizon Bank | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 1234567 1234567899TC ENTRY DATE=240208 IND ID NO=1234567 REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* ORIG CO NAME=BCBST OF TN COMPANY DATA=CLAIM PYMT ORIG BANK=First Horizon Bank ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXXXXXXX
2024-02-08 00:00:00 | BCBST FEP BASIC | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2042.5 | CR | ACH | 2042.5 |  | 1234567 | 1234567899TC | ENTRY DATE=240208 | BCBST FEP BASIC | COMPANY DATA=MEDICAL - FEB | ORIG BANK=FIRST NATL BK OF BIRMINGHAM | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 1234567 1234567899TC ENTRY DATE=240208 IND ID NO=1234567 REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* ORIG CO NAME=BCBST FEP BASIC COMPANY DATA=MEDICAL - FEB ORIG BANK=FIRST NATL BK OF BIRMINGHAM ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXXXXXXX
2024-02-08 00:00:00 | ACH MEDICAID | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 12354.99 | CR | ACH | 12354.99 |  | 123456789 | 1234567899TC | ENTRY DATE=240208 | ACH MEDICAID | ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK | ORIG ID=XXXXXXXX | DESC DATE=240202 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240208 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=ACH MEDICAID ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK ORIG ID=XXXXXXXX DESC DATE=240202 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-05 00:00:00 |  | ACCOUNT NAME 5 | XXXXXXXX5 | CHECK | 75 | DR | CHK |  | 75 | [PHONE] | [PHONE] | CHECK NO=[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] [PHONE] CHECK NO=[PHONE]
2024-02-05 00:00:00 |  | ACCOUNT NAME 5 | XXXXXXXX5 | CHECK | 25 | DR | CHK |  | 25 | [PHONE] | [PHONE] | CHECK NO=[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] [PHONE] CHECK NO=[PHONE]
2024-02-09 00:00:00 |  | ACCOUNT NAME 6 | XXXXXXXX6 | CHECK | 201.32 | DR | CHK |  | 201.32 | [PHONE] | [PHONE] | CHECK NO=[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] [PHONE] CHECK NO=[PHONE]
2024-02-09 00:00:00 |  | ACCOUNT NAME 6 | XXXXXXXX6 | CHECK | 101.29 | DR | CHK |  | 101.29 | [PHONE] | [PHONE] | CHECK NO=[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] [PHONE] CHECK NO=[PHONE]
2024-02-09 00:00:00 |  | ACCOUNT NAME 6 | XXXXXXXX6 | CHECK | 105.89 | DR | CHK |  | 105.89 | [PHONE] | [PHONE] | CHECK NO=[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] [PHONE] CHECK NO=[PHONE]
2024-02-09 00:00:00 |  | ACCOUNT NAME 6 | XXXXXXXX6 | CHECK | 233.2 | DR | CHK |  | 233.2 | [PHONE] | [PHONE] | CHECK NO=[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] [PHONE] CHECK NO=[PHONE]
2024-02-08 00:00:00 | KAISER FOUNDATIO | ACCOUNT NAME 7 | XXXXXXXX7 | EFT CREDIT | 23327 | CR | ACH | 23327 |  | 123456789 | 1234567899TC | ENTRY DATE=240208 | KAISER FOUNDATIO | ORIG BANK=CITIBANK | ORIG ID=XXXXXXXX | DESC DATE=240206 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  | 123456789 1234567899TC ENTRY DATE=240208 IND ID NO=123456789 REMARK=TRN*1*XXXXXXXXXXXXXXXX* ORIG CO NAME=KAISER FOUNDATIO ORIG BANK=CITIBANK ORIG ID=XXXXXXXX DESC DATE=240206 TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXXXXXXXX
2024-02-09 00:00:00 | [PHONE] | ACCOUNT NAME 8 | XXXXXXXX8 | EFT CREDIT | 283.34 | CR | ACH | 283.34 |  | ACH123456789101 | 1234567899TC | ENTRY DATE=240209 | [PHONE] | ORIG BANK=WELLS FARGO BANK NA | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | ACH123456789101 1234567899TC ENTRY DATE=240209 IND ID NO=ACH123456789101 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=[PHONE] ORIG BANK=WELLS FARGO BANK NA ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX
2024-02-09 00:00:00 | HORIZON | ACCOUNT NAME 8 | XXXXXXXX8 | EFT CREDIT | 40690.05 | CR | ACH | 40690.05 |  | ACH123456789101 | 1234567899TC | ENTRY DATE=240209 | HORIZON | ORIG BANK=WELLS FARGO BANK NA | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT |  |  |  |  |  | ACH123456789101 1234567899TC ENTRY DATE=240209 IND ID NO=ACH123456789101 REMARK=TRN*1*XXXXXXXXXX* ORIG CO NAME=HORIZON ORIG BANK=WELLS FARGO BANK NA ORIG ID=XXXXXXXX TRACE NO=XXXXXXXXXXXXXXX IND NAME=Org Name ENTRY CLASS=CCD ENTRY DESCR=HCCLAIMPMT | XXXXXXXXXX