For teams that run on QuickBooks Online
QuickBooks Online sales commissions, per rep
QuickBooks Online does not work out commissions, and a payment carries no sales rep. Sales teams put the rep in a custom field or a class, export the paid invoices to a spreadsheet and work out each person's share by hand.
How it goes today
- Export the invoices with the sales rep field.
- Match each invoice to its payment and payment date.
- Apply each rep's rate in a spreadsheet.
- Send each rep their figure and answer their questions.
How it can go
Each rep gets a commission statement based on what customers paid.
After each month you get a statement per rep: the invoices paid in that month, the amount paid and the commission at the rate you set per rep or per product. The rep comes from the custom field or class you already use. You check the totals before each rep gets their own statement.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. QuickBooks Online works with a sign-in instead of a key: you sign in to QuickBooks Online once to give access, never in the chat.
With Hypamoon, after each month, look at the invoices in QuickBooks Online that were paid in that month, take the sales rep from our custom field, and work out the commission per rep at the rates I give. Count partial payments when they come in. Show me a statement per rep to check, then email each rep their own statement.
You create your own app on the Intuit Developer Platform and connect your QuickBooks company once. It stays yours.
More for teams on QuickBooks Online
- My customers want a receipt when they pay, and I send each one by hand.
- I want statements to go out every month, only to customers who owe us.
- Every month I add up the reports of each company in a spreadsheet.
- Working out interest on every late invoice takes too much time.
- We raise prices each year and change every recurring invoice one by one.
- I want to download a full year of receipts at once for my accountant.
- I want to see per customer how many days they take to pay.
- A customer pays many invoices at once and I match each one by hand.
- I make several purchase orders by hand from every estimate.
- I keep a spreadsheet to spread prepaid bills over the months.
- I want customers who do not answer an estimate to get a reminder.
- Can you set credit limits for customers to stop invoices or orders being raised?
- QuickBooks Online doesn't let nonprofits create end-of-year donation letters for donors.
- It does not create a proper Canadian tax receipt.
- We need a report that HMRC accepts when making a Gift Aid claim.
- Can I set up expenses to split automatically to classes by percentage?
- How do I set up payment scheduling on an invoice?
- Is there a way to have QuickBooks flag a duplicate bill we entered by hand?
- How do you reconcile supplier statements to QuickBooks Online, like a bank statement?
- I need to add retention to an invoice and release it when the job is complete.
- Is there a report for economic nexus with another state?
- What is the best way to track restricted funds for my nonprofit?
- Is it possible to sell a product at set, different price levels?
- How can I use discounts to write off small amounts on my customer invoices?
- Can you close open estimates in a batch, not one by one?
- Now I have 90 some-odd payments to deposit.
- Does QuickBooks Online Plus have a notification for low inventory?
- Will it notify you if you are going over budget?
- Is there an easier way to track resale certificates?
- I need to create a positive pay file for the bank.
- Since QuickBooks Online cannot import IIF files, I had to hunt down a way.
- I chase clients every month about their uncategorized transactions.
- We keep a depreciation schedule in a spreadsheet and post it by hand.
- We need approvals, and on our plan that means upgrading to Advanced.
- Our government customer wants a Peppol e-invoice, not a PDF.
- I was looking for months for a way to create a customer portal.
- I want to enter my stock count in QuickBooks without printing and typing.
- Everything for QuickBooks Online