My accountant is requesting proof of pending funds (the balance) at a specified date from my shopify store. This would seem like a pretty typical request, as shopify is acting essentially as a short term bank, holding our funds. The accountant wants to know what the amount of pending funds was at year end, so that he can report appropriately on our balance sheet.
Where can I determine this? Surely I can't be the only one that requires a report on this. I can get a report on just about everything else, but unable to find anywhere that I can get my balance, except the current balance as of today.
I also cannot see the right amount or a column called 'Balance'.
I went to Analytics > Reports > Payments - and the column headers I see are:
Payment Method - Accelerated Checkout - Credit Card - Sales Channel - Transactions - Gross Payments - Refunds - Net Payments
None of these say BALANCE and none of the amounts = what shows as the Shopify Balance in Freeagent.