How do we pull a report that separates Cash Sales from actual cash on hand?

[rsilyan]

Good afternoon,

Currently when I look at my daily sales report I can see 

A. My total sales

B. What portion of my sales was paid with Credit card.

C. What portion of my sales was paid with Cash.

E. What portion of my sales was paid with other methods such as EBT.

In our business we do have cash payouts.  For example we payout to vendors from time to time, we pay out to customers for returning bottles that they paid a deposit fee on and so forth.  It is absolutely crucial that our totals at the end of the day weather they are credit card or cash payments match what is actually being deposited in our bank account.  Otherwise books will show undeposited funds that actually do not exist because those funds were payouts and the cash is no longer on hand.  This is a big big deal for our business and I am sure many others.  Any solutions available?  Thank you

[keicollective · Accepted solution]

Hi @rsilyan ! 

Square has a whole section on managing your cash drawers. They even have a "Paid Out" section to account for those withdraws you mentioned for vendors or deposit fees returned to customers. 

There's a pretty good article here to get ya started, but let me know if you have any follow up questions! 

https://squareup.com/help/us/en/article/5152-cash-drawer-management 

-Andrea  

[rsilyan]

Thank you Andrea,  I am aware of the paid out option and we use it.  however in the sales summery the paid out totals are not displayed.  You have to go into each day's drawer report to see payouts.  The issue is that the square reports show cash collected but do not account for cash paid out.  When we look at the full months sales and what was collected in cash it appears as if all the cash collected should is actual cash on hand with is not the case when you have payouts.  This creates a challenge with book keeping because then it makes it look like you have undeposited funds when in reality those funds were payed out.

Thanks again for your input.

[keicollective]

Ah, gotchya! I think this would be a feature request with Square to add the Paid Out info to reporting. I didn't see it as an option even in the custom reports, so they need to add that data to the reports area so you can include it. 

You can submit feature requests in the Ideate area of the community (I think this link works: https://www.sellercommunity.com/t5/Ideate/ct-p/Ideate but let me know if not) 

[rsilyan]

Andrea,  thank you that was very helpful.  I used the link you provided and submitted a request.  Thank you.