Expenses from a sheet into accounting, verified and stamped with transaction IDs
The scenario pulls expense accounts and vendors into your sheet, creates new vendors, books the expenses into accounting, and writes back the transaction IDs — or the reason a booking failed.
You work in the sheet you already use, not in an awkward accounting form
Accounts and vendors are pulled in as lists, so names never drift
The transaction ID is written back, so no expense is booked twice