thread Re: How do I download, or otherwise generate, monthly statements? in Reports Setup & Management

How do I download/generate monthly statements?

bobsmithagency — Wed, 14 Oct 2020 14:52:45 GMT

How do I download, or otherwise generate, monthly statements?

Re: How do I download, or otherwise generate, monthly statements?

Tom — Thu, 22 Aug 2019 15:40:44 GMT

Hello @bobsmithagency, thanks for bringing this up. I wanted to circle back on this question and clarify that we do not currently offer monthly statements, but you can access your sales activity for any period of time from your Sales Summary tab.

In addition, you can download your transaction history. For step-by-steps on this, have a look at our Support Center.

Rest assured that I'll be passing your post over to our Reporting team so they can make improvements based on your feedback. Please don't hesitate to reply with any other questions!

Re: How do I download, or otherwise generate, monthly statements?

SDSHAFT — Fri, 11 Aug 2017 01:45:04 GMT

Will this feature be implemented any time in the near future? I would like to use Square for my entire business but without this feature I would have to manually create statements for customers, some with over 30 purchases per month.

Re: How do I download, or otherwise generate, monthly statements?

puka — Wed, 16 Aug 2017 20:21:04 GMT

Hi @SDSHAFT - Unfortunately, we don't have any updates on if/when this feature will be available. However, we will make sure to forward your feedback as well and we will update this thread with any news.

Re: How do I download, or otherwise generate, monthly statements?

businessowner9 — Thu, 09 Nov 2017 01:32:41 GMT

@SDSHAFT Thanks for posing this question. @puka Thanks for answering this question. If Square won't be creating a feature for monthly statements anytime soon, I will be taking my entire business elsewhere. That is ridiculous not to offer that very basic feature for a real business to run. Good luck.

Re: How do I download, or otherwise generate, monthly statements?

puka — Thu, 09 Nov 2017 18:06:23 GMT

Hey @businessowner9 - Definitely sorry to see you go, but we understand we cannot meet every business's needs at the moment they need it. We always encourage our Sellers to do what they feel is in the best interest of their business even if it means moving away from Square products. We wish you continued growth and success!

Re: How do I download, or otherwise generate, monthly statements?

bloomincrazy — Tue, 20 Aug 2019 16:45:22 GMT

Is this still a feature not offered with square? I like what the software has to offer but would need to be able to generate statements and track outstanding sales.

Re: How do I download, or otherwise generate, monthly statements?

Helen — Thu, 22 Aug 2019 15:46:42 GMT

@bloomincrazy I think there are two requests in this thread! Square doesn't send monthly statements but you can generate and download sales reports for a specific date range (e.g. one monthn) from an online Square Dashboard.

However, it sounds like you might looking for monthly statements to send your customers. Is that correct? If you're using Square Invoices there is a new Outstanding Invoices Report that might help. If you don't use Square Invoices can you reply here with a bit more information about your business, how you take payments, and how often you need to reach out to customers about outstanding sales?

Re: How do I download, or otherwise generate, monthly statements?

SarahHeartsong — Mon, 21 Oct 2019 22:31:50 GMT

For me, I want a statement similar to a bank or credit card statement that simply shows start and end balance and each transaction date, what it was and how much it was, whether debit or credit. This is really the most frustrating part of using Square and, yes, I know about the reports and downloading a csv and they are annoying, hard to read and use. I agree with the other man commenting above that this lack of feature seems unprofessional of Square and a simple tool that most any accounting system needs. Why doesn't Square offer this? It's been years that I've been patiently waiting and I'm considering using just PayPal or another payment system and getting away completely from Square because it's made my accounting so hard.

Re: How do I download, or otherwise generate, monthly statements?

Joe — Wed, 23 Oct 2019 14:56:27 GMT

Hi @SarahHeartsong. Thanks for adding your voice here.

I hear you. The frustration you are experiencing with this has obviously impacted your business, and we appreciate you being steadfast.

To be clear, you are wanting a header on top of a printed statement that gives your starting and ending 'balance' for the month even after deposits, correct? I think our approach with not adding this feature is that balances are quickly deposited every business day, making balance a fluid number that changes rapidly. I will definitely pass this over to our Product Team as a Feature Request to be considered for the future.

If I seemed to have missed the mark in fully understanding your feedback, let me know! I want to make sure you voice is heard by our team on this.

Re: How do I download, or otherwise generate, monthly statements?

SarahHeartsong — Wed, 23 Oct 2019 16:08:26 GMT

