Skip to main content
M
marumir05
March 7, 2023
Solved

Shopify shipping

  • March 7, 2023
  • 1 reply
  • 0 views

We use a third-party company to ship orders, we purchase shipping labels thru them which includes the shipping cost + tax.

 

In order for us to purchase shipping labels, we top-up the account (e.g. $200)

 

So our bank transactions show just the top-up amount of $200 and categorized it as "shipping".

 

Now we have a monthly statement from the third-party company that shows how much was spent on the shipping label and the tax.

 

Shipping label: $170

Tax: $30

 

1. How do we put this entry in QBO? As we also want to put them in separate categories, not just put the whole $200 in to "shipping" category.

 

We want the Shipping label: $170 in a separate category and the $30 for the Tax category.

 

Please help!

 

Best answer by JamaicaA

You can split the categorized transaction, @marumir05. I’ll provide you with step-by-step instructions to enter the amount for Shopify shipping and tax separately in QuickBooks Online.

 

If you already classified the transaction, we'll need to go back to the Categorized tab to return it to the For Review tab. From there, you can split the amount for the tax collected and Shopify shipping.

 

Here' how:

 

  1. Go to Banking, and then choose the Categorized tab.
  2. Find the transactions in question.
  3. Select the Undo button, and then hit Continue.

 

If you need to combine multiple transactions into a single record, you can check out this article: Record and make bank deposits in QuickBooks Online. 

 

This will help us ensure your QuickBooks matches your bank transactions. I've added these resources that will help you with matching transactions and reconciling your accounts:

 

 

Feel free to add any additional queries about categorizing transactions or any other banking concerns. I'm always here to back you up. Keep safe.

1 reply

J
JamaicaAAnswer
March 7, 2023

You can split the categorized transaction, @marumir05. I’ll provide you with step-by-step instructions to enter the amount for Shopify shipping and tax separately in QuickBooks Online.

 

If you already classified the transaction, we'll need to go back to the Categorized tab to return it to the For Review tab. From there, you can split the amount for the tax collected and Shopify shipping.

 

Here' how:

 

  1. Go to Banking, and then choose the Categorized tab.
  2. Find the transactions in question.
  3. Select the Undo button, and then hit Continue.

 

If you need to combine multiple transactions into a single record, you can check out this article: Record and make bank deposits in QuickBooks Online. 

 

This will help us ensure your QuickBooks matches your bank transactions. I've added these resources that will help you with matching transactions and reconciling your accounts:

 

 

Feel free to add any additional queries about categorizing transactions or any other banking concerns. I'm always here to back you up. Keep safe.

Terms & ConditionsAccessibility statement