How to run customized Sales Report by Sales Rep in new QuickBooks Online?

There is no built-in business report available by Sales Rep in new QBO at this time. By using available custom field on the sales forms (invoice and sales receipt), you can easily get the information by selecting and customizing standard built-in “SALES BY CUSTOMER SUMMARY” report.

This quick and easy tutorial video shows you how to customize sales report by sales rep for tracking sales and manually computing sales commissions in the new QuickBooks Online (QBO).

Here is another top-rated tutorial video by VPController for newqbo.net. We encourage you to watch the entire video.. You do not want to miss a step!

Sign up QuickBooks subscription for new company. Or add additional company subscription for using the same user ID (choose “Already have an Intuit user ID?”)

How to handle early payment discount taken to an invoice when a customer pays on time? Example: 1% 10, Net 30 or 2% 10, Net 30

In ideal accounting process, I would think handling discount taken by the customer would be part of “Receive Payment” form screen. They will have the additional line to enter discounts given to the customer as negative amount entered and thereby would match customer payment amount.

Since QBO Receive Payment screen is unable to handle this specific transaction, you will need way-around approach. No doubt, it is unnecessary and time-consuming steps to handle such a simple customer payment transaction.

You will need to create a CREDIT MEMO for early discount taken by the customer. See photo#3 for reference.

For one-time, you will also need to create new GL account for “Discounts given” (see photo 1) and new Service item for “Early Payment Discounts” (see photo 2).

Once you’ve created Credit Memo, go to Receive Payment screen, apply for payment against the open invoice as well as apply subtract early payment discounts to match customer payment. See photo#4 for reference.

See screenshot photo#5 for reference to how it will show Discounts given in P&L.

See screenshot photo#5 for reference to how it will show Discounts given in P&L.

Need better way to handle discount taken by customer, add to QuickBooks Online Feature Requests here:

http://feedback.qbo.intuit.com/


 

Photo#1

Open new GL Account
Open new GL Account

Photo#2

Create new Product Item for Early Discounts Taken
Create new Product Item for Early Discounts Taken

Photo#3

Create Credit Memo
Create Credit Memo

Photo#4

Receive Payment Screen
Receive Payment Screen

Photo#5

Profit & Loss with Discounts Given
Profit & Loss with Discounts Given

 
[table id=39 /]

We need to pay Sales Commissions based on Sales Invoices paid date. How to run a Customer Sales report that will tell me exactly what invoices were paid in a specific date? 

To do this job, you can run “Sales by Customer Summary” report.
You will need to customize the report to show daily sales and change to cash basis.
If you are using custom fields for sales rep on the Invoice, you can match the sales by Sales Rep as well.
See attached screenshot photo1, photo2 and photo3 for reference.

qboe-customize-sales-summary-by-days1
qboe-customize-sales-summary-by-days2
qboe-customize-sales-summary-by-days3