How can I provide a Z report-like function for daily transaction reconciliation?

NicoleEll
Excursionist
11 2 3

Has anyone found a similar option to providing a Z report?  While I understand that it's not really the same as with QB POS since the payments were captured outside of the POS and Shopify payments captures them on it's platform. Our bookkeeper seems to need/desire the same type of report function in order to do her reconciling for daily transactions and to ensure we are balanced

Replies 9 (9)

Quartz
Excursionist
29 0 10
They have an app for that.
NicoleEll
Excursionist
11 2 3
Thanks. Anyone know what it's called??##- Please type your reply above
this line -##
Generic1user
Excursionist
26 0 25

Seriously? We need an app to be able to balance and report a drawer count at end of day on BRICK AND MORTAR POS system? This is a disaster shopify!

bdeaw
Shopify Partner
61 1 56
There is an option under more > register> "start tracking session" that
allows for setting a drawer starting amount.

At the end of the day you “end tracking session” and count the drawer. Then
you can print a report similar to the x or z out at the end of the night.
NicoleEll
Excursionist
11 2 3
Yes thank you this is what we currently do...but it's the "report" and what
it's called and where I find that I am looking for. Can anyone put me in
the right direction?

Thank you!
Amy_Dryden
Excursionist
23 0 22

Hi!  Go into the admin (log in on a browser, instead of logging in to the POS app on whatever you are using as a register).  You can then go to the "Analytics" section and get a wide variety of reports.  It's not as "all in one report" as the Z report, but everything is there!

NicoleEll
Excursionist
11 2 3
Yes thank you. We're using the payments report for the day to provide the
cash and cc totals.
SteelHead
Excursionist
39 0 49

Ha ha ha!!!!!!

BetterReports-K
Shopify Partner
176 6 16

Hi @NicoleEll,

 

Keanna here from the Better Reports support team. I would recommend our app Better Reports for this! 

 

We can create an end of day transaction report showing all transactions for each device in your POS location. We can show individual transactions or gateway (cash, credit card etc) totals. This can be scheduled to email or Google Sheets daily.

 

Better Reports offers more than 80 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. We can also help create custom reports to automate much of your daily workflows. 

 

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.