NEWQBO.COMQuickBooks Online Tutorial: QuickBooks 2020 Getting Started for Beginners
Sign up QuickBooks for a 30-day FREE Trial https://newqbo.com/test-drive/
Compare Features and Usage Limits of QuickBooks Online Plans – Advanced, Plus, Essentials, and Simple Start https://newqbo.com/features-and-usage-limits-in-various-quickbooks-online-plans/
Currently, there is no built-in Customer Sales Detail by the Sales Rep report to pay commission in QBO at this time.
The workaround in QBO is to use one of three available custom fields on the sales forms (invoice and sales receipt) for Sales Rep (as a text field). And then you can run the standard Sales by Customer Detail Report, and filter Group by Sales Rep. Since this is just a text field so you will need to assign sales rep every time you create an invoice or sales receipt.
With QBO Advanced version, you can assign Sales Rep at the Customer Information level but on other plans, such feature option is not available.
The following table will show features and usage limits available in various QuickBooks Online plans:
| Advanced | Plus | Essentials | Simple Start | |
|---|---|---|---|---|
| Features | ||||
| Price Rules | Yes | Yes | No | No |
| Inventory | Yes | Yes | No | No |
| Progress Invoicing | Yes | Yes | Yes | Yes |
| Track expenses and items by customer | Yes | Yes | No | No |
| Makes expenses and items billable | Yes | Yes | No | No |
| Purchase Orders | Yes | Yes | No | No |
| Track classes | Yes | Yes | No | No |
| Track locations | Yes | Yes | No | No |
| Projects | Yes | Yes | No | No |
| Time Tracking | Yes | Yes | Yes | No |
| Multi Currency | Yes | Yes | Yes | No |
| Recurring Transactions | Yes | Yes | Yes | No |
| Custom Fields | Yes | No | No | No |
| Manage Workflows | Yes | No | No | No |
| Import Data - Invoices from Excel CSV file | Yes | Yes | Yes | Yes |
| Budgeting | Yes | Yes | No | No |
| Customer Types | Yes | Yes | No | No |
| Customers - Delayed credit and Delayed charge | Yes | Yes | Yes | No |
| Accounts Payable (Bill & Pay Bills) | Yes | Yes | Yes | No |
| Enter Batch Transactions for Invoices, Checks, Expenses, Bills | Yes | No | No | No |
| QBO Support - Priority Circle | Yes | No | No | No |
| Apps: Chronobooks, Fathom | Yes | No | No | No |
| Usage limits | ||||
| Billable Users | 25 | 5 | 3 | 1 |
| Chart of Accounts | Unlimited | 250 | 250 | 250 |
| Classes and locations | Unlimited | 40 | Not available | Not available |
In this video, we will do a full comparison between various QuickBooks Online plans. We will do a deep dive into every aspect of Advanced, Plus, Essentials, Simple Start versions of QBO, and review all their features one by one. Hopefully, it will provide you with enough information to evaluate the right QBO plan for your business.
UPDATE: This import invoices from the Excel CSV feature is available on all QBO plans now. Steps: Gear – Tools – Import Data – Invoices.
As a general accounting method (especially if you’re an Accrual basis)*, you would record Prepaid Unearned Income from Customer to a Current Liability account. See the screenshot below for how to create this account in your Chart of accounts.
You’ve two ways of handling this, select one which works best for your business.
Option 1:
If you’re depositing this money in (and not creating Invoice), deposit to this account. And when ready to recognize income, write a Journal Entry (credit Income/Revenue account and debit Prepaid Unearned Income account).
Option 2:
If you’re creating an Invoice for this money in, you will need to add a new Product/Service item for this prepaid unearned income item. For the Income account field on the Product/Service information screen, you would select this Prepaid Unearned Income account. Create an Invoice using this item once to record prepaid deposit and create a 2nd Zero Invoice when ready to recognize Income (positive item) and clear Prepaid Unearned Income (negative item).
* If you’re on Cash basis accounting method, consult with your Accountant.
Currently, there is no such standard report in QuickBooks Online. However, you can run the Audit Log report for transactions and filter it to Show deleted/voided transactions and Using Accounts Receivable (A/R) as a source account for Invoices.
Unfortunately, you can print this report but not export it to Excel or PDF at this time.
Here’s how to run the Audit Log report for Deleted/Voided A/R Invoices:
Note: Click “View” under the History column and select “Show all” for Invoice details.
Price Rules feature is currently available in Advanced plan and Plus plan only. It’s not available in Essentials plan and Simple Start plan at this time.
How to turn Price Rules?
How to create Price Rules?
Note: you can also go to Price Rules page directly from the Products and Services page. Click “More” drop-down arrow and select Price Rules.
On the Price Rule page you can choose:
How to create a customer type?
How to assign a Customer type?
How to assign a Customer Type to multiple customers at the same time?
How to run a report for Price Rules or Customer Type?
Standard report is not available at this time. You can run the “Customer Contact List” report and customize this report to add a Customer Type column. Note: You can download this report to Excel and sort it as you need.
How to apply Price Rules to an Invoice or transaction?
When creating an Invoice, the price rule will automatically be applied per default sales rate as you add product/service items. You can also override the price rule by selecting the rate and seeing all active price rules.
