Sync Square Finance Data

Square

Finance & Accounting

Dataddo extracts the full Square record set - invoices, transactions, payments, ledger entries - and delivers it wherever your finance team needs it: into AI tools and agents, your warehouse like Snowflake and BigQuery, BI dashboards, and back into your ERP and CRM. Blend it across entities and systems, backfill full history for audit, and keep it fresh on your schedule - all fully managed, with the data plane running where you choose. No pipelines to build, no lock-in.

Start Free

Book a Demo Read the docs

YOUR FINANCE SOURCE OF TRUTH

Turn Square into financial reporting your whole team trusts

Financial data is only useful when it's complete, reconciled, and current. Dataddo extracts the full Square record model, governs it, and serves it to every warehouse, dashboard, AI tool, and downstream system - continuously and without manual exports.

Every record & field

Pull the full Square data model - invoices, transactions, payments, ledger and tax fields - not just a fixed preset, so your financial reports are never missing a line.

Blend across entities & systems

Combine Square with your other accounting, payment, and CRM sources so consolidated, multi-entity reporting lives in one place.

Backfill full history for audit

Load historical Square data beyond the platform's export limits, so period-over-period, reconciliation, and audit trails hold up.

Model & clean before load

Normalize currencies, tax codes, and account names, and let the Data Quality Firewall stop bad rows before Square data reaches your reports.

Fresh on your schedule

Incremental, scheduled syncs keep Square data current - as often as hourly - without manual exports or full reloads.

Governed & auditable

Delivery alerts and quality checks catch gaps in Square data early, so month-end close and dashboards never silently break.

DATASETS

What you can pull from Square

The Square connector provides a list of curated datasets - ready-made sets of records, fields, and metrics you can extract on a schedule. Need something specific? Any dataset can be forked and customized, or built from scratch, with our Universal Connector.

List of curated datasets

Typetype

string

Idid

string

Created Atcreated_at

datetime

Category Idcategory_id

string

Updated Atupdated_at

datetime

Versionversion

integer

is_deletedis_deleted

integer

Present At All Locationspresent_at_all_locations

integer

Item Data Nameitem_data_name

string

Item Data Is Taxableitem_data_is_taxable

integer

Item Data Tax Idsitem_data_tax_ids

string

Item Data Variations Typeitem_data_variations_type

string

Item Data Variations Iditem_data_variations_id

string

Item Data Variations Updated Atitem_data_variations_updated_at

datetime

Item Data Variations Created Atitem_data_variations_created_at

datetime

Item Data Variations Versionitem_data_variations_version

integer

Item Data Is Deleteditem_data_is_deleted

integer

Item Data Present At All Locationsitem_data_present_at_all_locations

integer

Item Variation Data Item Iditem_variation_data_item_id

string

Item Variation Data Nameitem_variation_data_name

string

Item Variation Data Ordinalitem_variation_data_ordinal

integer

Item Variation Pricing Typeitem_variation_pricing_type

string

Item Variation Sellableitem_variation_sellable

integer

Item Variation Stockableitem_variation_stockable

integer

Item Variation Default Unit Cost Amountitem_variation_default_unit_cost_amount

float

Item Variation Default Unit Cost Currencyitem_variation_default_unit_cost_currency

string

Item Variation Vendor Infos Typeitem_variation_vendor_infos_type

string

Item Variation Vendor Infos Iditem_variation_vendor_infos_id

string

Item Variation Vendor Info Updated Atitem_variation_vendor_info_updated_at

datetime

Item Variation Vendor Info Created Atitem_variation_vendor_info_created_at

datetime

Item Variation Vendor Info Versionitem_variation_vendor_info_version

integer

Item Variation Vendor Info Is Deleteditem_variation_vendor_info_is_deleted

integer

Item Variation Vendor Info Present At All Locationsitem_variation_vendor_info_present_at_all_locations

string

Item Variation Vendor Info Data Ordinalitem_variation_vendor_info_data_ordinal

