Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27
Buy nowWe are a small travel company. When we book a hotel, the hotel agrees to pay us a commission after the hotel stay has been completed. For example:
I book a hotel for John Doe today - June 1st. He will stay at the hotel from June 25th - June 30th. The hotel will pay me commission no later than July 30th. I know that the commission amount will be $400.
How do I track this commission payment as income expected in July so that it shows up in July on my cash flow statement, but not recognize it as actual income until we receive the payment?
I have thought about creating an invoice to the vendor (hotel in the example above) and dating it with the expected payment date, and then receiving the commission payment against that invoice when it arrives. However, I've been told this is not the correct way to do this because it will recognize the commission as a sale, when technically it is not.
Any ideas?
Are you a cash basis taxpayer? If so, and your books are set to cash basis, then you can create an invoice and date it for the date you expect to be paid the commission. QuickBooks ignores the invoice date for booking income when you're on cash basis and only books the income when you receive the payment.
On the other hand, if you're an accrual basis taxpayer, income is booked as of the invoice date. But, you should not create an invoice if you're an accrual basis taxpayer until the "all-events test" has been met - when all events fixing your right to receive the income have been met. In the case of the hotel commission, that doesn't happen until you're entitled to the commission per your agreement with the hotel which, presumably, is some time after the guest stays at the hotel.
@Rainflurry thanks for your response! We are an accrual basis taxpayer, which makes sense why we shouldn't invoice it until we actually receive the commissions.
However, do you know of a way that we can track those commissions within Quickbooks for forecasting and budgeting purposes? Specifically I'm looking for some kind of pro forma cash flow statement.
Allow me to chime in and provide more information about tracking your commission, awats.
QuickBooks Online doesn't have a feature for calculating sales commissions. However, you can track your commission using the Class Tracking and Location Tracking feature. Let's turn on the Class or Location features. I'll show you how.
After that, you can create a Class or Location list. Just go to the Gear icon again and select All Lists. Then, you can either choose Classes or Locations. When you enter transactions, you'll see fields for Class or Location. You can then select the salesperson who is associated with that transaction.
If you receive your commission without an invoice, you can record it as a bank deposit and link it to an invoice. Check out this article for more details: How to link a bank deposit to an invoice.
I'm also sharing this resource about tracking your cash flow for future reference: Track your cash flow in QuickBooks Online.
I appreciate you taking the time to contact the Community forums. If you have any further questions about tracking commissions, please let us know. We're always here to assist you.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here