Skip to main content
H
HD01234
February 23, 2024
Question

Adding Formulas To An Invoice

  • February 23, 2024
  • 1 reply
  • 0 views

I run a photography company, and have just transitioned to Quickbooks Online. When I invoice, I charge clients on a per image basis. However, when clients get larger orders with more photos, there is a bit of a discount on the per image price. So for instance, at 12 images, it's $120 so $10 per image, but at 48 it's $385 so about $8 per image. I set all these prices by graphing out a point slope formula so everything is consistent as the orders go up.

 

My question being, is there a way to put this formula into an invoice template so that whatever number of images I deliver to a client, I can input that number and will get the exact price on that line, or will I need to calculate it myself every time or have an entry in the services tab for numbers 12-48?

1 reply

A
Amanda-B
February 23, 2024

Hey there, HD01234.

 

I appreciate you joining us here in the Community. QuickBooks provides the option to add discounts to your invoices when you need to. I recommend taking a look at these two helpful articles to see which option would best fit your business needs. 

 

1. Add a discount to an invoice or sales receipt in QuickBooks Online. https://quickbooks.intuit.com/learn-support/en-ca/help-article/service-items/add-discount-invoice-sales-receipt-quickbooks/L3VyP6cwJ_CA_en_CA?uid=lsz27f5t

2. Set price rules in QuickBooks Online https://quickbooks.intuit.com/learn-support/en-ca/help-article/mobile-apps/set-price-rules-quickbooks-online/L5jI9VwXt_CA_en_CA?uid=lsz39y3c

 

If these options are not meeting your business needs, feel free to leave feedback for our developers. Comments are viewed and considered as they create new features and updates for QuickBooks.

 

If you have any other questions, feel free to reach back out here. 

Terms & ConditionsAccessibility statement