integer

Item Variation Vendor Info Data Price Money Amountitem_variation_vendor_info_data_price_money_amount

float

Item Variation Vendor Info Data Price Money Currencyitem_variation_vendor_info_data_price_money_currency

string

Item Variation Vendor Info Data Item Variation Iditem_variation_vendor_info_data_item_variation_id

string

Item Variation Vendor Info Data Item Vendor Iditem_variation_vendor_info_data_item_vendor_id

string

Item Data Product Typeitem_data_product_type

string

Item Data Ecom Availableitem_data_ecom_available

integer

Item Data Ecom Visibilityitem_data_ecom_visibility

string

Item Data Is Archiveditem_data_is_archived

integer

Reporting Category Idreporting_category_id

string

Idid

string

Created Atcreated_at

datetime

Updated Atupdated_at

datetime

Given Namegiven_name

sensitivestring

Family Namefamily_name

sensitivestring

Email Addressemail_address

sensitivestring

Phone Numberphone_number

sensitivestring

Reference Idreference_id

sensitivestring

Notenote

string

Creation Sourcecreation_source

string

Versionversion

integer

Address Line 1address_line_1

sensitivestring

Address Line 2address_line_2

sensitivestring

Localitylocality

string

Administrative District Level 1administrative_district_level_1

string

Postal Codepostal_code

sensitivestring

Countrycountry

string

Email Unsubscribedemail_unsubscribed

boolean

Group Idsgroup_ids

string

Segment Idssegment_ids

string

Local Datelocal_date

datetime

Category Namecategory_name

string

Item Nameitem_name

string

Item Variation Nameitem_variation_name

string

Location Namelocation_name

string

Channel Namechannel_name

string

Transaction Typetransaction_type

string

Item SKUitem_sku

string

Payment Methodpayment_method

string

Customer Typecustomer_type

string

Items Sold Countitems_sold_count

float

Items Returned Countitems_returned_count

float

Net Quantitynet_quantity

float

Item Net Salesitem_net_sales

float

Item Net Sales With Taxitem_net_sales_with_tax

float

Sales Gross Amountsales_gross_amount

float

Returns Gross Amountreturns_gross_amount

float

Discount Amountdiscount_amount

float

Avg Item Gross Salesavg_item_gross_sales

float

Avg Item Net Salesavg_item_net_sales

float

Unique Customersunique_customers

float

Idid

string

Namename

string

Address Line 1address_line_1

string

Address Localityaddress_locality

string

Address Administrative District Level 1address_administrative_district_level_1

string

Address Postal Codeaddress_postal_code

string

Address Countryaddress_country

string

Timezonetimezone

string

Capabilitiescapabilities

string

Statusstatus

string

Created Atcreated_at

datetime

Merchant Idmerchant_id

string

Countrycountry

string

Language Codelanguage_code

string

Currencycurrency

string

Phone Numberphone_number

string

Business Namebusiness_name

string

Typetype

string

Business Hours Day Of Weekbusiness_hours_day_of_week

string

Business Hours Start Local Timebusiness_hours_start_local_time

string

Business Hours End Local Timebusiness_hours_end_local_time

string

Business Emailbusiness_email

string

Descriptiondescription

string

Coordinates Latitudecoordinates_latitude

float

Coordinates Longitudecoordinates_longitude

float

Logo Urllogo_url

string

Mccmcc

string

Full Format Logo Urlfull_format_logo_url

string

Tax Ids Eu Vattax_ids_eu_vat

string

Tax Ids Es Niftax_ids_es_nif

string

Idid

string

Location Idlocation_id

string

Line Items Uidline_items_uid

string

Line Items Catalog Object Idline_items_catalog_object_id

string

Line Items Quantityline_items_quantity

integer

Line Items Nameline_items_name

string

Line Items Variation Nameline_items_variation_name

string

Line Items Base Price Moneyline_items_base_price_money

float

