Partial payments and taxes layaways

Jewelcam
Explorer
48 0 15

Hello All

 

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. 

 

 

0 Likes
CloudlabSam
Explorer
66 3 4

You would need to prorate the tax based on the amount paid. That may be complicated by whether shipping is taxed or not. Would seem easiest to just assume that you pay the entire tax amount if any amount of the order is paid. How many partial payments do you get?

0 Likes
Jewelcam
Explorer
48 0 15

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. 

0 Likes
CloudlabSam
Explorer
66 3 4

Gotcha. Is there a reason you can’t wait to pay the tax until the order is fully paid? That way you don’t need to do anything if there’s a partial pay that you refund. 

0 Likes
Jewelcam
Explorer
48 0 15

Yes i woud love to do that, but with Shopify POS I have not figured out how to run a report that would remove the partial paid items from the fully paid sales, so i can figure what taxes i need to pay. 

 

If you know where in SHopify i could run that type of report please help me.

 

thank you

0 Likes
CloudlabSam
Explorer
66 3 4

I'm not on the POS system right now - but if I go to my storefront admin and choose Analytics and then Reports I can select the Sales Over Time report. Then you can change the filter to payment status of "paid". This should limit to orders that are completely paid.

0 Likes
Jewelcam
Explorer
48 0 15
hi i have downloaded your app, thanks for making it free.

So exactly how do i run the report to only show taxes for fully paid
orders.

Then i would like to run a report on all orders that have an out standing
balance.

thank you
0 Likes
CloudlabSam
Explorer
66 3 4

I can see you in chat right now. Would be easier to explain there because we can go back and forth faster. Let me know if that doesn't work for you

0 Likes
Jewelcam
Explorer
48 0 15
ok
0 Likes