Automated Multi-Step Dext Expense Approval & QuickBooks Sync (Zapier)

Streamline accounts payable with automated approvals and audit-ready data syncing via Zapier.

Tools: Dext → QuickBooks

Platform: Zapier

Short Answer

Users achieve a hands-off document pipeline where small expenses are auto-categorized and synced to QuickBooks, while high-value items are routed for approval, ensuring 100% accurate books with zero manual data entry.

The Problem

Manual entry of receipts and bills leads to human error and delayed financial reporting. While native integrations exist, they lack the granular control needed to filter high-value transactions for approval or verify vendor existence before posting to the General Ledger.

The Outcome

Users achieve a hands-off document pipeline where small expenses are auto-categorized and synced to QuickBooks, while high-value items are routed for approval, ensuring 100% accurate books with zero manual data entry.

Step-by-Step Guide

1. **Authenticate Dext**: Inside Zapier, create a new Zap and select 'Dext' as the Trigger App. Choose 'New Published Item' as the Event. Connect your Dext account and select the specific 'Profile' you wish to monitor. 2. **Test the Trigger**: Click 'Test Trigger' to pull a recent published document. Ensure the sample data includes fields like `Supplier Name`, `Total Amount`, and `Image Link`. 3. **Add Logic (Paths by Zapier)**: Add a 'Paths' step to create conditional logic. Name Path A 'Small Expenses' and Path B 'High-Value Approval'. 4. **Configure Path A (Auto-Sync)**: Set the filter rule: If `Total Amount` is less than 1000. 5. **Find or Create Vendor in QBO**: Within Path A, add a QuickBooks Online (QBO) step: 'Find Vendor'. Use the Dext `Supplier Name` for the search. Check the box 'Create QuickBooks Online Vendor if it doesn't exist yet' and map the Dext `Supplier Name` to the Name field. 6. **Create Expense/Bill in QBO**: Add a second QBO step: 'Create Purchase' (for receipts) or 'Create Bill' (for unpaid invoices). Map the `Vendor ID` from Step 5, the `Date` from Dext, and the `Net/Tax/Total` amounts. Use 'Formatter by Zapier' if the date format needs adjustment. 7. **Configure Path B (Approval)**: Set the filter: If `Total Amount` is greater than or equal to 1000. Add an action like 'Slack: Send Channel Message' with buttons to approve/deny. 8. **Wait for Approval**: Use 'Delay by Zapier' or 'Approval by Zapier' to pause the workflow until a manager gives the green light before proceeding to the QuickBooks steps. 9. **Upload Attachment**: After the QBO transaction is created in either path, add the 'QuickBooks Online: Upload Attachable' action. Map the 'Attachable ID' to the Transaction ID from the previous step and the 'File' field to the Dext `Image URL` or `PDF URL`. 10. **Error Handling**: Click 'Output' on the Zapier step to configure 'Error Handling'. Set up a notification if a Vendor cannot be created or if a Tax Code mismatch occurs.