Line Items Base Price Money Currencyline_items_base_price_currency

string

Line Items Total Tax Moneyline_items_total_tax_money

float

Line Items Total Tax Money Currencyline_items_total_tax_money_currency

string

Line Items Total Discount Moneyline_items_total_discount_money

float

Line Items Total Discount Money Currencyline_items_total_discount_money_currency

string

Line Items Total Moneyline_items_total_money

float

Line Items Total Money Currencyline_items_total_money_currency

string

Line Items Variation Total Price Moneyline_items_variation_total_price_money

float

Line Items Variation Total Price Money Currencyline_items_variation_total_price_money_currency

string

Line Items Applied Taxes Uidline_items_applied_taxes_uid

string

Line Items Applied Taxes Tax Uidline_items_applied_taxes_tax_uid

string

Line Items Applied Taxes Tax Applied Moneyline_items_applied_taxes_tax_applied_money

float

Line Items Applied Taxes Tax Applied Money Currencyline_items_applied_taxes_tax_applied_money_currency

string

Line Items Item Typeline_items_item_type

string

Taxes Uidtaxes_uid

string

Taxes Catalog Object Idtaxes_catalog_object_id

string

Taxes Catalog Versiontaxes_catalog_version

integer

Taxes Nametaxes_name

string

Taxes Percentagetaxes_percentage

string

Taxes Typetaxes_type

string

Taxes Applied Moneytaxes_applied_money

float

Taxes Applied Money Currencytaxes_applied_money_currency

string

Taxes Scopetaxes_scope

string

Created Atcreated_at

datetime

Updated Atupdated_at

datetime

Statestate

string

Versionversion

string

Total Tax Moneytotal_tax_money

float

Total Tax Money Currencytotal_tax_money_currency

string

Total Discount Moneytotal_discount_money

float

Total Discount Money Currencytotal_discount_money_currency

string

Total Tip Moneytotal_tip_money

float

Total Tip Money Currencytotal_tip_money_currency

string

Total Moneytotal_money

float

Total Money Currencytotal_money_currency

string

Total Service Charge Moneytotal_service_charge_money

float

Total Service Charge Money Currencytotal_service_charge_money_currency

string

Net Amounts Total Moneynet_amounts_total_money

float

Net Amounts Total Money Currencynet_amounts_total_money_currency

string

Net Amounts Tax Moneynet_amounts_tax_money

float

Net Amounts Tax Money Currencynet_amounts_tax_money_currency

string

Net Amounts Discount Moneynet_amounts_discount_money

float

Net Amounts Discount Money Currencynet_amounts_discount_money_currency

string

Net Amounts Tip Moneynet_amounts_tip_money

float

Net Amounts Tip Money Currencynet_amounts_tip_money_currency

string

Net Amounts Service Charge Moneynet_amounts_service_charge_money

float

Net Amounts Service Charge Money Currencynet_amounts_service_charge_money_currency

string

Source Namesource_name

string

Customer Idcustomer_id

string

Net Amounts Due Moneynet_amount_due_money

float

Net Amounts Due Money Currencynet_amount_due_money_currency

string

Idid

string

Created Atcreated_at

datetime

Updated Atupdated_at

datetime

Amount Moneyamount_money

float

Amount Currencyamount_currency

string

Statusstatus

string

Delay Durationdelay_duration

string

Source Typesource_type

string

Card Statuscard_status

string

Card Brandcard_brand

string

Card Last 4card_last_4

string

Card Exp Monthcard_exp_month

integer

Card Exp Yearcard_exp_year

integer

Card Fingerprintcard_fingerprint

sensitivestring

Card Typecard_type

string

Card Prepaid Typecard_prepaid_type

string

Card Bincard_bin

string

Entry Methodentry_method

string

Cvv Statuscvv_status

string

Avs Statusavs_status

string

Auth Result Codeauth_result_code

string

Statement Descriptionstatement_description

string