I want a report that can easily be generated (a button on top so we don't have to search a lot would be helpful) that has start and end balance, even if it's 0, although there are going to be times when things sell on the 31st and are deposited in the new month. This is because all of the accounting systems I use and have used ask for this info to reconcile and Square doesn't electronically integrate with all of them, nor is the current method of getting this info easy at all, and doesn't give that begin/end balance from 1st to 30/31st.

Re: How do I download, or otherwise generate, monthly statements?

yandj — Mon, 27 Jan 2020 17:26:48 GMT

Any update on if this will be implemented? The small business I'm working for is requesting statements and the excel files will not work for what the accountant needs. I'd be disappointed to have to move both this business and my own personal business away from Square if this isn't rectified.

Re: How do I download, or otherwise generate, monthly statements?

StThereseInst — Mon, 27 Jan 2020 19:57:54 GMT

We also need a nice, clear monthly statement for our account reconciliation. Even being able to print the TRANSACTION screen would do the trick for us. Rright now, when you try to print that screen, the print out only shows the 13 transactions that are currently on screen, not the 93 that I have made this month!

Re: How do I download, or otherwise generate, monthly statements?

yandj — Mon, 27 Jan 2020 20:09:00 GMT

StThereseInst -

You can download a CSV file on the transaction page of your transactions for the month instead of "print screen" the page. On the page to the left, there is a date range you can choose, as an entire month, then you can export the transactions, item summary, or item detail.

But my accountant needs more than an edited Excel file!

Re: How do I download, or otherwise generate, monthly statements?

Joe — Wed, 29 Jan 2020 14:25:33 GMT

Thanks for adding these tips here, @yandj!

Re: How do I download, or otherwise generate, monthly statements?

StThereseInst — Fri, 25 Sep 2020 21:03:57 GMT

I ended up coding a web page that I can upload my monthly CSV file to and have it spit out a traditional looking paper statement the way that I want it to look, with the data we need to see.

I can provide the url if anyone wants to try it with their data, but a) it is not customizable without me altering code; b) you have to trust me that I'm not stealing your data (which I'm not, but you have to take my word for it); c) I can't guarantee that it is 100% error free (although I fix any bugs that I find); and d) I code it live online, so you could end up bumping into bugs or something I'm working on changing or implementing if you visit it at the right moment (but I can post a warning note when I'm working on it).

It is something that Square really should be providing (imao) as I personally know many merchants that want to see the statement and not just rely on everything happening automatically through APIs and software integration.

For us, we are a non-profit charity with annual audits, and being able to give the auditor a piece of paper with everything on it makes the audit process so much smoother. Otherwise, we're having to log them into this website and that website (and re-log them in after the website times out) and teach them how to find what they need etc. every time.

edit: Here's the PHP code I wrote to do this https://github.com/StThereseInstitute/SquareStatementGenerator. Feel free to modify and make it better, but please keep the © credit intact 🙂

Re: How do I download, or otherwise generate, monthly statements?

StThereseInst — Thu, 13 Feb 2020 18:16:31 GMT

@yandj -- Needing more than an excel spreadsheet is exactly our problem too. I built my own csv -> statement creator (see my post above).

Re: How do I download, or otherwise generate, monthly statements?

yandj — Thu, 13 Feb 2020 18:49:50 GMT

@StThereseInst
Do you use GitHub to open-source this? If you can or know how, you can drop the source code into GitHub and people can download it to customize it for themselves if you are OK with it.

If you did drop it in GitHub or another open-source provider, let us know!

Re: How do I download, or otherwise generate, monthly statements?

StThereseInst — Fri, 25 Sep 2020 21:28:43 GMT

@yandj I definitely thought about open-sourcing it via Github... but I'd have to get permission from my organization as it was done on company time. Also, the code at present is not quite at a distro state yet (nothing is commented, the code is sloppy in places, I've only set it up to handle a few card types, etc). So, at least for right now, I need to keep the code closed.

Maybe I can polish it and rewrite it on my own time at some point and then release it open-source????

I only know PHP, so whatever I do is confined to being web-server based (although, I just discovered through a Google search that there are PHP to EXE compilers available...).

I still feel that, ultimately, Square should be the one to provide this feature to all customers. An experienced coder could produce the whole thing in a few hours, especially if they had access to all the back-end stuff 🙂

edit: I have uploaded my PHP script to GitHub. You'll find the link tagged onto my posts above from 2019-02-13, as well as in a new post made 2020-09-25.

Re: How do I download, or otherwise generate, monthly statements?

Joe — Fri, 14 Feb 2020 15:57:00 GMT

Thanks for adding your tips and sharing your experience here, @StThereseInst!