Skip to content
DuckHouse

For auto repair shops

Keep the bays full.
And the invoices paid.

Estimates, invoices and parts bills already live in QuickBooks, and if your shop software can export to CSV, DuckHouse can load that too. It brings them together and keeps them current, so you can see which work wins, who owes you, and who is due back.

Get started How it works

Works with QuickBooks Online, SFTP / FTP and Google Sheets.

A mechanic at a workbench in a small garage, beside a car lift and spare wheels.

Which customers haven’t had an invoice since April?

Read quickbooks.invoices, quickbooks.customers

38 customers haven’t had an invoice since April. The ones who spent the most in the year before:

D. OkaforMar 28$2,140
Hillside FloristMar 14$1,860
S. PatelFeb 9$1,415
M. RuizMar 3$1,290

and 34 more

An example answer. The business and its numbers are made up.

Questions you can answer

The things you’ve always wanted to know.

Each of these comes from data your tools already have. DuckHouse puts it side by side.

“How many estimates turn into work, and how quickly?”

QuickBooks estimates, their status and accepted dates, against the invoices that followed.

QuickBooks Online

“Who hasn’t been in for six months and is due a service?”

Each customer’s last QuickBooks invoice.

QuickBooks Online

“Who owes me, and for how long?”

Open balances and due dates on QuickBooks invoices.

QuickBooks Online

“What’s my average ticket, by month and by kind of job?”

QuickBooks invoices and the items on them.

QuickBooks Online

“What am I spending with each parts supplier?”

QuickBooks bills by vendor, month by month.

QuickBooks Online

How it works

Three steps, no data team.

You keep using the tools you have. DuckHouse gathers what they know.

  1. 1. Create a database

    It runs on its own machine with its own storage. There is nothing to install.

  2. 2. Connect your tools

    Sign in or paste a key for each one. DuckHouse only reads from them, brings in your history, then keeps up, as often as every 5 minutes for SFTP / FTP.

  3. 3. Ask in plain English

    Connect Claude or ChatGPT to DuckHouse and ask: “Which customers haven’t had an invoice since April?” It looks in your data and answers. How to connect an assistant.

What it connects

The tools you already use.

What DuckHouse brings in from each, and how you connect it.

QuickBooks Online

Estimates and whether they were accepted, invoices and payments, customers, and parts bills by supplier.

Sign in with your Intuit account. New data comes in as often as every hour.

How to connect QuickBooks Online

SFTP / FTP

CSV exports from your shop management software: repair orders, vehicles or technician hours, if it can save them to a folder.

Point it at the folder your software exports CSV files to. New data comes in as often as every 5 minutes.

How to connect SFTP / FTP

Google Sheets

A bay schedule, a list of fleet accounts or anything else kept in a sheet.

Share the sheet with DuckHouse. Every tab becomes a table. New data comes in as often as every 15 minutes.

How to connect Google Sheets

An example

A two-bay shop

A made-up example, not a customer.

  1. 1

    The owner signs in to QuickBooks from DuckHouse, and sets the shop software to export repair orders to a folder each night.

  2. 2

    On Friday they ask ChatGPT which estimates from the last month are still open, and call those customers back.

  3. 3

    Each month they ask who is past due a service, from the date of everyone’s last invoice.

Greasy hands holding a wrench over a car engine.
Photos by Kato Blackmore and Christian Buehner on Unsplash.

What it costs

Pay for the hours it runs.

The smallest database is $0.0117 an hour while it runs. Left on all month with its 10 GB disk, it comes to $10.80. Set it to stop when idle and you pay for the hours it is awake, plus the disk. Data kept in object storage is $0.02 per GB a month.

Every sync wakes the database, so one synced every 15 minutes is awake most of the day. Syncing every hour, or once a day, lets it sleep in between, and you can change that per connection whenever you like.

See full pricing

Questions

Before you start.

Do I need to know SQL?
No. Connect Claude or ChatGPT to DuckHouse and ask in plain English; it writes the query and shows you the answer. If you or your bookkeeper know SQL, the dashboard has a query console too.
Will DuckHouse change anything in my other tools?
No. Connections only read. DuckHouse copies your data into your own database and never writes back to Square, QuickBooks, Shopify, Stripe or anything else.
Who can see my data?
Your database runs on its own machine with its own storage, and only people you invite to your organization can open it. AI assistants reach it only after someone in your organization signs them in, and they can only read unless you allow more.
Can my bookkeeper or manager use it too?
Yes. Invite them to your organization and they can ask questions of the same data.
What if my software isn’t listed?
Most business software can export CSV files. Save them to an SFTP or FTP folder and DuckHouse loads them on a schedule, or keep the data in a Google Sheet. PostgreSQL and MySQL databases connect directly.
What does it cost?
The smallest database is $0.0117 an hour while it runs. Left on all month with its 10 GB disk, it comes to $10.80. Set it to stop when idle and you pay for the hours it is awake, plus the disk. Data kept in object storage is $0.02 per GB a month. There are no contracts or minimums.

Put your numbers in one place.

No contracts and no minimums. Connect the tools you use, and stop the database whenever you like.

Get started Other businesses