thread Re: How do I get reports to match my deposit? in Archived Discussions (Read Only)

How do I get reports to match my deposit?

JMUSK — Sat, 30 Apr 2016 00:08:16 GMT

I have never quite been able to recreate the Sales Summary Net items (gross sales, discounts etc.) in a way that matches our actual deposits.

There's a lot of factors that affect the sales reports like pay outs, fees, refunds, and subscription purchases.

I would appreciate if someone could make a breakdown of everything that actually affects Net Sales so that I could create invoices in my accounting software that actually match my deposits.

Here's an example of what I would need:

The following stuff is already included in the Sales Summary

Gross Sales
(Discounts)
Net Sales

Gift Card Sales
Tax
Tip
(Partial Refunds)
Total Collected

I would like to go from Total Collected down to Expected Deposit Total as follows:

Total Collected

- pay outs

- subscription fees

- Transactions carried over to next days sales summary

+ transactions from previous day

- Pending credit transactions

+ Previously pending credit transactions added to deposit

+/- anything else that affects the Sales Summary down to the point of deposit.

Ideally Square could create a master report that includes data from ALL the other reports (payment methods, drawer reports, etc).

Thanks in advance!

Re: How do I get reports to match my deposit?

EJ_ — Thu, 07 Jul 2016 20:48:47 GMT

@JMUSK Thanks for the post!

This specific report you mentioned isn't fully available, but you might get a bit more useful information from downloading your Deposit Transaction report.

This will at least give you the transactions that were included from the previous day.

You can also view the Pending Deposit amount that's sitting in your Square Balance from the Deposits tab.

I'll definitely send this over to our Product Team, as I can see how these specific categories of reports would help with accounting.

Re: How do I get reports to match my deposit?

Tracys — Thu, 25 Aug 2016 18:31:30 GMT

so without being able to print a report with the total paid in and paid out-we find the square app not useful for our company. Please let me know when this becomes available. I will start researching other vendors for POS.

Thank you,

Re: How do I get reports to match my deposit?

ycsf — Fri, 06 Jan 2017 16:12:30 GMT

The advice to download a transaction report and analyze it is ludicrous for restaurants and cafes. What good would it do? I would only know what transactions had been included in the deposit, but it wouldn't address the issue raised by the original poster. Why can't Square reconcile deposits and sales in a helpful daily way?

Re: How do I get reports to match my deposit?

TahoeKristen — Mon, 07 Aug 2017 00:10:23 GMT

"downloading your Deposit Transaction report"

How does one go about doing this and will this show which transactions were included in each deposit? It's pretty annoying that the deposits are random numbers. Thinking there's got to be an easier way than hand doing the math to figure out which transactions we were actually paid for and when. Thanks!

Re: How do I get reports to match my deposit?

Chad — Wed, 09 Aug 2017 15:59:45 GMT

Hey @TahoeKristen!

When you're on the Square Dashboard head to the Sales tab on the left hand side. This will take you to all of the reports. On the top of this page you will see the Deposits option you're looking for.

You should now see a screen outlining all of your deposits by date. If you click on a specific deposit it will show which transactions were included. You can also download a CSV file of this report using the Export option in the top right corner.

Please let me know if you get stuck at any point! 😀

Re: How do I get reports to match my deposit?

jenviale — Fri, 13 Oct 2017 17:03:12 GMT

The deposit still doesn't match up when I go to my bank account. In the past I use to be a ble to look at my square deposit and my bank account and it would match. I'm very confused.

Re: How do I get reports to match my deposit?

Helen — Mon, 16 Oct 2017 00:15:46 GMT

Hello @jenviale! The Deposits report that Chad mentioned above includes the date and status of each deposit sent to your bank account. I also recommend this Support Center article about the next business day deposit schedule which has useful information about when your deposits will be sent to your bank account!

Re: How do I get reports to match my deposit?

Dvalleyassoc — Mon, 24 Sep 2018 16:00:23 GMT

