---
title: "Automate invoice creation"
description: "Design a controlled Google Sheets, Zapier, and Zoho Books invoice workflow with financial-data safeguards."
canonical: https://docs.ordering.co/docs/products/dashboard/reports/invoice-manager/automate-invoices/
---

# Automate invoice creation

This external workflow uses an order export in Google Sheets, a scheduled Zapier workflow and Zoho Books to prepare a sales invoice. In Dashboard, [Invoice manager](https://docs.ordering.co/docs/products/dashboard/reports/invoice-manager/) generates PDFs from selected orders. In this workflow, Zoho Books creates the accounting record. Have the finance and integration owners approve the data, mapping and test before activation.

> **Protect financial data**
>
> The workflow can expose business legal names, order totals, fees, discounts, tips, tax, and invoice data to Google Sheets, Zapier, and Zoho Books. A scheduled run can create accounting records. Use non-production data and provider test environments until an authorized owner has defined the scope, credentials, retention, rollback, and reconciliation process.

## Design the input sheet

Start with an approved order export. Follow [Export orders](https://docs.ordering.co/docs/products/dashboard/orders/export-orders/) for the Dashboard export procedure, then check that the file contains the fields and date range needed for the accounting period. In Google Sheets, keep the source export separate from the **Monthly Totals** tab. Include the business ID, approved legal name, accounting period, currency and only the totals your finance team needs.

### Use formulas only after confirming the sheet schema

Use explicit dates for the closed period so a retry uses the same reporting window. In this example, `Global History` has business ID in column D, subtotal in F and order date or timestamp in L. In **Monthly Totals**, `A2` contains the business ID, `J1` contains the inclusive period start and `J2` contains the exclusive period end. Enter real dates in both cells and use the same time zone as the export.

```excel
=SUMIFS('Global History'!F:F, 'Global History'!$D:$D, $A2, 'Global History'!$L:$L, ">="&$J$1, 'Global History'!$L:$L, "<"&$J$2)
```

For example, set the start to April 1 and the end to May 1 to include April orders. Adapt the column references to the export and reconcile the total before using it in an accounting action. [Google Sheets SUMIFS reference](https://support.google.com/docs/answer/3238496)

## Configure the scheduled workflow

Set the monthly Zapier trigger for a time after the approved export is complete. The schedule uses the Zapier account time zone and can run a few minutes after the selected time. Look up the row for the exact business ID and closed period. Stop the run if the lookup returns no row, multiple rows, or an unapproved total. [Schedule by Zapier documentation](https://help.zapier.com/hc/en-us/articles/8496288648461-Schedule-Zap-workflows-to-run-at-specific-intervals)

## Create the accounting record

For a controlled test, map the approved row to the intended Zoho Books organization, customer and line items using Zapier’s **Create Sales Invoice** action. Verify the exact customer match, quantities, rates and taxes with the accounting owner. Keep **Send** disabled during the test. Confirm the resulting record separately from delivery and payment. [Zoho Books actions in Zapier](https://zapier.com/apps/zoho-books/integrations) · [Zoho Books invoice operations](https://www.zoho.com/books/api/v3/invoices/)

## Review before activation

1. Confirm the order export, business IDs, legal names, period cutoff, currency, and formula inputs.
2. Confirm the Zapier trigger, Google Sheets lookup, Zoho Books organization, customer match, and line-item mapping in a controlled test.
3. Define duplicate prevention, retry behavior, error handling, record retention, and reconciliation with the accounting owner.
4. Verify the document’s legal text, taxes, totals, recipient, and approval process before any customer or business receives it.
5. Keep credentials, API keys, exported orders, and accounting records out of support tickets, screenshots, shared notes, and this documentation.

**Related guides:** [Invoice manager](https://docs.ordering.co/docs/products/dashboard/reports/invoice-manager/) · [Manage business invoices](https://docs.ordering.co/docs/products/dashboard/reports/invoice-manager/business-invoices/)