# Monthly Deel contractor invoice ledger in Google Sheets

> On the first business day of each month, log every Deel contractor invoice from the previous month to a Google Sheets ledger for finance reconciliation.

- Workflow type: code
- Services: Deel, Google Sheets
- Categories: Finance, Operations
- Published: 2026-07-17

## What it does

- Runs automatically on the first business day of each month, no button-pushing required.
- Pulls every contractor invoice Deel issued during the previous calendar month.
- Appends one row per invoice to a Google Sheets ledger you already own, so nothing gets overwritten.
- Captures the fields finance actually reconciles against: invoice ID, contractor name, contract, country, currency, gross amount, status, and issue date.

## What you'll need

- A Deel account with permission to view contractor invoices
- A Google account with edit access to the destination spreadsheet
- The Google Sheets spreadsheet ID and the tab name where the ledger lives

## Prompt

On the first business day of every month, pull the previous month's contractor invoices from Deel and append every invoice as a new row to a Google Sheets ledger so finance has a single source of truth for reconciliation.

Trigger: cron, scheduled to fire on the 1st business day of each calendar month in the account's timezone. When it fires, compute the date range for the previous full calendar month (first day 00:00:00 through last day 23:59:59) so the workflow always exports a clean, closed month regardless of exactly when it runs.

Step 1: Call Deel's Retrieve Invoices to list every contractor invoice issued during that previous-month window. Page through results if the response is paginated so no invoices are missed. Filter to invoices where the issue date falls inside the target window.

Step 2: For each invoice, build a row in this fixed column order: invoice ID, contractor name, contract ID, country, currency, gross amount, status, issue date. Format the issue date as YYYY-MM-DD and keep the gross amount as a plain number (no currency symbol) so the sheet stays sortable and formula-friendly.

Step 3: Call Google Sheets' Append Values once with all rows for the month, targeting the user-supplied spreadsheet ID and sheet tab. Append after the last populated row so existing history and any manual columns stay intact. If the month had zero invoices, skip the append and finish silently.

The author should expose three inputs to the user: the destination Google Sheets spreadsheet ID, the sheet tab name (e.g. "Contractor Invoices"), and the monthly run day (default: 1st business day of the month). The workflow is deterministic — no drafting, no judgement, no LLM calls. Every step is a known operation on structured data.

## How to customize

- Change the run day to match your finance close calendar (default: the 1st business day of the month).
- Point at a different spreadsheet or a new tab per year if you want clean annual archives.
- Add extra columns like approver, payment method, or internal cost center by updating the row template.

## FAQ

### Does this replace an accounting integration like Xero or QuickBooks?

No. It is the lightweight equivalent for teams that do not have a full accounting sync wired into Deel. Finance still gets a single source of truth to reconcile against, without the setup cost of a formal integration.

### Which invoices get logged each month?

Every contractor invoice Deel issued during the previous calendar month. Each one lands as its own row with the invoice ID, contractor name, contract, country, currency, gross amount, status, and issue date.

### What happens if the previous month had no invoices?

The workflow simply adds nothing to the sheet and finishes silently. The ledger stays exactly as it was, no empty rows and no error emails.

### Can I run it more often than once a month?

Yes. You can switch it to weekly or even daily if you want the ledger closer to real time. Monthly is the default because it lines up with most finance close cadences.

### Will it ever overwrite rows I have already added to the sheet?

No. It always appends after the last row, so any manual notes, formulas, or historical data you added by hand stays untouched.

Use this prompt in General Input: https://www.generalinput.com/prompts/monthly-deel-contractor-invoice-ledger-in-google-sheets