Any update in this? This is exactly what I am looking for.

Re: How do I get reports to match my deposit?

Chad — Wed, 26 Sep 2018 18:26:16 GMT

Hey @Dvalleyassoc!

The report JMUSK suggested is still a feature request. We're tracking the feedback on this thread, but we don't have any updates to share at this time. If there is movement on this a member of the Community Team will update the thread.

Re: How do I get reports to match my transfer?

plastercarousel — Mon, 06 Jan 2020 16:38:54 GMT

[This post was updated by moderator in 2020 to reflect a name change - deposits are now called transfers.]

I am also looking for a clean transfer report that I can use to compare to what is shown in QuickBooks for my bank deposits. I just need a report that shows the net amount transferred per day (just like the bank shows it) so I can easily reconsile. Currently, I am only able to export every transaction but I just want a daily summary. Thanks in advance!

Re: How do I get reports to match my deposit?

Tom — Sat, 10 Nov 2018 21:05:41 GMT

Hey @plastercarousel, welcome to the seller community and thanks for bringing this up. If I'm understanding your reporting needs correctly, it sounds like the reporting process in this article should get you the right information: Match Deposits to Sales. Have a look there and let us know if any questions remain. 🙂

Re: How do I get reports to match my deposit?

plastercarousel — Mon, 06 Jan 2020 16:39:38 GMT

Thanks Tom. Unfortunately, this gives me a detailed list of all transactions that occurs. I just want a single number that matches what is transferred into my bank account each day. So, an aggregate of each days total minus fees, etc. so I can match what gets transferred with what Square reports. Does this make sense?

Re: How do I get reports to match my transfer?

Tom — Mon, 06 Jan 2020 16:42:02 GMT

Ah, got it—apologies for the confusion! It sounds like you'll be able to find the information you're looking for on the online Square Dashboard > Balance >tab. From there, you can set any given time period and either view or export the report that shows the net transfer amount accompanied with the date it was sent from Square.

Note: if you're set up with the "Next Business Day" transfer schedule and the cutoff time is causing your transfer to be split up, you may need to adjust your close of day. This will ensure that a full day’s business activity is grouped in one transfer.

Hope this helps clear things up. Please don't hesitate to let me know if any questions remain, or get in touch with an account specialist if you'd like someone to take a deeper dive into specifics.

Re: How do I get reports to match my deposit?

plastercarousel — Thu, 15 Nov 2018 16:47:08 GMT

Thanks Tom. That did the trick!

Re: How do I get reports to match my deposit?

Tom — Thu, 15 Nov 2018 17:50:35 GMT

Glad to hear it—appreciate your patience! 🙂

Re: How do I get reports to match my deposit?

Ralla — Sun, 03 May 2020 21:13:24 GMT

We await this feature. All we need though, is simple report to PRINT that helps us reconcile the account at the end of the month.

For each item deposited, we would need the gross amount paid by customer, customer info, the amount deducted by Square and the net we should see in our account. On that SAME report we should have any transfers from Square Up into our bank account and end balance with square at the end of the period.

Every other processor gives us this simple, easy, report so we can reconcile. Why would this still be in formulation state?

Re: How do I get reports to match my deposit?

Megmorri22 — Mon, 16 Nov 2020 11:43:46 GMT

I'm shocked that deposits haven't been added. I take deposits for 90% of my services and it is extremely frustrating that the sales report doesn't have that feature.

Re: How do I get reports to match my deposit?

JoJoEngs — Thu, 28 Jan 2021 20:31:58 GMT

We also would benefit from a more detailed report that show exactly what transactions are included in the transfers

Re: How do I get reports to match my deposit?

isabelle — Thu, 28 Jan 2021 21:25:33 GMT

Thanks for commenting on this thread @JoJoEngs! 💫

We do have this kind of report in the Square Dashboard > Balance > Transfer Reports. From there, you can click on a transfer and view each individual transaction that's included. Does that work?