Integrations / Finance
Square logo

Connect Square to Silo

Square runs your farm gate, market stall or cellar door. Connect it and we sync your orders, payments, customers, catalogue and stock into your warehouse so direct sales sit alongside production and the rest of your books.

Book a demo

What we sync from Square

Silo brings your Square records into your warehouse so you can report on them alongside the rest of your operation.

Orders

One row per order

Every transaction with its line items, location and fulfilment state.

DateTotalLine itemsLocationState

Payments

One row per payment

What was taken, how, and what the processor kept.

AmountProcessing feePayment methodStatusRefunded amount

Refunds

One row per refund

Refunded transactions with reasons and linked payments.

PaymentAmountReasonDate

Customers

One row per customer

Contact details, lifetime spend and visit history.

EmailTotal spentVisit countCreated

Customer groups

One row per group

The segments you sell to.

NameCreated

Catalogue items

One row per item

Products with variations, pricing and categories.

NameVariationsCategoryItem data

Inventory

One row per item per location

Stock on hand and how it moves between locations.

ItemLocationQuantityStateCalculated at

Invoices

One row per invoice

Invoiced sales, payment schedules and collection status.

Invoice numberCustomerPayment requestsStatusDate

Works well with Square

Connect these alongside Square to get a complete picture of the whole operation.

How it works

Connect Square once and Silo handles the rest, from sync to dashboards.

1

Connect your data

Securely connect Square and Silo syncs your records into your own managed warehouse, automatically.

2

Ask in plain English

Ask Aggie questions about the operation the way you'd ask a colleague: no formulas, no SQL, no spreadsheets.

3

Get instant dashboards

Get back charts and reports you can save, share and revisit as your data keeps syncing in the background.

Questions & answers

What Square data gets synced?

Your orders, payments, refunds, customers and groups, catalogue items, inventory and invoices, brought into your own managed warehouse, automatically.

How far back does it go?

We sync your full Square history, so you can compare seasons and track customer behaviour over years, not just the current month.

Can I connect more than one location?

Yes. We sync every location on your Square account, so you can compare the farm gate, the market stall and the cellar door side by side.

Where is my data stored?

In a dedicated database stored in Australia that only your operation can access, protected with enterprise-grade encryption.

Do I need to be technical to use Silo?

No. Ask Aggie questions in plain English and get back charts and reports, with no formulas, SQL or spreadsheets required.

How often does my data sync?

Automatically, every day. Connect Square once and Silo keeps everything up to date in the background.

Can I try Silo before committing?

Book a demo and we'll show you exactly what your Square data looks like through Silo.

Ready to connect Square?

Book a demo and we'll show you exactly what your Square data looks like through Silo.

Book a demo