Card Payment Timeline Authorized Atcard_payment_timeline_authorized_at

string

Card Payment Timeline Captured Atcard_payment_timeline_captured_at

string

Location Idlocation_id

string

Order Idorder_id

string

Processing Fee Effective Atprocessing_fee_effective_at

datetime

Processing Fee Typeprocessing_fee_type

string

Processing Fee Amount Moneyprocessing_fee_amount_money

float

Processing Fee Amount Currencyprocessing_fee_amount_currency

string

Notenote

string

Total Money Amounttotal_money_amount

float

Total Money Currencytotal_money_currency

string

Approved Money Amountapproved_money_amount

float

Approved Money Currencyapproved_money_currency

string

Employee Idemployee_id

string

Receipt Numberreceipt_number

string

Receipt Urlreceipt_url

string

Delay Actiondelay_action

string

Delay Untildelayed_until

datetime

Team Member Idteam_member_id

string

Application Details Square Productapplication_details_square_product

string

Application Details Application Idapplication_details_application_id

string

Version Tokenversion_token

string

Customer Idcustomer_id

string

Need a dataset, metric, or attribute you don't see?

Tell us what's missing and we'll add it to the connector.

Request it

WITH VS. WITHOUT

Who carries the load when things change

Keep Square data flowing to every warehouse, dashboard, and tool - and see who owns it when an API or schema changes:

	Without Dataddo	With Dataddo	Outcome for you
API or auth change	You discover the breakage and scramble to fix it.	We update the connector and restore the pipeline - often before you notice.	Syncs from Square keep flowing
Schema drift	Columns change and pipelines break or corrupt data silently.	Detected automatically and handled by configurable rules.	Only clean Square data lands in reports
Endpoint deprecated	You re-engineer the integration.	We own the update - the data contract holds.	Your Square reporting keeps working
Missing connector	You build and maintain a custom integration.	We build it and maintain it, under a ~4-week SLA.	Any Square record you need, on request
Silent degradation	You find out when a report or model run fails.	Proactive monitoring catches anomalies and delays first.	Gaps caught before month-end close
Debugging	You dig through logs across disconnected tools.	Run histories, payload inspection, and end-to-end lineage in one place.	Faster root-cause, fewer reporting gaps

Data residency by design

Choose where Square data is processed - same cloud, region, or sovereign

Square is a cloud API, so the question isn't on-prem vs cloud - it's which region your financial data flows through. With Dataddo you run the data plane in the region you choose, so Square payloads move straight to your destinations without transiting a third-party SaaS. Pin it to an EU or US region for compliance and data-residency requirements, or self-host when a downstream target lives inside your own network.

Data Plane location	Typical data sensitivity	Why this setup
Public cloud AWS Microsoft Azure Google Cloud	Low to moderate - general business, marketing, and product data; sources that are already cloud-native.	Fastest to stand up and scales elastically. Best when the data has no residency restriction and often already lives in the same public cloud.
Regional & EU sovereign clouds EU sovereign clouds Regional providers Private cloud	Regulated / residency-bound - PII, financial, and health data governed by GDPR or local law.	Keeps processing inside a specific jurisdiction to meet data-residency and sovereignty rules, while still running as managed infrastructure.
On-premises Kubernetes Red Hat OpenShift VMware Tanzu	Highly sensitive / restricted - data that contractually or legally cannot leave the corporate perimeter.	Data never leaves your network. Required for air-gapped, classified, or locked-down environments; the Control Plane still manages it via metadata only.

DATA DELIVERY

Every way to deliver Square data

Financial data rarely has one home. Dataddo feeds Square into AI and agents, loads it into your warehouse for financial modeling, syncs records back into ERP and CRM systems, and delivers files to storage for archival - all governed the same way.

