Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 8, 2020
Question

What account should a check received from a vendor for consulting be posted to? I have the check added to the components of the invoice that it came from.

  • March 8, 2020
  • 16 replies
  • 35 views
No text available

16 replies

Rustler
Level 15
March 8, 2020

make the vendor a customer, change the name slightly (I add a period), and use a sales receipt if you actually got a check in hand

If consulting is an aspect of your business then I would use an income account I create called consulting income.  If it is not an aspect of your business, then it is Other Income.

 

If the check was a reduction of the vendor bill, use the income account for it, and enter the amount as a negative number on the bill

egandersAuthor
March 8, 2020

I am not sure I was clear.  Some of my entries went to the correct account.  I have attached an example of my problem.  In August 2019 there is a deposit of $13035.37 as an unapplied deposit.  It is actually to be applied to the sum of the items above it that are from an invoice to the customer.  The way it is now it looks like I made double the amount I actually did since the components above the deposit are added to the deposit.  How do I apply them?  All the elements are present, just not combined properly.

Level 10
March 8, 2020

I appreciate you for providing complete information above to clarify the issue, @eganders.

 

Let me help ensure you're able to apply your deposits to make sure your books are accurate.

 

Before we start, I'd like to verify if you add the deposit instead of matching them to the actual payment? If so, this process will create duplicate entries in the register. To resolve the duplicate amount, you can undo the added deposit and match it to the correct invoice payment.

 

To undo the added bank transaction, here's how:

  1. Go to the Banking menu.
  2. Select the blue tile for the account you want to review.
  3. Click the Reviewed tab.
  4. Find the transaction you want to undo.
  5. Select Undo from the Action column. 

Once done, the transaction will go back to the For Review tab. From there, let's match it with the transaction you've already entered in QuickBooks so there aren't any duplicates.

  1. Select the transaction to expand the view. 
  2. Review the Records found.
  3. Select the link next to each record to get more details.
  4. Review the Deposit to field on the forms. 
  5. Click Match when you're done.

In case you want to review your accounts in QuickBooks to make sure they match your bank statements, kindly refer to this article for the detailed steps: Reconcile an account in QuickBooks Online. It also contains information on how you can edit your completed reconciliations.

 

Please let me know if you have other concerns. I'm just around to help.

egandersAuthor
March 8, 2020

I need to supply some more information because I think I gave the impression I was making manual entries that created the unapplied cash payment income.  What I did is change an entry that was downloaded from my bank from consulting income (entered during review of bank downloads, which appeared to duplicate the total from the invoice entries) to accounts receivable.  It then shows up as unapplied cash payment income.  I was hoping to match the payment to the invoices, but I don't know how.  I am somewhat new to the online Quickbooks and the methods are different I have some screenshots that I hope will help.  I hesitate to make any changes until I know I am on the right track. 

egandersAuthor
March 8, 2020

Here is another image showing the change I did to the bank download from consulting income to accounts receivable.  It showed up as unapplied cash payment income.

 

  

Level 9
March 8, 2020

I appreciate the screenshots and detailed information you've provided, eganders. 

 

It looks like that we already added the payment from our bank feeds to the bank's register. These payments are now available credits to your customers since we changed the account to Accounts Receivable (A/R). Instead of undoing the process for us to match it to the invoices, we can receive a payment. From there, we can link the invoice and payment. 

 

I'll show you how:

  1. From the + New button click Receive Payment
  2. Select the Customer and Payment date
  3. Check all applicable Invoices under the Outstanding Transactions
  4. Under the Credit section, select the Deposit or Unapplied Payment
  5. Click Save and close

Please do the same process to the other customers. Once done, we can review our Profit and Loss report again if the Unapplied Cash Payment Income is already cleared out. 

 

Feel free to get back to me if you need anything else. Thanks!