Best Practice for Entering Sales and Taking Payments for a Bar

I'm a new office manager/bookeeper for a bar. We are using Square but I don't think we are using it to it's potential and I've seen some 'quirky' things.

I'm familiar with Square, having used it for an online business seamlessly, but in person is new and I have some questions.

Our sales summary report is 'doubling up'. The item sales report is fine.
The card transaction show the correct amount, the cash amount is out (it is actually the total sales) and the total sales add the two together.
eg:
Payment Collected
Card $200
Cash $450 (this is really the total sales, and the cash sales are actually$250)
Total $650 (total was really $450)
When I reconcile, I take this into account and everything balances, no additional payments are recorded, but there must be a way to correct this.
We have an ipad and a square terminal.

What is the best practice? I've looked through the documentation but haven't been able to find much in the way of tutorials for staff.

643 Views
Message 1 of 11
Report
2 Best Answers
Square Champion

Solution

As for your guess about why they are entering custom amounts, anything is possible.  It could be as simple as the fact that no one knows how to add products to catalogs anymore, or maybe prices are wrong.  So it sounds like you might need to review how the item catalog is set up, ask employees "why" they resort to custom amounts, and try to figure out how you can minimize it with more/better items in your catalog.  Good luck with that.  Training people to do things the "right" way is never easy.

 

Otherwise, you are welcome.  Do not hesitate to reach out if you have any more questions.  As you are on the Canadian help forum, I won't see any new posts that you make.  But feel free to "tag" me to alert me to a question you might have.  I'm doing all of the accounting and even taxes for my business, and in a previous life I was a designer/programmer for accounting software at the corporate level.  I'm pretty sure I can assist you with how Square works in that regard  To tag me, just type @ followed by TheRealChipA.  As you type it will autofill for you.

 

Best,

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!

View Solution >

521 Views
Message 8 of 11
Report
Square Champion

Solution

@AnnieZC 

 

Re: your report about the connected terminal solution, yay.  I'm happy that part is working.

 

To your questions -- I'm afraid not, at least not in connected terminal mode.  In order to do what you want, you would have to exit that mode, switch to Restaurants mode, enter a sale and then complete it before returning to connected terminal mode.  It's not exactly an elegant solution, eh?  Anyway that's not the way that mode was designed.  It's one or the other, from a practical point of view.

 

Your only choices involve a second device to be used as a remote order-taking device.  You can use another Terminal configured in Restaurants mobile mode.  OR, you could possibly use the new Square Handheld, which has advantages of its own (other than it can't swipe cards, but hopefully your don't have that problem in CA like we do in the US whee swipe-only cards are still plentiful.  Sigh.)

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!

View Solution >

137 Views
Message 10 of 11
Report
10 REPLIES 10
Square Community Moderator

Hi @AnnieZC, thank you for your inquiry here on the Square Community. Welcome!

 

I am going to go ahead and tag in a few of our knowledgeable Square Champions on this and see if they may have some insight on this. @doc_choc@artizansty, and @TheRealChipA, are any of you familiar with some best practices for a situation as such?

Sammie_C
Community Moderator, US, Square
Sign in and click Mark as Best Answer if my reply answers your question :sparkles:
555 Views
Message 2 of 11
Report
Square Champion

Hi there @AnnieZC 

 

Welcome to Square.  I see your numbers above but it's really important for me to see the actual sales summary report.  Since you shared numbers, I'm assuming that you aren't so concerned about posting a screen shot of your actual sales summary report.  What you are describing is not how Square does reporting, so I'm guessing you are either dealing with a bug/anomaly OR you are reading the report wrong.  Either way, I can't be sure where to start without the actual report -- not a description of the report.

 

To post a screen shot here, just take it and save it somewhere.  Then click on the little camera icon in your post editor window and attach it.

 

Thanks

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
548 Views
Message 3 of 11
Report

These are made up numbers in my original post, but here are some actual screen shots.

1130.40 shows as our sales...
However:

818.50 was the actual total sales, with 402.66 on cards and 415.84 cash.


Some things are showing up as "uncategorized" - we don't count these (and I was told "we don't know why it shows like that, just ignore it 🤔 - that's not how I roll ha!). All our items are in categories, but it looks like they are entering some things as "custom". I don't think this is how it should be done 😉
On the report for this day, the uncategorized is $311.90, and that is the difference. I want to get this sorted so we can take the next step and have Square import right into our accounting system.

 

Screenshot .png

 

 

Screenshot 2.png

539 Views
Message 4 of 11
Report
Square Champion

@AnnieZC Thank you so much.  Also, thank you for explaining the uncategorized sales is the exact amount you are off.  I was pretty sure that the cash/card thing could not possibly be the real problem.  Now..

 

Whatever idiot told you to ignore the uncategorized sales needs to be flogged (and maybe fired, especially if they are a Square support person @Sammie_C.). Statements like that make us accounting nerds roll over in our graves.  NEVER ignore a number, as you already proved you understand.

 