Transport type	What it does	Typical destinations	Typical business use cases
Data to AI™ & Agents	Feed Square data into vector databases, LLMs, and AI agents so finance copilots can reason over your numbers.	Claude OpenAI Gemini Mistral AI + 400 more	Load Square records into vector stores for retrieval-augmented finance assistants, Give AI agents and copilots governed access to live Square financial data
ETL / ELT to your warehouse	Load Square records and metrics into your warehouse for financial and revenue analytics.	Snowflake BigQuery Amazon Redshift PostgreSQL + 400 more	Centralize Square across entities in Snowflake, BigQuery, or Redshift for consolidated reporting, Backfill Square history for reconciliation and audit
Sync back to ERP & CRM	Push reconciled or modeled records built from Square data back into ERP, accounting, and CRM systems.	NetSuite Exact Online Salesforce HubSpot + 400 more	Sync modeled financial records from Square into your ERP or CRM, Keep Square data aligned across finance and revenue systems
Files to storage & archive	Deliver raw or modeled Square extracts to object storage and partners for archival and audit.	AWS S3 Google Cloud Storage Azure Blob Storage SFTP + 400 more	Archive raw Square exports to S3, GCS, or Azure storage for retention, Send scheduled Square extracts to auditors or partners over SFTP

Case Studies

See what finance teams build with Dataddo

65,000 Social Media Accounts. One Platform. Zero Manual Authorizations.

Beauty & Consumer Goods

How Livesport Activates Data, Saves Engineering Resources with BigQuery and Dataddo

Entertainment

How ID&T Group Activates Data from 1M+ Festival Fans and Dozens of Social Accounts

Entertainment

How Sensire Accelerated Migration of a Proprietary On-Premise Data Infrastructure to the Cloud with Dataddo

Healthcare

How Ringside.ai Builds a Data Product Better and Faster Using Dataddo

Marketing

How Publicis Groupe Brasil Uses Dataddo's API to Scale a Data Product

Advertising

Pricing

Pick the plan that fits how you use your data.

Move data into your warehouse, lake or business apps with Data Anywhere, or let your AI assistants query it directly with Data to AI™. Need tailored contracts or volume pricing? Talk to us about Enterprise.

~25% OFF

Data to AI^TM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

$13.99 /mo

per seat, billed monthly per seat, billed annually

Data Anywhere^TM

Sync data between any sources and any destinations.

$129.00 /mo

31530

Choose a number of data flows

3 data flows

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →

FAQ

Square as a source + Dataddo, answered

Where can I send Square data?

To any of Dataddo's 150+ destinations - warehouses like Snowflake and BigQuery, BI dashboards, ERP and CRM systems, object storage, and AI or vector stores - plus custom destinations on request.

Do I have to maintain the pipeline?

No. Dataddo is fully managed: we maintain the Square connector, adapt to API and schema changes, and alert you if anything needs attention. There is no pipeline code for you to write or fix.

Can I consolidate Square data across multiple entities?

Yes. Dataddo can pull Square data from multiple accounts or entities and load it into one warehouse, blended and normalized, so consolidated and multi-entity reporting works without manual exports or spreadsheets.

What if Square changes their API?

That's on us, not you. Dataddo's team proactively tracks Square API and schema changes and updates the connector before they break your pipeline. Continuous monitoring watches every sync, and if anything needs attention you get an alert - so your Square data keeps flowing without you touching a thing.

Which Square records and fields are available?

The full Square data model - invoices, transactions, payments, ledger and tax fields, not a fixed subset. If a field you need isn't exposed yet, we add it on request, usually at no extra cost.

How is my data secured?

Dataddo is SOC 2 Type II and ISO 27001 certified. Data is encrypted in transit and at rest, PII and financial data can be masked or hashed, and EU or US data residency is available. Self-host the data plane and payload data never leaves your network.

Will API rate limits be a problem?

Dataddo handles Square pagination, rate limits, and retries for you, and pulls incrementally on a schedule so you stay within API quotas without impacting your accounting system.

Am I locked in?

No. Pipelines are source- and destination-agnostic - you can add or switch destinations without rebuilding, and data lands in native formats you own.