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.