Yes, if you a) see a sales as uncategorized and b) your are dead certain that all of your items have categories assigned to them, then you can be 100% certain your employees are adding custom amount to their transactions.  You have two choices here if you don't want them to do that, which I would recommend:

 

  1. Put the fear of god in them and tell them that custom amounts are punishable by unemployment, then follow through, or
  2. Go to your team permissions and toggle off the Checkout permission "manually enter custom amounts."  Custom amounts will still be allowed, but a manager override will be required.

Otherwise, your report looks like you are good to go.  May I ask how you are planning to do your daily revenue accounting?  And what accounting software you use?  Of course, you can manually enter these numbers but I know a few very good third-party apps that automatically do all of the revenue accounting journal entries for you (for a small fee, of course).  I'm using one and don't regret that expense even a little.  LOL

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
535 Views
Message 5 of 11
Report
Square Champion

@AnnieZC I hit the send button too soon.  There's more.

 

Don't forget that "total sales" in your report includes taxes and tips.  No, these are NOT sales.  They are receipts.  I'm beating the drum with Square product teams every chance I get that they need to correct the name of that line.  I think they are starting to listen.  Anyway, your total card amount INCLUDES taxes and tips -- not just product sales.

 

One last thing.  Square is working on a beta for a new report that will show us exactly how they arrive at our bottom-line deposit each day.  It is in Reports > Accounting > Reconciliation.  For now, it is a beta report with more than a few issues and bugs, so don't rely on it until it is fully released.  But you might want to look at it to see where they are going with it.  To me, it will be THE perfect Square report.  

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
532 Views
Message 6 of 11
Report

The previous person doing this job 😅 

Your response made my day. Wonderful human that just has a different way of doing things.

I'm slowly changing some processes.
The sales were all entered manually on a spreadsheet, and then at the end of the month added to QuickBooks using a journal entry <<cringe>>. Then they reconcile to the bank outside of QuickBooks...
I am still using the spreadsheet as we have some other complexities and if someone else is reconciling the day for me, this is what they are familiar with. I am entering the daily sales, charges, deposits so that I cab have daily report, up-to-date figures, and can reconcile in QuickBooks. 

It's the front end entering in Square using the terminal and ipad that I am not familiar with. Could it be they are entering the total from a clients tab on the terminal independent of what is on the ipad? I want to have it all straight and the correct process clear for them before putting the fear of god in them 😉

Thank you so much for your answers!

524 Views
Message 7 of 11
Report
Square Champion

Solution

As for your guess about why they are entering custom amounts, anything is possible.  It could be as simple as the fact that no one knows how to add products to catalogs anymore, or maybe prices are wrong.  So it sounds like you might need to review how the item catalog is set up, ask employees "why" they resort to custom amounts, and try to figure out how you can minimize it with more/better items in your catalog.  Good luck with that.  Training people to do things the "right" way is never easy.

 

Otherwise, you are welcome.  Do not hesitate to reach out if you have any more questions.  As you are on the Canadian help forum, I won't see any new posts that you make.  But feel free to "tag" me to alert me to a question you might have.  I'm doing all of the accounting and even taxes for my business, and in a previous life I was a designer/programmer for accounting software at the corporate level.  I'm pretty sure I can assist you with how Square works in that regard  To tag me, just type @ followed by TheRealChipA.  As you type it will autofill for you.

 

Best,

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
522 Views
Message 8 of 11
Report

@TheRealChipA

 

I got around to digging into this because the staff was entering sales on the Square stand and then using the Square terminal to take a payment by simply entering the payment amount (not linked to the sale).
I went through the process of setting the stand to send the sale to the terminal for payment, and the issue was solved! Yeah! 

Next issue, the bartender tells me today that she cannot enter sales on the terminal. Only receive payments? The "Powered by Square" screen displays and you can't tap to get anything else. All it will do now is take the payments.
Surely you can do both on the terminal? 

166 Views
Message 9 of 11
Report
Square Champion

Solution

@AnnieZC 

 

Re: your report about the connected terminal solution, yay.  I'm happy that part is working.

 

To your questions -- I'm afraid not, at least not in connected terminal mode.  In order to do what you want, you would have to exit that mode, switch to Restaurants mode, enter a sale and then complete it before returning to connected terminal mode.  It's not exactly an elegant solution, eh?  Anyway that's not the way that mode was designed.  It's one or the other, from a practical point of view.

 

Your only choices involve a second device to be used as a remote order-taking device.  You can use another Terminal configured in Restaurants mobile mode.  OR, you could possibly use the new Square Handheld, which has advantages of its own (other than it can't swipe cards, but hopefully your don't have that problem in CA like we do in the US whee swipe-only cards are still plentiful.  Sigh.)

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
138 Views
Message 10 of 11
Report

Well, that sucks 😂 I couldn't find anything on this specifically, so thank you for the reply!


Odd that it can't do both! Ugh.
It's only going to be an issue when it is really busy or we have more than one employee working. 
You are right in that we have very few (if any) tap only cards here.

131 Views
Message 11 of 11
Report