Square payouts to Sage Accounting
Upload the Square payout or settlement report and download two things: a bank-style file of the individual lines, and a payout journal that splits each payout into gross sales, fees, refunds, chargebacks and net so the bank line reconciles in Sage Accounting.
First 5 pages free. No card, no account until you download.
| Description | Account | Debit | Credit |
|---|---|---|---|
| Gross sales | 200 | 1,000.00 | |
| Square processing fees | 404 | 29.50 | |
| Refunds | 200 | 50.00 | |
| Net payout to bank | 090 | 920.50 |
Where the report is in Square
Balance > Transfers, or Reports > Transfers, exported as CSV or PDF.
How Square fees work
Square shows Collected, Fees and Net per transfer.
Posting it in Sage Accounting
Sage imports Date, Reference, Details, Net Amount and Type. The payout split is provided as a separate journal CSV. The journal PayoutParse produces uses Sales, Fees and a bank clearing line per payout; change the account codes in the file to match your chart of accounts before importing.
The check
For each payout, gross less fees less refunds less chargebacks plus adjustments must equal the printed net. If it doesn't, the file is marked needs review and is not charged.
Other software
Square to Xero, Square to QuickBooks Online, Square to FreeAgent.