Detailed Transfer Report Needed For Bookkeeping - Customer Name, Invoice Number, Amounts, Dates etc.

[S3Adventures]

My Accountant and Bookkeeper need a report that details all Invoice Numbers, Customer Names, Partial Payments that are included in a Transfer to my bank account(s).

Square combines payments for transfers so when you get a deposit you have no idea Who, How much, or What Invoice they are from. The Lump Sum of money is basically a blind deposit and Accountants and Bookkeepers can't decipher what to do with it.

The Report that Square does provide does not include Customer Name, or Invoice Number so the report falls well short of what a Bookkeeper needs to see. 

I'll explain in more detail below

The Problem:

Square Combines payments from various customers and various invoices into a single transfer to my bank account.

That transfer could include multiple customers and multiple payments (some partial, some full). 

So, if Bob pays a $500 deposit on his $2000 invoice on Monday and Sue pays her $200 invoice in full on Monday, and Charlie pays $50.50 for his balance due on his invoice also on Monday, the Transfer from Square hits my bank on Tuesday. That transfer is the Sum of Bob, Sue and Charlies Deposits less the Square fee. Let's for simplicity sake ignore the square fee and say the transfer amount to my bank is $750.50 

Although we are happy to see the money come in, we cannot tell who it came from (Bob, Sue, or Charlie) and/of what Invoice it was associated with, or the Amounts each person paid.

This prevents you from allocating the payments correctly because the only thing we know is $750.50 was sent. We don't know if that was from 1 person or 20, nor the amounts or details of whom. 

The Solution:

A Report that exports ALL of the details the Balance the "View All Transfers" report provides before you export it. Because when you view that report, you can drill into each Transfer and drill down into the details of it. This is great, but incredibly time consuming when you have lots of transactions and lots of invoices.  The actual 'Export' of that report to .CSVC does not work because it's missing important information eg. Who, How Much, Invoice #'.

Without this vital information that combined Transfer cannot be registered appropriately in any accounting system because the Bookkeeper has no ideas what is all included.

Also, keep in mind that some customers will have multiple invoices, so the detail of WHICH one (invoice number) and WHICH Person (Customer Name) is imperative.

Please HELP me. I do not want to transfer off SQUARE. 

[Ria]

Thanks for stopping by The Ideate Board with your request @S3Adventures 

I appreciate you providing such detailed information to support your request, that will come in handy for our engineers who review these requests.

I do understand how important this request is to your business. 

At this time, this is not currently on the road map for development but is in the correct place to be considered to be implemented onto the platform.

Once this request has been reviewed, it will be marked as reviewed and an update will be provided.

Thanks again!

[S3Adventures]

This is an absolute shame. You literally provide the information on the screen but not the export.

Such a shame you hold all the power, meanwhile your clients struggle to manage the books because your product falls short of providing people what they need to keep it all straight. This is not a complicated ask, just make all the data available in the export and call it a day.

Still incredibly disappointing. 

[Camp4Fun]

Any update for this?  We would really appreciate having names attached to the transfer report!

[jlsims]

It is absolutely ridiculous that this can't be done! This is BASIC accounting info we bookkeepers need! We will be looking elsewhere for software.  So beyond frustrated!