If you go in to your DashBoard-Transactions
The select the Date range (Last Month - This Moth . or select the days ) then Export.
From the Drop Down in Export you can get a CSV file of all transactions for that Time frame you selected.
Quick way to find a Split Transaction is in column AC Header of Staff ID, you should have your staffs 4 digit pin listed say 1234, for all transactions. for a Split Transaction it would have the Staffs ID 2 times 1234,1234. One is for Cash and One is for the CC transaction. You will also see the fee for the CC transaction along with the Total Collected, Tax Charged Cash and the Card amount.
I hid a few columns but here is what it would look like in a CSV minus the Header fields.
| Date | Time | Time Zone | Gross Sales | Discounts | Service Charges | Net Sales | Gift Card Sales | Tax | Tip | Partial Refunds | Total Collected | Source | Card | Card Entry Methods | Cash | Square Gift Card | Other Tender | Other Tender Type | Other Tender Note | Fees | Net Total | Card Brand | PAN Suffix | Device Name | Staff Name | Staff ID |
| 4/13/2023 | 11:24:13 | Eastern Time (US & Canada) | $8.99 | $0.00 | $0.00 | $8.99 | $0.00 | $0.54 | $0.00 | $0.00 | $9.53 | Point of Sale | $4.53 | Tapped | $5.00 | $0.00 | $0.00 | | | ($0.21) | $9.32 | Visa | 8602 | iPad | Pocono Candle Store, Pocono Candle Store | 1234, 1234 |
There are more fields after the Staff ID for more details about the Transaction but this has been the quickest way I was able to find Split Transactions. You probably could sort the Staff ID column to find the multiple IDs and get all Splits together.
Keith
Owner
Pocono Candle
Mark as Best Answer if this Helped you solve an issue or give it a thumbs up if you like the answer.
Square Support Number 855-700-6000.
Make Sure App and OS is up to date on your Device.
