How does Nance connect to Google Sheets?

Through a secure, scoped connection limited to the spreadsheets you choose. Access is granted per file or folder, and you can revoke it at any time.

Will Nance overwrite our formulas?

No. You designate the tabs or ranges Nance may write to, typically a data tab your own formulas read from. The rest of the sheet stays yours.

Does this replace our accounting system?

No. The ledger remains the source of truth. Sheets is a window onto it: a familiar surface where the figures show up, not where they are kept.

Can the team keep editing the sheets?

Yes. They are still ordinary Google Sheets. Nance updates its part on schedule; everything else, comments, formatting, extra tabs, works exactly as before.

Nance + Google Sheets.

Email, documents & spreadsheets

Your budgets and working files live in Sheets, your actuals live in the ledger. Nance keeps the two in sync, so the sheet everyone looks at is finally the sheet that is right.

Book a demo See how she works

There is a budget sheet somewhere in your Drive, and it is wrong. Not badly wrong, just three weeks stale, because updating it means someone exporting actuals from the accounting system, pasting them in, fixing the categories that never quite match and mailing the result around. So decisions get made on the version from last month, and the person who maintains the sheet has quietly become a human integration.

Nance takes over that job. It reads the budgets and working files you keep in Sheets, pulls the actuals from the ledger and keeps the comparison current, on a schedule, without anyone exporting anything. Your team keeps working in the spreadsheet they already know; the difference is that the numbers in it are now the numbers in your administration.

Why connect Nance to Google Sheets.

The connection and the colleague in one

She reads Google Sheets, applies your rules and does the actual finance work in your accounting system.

Nothing posts outside your rules

You decide what runs automatically and what waits for approval. Every action logged, with the why attached.

One agent across the stack

Payments, commerce, CRM, spend and inboxes: one set of rules and a full audit trail between them.

Up and running in three steps.

Connect
Through the official Google Sheets API, with scoped access. Nothing to install and nothing to migrate.
Set the rules
What she books on her own, what waits for you, who approves. Start anything as a Test Run: a read-only preview first.
She works daily
What arrives in Google Sheets is read, matched and booked in your accounting system. Exceptions come to you with context.

What Nance automates with Google Sheets

Budget versus actuals

Your budget sheet is checked against the ledger and updated with the latest actuals, so the comparison your team relies on stops being a snapshot from whenever someone last had time.

Working files kept current

Cashflow overviews, cost trackers and project sheets are refreshed with live figures from the administration instead of waiting for a manual export.

The end of emailed exports

Nobody downloads a CSV, pastes it into a sheet and mails it around anymore. Nance writes the figures directly into the file the team already shares.

Reporting where the team already works

Management views and department overviews land in a spreadsheet everyone can open, filter and question, instead of a tool only finance logs into.

Sheets as input

Budgets, forecasts and supplier lists you maintain in Sheets are read as context, so Nance knows what a cost line was supposed to be before it judges what it is.

Deviation flagging

When actuals drift from the budget in your sheet, Nance flags it and points to the bookings behind the difference, not just the difference itself.

Access and security

No bank connection, no bank credentials, ever
Her own user account with scoped permissions
Every action logged, visible and attributable
Test Run: read-only preview before anything changes
Hosted on Google Cloud in the EU
Your data never trains AI models

Frequently asked questions

Connect Google Sheets to Exact Online, Twinfield, Moneybird, Xero and QuickBooks

Most Google Sheets connectors are data pipes: they copy fields on a schedule and stop there. Nance is the connection and the colleague in one. It reads Google Sheets, applies your rules and does the actual finance work in your accounting package, with approvals where you want them and every action logged.

Exact Online

Book, reconcile and close inside your Exact Online administration

Twinfield

Automated processing and period checks across Twinfield administrations

Moneybird

Keep your Moneybird books current and VAT-ready, automatically

Xero

Automate invoice processing and reconciliation in Xero

QuickBooks

Bills coded, bank lines matched and debtors chased inside QuickBooks Online

Security is part of the job.

Nance works inside your financial systems, so we treat protecting them as core product work. The live details are public in our trust center.

Encrypted everywhere

AES-256 at rest, TLS in transit.

GDPR compliant

a standard DPA with every plan.

ISO 27001

certification in finalization.

Hosted in the EU

on Google Cloud, by default for everyone.

Never trains AI models

your data stays yours alone.

Payments stay at your bank

Nance prepares the batch, you release it.

Open the trust center →More on security →

✓ Booked 42 purchase invoices✓ Matched €18,430.00 in bank transactions✓ Flagged 1 duplicate from Coolblue✓ Prepared Thursday's payment run✓ Chased 6 overdue invoices✓ Held 1 changed IBAN for review✓ Refreshed the cash dashboard✓ Closed February, clean

✓ Matched €18,430.00 in bank transactions✓ Flagged 1 duplicate from Coolblue✓ Prepared Thursday's payment run✓ Chased 6 overdue invoices✓ Held 1 changed IBAN for review✓ Refreshed the cash dashboard✓ Closed February, clean✓ Booked 42 purchase invoices

✓ Flagged 1 duplicate from Coolblue✓ Prepared Thursday's payment run✓ Chased 6 overdue invoices✓ Held 1 changed IBAN for review✓ Refreshed the cash dashboard✓ Closed February, clean✓ Booked 42 purchase invoices✓ Matched €18,430.00 in bank transactions

✓ Prepared Thursday's payment run✓ Chased 6 overdue invoices✓ Held 1 changed IBAN for review✓ Refreshed the cash dashboard✓ Closed February, clean✓ Booked 42 purchase invoices✓ Matched €18,430.00 in bank transactions✓ Flagged 1 duplicate from Coolblue

✓ Chased 6 overdue invoices✓ Held 1 changed IBAN for review✓ Refreshed the cash dashboard✓ Closed February, clean✓ Booked 42 purchase invoices✓ Matched €18,430.00 in bank transactions✓ Flagged 1 duplicate from Coolblue✓ Prepared Thursday's payment run

✓ Held 1 changed IBAN for review✓ Refreshed the cash dashboard✓ Closed February, clean✓ Booked 42 purchase invoices✓ Matched €18,430.00 in bank transactions✓ Flagged 1 duplicate from Coolblue✓ Prepared Thursday's payment run✓ Chased 6 overdue invoices

✓ Refreshed the cash dashboard✓ Closed February, clean✓ Booked 42 purchase invoices✓ Matched €18,430.00 in bank transactions✓ Flagged 1 duplicate from Coolblue✓ Prepared Thursday's payment run✓ Chased 6 overdue invoices✓ Held 1 changed IBAN for review

✓ Closed February, clean✓ Booked 42 purchase invoices✓ Matched €18,430.00 in bank transactions✓ Flagged 1 duplicate from Coolblue✓ Prepared Thursday's payment run✓ Chased 6 overdue invoices✓ Held 1 changed IBAN for review✓ Refreshed the cash dashboard

Hire Nance.

Connected to Google Sheets in an afternoon, and we walk you through it.

Book a demo See pricing