Skip to content
DuckHouse

For bars and taprooms

See which nights really pay.
Drinks, staff and promos included.

Square knows what you poured and who rang it up. QuickBooks knows what the distributors charged. Your ads know what you spent on trivia night. DuckHouse lines them up so you can see what each night, offer and shift is worth.

Get started How it works

Works with Square, QuickBooks Online, Meta Ads and Google Sheets.

A glass of beer being filled at the taps of a busy bar.

How did happy hour discounts compare with sales from 4 to 7pm last month?

Read square.orders

From 4 to 7pm last month you took $18,420 and gave back $2,310 in happy hour discounts, 12.5%. It costs most early in the week. Share of those sales, by day:

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.

“Does happy hour bring in more than it gives away?”

Discounts on Square orders, against sales in the same hours on other days.

Square

“Who sells the most per hour on shift, tips included?”

Square payments and tips by team member, over the hours on their timecards.

Square

“What do I spend with each distributor, against what that category sells?”

QuickBooks bills by vendor, beside Square sales by menu category.

QuickBooks OnlineSquare

“Did the trivia night ads bring people in?”

Daily ad spend from Meta, against Square sales on the nights they ran.

Meta AdsSquare

“Which nights are worth a second bartender?”

Orders by hour, beside how many people were on the clock.

Square

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 15 minutes for Square.

  3. 3. Ask in plain English

    Connect Claude or ChatGPT to DuckHouse and ask: “How did happy hour discounts compare with sales from 4 to 7pm last month?” 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.

Square

Every order with its discounts, payments and tips by bartender, timecards, and your drink menu by category.

Paste an access token from Square’s Developer Console. New data comes in as often as every 15 minutes.

How to connect Square

QuickBooks Online

Bills and payments to your distributors and suppliers.

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

How to connect QuickBooks Online

Meta Ads

What each Facebook and Instagram campaign cost, by day.

Paste a system user token from Meta’s Business Settings that can read your ads. New data comes in as often as every hour.

How to connect Meta Ads

Google Sheets

Event calendars, keg logs or anything else you track by hand.

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 neighbourhood taproom

A made-up example, not a customer.

  1. 1

    The owner connects Square and QuickBooks, then Meta Ads. Square syncs every 15 minutes; QuickBooks and Meta every hour.

  2. 2

    Before reordering, they ask which taps sold through fastest last month, and what those kegs cost from the distributor’s bills.

  3. 3

    After a slow Wednesday, they ask whether the event ads that week cost more than the extra sales they brought.

A row of brass beer taps behind a bar.
Photos by Amie Johnson and Lucas Santos 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