Invoices reconciled against your bank statement in one run

The scenario merges the invoices and the statement from Microsoft Excel 365, AI finds the matches, and the result is filed onto sheets: matched, uncertain, unpaired.

  • Merges invoices and the statement from Microsoft Excel 365
  • AI finds the matches instead of your eyes
  • Files them as matched, uncertain or unpaired
  • Builds the final summary
Set it up for yourselfScriptera

How it works

To move data from Microsoft Excel 365 to automatically, use a ready-made scenario — no manual exports.

  1. Starts when: When clicking ‘Execute workflow’
  2. Then: Invoice Data
  3. Check: Merge
  4. Then: Combine and Label Merged Data
  5. Then: Process the Invoice Vs Bank Statement Data1
  6. Then: Clean and Format Data
  7. Then: Add Stream Label Filter
  8. Check: Switch
  9. If yes: Matched
  10. If no: If
  11. If yes: Unmatched_Invoice
  12. If no: Unmatched-Bank Transaction
  13. If no: Summary
  14. If no: Possible Matches
  15. Then: Bank Statements
  16. Then: OpenAI Chat Model

You can launch this integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios