Daily Deposit Total Report

[Candlestore]

I keep seeing questions from people how do I see what matches my Daily deposit record at the bank.

Why can I not down load a Daily Transaction report from Square?  This should be easy since any day I can look up what was the sales for that day, Cash, CC, and the Associated Square Fees.  I think Square should be able to have under the Balance Transfer report a tab Kind of like the Drop down for Exporting transactions where you can choose what is being downloaded.

Meaning in the Transaction Tab when you choose Export you get a Drop down of :

Transactions CSV

Items Summary CSV

Items Detail CSV

Add another Drop down call it Daily Totals which exports Daily Gross Credit Card Totals, The Square Fee total and the Total Square Wired to the Bank for the Days requested to Download.   That way people could see and match the Totals to a Bank Statement.   I know if I miss one Transaction or it did not import correctly I spend Hours looking for why things are not matching up.  For QuickBooks I do not need each transaction imported of the gross sale and the associated fee, but I do need the Days Gross CC sales and the total Fee Charged by Square for the Day.  Now if I used QuickBooks to track my inventory, then I would need each sale Item listed and entered and the quantity sold, but I use Square for inventory tracking.

With the holidays and the short crewing I do not have time to always enter each days sales, but do try to import them at the end of the week and when I do this my importing tool may make a mistake or most likely I do and then I am here for hours and find that the same transaction has been entered a few times throwing off my QuickBooks accounting.

I do not believe this should be limited to retail but through out Square POS systems.  Then for each day I would have a Gross Sales Deposit of my Credit Card transactions and A fee (Payment) of Processing fee..... 2 transactions instead of anywhere from 20 to 200 transactions to look through to see if it was doubled or missed. 

I follow Hector Garcia CPA's idea for importing and checking my Square Deposits and Fees and my Banks Deposits.  Basically, I setup a Bank account Called Square in QB's, Deposit Gross CC sales to it, Subtract the Fees and then when I import my bank account it withdrawals the Money that Square deposited.  By doing it this way it should show my Square "bank Account" at $0.00 or The next days Deposit amount if the Deposit was not made by Square to my business Bank Account.   The Main problem I have with this is the Daily Transactions can be very long on busy days times 2, for Deposit of each sales Transaction then checking with Each Square Processing Fee.  It would be so much nicer and easier to find errors if the exported CSV file was just the Days Balance Report totals of Gross Sales, Square Fees and Deposit amount.

Here is the video from you tube which is about 14 min long.

CSV file to QuickBooks Desktop 

[frances_a]

Hello @Candlestore! 

Let's make sure I'm understanding what you need correctly.

You need two reports you can export showing daily totals, one for items and one for transactions?

And then from there another breakdown of daily sales, but separating your gross sales, Square fees and the total Square sent to your bank account?

Thank you for answering these questions so we can better assist!

[Candlestore]

@frances_a ;

Currently I can export all my daily transactions, which shows as individual transactions.

All I am looking for is a way that Square can export the Daily totals of Sales, Fees, and what was Deposited on a Daily basis not as individual transactions.

The Reason for this would be to compare Squares Deposits with a Bank Deposit.  I understand the reason for each transaction incase there is a refund or customer complaint of fraud etc but for most businesses to import and do a check and balance we just need the daily deposit and fee totals.  If there is a complaint we could look it up by the receipt in transaction or the detailed view on transactions. When We export Transactions or the Balance Report all Transactions for the Day are exported, When I export the sales summary for Payment Methods it does not show Total Credit card Transactions... they are broken down by Tap Dip Not Present and the associated fees, But online Square Has CARD -  Column of Total Collected $XXXX.XX    Fees column with Total Fees $XX.XX  and then broken down below that Dipped collected $XX.XX   Dipped Fees X.XX    Swiped $XX.XX   Fees $X.XX  etc     Why cant we get a a csv file that has Total Credit Card Sales for the day and the Total Fees Square Charged and a Column that Shows What Square Sent for the Day to the bank account on file.   To get what Square Sent to a bank account in a CSV file we need to export Transactions and then manually total them up for each day.   Now If I do this weekly I have seven days that I need to manually separate in the CSV file to get the totals to see what is deposited by Square.  

If you need more clarification let me know and thanks.  Below is what else would be helpful.... Shows a Total of Credit Card income and the Total Fees charged that would give the Daily deposited amount.

 So basically if you got to sign into your Square account and from your dashboard go to Reports-Payment Methods and see the Report online, Why is there no way for me to download and see in a CSV file the Top line that States CARD?  https://squareup.com/dashboard/sales/reports/payment-methods 

The Red area would even Help since It Shows the Daily Total Card Sales and TOTAL Fees on one line... the Difference would be the deposited amount.

[Candlestore]

@frances_a 

Here is a post from 2016 and people said about mentioning it for a feature request....  Even the Balance report shows ALL transactions.  Not just the BALANCE that gets deposited to a bank account .  Questions-How-To/How-do-I-get-reports-to-match-my-deposit 

What we currently would be if your Paystub for a 2 week period showed 80 transactions, 1 for each hour of work showing the minutes you worked - (breaks, Lunch, lates, leaving early)  so most would be 60 but others could be 45 or 47 etc then another column that used the minutes you worked in those hours to subtract ( insurances, taxes paid, 401k deposit etc )   which I had calculated out before as about 23.76% of my gross. So each pay check stub would show you these 160 plus numbers depending on how many deductions are in your check but in your bank statement you are shown 1 deposit for 2 weeks.