You have chosen to sponsor your bid up to a maximum amount of .
We have an existing VBA script for Microsoft Excel that processes a CSV input and produces an Excel file as output. However, the format of the CSV has changed slightly, and we'd like the script to account for those changes. (The CSV file is produced by Squareup.com, which recently changed a few details.)
1. Currently the script tallies "Card - Swiped" transactions; we'd like for it to also account for "Card - Keyed" transactions (which are just credit card transactions that had to be manually keyed in at the point-of-sale -- there's no difference in any other way).
2. Squareup.com added a new column after "subtotal" (they added "discount"), which pushes everything over a column.
3. Finally, cash transactions are no longer identified by the "Payment Method" column. Instead, they're only identified in the "Payment Type" field.
The script and new sample CSV files are attached.
New sample CSV files attached as ZIP