Workflow · Reconcile · Opening soon

Match Square deposits to QuickBooks

Export your Square transfers and QuickBooks deposits, then compare them row by row. You get a clear status for each transfer, so you can spot matches and problems fast.

Book a demo

Someone typed

“match the square transfers to our quickbooks deposits and show every transfer with a Status that says "Agrees" when the amounts line up, else a short note on what's off or missing”

The agent read it as

match the Square transfers to our QuickBooks deposits and show every transfer with a Status that says "Agrees" when the amounts line up, else a short note on what's off or missing

What the agent built

3 steps, each one an ordinary Mammoth step you can open and change.

File

Square transfers

CSV export · 16 rows

File

QuickBooks deposits

CSV export · 16 rows

Step

Keep square deposits

Step 1

Join

Match deposits

14 of 16 paired

Step

Set status

Step 3

Result

Square deposit match

16 rows · 2 flagged

Schedule

Runs when you say

Proposed

File
Square transfers
CSV export · 16 rows
File
QuickBooks deposits
CSV export · 16 rows
Step
Keep square deposits
Step 1
Join
Match deposits
14 of 16 paired
Step
Set status
Step 3
Result
Square deposit match
16 rows · 2 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 16 rows came out, and the join paired 14 of 16 rows.

Download Square transfers sample (16 rows)Square Dashboard: Balance > Transfers > Export
Download QuickBooks deposits sample (16 rows)QuickBooks Online: Reports > Deposit Detail > Customize > Run report > Export to Excel

What you get back

The result of that run, the rows to look at first.

Square deposit matchSample data16 rows

14 agrees2 no matching deposit

Transfer ID	Transfer date	Square amount	QuickBooks amount	Status
tr_8k2m4p9q1h	2026-10-10	1,420	·	No matching deposit
tr_8k2m4p9q1j	2026-10-16	1,850	·	No matching deposit
tr_8k2m4p9q1a	2026-09-11	985.50	985.50	Agrees
tr_8k2m4p9q1b	2026-09-18	1,120	1,120	Agrees
tr_8k2m4p9q1c	2026-09-25	760	760	Agrees
tr_8k2m4p9q1d	2026-09-30	1,435.25	1,435.25	Agrees
tr_8k2m4p9q1e	2026-10-02	890	890	Agrees
tr_8k2m4p9q1f	2026-10-03	1,250.75	1,250.75	Agrees
tr_8k2m4p9q1g	2026-10-07	1,650	1,650	Agrees
tr_8k2m4p9q1i	2026-10-14	980	980	Agrees
tr_8k2m4p9q1k	2026-10-17	1,175	1,175	Agrees
tr_8k2m4p9q1l	2026-10-20	640	640	Agrees

16 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you reconcile Square deposits in QuickBooks?

Export your Square transfers from Square and your deposit list from QuickBooks, then load both files into the workflow. It matches each Square transfer to a QuickBooks deposit, keeps the Square rows, and marks each one as Agrees when the amounts line up. If a row does not match, you see a short note that says what is off or missing.

How it works

How to use the Square deposit match workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Square deposit match: questions

Which export should you use?

Use a Square export that lists transfers, and a QuickBooks export that lists deposits. The files should include the amounts and any fields you want to match on, such as date or reference.

What happens to rows that do not match?

They stay in the result with a status that shows there is no match or that the amounts do not line up. You can review those rows and decide what to fix.

How do you change the matching rules?

You change the rules in plain words by choosing which columns should be compared and what counts as a match. You can also change the status text and add extra checks if you need them.