This might be long.
I've got this
cash register. I like it.
Here is my daily Z tape reconciliation excel sheet: here
Here's the situation. The register can download directly to quickbooks, which I tried, and it's a pain in the butt. It is NOT done in a particularly helpful well. With the client tool, you can VIEW items in tables that look like excel spreadsheets, but you CANNOT import them to excel. (Grr.) I'm working on getting another card reader night now...but I don't think it's going to let me do it one way or the other.
I would like to simplify my Z as much as possible for daily reporting. We WILL be keeping the printouts for 18 months, so they will be accessible if I need to backtrack.
Right now I process the cash in house, email the spreadsheet to my boss who does his quickbooks thing, then I bring him the deposit and it goes in the bank. Soon I'll be doing the actual depositing, but for right now this is the way it is.
So...who's up for the task? Help me simplify! I've also got the drawer start/end sheets from the cashiers for the day which also get saved for 18 months, and I've got the daily batch reports from the CC machine.
For the record:
We're an NPO hardware store, averaging between $300 and $3000 in sales per day. All departments get hits, just not every day. Any more questions, email me or post 'em here.
Thanks in advance!!
Add on: is there a website to do it online? I'd <3 to have another backup, although I guess 3 is enough. Any and all advice is welcome!