Turn a multi-invoice EDI message into a spreadsheet
At a glance
A commenter used ChatGPT to turn a D.96A invoice message into an Excel report, correcting its interpretation along the way. This workflow is listed under Invoices, Spreadsheets.
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Open the ChatGPT web interface and upload the D.96A INVOIC text message containing the invoices. Ask it to analyze the message. 2) Check how many invoices it found. In the author’s case it parsed only the first; they told it the file contained 27, identified `MOA+77` as the invoice amount and explained that `BGM+381` marked invoice 19 as a credit note. 3) Request a detailed Excel report including all line items, initially with one worksheet per invoice. Then request a variant with all 27 invoices in one sheet and a column for the invoice or credit-note number. 4) Ask for a second sheet summarizing each invoice with a separate column for each MOA code. Inspect the generated workbook against the source and correct interpretation errors.
How it went
The commenter reported receiving an Excel file after correcting several code-interpretation mistakes. Their description of the final worksheet arrangement is ambiguous, so the exact final layout is not established.