Need a Sales Report that includes deposits (without tax)
I'm trying to find a way to create a report for "Gross Sales" which includes all payments received (whether deposits for orders or layaways, not just cash&carry sales) but pre-tax. Many landlords require this and consider any and all payments received, regardless of when the sale is completed or if it is, as "Gross Sales". Even if there is a workaround to get these numbers. The issue I'm running into is if I simple just combine the sales report in lightspeed with the report of open orders at the end of the month, and I do the same the following month, I would be running into duplicates if the prev. months open order totals turned into completed sales for the next month. I hope this makes sense. As an FYI, I also signed up to lightspeed accounting and quickbooks online. I haven't set it up yet, but if there's a way through the integration to achieve what I need, that could work also. Prev to transitioning to lightspeed, we manually tracked everything in a ledger from an old register.
0 · Share on Google+