What you will build on BILL
Each is one formula on live data. These are examples of the syntax: the column names will follow BILL's own fields once the integration ships.
=data.transactions.sum(amount, department, A2) =data.transactions.count(id, receipt, "missing") =data.transactions.sum(amount, merchant, A2) Tables from BILL
Card transactions · Bills · Reimbursements · Departments · Merchants
Your data stays in BILL
You will sign in with your BILL account and give Sheets read access. Sheets runs on our servers in the EU and reads your data through BILL's API when a sheet opens or refreshes.
Vote for Sheets for BILL
A thumbs up moves BILL up the roadmap. Leave your e-mail address too and we write once, when it ships.
Questions
Is Sheets for BILL available?
Not yet. BILL is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.
What will Sheets read from BILL?
Your transactions, bills and reimbursements, as tables: Card transactions, Bills, Reimbursements, Departments, and Merchants. Each table becomes a data source that formulas, pivot tables and charts read live.
Will Sheets change anything in BILL?
It is planned read-only: Sheets reads your BILL data and does not change it.
What works today?
Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.
Want Sheets for BILL?
Requests decide what we build next. We write once, when it is ready.
85 tools on the integrations page