cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
1231 4613 1578 079
Level 1

I want to export profit for each Invoice order ,How does our test fee ,shipping fee and Invoice relate in QB, so I can export it directly?

should I need to set up bilable expense for test fee and shipping fee, and then create it in relate Invoice. The amount of expense is 0?So I can see the Income and related expenses in report for this order
1 Comment 1
JenoP
Moderator

I want to export profit for each Invoice order ,How does our test fee ,shipping fee and Invoice relate in QB, so I can export it directly?

There's a default expense account for shipping and delivery expenses, customer.

 

Although, you can still create a dedicated expense account for billable expenses. Here's how:

 

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Click New in the upper right-hand corner.
  3. Select Expenses in the Detail Type, then use the correct detail type that you want.
  4. Click Save and close.

 

Then, create a billable expense for the shipping cost so you can add it in your invoices. You can follow the steps in this article on how to record and track the expenses that will be billed to your customers: Enter Billable Expenses.

 

After that, you can now add the billable expense when creating an invoice. Here's how:

 

  1. Click the + New. button and select Invoice.
  2. Select the name of the customer you created a billable expense for. This opens the Add to invoice window.
  3. Click Add on the billable expense you want to charge to your customer.
  4. Select Save and close.

 

Once done, run the Profit and Loss report. Then, look for the billable expense account to check how much you've spent on shipping. Just click the amount of the expense account  to see the list of transactions that has shipping fee. 

 

You can also follow the steps in this article on how to export the data: Export Your Reports to Excel From QuickBooks Online.

 

Please don't hesitate to reach out to us again or directly reply to this thread if you have follow-up questions. We're always here to help.