cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
cbw73
Level 1

Can I easily track indiv customer acquisition costs in QBO? I have referral discounts showing up as a sales reduction, but I'd like to track as an expense for LTV calcs.

I'm trying to understand our payback on different referral programs. All my data is exported from shopify. Do I need to adjust each sales invoice to remove the discount and then add an expense for each customer - or is there a better way?
1 Comment 1
Jen_D
Moderator

Can I easily track indiv customer acquisition costs in QBO? I have referral discounts showing up as a sales reduction, but I'd like to track as an expense for LTV calcs.

Thanks for reaching out to the community, @cbw73.

 

I wanted to share some insights about this customer management concern in QuickBooks Online.

 

If you need to update the details of your existing transactions in QuickBooks Online, you will need to do it one at a time. You can remove the discount and then add a service item mapped to the expense account you want to use.

 

Create a service expense item using these steps:

 

  1. Go to the Sales menu and select the Products and services tab.
  2. Click New.
  3. Choose Service.
  4. Add the name of the item.
  5. From the Category ▼ dropdown, select the category that best describes the expense. Learn more about item categories.
  6. Fill out the rest of the fields as needed.
  7. When you're done, select Save and close.

 

Once done, you can assign this item to the invoice by adding a negative amount to reduce the total balance.

 

Other than that, you can also use journal entries to make adjustments. However, we do recommend that you reach out to an accounting professional for this option. Adjustments to your balances needs thorough guidance. We can only provide the steps you need to do in QuickBooks, but handling your books and doing journal entry transactions is best assisted by your accountant.

 

If you don't have one, we can help you find someone to help you. You can visit the following link to locate accountants based in Canada: https://quickbooks.intuit.com/ca/find-an-accountant/

 

Visit us again for other Quickbooks concerns. You can also mention me if you have questions about this sales topic. I'll be more than happy to help. Have a good one!

Need to get in touch?

Contact us