Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
nitsujayyy
Level 2

Recording free shipping expense and recording properly

Hi,

 

So with webgility i can import orders from shopify and shipstation (shipping cost) as a invoice for sales order and Bill for shipping expense.

 

When I want to pull a detail report on net customer sales (Sales-COGS), I'm not able to pull the shipping expense associated with the order. One way I can do that is record the total shipping expense as a line item and negate that with a Free Shipping item? Would that give me a accurate report?

 

Another question is that shipstation only gives me a close estimate reporting. I wait for the FedEx bill to record any other expenses outside customer order, but relevant to business such as samples shipping expense and etc. While I can sum up the order for shipping expense and adjust the amount in invoice, how do I also create a bill that wont duplicate the shopify expense, but will catch the other shipping expense I manually enter it? 

1 Comment 1
MirriamM
Moderator

Recording free shipping expense and recording properly

I'll be happy to provide answers to your questions to ensure that you can accurately record shipping expenses, leading to correct reporting in QuickBooks Desktop (QBDT), nitsujayyy.

 

To ensure that the shipping costs associated with the order are properly represented in a detailed report on net customer sales, it is recommended to add the shipping expense as a line item on the invoice or sales receipt, and then negate it with the Free Shipping Fee. This approach will provide an accurate representation in the reporting.

 

Regarding your additional inquiry about generating a bill that avoids duplicating the Shopify expense while capturing the manually entered shipping expense, you will need to document the FedEx shipping expense for non-customers as a separate shipping expense through a Bill transaction. For the appropriate expense account to utilize, I suggest consulting with your accountant to guarantee financial precision, adherence to tax laws, and effective management of your financial records.

 

For guidance on reviewing your accounts in QuickBooks Desktop and preparing them for the end of the year, you can consult this article: Year-end guide for QuickBooks Desktop. This resource is designed to help verify the correctness of your transactions.

 

If you find yourself with lingering questions or need a helping hand with your data management in QuickBooks Desktop, don’t hesitate to drop us a comment or kick off a new conversation. Your journey is important to us, and we're right here beside you, eager to offer guidance and support at every twist and turn.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us