Square

Square provides various solutions to run your business by offering financial services, hardware for contactless payments, and even point of sales system.

Sync Square data to Sourcetable

Build reports once. Connect to Square and start modeling from live data.

Popular Use Cases

Square connector Sourcetable connector
Analyze paying customers using Square transactions data
Square + Sourcetable
Square connector Sourcetable connector
Automate daily revenue reports using Square transactions data
Square + Sourcetable
Square connector Sourcetable connector
Analyze Square data to create models and revenue forecasts
Square + Sourcetable
Square connector Mailchimp connector
Determine the impact of Mailchimp newsletter marketing on customer purchases
Square + Mailchimp
Square connector Sourcetable connector
Create customer lists to combine with other data sets
Square + Sourcetable
Here's a sample of the Square data that will be available in your Sourcetable spreadsheets:
ADDITIONAL_RECIPIENT_RECEIVABLE

Contains transaction, location, amount money and created at fields

ADDITIONAL_RECIPIENT_RECEIVABLE_REFUND

Contains information of additional receipient receivable, refund, location, and amount money

ADDITIONAL_RECIPIENT_REFUND

Contains information of refund, location, amount money, description and additional recipient receivable

BREAK_TYPE

Contains location, break name, expected duration, is paid , version and timestamps of created at and updated at

CARD

Contains card type, brand, last4, expiration month, year, cardholder name, billing address, prepaid type and fingerprint

CARD_PAYMENT_DETAILS

Contains payment information, card information, application cryptogram, identifier, and name, cvv status, avs status, device details, entry method, statement description, status, verification method and results

CATALOG_CATEGORY

Contains catalog object id and name

CATALOG_DISCOUNT

Contains catalog object id, name, discount type, percentage, amount money, pin required, label color

CATALOG_ITEM

Contains catalog object, name, description, abbrevation, label color, available online, available for pickup, available electronically, image url, product type, skip modifier screen

CATALOG_ITEM_MODIFIER_LIST_INFO

Contains catalog item, catalog modifier list, min selected modifier, max selected modifier, and enabled

CATALOG_ITEM_MODIFIER_OVERRIDE

Contains catalog item, catalog modifier list, catalog modifier, and on by default

CATALOG_ITEM_TAX

Contains association of catalog item and catalog tax

CATALOG_ITEM_VARIATION

Contains category item, name, sku, upc, ordinal, pricing type, price money, track inventory, inventory alert type and threshold, user data and service duration

CATALOG_LOCATION

Contains association of catalog object and location along with fields of present and absent

CATALOG_MODIFIER

Contains catalog object, price money and name

CATALOG_MODIFIER_IN_CATALOG_MODIFIER_LIST

Contains association of catalog modifier and catalog modifier list

CATALOG_MODIFIER_LIST

Contains catalog object, name and selection type

CATALOG_OBJECT

Contains type, version, is deleted, catalog v1 ids, present at all locations, present at location ids, absent at location ids

CATALOG_TAX

Contains catalog object, calculation phase, name, inclusion type, percentage, enabled, applies to custom amounts

CUSTOMER

Contains family name, given name, nickname, email address, address, phone number, birthday, reference id, note, creation source

CUSTOMER_CARD

Contains associations of customer and card

CUSTOMER_GROUP_ASSOCIATION

Contains associations of customer and group info

CUSTOMER_GROUP_INFO

Contains id and name

EMPLOYEE

Contains first name, last name, id and timestamps of created at and updated at

EMPLOYEE_LOCATION

Contains associations of employee and location

EMPLOYEE_WAGE

Contains employee, title and hourly wage

INVENTORY_COUNT_HISTORY

Contains catalog object, location, calculated at, catalog object type, state and quantity

ITEM_VARIATION_LOCATION_OVERRIDE

Contains catalog item variation, item name, location, price money, price type, track inventory, inventory alert type and threshold

LOCATION

Contains name, address, capabilities, timezone, status, country, merchant id, currency, phone, business name, type, website url

ORDER

Contains customer, location, reference id, order source name, closed at, state, return amount, net amount, total money, total tax money, total discount money and service charge money

ORDER_FULFILLMENT

Contains uid, order id, catalog object id, type, state, pickup details

ORDER_LINE_ITEM

Contains uid, order id, catalog object id, name, quantity, note, variation name, base price money, gross sales money, total tax money, total money, and total discount money

ORDER_LINE_ITEM_DISCOUNT

Contains uid, order id, catalog object id, type, name, percentage, scope, amount money, and applied money

ORDER_LINE_ITEM_MODIFIER

Contains uid, order line item id, catalog object id, name, base price money and total price money

ORDER_LINE_ITEM_TAX

Contains uid, order id, catalog object id, name, type, percentage, applied money and scope

ORDER_RETURN

Contains uid and source order id

ORDER_RETURN_LINE_ITEM

Contains order return id, source line item id, catalog object id, name, quantity, qunatity unit, note, variation name, variation total price money, base price money, gross sales money, total tax money, total money, total discount money

ORDER_RETURN_LINE_ITEM_MODIFIER

Contains information of order return line item, orer line item modifier, catalog object, base price money, total price money and name

ORDER_SERVICE_CHARGE

Contains order id, catalog object id, name, percentage, taxable, amount money, applied money, total money, total tax money, calculation money

PAYMENT

Contains information of location, order, customer, amount money, app free money, billing address, buyer email address, delay action, delay duration and until, employee id, note, receipt number, receipt url, status, total money

REFUND

Contains location id, transaction id, order id, tender id, payment id, reason, amount money, amount currency, status, processing fee money

TENDER

Contains location id, transaction id, order id, amount money, note, tip money, customer id, type, card details status, last4, fingerprint, entry method

TENDER_ADDITIONAL_RECIPIENT

Contains receivable id, tender id, location id, amount money and description

TRANSACTION

Contains location id, tender id, order id, client id, product, refunds, refernce ids, shipping address

WORKWEEK_HISTORY

Contains start of week, start of day local time, version and timestamps of created at and updated at