Categories
Company Gear Company Settings Custom Form Styles Customer Center Customers Invoice Reports Sales

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.com. 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?”)

Categories
Customers Invoice Sales

How do I add a client purchase order onto my invoice, ie how do I show this on the invoice is there a custom column?

Sales Form Content - Custom Fields
Sales Form Content – Custom Fields

In new QBO, they’ve up to three custom fields selections available to customize invoice layout.
You can pick one field for Client Purchase Order Number.

From the Home page screen

  • Select the Company Gear (located top upper corner)
  • Select “Company Settings” under Settings header
  • Select “Sales” under Settings”
  • Select “Sales Form Content”
  • Select “Custom Fields”
  • This is where you add Client PO No.
  • Save and Done
  • See screenshot photo below for reference

Categories
Company Gear Company Settings Custom Form Styles Customer Center Customers Invoice

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