MIP Toolbox
GRFD PNC CC
GRFD PNC CC
Upload a Cash Requirements file. The tool duplicates the dataset (row 8 through the first blank in column L), gives each original line and its reversed line the same document number, then writes the document number (column R), a combined name (column S), and your Session ID (column T) into the empty columns to the right, and sorts so every +amount/−amount pair sits together.
Cash Requirements File
The source file with transaction data beginning on row 8. Rows 1–7 are preserved unchanged. XLSX, XLS, or CSV.
Drop file here
or click to browse
Session Settings
Written to column T (the empty column to the right of the data) on every transaction row.