Financing, tax rates, and accounting
Is there a report that shows the cash removed/added from the tills? To find these , we are currently having to drill down in each till every day and that consumes a lot of time with more than 30 tills. We reconcile cash in a way that allows us to find cash discrepancies and the transactions are part of that.
Following this thread, because I have been searching the Shopify Community for this same information. If a report is NOT available, this needs to be a priority with Shopify to rectify ASAP! It's an accounting necessity!
Between this issue and the inability to do a partial refund on an item for a discount that wasn't applied with the proper tax identified appropriately, Shopify has become my 'Bookkeepers nightmare'!🤦🏼♀️
Since they now have the Cash Tracking, adding this reporting feature should be a simple programming task!
Be aware that the cash tracking report and the financial summary reports don't always tie out. There are issues with some returns not being in one report but are in the other.
Thanks for the warning KP_Enterprises! I'm discovering a number of things that don't tie-out between different reports! Uggggg......
I have discovered that the majority of the tie-out issues with the Finance Summary are related to the inability of Shopify to properly handle a 'partial refund'. I've discovered that I can readily identify these by filtering for 'Unknown' transaction type! The rest of the discrepancies have been 'Draft Orders'. Doesn't make sense that 'Draft Orders' is listed as a Sales Channel, but Shopify doesn't list 'Draft Orders' in the All Channels drop-down menu.
I was aware of the draft orders but I didn't think about looking at unknown transactions for partial refunds. Thanks
It looks like this was never resolved? We have been struggling with this and other refund/exchange/gift card credits. Having access to cash/credit refunds would be an excellent place to start.
It doesn't appear to be a priority 'fix' with Shopify, although this is causing accounting nightmare issues!
Right!? I'm pulling my hair out over here. We keep adding whatever I can't reconcile into a clearing account in our accounting system. I'm wondering if there's a POS reporting app. There are so many apps...
Thank you to everyone who participated in our AMA with Klaviyo. It was great to see so man...By Jacqui May 30, 2023
Photo by Marco Verch Sales channels on Shopify are various platforms where you can sell...By Ollie May 25, 2023
Summary of EventsBeginning in January of 2023, some merchants reported seeing a large amo...By Trevor May 15, 2023