cancel
Showing results for 
Search instead for 
Did you mean: 
llan
Level 1

How do I reconcile a tip added to an invoice? The invoice is fully categorized. The tip was left for a contractor which I will pass through so it's not income to my biz.

I've not been able to find anyone with knowledge through support. I've created an Undistributed Tips account but need to know the steps to distribute it to zero out the account. How to I match the overpayment in Banking? This is not a restaurant situation and I don't want to lose the revenue detail in my original invoice.
5 Comments 5
Candice C
QuickBooks Team

How do I reconcile a tip added to an invoice? The invoice is fully categorized. The tip was left for a contractor which I will pass through so it's not income to my biz.

Good morning, @IIan. 

 

It's great to see a new face here in the Community. Let's work together and get this problem handled. 

 

To clarify before digging further, did you use the steps from this guide to record an overpayment as a tip? If not, please give us screenshots or additional information about how you recorded it. 

 

Once I've received some more details, I'll be able to determine the best solution for your business. Tap the Reply button to respond. I'll be around the corner when you're ready!

llan
Level 1

How do I reconcile a tip added to an invoice? The invoice is fully categorized. The tip was left for a contractor which I will pass through so it's not income to my biz.

That solution does not work since it's recording the tip as income.  I do not want the tip recorded as income to my business.  I'm simply passing it through my books to a contractor.

llan
Level 1

How do I reconcile a tip added to an invoice? The invoice is fully categorized. The tip was left for a contractor which I will pass through so it's not income to my biz.

No that solution does not work since it's recording the tip as income.  I do not want to record it as income since I am simply passing it through my books to a contractor.

DivinaMercy_N
Moderator

How do I reconcile a tip added to an invoice? The invoice is fully categorized. The tip was left for a contractor which I will pass through so it's not income to my biz.

I'm here to ensure you'll get the right support in reconciling a tip added to an invoice, @llan.

 

In QuickBooks Online (QBO), you'll have first to record the transactions before reconciling your account. To start, let's create a Gratuity/Tips account for the tip and select Other current liabilities. Here's how:

 

  1. Open your QBO account and click the Gear icon.
  2. Choose Chart of Accounts and then select New.
  3. Select Other Current Liabilities in the Account Type field and choose the Detail Type best fits the transactions you want to track. 
  4. Enter Gratuity/Tip in the Name section.
  5. Once done, click Save and close.

 

Next, let's create a Journal Entry to move the credit from the overpayment into the Gratuity account. Refer to these steps below:

 

  1. From your QBO account, select the +New button and choose Journal Entry.
  2. Set the date as the same date as the payment you received.
  3. In the first line, choose Accounts Receivable and enter the tip amount under the Debit column.
  4. Then, pick the customer's name in the Name field.
  5. Next, select the Gratuity account on the second row and input the amount in the Credit column.
  6. When you're finished, click Save and close.

 

Then, let's use the Receive Payment feature to clear the credit of the customer. Let me guide you how:

 

  1. Navigate to the +New icon and choose Receive Payment.
  2. Ensure that the date is the same as the journal entry you've created.
  3. From the Outstanding Transactions section, select the journal entry.
  4. Next, check the box beside Unapplied Payment under the Credits field. This is the amount we're trying to move.
  5. Once done, select Save and close

 

After that, go to the Banking menu and check if you see a matched deposit. 

 

When everything is fine, you can now proceed in reconciling your account

 

You can also generate a handy copy of your reconciliations to have a reference guide in the future. To have one, check out this article for the detailed steps: How do I view, print, or export a reconciliation report?. You can either print or export it and save it on your desktop folder. 

 

Should you have any other questions in reconciling a tip added to an invoice, you can always post it here in the Community. I'm always here to assist and ensure your success. Have a good one.

llan
Level 1

How do I reconcile a tip added to an invoice? The invoice is fully categorized. The tip was left for a contractor which I will pass through so it's not income to my biz.

Thank you!  That seems to work based on all the reports I ran after following the steps 🙌

Need to get in touch?

Contact us