Spreadsheet: 830005d1684620275-extract-values-from-cell-and-convert-to-number-book1-pq-bank
Sheet: PQ_FinalEntry

Index | Details | Subsidiary | Post Date | Name | Description | journalItemLine_accountRef | journalItemLine_debitAmount | journalItemLine_creditAmount | Memo | journalItemLine_departmentRef | journalItemLine_locationRef
1 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f4784Minus2440* TRN: [NAME] | 630 | 23.44 |  | Trans Number | Clinical | [NAME]
1 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f4784Minus2440* TRN: [NAME] | 640 | 24.4 |  | Trans Number | Clinical | [NAME]
1 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f4784Minus2440* TRN: [NAME] | 523 |  | 47.84 | Trans Number | Clinical | [NAME]
2 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf5004Min us2552* TRN: [NAME] | 630 | 24.52 |  | Trans Number | Clinical | [NAME]
2 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf5004Min us2552* TRN: [NAME] | 640 | 25.52 |  | Trans Number | Clinical | [NAME]
2 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf5004Min us2552* TRN: [NAME] | 523 |  | 50.44 | Trans Number | Clinical | [NAME]
3 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of16406Minus8367* TRN: [NAME] | 630 | 80.39 |  | Trans Number | Clinical | [NAME]
3 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of16406Minus8367* TRN: [NAME] | 640 | 83.67 |  | Trans Number | Clinical | [NAME]
3 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of16406Minus8367* TRN: [NAME] | 523 |  | 64.06 | Trans Number | Clinical | [NAME]
4 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f22729Minus11592* TRN: [NAME] | 630 | 111.37 |  | Trans Number | Clinical | [NAME]
4 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f22729Minus11592* TRN: [NAME] | 640 | 115.92 |  | Trans Number | Clinical | [NAME]
4 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f22729Minus11592* TRN: [NAME] | 523 |  | 227.29 | Trans Number | Clinical | [NAME]
5 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf56606Minus288 69* TRN: [NAME] | 630 | 277.37 |  | Trans Number | Clinical | [NAME]
5 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf56606Minus288 69* TRN: [NAME] | 640 | 288.69 |  | Trans Number | Clinical | [NAME]
5 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf56606Minus288 69* TRN: [NAME] | 523 |  | 66.06 | Trans Number | Clinical | [NAME]
6 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f81327Minus41477* TRN: [NAME] | 630 | 398.5 |  | Trans Number | Clinical | [NAME]
6 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f81327Minus41477* TRN: [NAME] | 640 | 414.77 |  | Trans Number | Clinical | [NAME]
6 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f81327Minus41477* TRN: [NAME] | 523 |  | 813.27 | Trans Number | Clinical | [NAME]
7 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf96507Minus49 219* TRN: [NAME] | 630 | 472.88 |  | Trans Number | Clinical | [NAME]
7 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf96507Minus49 219* TRN: [NAME] | 640 | 492.19 |  | Trans Number | Clinical | [NAME]
7 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf96507Minus49 219* TRN: [NAME] | 523 |  | 5.07 | Trans Number | Clinical | [NAME]
8 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f114048Minus58164* TRN: [NAME] | 630 | 558.84 |  | Trans Number | Clinical | [NAME]
8 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f114048Minus58164* TRN: [NAME] | 640 | 581.64 |  | Trans Number | Clinical | [NAME]
8 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f114048Minus58164* TRN: [NAME] | 523 |  | 1140.48 | Trans Number | Clinical | [NAME]
9 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of207662Minus105908* TRN: [NAME] | 630 | 1017.54 |  | Trans Number | Clinical | [NAME]
9 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of207662Minus105908* TRN: [NAME] | 640 | 1059.08 |  | Trans Number | Clinical | [NAME]
9 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of207662Minus105908* TRN: [NAME] | 523 |  | 2076.62 | Trans Number | Clinical | [NAME]
10 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf2040092Minus104 0447* TRN: [NAME] | 630 | 9996.45 |  | Trans Number | Clinical | [NAME]
10 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf2040092Minus104 0447* TRN: [NAME] | 640 | 10404.47 |  | Trans Number | Clinical | [NAME]
10 | CREDIT | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf2040092Minus104 0447* TRN: [NAME] | 523 |  | 20400.92 | Trans Number | Clinical | [NAME]