Library / Finance, Invoices & Accounting
Finance, Invoices & Accounting
Create QuickBooks invoices from won HubSpot deals with Slack alerts
On a schedule, it processes financial data using HubSpot, Quickbooks, Slack.
What it does
## Create QuickBooks invoices from won HubSpot deals with Slack alerts ### How it works Every hour Find Won Deals Without Invoice pulls HubSpot deals in your won stage with no quickbooks_invoice_number yet. For each deal it reads the contact and line items, finds the QuickBooks customer by email or creates one, and creates an invoice with one line per HubSpot line item. The invoice number is saved on the deal, so a deal is never billed twice. Invoices up to autoSendLimit are emailed by QuickBooks, bigger ones wait for finance. Deals without a contact email, and any failed step, are posted to Slack. ### Setup 1. Credentials: HubSpot App Token (private app with deals, contacts and line items read, deals write), QuickBooks Online OAuth2, Slack 2. In HubSpot add a single-line text deal property with internal name quickbooks_invoice_number 3. In Workflow Configuration set wonDealStage, startFromCloseDate, hubspotPortalId, quickbooksCompanyId, quickbooksApiUrl and quickbooksAppUrl (sandbox or live), defaultItemId, paymentTermsDays, autoSendInvoices, autoSendLimit, slackChannel, invoiceMemo 4. Test with a QuickBooks sandbox: mark a test deal with a contact and two line items as won, run Check Every Hour manually. Expected: a two-line invoice in QuickBooks, its number on the deal and a Slack message 5. Activate ### Customization tips The sample Slack messages and memo are a starting point, not a fixed format. - Post Invoice Sent to Slack, Ask Finance to Review Invoice, Ask Sales to Add a Contact, Alert Finance About Failed Deal: message text - Build Invoice: line mapping and due date - Check Every Hour: schedule - autoSendLimit: review threshold
The steps
- Check Every Hour
- Workflow Configuration
- Find Won Deals Without Invoice
- Keep New Deals With Amount
- Get Deal Contacts and Line Items
- Loop Over Deals
- Get Deal Contact
- Contact Has Email?
- Get Line Item Details
- Flag Deal as Missing Contact
- Ask Sales to Add a Contact
- Find Customer by Email
- Customer Already in QuickBooks?
- Build Invoice
22 steps in total.
Similar automations
Finance, Invoices & AccountingCreate freee請求書 invoice drafts from won HubSpot deals with Slack updates19 stepsCRM & Sales PipelineCreate Line Items from Won HubSpot Deals for Slack54 stepsFinance, Invoices & AccountingRun QuickBooks Actions from a Manual Trigger5 stepsFinance, Invoices & AccountingCreate QuickBooks Invoices from Labeled Gmail with GPT-4o12 steps