How are users of Shopify POS determining the correct amount of taxes to pay from the "Sales Report"
For example, if you do an order that has a partial payment Shopify treats it as a Sale. I realize I can look at the "Payment report" and see money collected but from that report, I do not know if the money received was for taxable items or not. And the "Sales Report" shows the total tax for the Total of the Sale (but in reality, I have not collected those funds yet because it is a partial payment or layaway.)
So anyone who is using Partial payments with Shopify how are you determining how much tax is owed to the "State" and "County." from the reports.
Really need some help with this.
All past POS systems i have used treat a layaway as a liability and places the items "on-hold" (removing form inventory) until paid in full then the correct taxes can be paid to the "State" and "County because the order is now really a completed sale once paid in full.
We do about 50 partial payment/layaway orders a month.
For example, if an order is $1000 the tax would be 7% or $70. If the person made an initial deposit of $100 and it takes them 8-10 months to pay in full it would be a gamble for me to go ahead and pay the taxes for the complete order amount ( we pay taxes each month) Because the person may decide not to get the item. So let's say I paid the full taxes $70, and let's say they made a total of $500 in payments, and they decide not to get the layaway, So I issue them a refund of the amount they paid $500 in cash or Gif-Card. That means I have paid $70 in taxes for no income received.