Automate expense reporting from Airtable to QuickBooks

This n8n template from [Intuz](https://www.intuz.com/) provides a complete solution to automate your expense approval and accounting process.

It seamlessly connects an Airtable base, where expenses are submitted, to your QuickBooks account, eliminating manual data entry and ensuring financial records are always up-to-date.

Who's this workflow for? - Accountants & Bookkeepers - Small Business Owners - Finance Teams - Operations Managers

How it works 1. Trigger on New Expense: The workflow starts automatically when a new expense record is added to your Airtable base.

2. Filter for Approval: It checks if the expense's Status field is marked as "Approved". Unapproved items are ignored.

3. Create Expense in QuickBooks: For every approved item, the workflow creates a new expense record in QuickBooks, mapping data like amount, date, vendor, and accounts directly from Airtable.

4. Download and Upload Receipt: It downloads the receipt from the URL provided in Airtable and uploads it as an attachment to the corresponding expense record in QuickBooks.

5. Update Airtable Status: Once the expense and receipt are successfully logged in QuickBooks, the workflow updates the record's Status in Airtable to "Done", closing the loop.