How to set up and use special pricing for selected or all customers in QuickBooks Online?
1. Setup New Customer Type (Dashboard > Sales > Customers > Customer types > New Customer type).
2. Turn on Price Rules (Gear > Your Company > Account and Settings > Sales > Products and Services > Turn on Price Rules).
3. Setup New Price Rules (Gear > Lists > Products and Services > Drop-down arrow under MORE > Price Rules).
4. Create Invoice or Sales Receipt (Create + sign > Customers) > Select (or use default) Price Rules under Rate column.
Educational and Instructional Video:
QuickBooks Online QBO Price Rules (aka Price Levels) – Special pricing for selected or all customers
The billable feature is available only in QuickBooks Online with Plus plan.
When you select “Billable” Expense checkbox field, you must also select a Customer/Project field each split line that is billable. If you don’t select Customer/Project field, you will get an error message. You can’t the save the transaction. (If you’ve Markup percentage turned on from the settings, you can also choose that field to alter that billable invoice amount).
By selecting “Billable” checkbox and Customer/Project field, it will do two things:
1) It will create an expense from that vendor.
Checking billable allows you, when you create an invoice, to move that expense to the invoice without having to retype it.
2) It also allows you to create an invoice to move those expenses automatically to the invoice without having to retype it again. In other words, you will see all open expenses ready to be included when you are ready to create invoices. Just create an invoice, select customer and right side Add to Invoice panel will open. You can choose “Add all” or each billable item.
To turn on the Use Billable Expenses preference:
Choose the Gear icon at the upper right corner > Your Company / Account and Settings.
Choose Expenses from the menu on the left.
In the Bills and expenses section, check on the Edit icon.
Place a check in the box to Make expenses and items billable.
Optional: you can also select Markup with a default rate of xx% box.
Transaction reference numbers help you easily identify transactions. QBO will automatically assign transaction numbers in sequence. But if you want to change the starting custom transaction number of your own, you can do so. You would want to turn the company settings ON once, assign a custom number and turn it OFF again so that QBO can identify number sequence based on the last transaction number.
A separate number sequence appears on:
Invoices, sales receipts, refund receipts, and credit memos
Delayed charges and Delayed credits
For Statements, QBO will automatically control the numbers that reference identify so you can’t change it.
QBO lets you customize your transaction numbers.
How do custom transaction numbers work?
When you turn ON custom transaction numbers:
You can change transaction numbers when you create or modify a transaction.
Transaction numbers can include letters (such as 2017-1001).
New transactions get new numbers (such as 2017-1002), based on the last transaction. You’ll be warned if you try to enter a duplicate transaction number.
When you turn OFF custom transaction numbers:
Transaction numbers are never changeable, even numbers created with custom transaction numbers on.
Transaction numbers are assigned when transactions are created.
Transaction numbers are sequential, based on the last number, starting at 1.
To turn custom transaction numbers ON or OFF from the company settings:
Click the Gear icon at the upper right corner > Your Company > Account and Settings).
For customer transaction numbers on sales forms:
Click “Sales” on the left, and then click the edit icon for “Sales form content”. Select the “Custom transaction numbers” checkbox, and click Save.
For custom numbers on purchase orders:
Click Expenses on the left, and then click the edit icon for Purchase orders. Click the “Use purchase orders” checkbox. Select the “Custom transaction numbers” checkbox, and click Save.
To reset your transaction numbers again:
Select the Custom transaction numbers checkbox, and click Save
Create a transaction with a new starting number.
Clear the Custom transaction numbers checkbox, and click Save.
It will show as viewed whoever viewed it (primary or cc). If it’s viewed by both it will show as viewed twice.
Viewed Status Icon: If you open sales transactions (left navigation bar > transactions > sales) under status column, it will show many have opened the invoice and viewed it. It will show one black icon if viewed by one person or two black icons if viewed by both. See attached screenshot.
(Note: In case, you do not see Status column and need to add, go to middle Gear at the far right and select show more and add status column).
Invoice Activities: Open the invoice in question from the sales transactions or directly from customer center. Under activities (below invoice balance due, next in line to attachments), it will show invoice viewed with date and time record. But it is not possible to identify who actually viewed it (primary or cc person), especially if viewed by just one person unless one or both replied with the message. See attached screenshot.
This has to do with reflecting accurate direct expenses related to customers on Income by Customer Report.
If you are depositing a vendor/supplier refund for an expense that was previously Billed to a customer, select “Track returns for customers” box and choose that same customer on the deposit and mark it Billable.
For example, if you buy a material for a customer’s job, you would bill the expense to the customer. But if the customer later returns the material to you and you return it to the vendor/supplier for a refund that you are depositing, you need to mark the deposit billable to that same customer and also select “Track returns for customers” box. Otherwise, it will show as customer billed for the material expense, and the vendor credit will not appear on Income by Customer Summary Report.
Here is an example of what happens when $1,000 billable purchase returned to the supplier for a refund and deposited that money in the bank. The goal is to show zero expense related to that customer.
SHOWING RESULT WITHOUT BILLABLE AND RETURNS FROM CUSTOMERS
SHOWING RESULT WITH BILLABLE AND RETURNS FROM CUSTOMERS
QuickBooks Online Plus: Track returns for customers box on Deposit Form