Good Day.
Wonder if anyone can assist.
We work with QBDT Premier 2017.
We want to be able to have a column on our estimates and invoices where we can change the markup as we go. We charge different clients different markups so dont want to change it on the product itsself in the "back-end" as we would constantly need to change it back and forth.
I.e. ABC Stores has a 20% markup on a chair. JOE SOAP has a 15% markup on a chair. So i want to be able to have a column where i can customise the markup on the estimate or invoice.
Am i missing something simple, or is it not as simple as I think?
Thanks in advance!
Welcome and good day to you also, @Melyssa1.
I know how to add a column for Markup in your Invoice and Estimate form, and I'll gladly assist you with this.
Please know that after you add the Markup column, it won't calculate the amount automatically. You'll need to calculate the amount manually and place it there.
Let's start by adding the column to your Invoice form. You can add it in the Formatting section when you create an invoice transaction. Here's how:
Also, check the Template used when adding the column since this only applies to that invoice template. If you want to see the Markup column on all invoice templates, repeat the steps above for each of them.
To add the Markup column to the Estimate form, go to the Customer tab and select Create Estimates. Then, follow the steps above, and the Markup column will appear in the form.
You may want to learn how to modify sales form templates before sending them to your customers. Check out this article: Use and customize form templates.
Please return here if you have additional questions about managing your invoice and estimates form. We'll assist you as soon as possible. Take care, and have a good one.
@Melyssa1 RE: We want to be able to have a column on our estimates and invoices where we can change the markup as we go.
Unfortunately there's no way to create a column that impacts the invoice calculation. The custom field @Bryan_M recommended will function like a memo/text and won't have any actual impact on the Amount.
Some versions of QuickBooks include a feature called Price Levels which may help. Check in your preferences to see if you have this feature. Start at Edit | Preferences | Sales & Customers | Company Preferences and see if you have a section there for Custom Pricing:
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here