QuickBooks Online: Commissions Due Report

Commission calculation is handled many different ways by different companies. Based on feedback from many of our subscribers, we have put together a basic commissions due report. If this does not meet your particular requirements, talk to us... we can put together a quote for a custom commission report to meet your needs.

NOTE: The commission report will only be available to you if you are on either our Sales Force or Full Circle package.

Here's an overview of how the Crik-IT commissions due report works:

You assign a commission rate for each customer. If no commission rate is assigned for a customer, commissions will not be calculated on sales to that customer.
You indicate if an item is commissionable or not. Commissions are only calculated on sales of items that you indicate are commissionable.
Commissions are calculated on invoices that were paid in full during the reporting date range. Any line on the invoice that is for an item that is commissionable will have commission calculated as follows: quantity sold x price x customer's commission rate.
Credit memos "paid in full" (i.e. applied in full) during the reporting date range will show negative commission.

Here's a sample commission report:

Here's how you set up a commission rate for a customer:

For each customer who's sales should generate commissions, in the QuickBooks Online customer notes field, enter "CommRate:" followed by the commission rate, followed by a percent sign (%).
Here's an example of a customer who's sales generate 25% commission.

Here's how you indicate if an item is commissionable

You have two options.

Option 1 - Use the QuickBooks product SKU field
- For each item for which commissions should be calculated, put "commissionable" somewhere in the QuickBooks SKU field of the Product/Service setup page.

Option 2 - Use the QuickBooks product purchase description field
- For each item for which commissions should be calculated, put "commissionable" somewhere in the QuickBooks Online purchasing description area of the Product/Service setup page.

Things to be aware of:

Credit memos fully applied during the report period will appear on the report as negative values.
If a transaction is paid in full, that transaction will appear on the commission report if paid-in-full date is within the report date range. If the payment is reversed/voided/deleted making the transaction no longer paid in full, if the commission report is run again for the same date range as before, that invoice will no longer appear on the report since it is no longer paid in full.
Paid-in-full date will be the latest of:
- Transaction date (e.g. invoice or credit memo date)
- Payment date
QuickBooks Online nitty gritty idiosyncrasies to be aware of:
- If you enter a payment on 4/1/2018 of $100 and apply $25 of that payment to an invoice dated 3/15/2018, that invoice will have a paid-in-full date of 4/1/2018. Then, on 5/1/2018 you apply the other $75 of that payment to an invoice dated 5/1/2018, for the sake of the commission report the paid-in-full date will be 5/1/2018 (but in QuickBooks, the payment date will show as 4/1/2018).
- In QuickBooks, when you create a credit memo (cm), when you save that credit memo QuickBooks may (depending on your QuickBooks configuration) automatically apply it as payment to any open invoices it can using the current date as the payment date. So, if you enter a credit memo and intentionally change the credit memo date to something other than the current date, when you save that credit memo and QuickBooks creates payments to apply that credit memo to open invoices, QuickBooks uses the current date as the payment date, regardless of the date you entered as the credit memo date. That means that the invoice(s) the cm is applied to, and the cm "paid" date will have a paid date in QuickBooks of the date the cm is entered, not the actual date of the cm. The commission report will use the later of the transaction date or the paid date as the paid-in-full date.
- If a credit memo (cm) was used while applying credits or payments to an invoice, the commission report will indicate that a credit memo may have been used as a partial or full payment for the specific invoice. Here's more info on how QuickBooks handles using credit memos to pay invoices.

How can we help you today?

Search

NOTE: The commission report will only be available to you if you are on either our Sales Force or Full Circle package.

Here's an overview of how the Crik-IT commissions due report works:

You assign a commission rate for each customer. If no commission rate is assigned for a customer, commissions will not be calculated on sales to that customer.

You indicate if an item is commissionable or not. Commissions are only calculated on sales of items that you indicate are commissionable.

Commissions are calculated on invoices that were paid in full during the reporting date range. Any line on the invoice that is for an item that is commissionable will have commission calculated as follows: quantity sold x price x customer's commission rate.

Credit memos "paid in full" (i.e. applied in full) during the reporting date range will show negative commission.

Here's a sample commission report:

Here's how you set up a commission rate for a customer:

For each customer who's sales should generate commissions, in the QuickBooks Online customer notes field, enter "CommRate:" followed by the commission rate, followed by a percent sign (%).

Here's an example of a customer who's sales generate 25% commission.

Here's how you indicate if an item is commissionable

You have two options.

Option 1 - Use the QuickBooks product SKU field

For each item for which commissions should be calculated, put "commissionable" somewhere in the QuickBooks SKU field of the Product/Service setup page.

Option 2 - Use the QuickBooks product purchase description field

For each item for which commissions should be calculated, put "commissionable" somewhere in the QuickBooks Online purchasing description area of the Product/Service setup page.

Things to be aware of:

Credit memos fully applied during the report period will appear on the report as negative values.

Paid-in-full date will be the latest of:

Transaction date (e.g. invoice or credit memo date)

Payment date

QuickBooks Online nitty gritty idiosyncrasies to be aware of:

If a credit memo (cm) was used while applying credits or payments to an invoice, the commission report will indicate that a credit memo may have been used as a partial or full payment for the specific invoice. Here's more info on how QuickBooks handles using credit memos to pay invoices.

How can we help you today?

Search

NOTE: The commission report will only be available to you if you are on either our Sales Force or Full Circle package.

Here's an overview of how the Crik-IT commissions due report works:

You assign a commission rate for each customer. If no commission rate is assigned for a customer, commissions will not be calculated on sales to that customer.

You indicate if an item is commissionable or not. Commissions are only calculated on sales of items that you indicate are commissionable.

Commissions are calculated on invoices that were paid in full during the reporting date range. Any line on the invoice that is for an item that is commissionable will have commission calculated as follows: quantity sold x price x customer's commission rate.

Credit memos "paid in full" (i.e. applied in full) during the reporting date range will show negative commission.

Here's a sample commission report:

Here's how you set up a commission rate for a customer:

For each customer who's sales should generate commissions, in the QuickBooks Online customer notes field, enter "CommRate:" followed by the commission rate, followed by a percent sign (%).

Here's an example of a customer who's sales generate 25% commission.

Here's how you indicate if an item is commissionable

You have two options.

Option 1 - Use the QuickBooks product SKU field

For each item for which commissions should be calculated, put "commissionable" somewhere in the QuickBooks SKU field of the Product/Service setup page.

Option 2 - Use the QuickBooks product purchase description field

For each item for which commissions should be calculated, put "commissionable" somewhere in the QuickBooks Online purchasing description area of the Product/Service setup page.

Things to be aware of:

Credit memos fully applied during the report period will appear on the report as negative values.

Paid-in-full date will be the latest of:

Transaction date (e.g. invoice or credit memo date)

Payment date

QuickBooks Online nitty gritty idiosyncrasies to be aware of:

If a credit memo (cm) was used while applying credits or payments to an invoice, the commission report will indicate that a credit memo may have been used as a partial or full payment for the specific invoice. Here's more info on how QuickBooks handles using credit memos to pay invoices.

Related articles