Automate Chase Business Transactions to QuickBooks Online (Zapier)

1. **Authenticate Chase via Plaid**: Create a new Zap and select 'Plaid' as the Trigger app. Connect your Chase Business account using the secure OAuth popup. Choose the 'New Transaction' trigger. 2. **Configure Trigger Options**: Select the specific Chase account (e.g., Checking or Credit Card) to monitor. Ensure 'Include Pending Transactions' is set to 'False' to prevent duplicate entries before transactions clear. 3. **Sanitize Data with Formatter**: Add a 'Formatter by Zapier' step. Choose 'Text' and the 'Replace' transform. Use this to remove messy strings like 'SQ *' or 'VZWRLSS' from the 'Transaction Description' to make vendor matching easier. 4. **Add a Filter Step**: Use 'Filter by Zapier' to ensure only transactions above $0.00 (or specific types) proceed. This prevents 'Bank Fees' or small interest payments from cluttering your books if you prefer to handle those manually. 5. **Branching with Paths**: Add a 'Paths by Zapier' step. Set Path A for 'Income' (where Amount is positive) and Path B for 'Expenses' (where Amount is negative). 6. **Map Income (Path A)**: Select 'QuickBooks Online' as the Action app. Choose 'Create Sales Receipt'. Map the 'Transaction Date' and the cleaned 'Description' to the Memo field. 7. **Map Expenses (Path B)**: Select 'QuickBooks Online' and choose 'Create Expense'. Use the absolute value of the amount (using Formatter if necessary) since QBO expects positive numbers for expense entries. 8. **Setup Account Mapping**: In the QBO step, hardcode the 'Bank Account' field to match your Chase account in your Chart of Accounts. Use 'Find Vendor' as a search step before the Create step to link the transaction to an existing profile. 9. **Enable Error Handling**: Click the three dots on the QuickBooks action step and select 'Always continue even if this step fails' to ensure one failed transaction doesn't stop the entire Zap. Pair this with a 'Digest by Zapier' to receive a nightly report of any failures.