Excel Invoice Rows to QuickBooks

Raise QuickBooks invoices from rows in an Excel billing sheet, saving finance from typing the same figures twice.

Sign in with your Edesy account; the setup wizard opens on this template.

Category

Sales & CRM

Type

App automation

Steps

2

Apps

Microsoft Excel, QuickBooks

Level

Beginner, about 9 min to set up

How the workflow runs

Choose the workbook and worksheet (A: invoice number, B: customer, C: amount, E: billing e-mail, F: phone). Each row creates the customer in QuickBooks and then an invoice for the amount. If your customers already exist in QuickBooks, remove the first step and put the QuickBooks customer id in a column instead to avoid duplicates.

App trigger · Microsoft ExcelExcel: new rowApp action · QuickBooksQuickBooks: create customerApp action · QuickBooksQuickBooks: create invoice

Steps in order

  1. 1

    Excel: new row

    Starts the workflow · Microsoft Excel

  2. 2

    QuickBooks: create customer

    App action · QuickBooks

  3. 3

    QuickBooks: create invoice

    App action · QuickBooks

Apps it connects

  • Microsoft Excel
  • QuickBooks

Excel Invoice Rows to QuickBooks: questions

You sign in to Edesy Flow with your Edesy account and the template wizard opens: map each role to a person, pick the app connections it needs, and Flow creates the forms and the workflow for you to edit.

Yes. The workflow opens in the visual builder, where you can add, remove or reorder steps, change who approves, edit the e-mails and add branches.

Related templates