bookkeeper
-
Posts
3 -
Joined
-
Last visited
Content Type
Forums
Gallery
Blogs
Events
Store
Downloads
Profiles
Posts posted by bookkeeper
-
-
Selling product on website and also using SquareSpace Invoicing for Wholesale.
Wholesale customer paid by check. Not going to lie--I'm not turning away a payment.
How do I manage the invoices paid externally without deleting them?
-
I use the report at `[Home] Selling > Orders --> All Statuses --> Export` to capture and record SquareSpace sales for bookkeeping.
I am experiencing two problems around Sales Tax with this report.
1) Distinguishing Wholesale vs. Retail sales
It's difficult to distinguish between Wholesale and Retail sales. The Order report does not show notes, or tags (I think tags would be great). The feature `Lineitem taxable` has value TRUE, but as you can see in the example below no tax was collected on Order #75. After some further investigation, I see the feature `Lineitem sku` is different for same items which are taxed or not taxed.
All untaxed sales have SKU similar to : `CUSTOM-ef4c5722-XXXX-XXXX-XXXX-XXXXXXXXXXXX`. But not all `CUSTOM-*` are non-tax items.
Taxed sales, (like order #74) have a different SKU pattern: `SQ360XXXX`
--> Can the SKU be customized to differentiate Wholesale purchases? (ie. `CUSTOM-W-*`)
2) Non-tax item with no shipping tax?
For example order #75 here is not collecting sales tax on wholesale order.
--> Why is tax not charged on Shipping for all orders? Is there a tax-exempt feature I missed?
Order ID 00075 00074 Subtotal 894.60 50.00 Shipping 8.00 12.00 Taxes - 5.51 Total 902.60 67.51 Shipping Method USPS Priority USPS Priority Lineitem requires shipping TRUE TRUE Lineitem taxable TRUE TRUE
Order Report and Taxable/non-taxable items
in Commerce
Posted
Thank you for your response. I will look into those features.
Just to confirm, the two arrow pointers in the screenshot (On Sale, Unlimited Quantity) have no significance for the SKU--they're just what was in the Documentation screenshot.