# How to Bulk Create Invoices for Amazon Customers in Google Sheets (https://sellersheetai.com/guides/bulk-create-invoices-for-amazon-customers-in-google-sheets)

> Generate VAT invoices or receipts for your Amazon customers in bulk, straight from your synced order data in Google Sheets, with your own branding and tax details.





Generating professional invoices for Amazon customers can be a time-consuming manual task. SellerSheet automates the whole process: you create VAT invoices or receipts in bulk, directly from your synced order data in Google Sheets.

## Step 1: Configure store information [#step-1-configure-store-information]

Before generating invoices, set up your business branding and tax details in the **Store Info** sheet of the SellerSheet Sales spreadsheet. This data fills your invoice headers.

| Column        | Type     | Description                                                | Sample          |
| ------------- | -------- | ---------------------------------------------------------- | --------------- |
| StoreName     | Required | Primary identifier. Must match a connected store.          | myStore-AE      |
| Company       | Required | Legal entity name for the invoice header.                  | The Company LLC |
| TRN / TaxRate | Optional | If empty, a receipt is generated instead of a VAT invoice. | 123… / 5%       |

### Invoice type logic [#invoice-type-logic]

SellerSheet uses the presence of **TRN** and **TaxRate** to decide the invoice type:

* **RECEIPT (REC):** created if TRN or TaxRate is missing.
* **VAT INVOICE (INV):** created only if **both** TRN and TaxRate are provided.

\[\[TODO: screenshot Store Info sheet configuration (retake — the old one showed real store data)]]

## Step 2: Generate bulk invoices [#step-2-generate-bulk-invoices]

Once your store information is configured, generate invoices by providing order and customer details in the **Invoices** sheet.

### Invoice prerequisites [#invoice-prerequisites]

* **Store match:** the store in the **Store** column must exist in the **Store Info** sheet.
* **Order match:** the **Amazon Order ID** must already exist in your **Orders** sheet (synced from the Sales panel — see [How to Sync Amazon Orders](/guides/sync-amazon-orders-to-your-google-sheets)).
* **Shipped orders:** the order must be shipped.

### Filling customer data [#filling-customer-data]

Fill in these columns for each order you want to invoice:

* **Customer Name:** the name that appears on the invoice.
* **Customer TRN:** required for VAT invoices only.
* **Customer Address:** ship-to or billing address.
* **Invoice Time:** optional. If left blank, the current time is used.

### Triggering creation [#triggering-creation]

1. Go to the **Sales** panel in the SellerSheet sidebar.
2. In the **Invoices** dropdown, click **Create Invoices**.

SellerSheet goes through the active sheet and generates a PDF invoice in Google Drive for every valid row.

<img alt="Create Invoices button on the Sales panel" src="__img0" />

\[\[TODO: screenshot Invoices sheet populated with orders ready for bulk invoicing (retake — the old one showed real store data)]]

### Automation results [#automation-results]

* **Auto-populated links:** once created, the **Invoice Link** and **Invoice Folder** columns fill in automatically.
* **Folder logic:** invoices are stored in a nested structure, `SellerSheet/{Store}/{Marketplace}/{Year}/{Month}` (for example `SellerSheet/myStore/AE/2025/07`).

### Limits and scope [#limits-and-scope]

* **Runtime limits:** Google Sheets sidebars have a standard execution limit. If you have hundreds of invoices and the process stops, click **Create Invoices** again to resume.
* **Active sheet scope:** the action only processes the sheet you are currently viewing.
* **Skipping logic:** if an **Invoice Link** already exists for a row, SellerSheet skips it to prevent duplicates.

<Callout title="Pro tip: resuming tasks">
  If invoicing times out because of Google's limits, your progress is saved. Click the button again — it picks up where it left off by skipping rows that already have links.
</Callout>

## Conclusion [#conclusion]

With SellerSheet's bulk invoicing, you keep professional communication with your customers while your tax paperwork runs on its own. Every button of the panel is listed on [Sales](/help/sheets/sellers/sales).