Skip to main content
December 11, 2018
Solved

Paid invoices go to Accounts Receivable, and once there they no longer show up as Income on my P & L. Why?

  • December 11, 2018
  • 5 replies
  • 0 views

I send QB invoices to customers (usually clients that I record music for in my recording studio).  When they pay me (usually via check or Paypal), I tell QB that they've paid to close out the invoice.  At which point QB puts that money in A/R.  I wish it didn't, I wish it could just corroborate with the bank/Paypal deposits.

Worse still, these transactions are hidden in my A/R, as my P & L reports don't see them as income.   So each time I mark them as paid, the amount goes into the abyss of A/R.

How can I get these invoice transactions to show up as Income on my P& L like all my other non-invoice transactions? 

P.S. I use the cash method (I tried accrual but it seemed more problematic and unnecessary, I'm a sole proprietor).  


Best answer by ObviousDWest

Many of the responses to this question seem to have overlooked the fact that the OP said they are using cash-basis. With cash-basis there isn't really supposed to be accounts receivable or accounts payable. Income is earned when funds are received, not when billed through an invoice.

 

What I've found is that QBO does have a AR account, some reports make reference to it, and you can look at it in the chart of accounts. So. Lots of opportunity for confusion.

 

What I do is create an invoice, and send it out (I like that QBO does that legwork for me). When I receive funds (e.g. through direct deposit) from a customer, instead of "add"ing the transaction as a deposit, I first go to the invoice, and do "receive payment". When I go back to the Banking page and look at transactions, it offers to match the bank transaction with the "Payment" I made.

 

After doing all that, on a P&L, I will see income reported. When you click on it, you'll be taken to the Invoice (even if it was from only a partial payment), not the deposit, or whatever transaction shows in the bank account register. Note that I don't have to do anything to the AR account. I suspect it is being manipulated behind the scenes by QBO. But it doesn't show up in P&L, nor Balance sheet. I get the appearance of real cash-basis accounting.

5 replies

qbteachmt
December 11, 2018

What I see is Not Correct. Let's review:

You charge a Service, so that is linked to Income. This will control the flow of the data to accounts.

You use it on Sales Receipt = the date of the sale is also the date of the payment.

Or, you use it on Invoice = This is Income, but not yet a Paid sale. This creates the AR. Your Item is not the AR. The function of using Invoice creates an Unpaid sale, which is AR.

Then, you get paid; this is Not a Deposit. You should never see DEP. This is a Payment, when you used Invoices. Or, you already got the funds from the Sales Receipt. The only time you would see DEP is if you Batched all the payments and your sales receipt by sending the payment data to Undeposited Funds, to be held until the banking shows up.

So, it is like this:

Sales invoice (income here) ==> AR ==> Payment arrives ==> Held as UF ==> Banking happens

That's why DEP never shows Engineering Fee Income. That is Settlement of the sales, and not your Income event.

Let's break this down a bit:

"At which point QB puts that money in A/R."  I wish it didn't, I wish it could just corroborate with the bank/Paypal deposits."

It is Neither AR nor Banking; you need to edit your Charge items and link them to Income and let QB move existing data for you.

"Worse still, these transactions are hidden in my A/R, as my P & L reports don't see them as income."

You will always see Invoice as the Transaction Type that creates Income. But the income doesn't show on Cash Basis for unpaid sales; it shows on Accrual Basis for the date of the invoice, even if Never paid. For cash basis, it shows that invoice for the date of the Payment, on Cash Basis, but you still see the Invoice. The invoice (the Sales) is the Income transaction.

"I wish it didn't, I wish it could just corroborate with the bank/Paypal deposits."

If you use the banking download, never let this Add to the file; these are not DEP, if you never yet processed payments. They are Matched to open invoice. Or, Matched to the amounts still sitting in UF.

And you should be managing PayPal as its own Bank account in your system, if they hold your funds and you incur fees there. That way, a sales receipt or Invoice Payment would post to the PP bank, not to US, because they are posted Individually in reality. Bookkeeping matches reality. Then, settlement to Real Checking from PP is a Transfer; this is not income again. It is you, moving your own funds around. Your PP fee is a Check from the PP bank. You use the PP statement to reconcile your PP bank in this file.

"P.S. I use the cash method (I tried accrual but it seemed more problematic and unnecessary, I'm a sole proprietor)."

You run the Reports on Both Basis, to keep on eye on things. You are using invoice to Anticipate payment will arrive, because you have in fact charged the people. That is fine.

Cash or Accrual is a Tax Reporting perspective. In the accounting, we use the tools that meet our needs.

I have attached some images that are from PC desktop, but they should be helpful to you.



December 11, 2018
unsure whether this is the worst answer ever or if QB sucks that much....
qbteachmt
December 11, 2018

"Your income account is not set correctly. Check the box "this service is performed by a sub contractor" Now you will see where you can assign an expense account on the cost side and an income account on the sales side."

You would do that when this is something you Incur, Charge, or for Both events. Otherwise, all of your Fee items are linked to Income. You showed an image with one linked to AR and this is the Error.


July 28, 2022

I do not see this box to check.

July 28, 2022

Hello, @Mwright4. I'm here to help you locate the option you're looking for.

Before I can help you, I'd like to know more about this issue. May I know which area of the check box option specifically you're looking for? This way, I can provide you with a resolution that fits your situation. Any additional information will be greatly appreciated.

I'll be waiting for you in this thread. Stay safe and have a good one!

December 11, 2018

Check the items used on the invoice, the cost side should be assigned an expense account or COGS, and the sales side assigned an income account.

ebtihalAuthor
December 11, 2018
That's what my accountant had suggested.  But I checked that, and it looks correct to me….maybe you can see what’s wrong.  
In the Item List (see “Item List” screenshot) I use the Item Name I made called “music consulting,” which covers just about everything I do in the studio.  As you can see, the Account this item is attached to is “Engineer, Consultant.”   If I get paid by a client that I did NOT invoice, their deposit shows up in a Downloaded Transaction from my Bank, and when I match it and enter each transaction’s details to my QB bank account, “Engineer, Consultant” is the Account I use for any recording client (see “Recording Client Bank Account Entry” screenshot).  This works fine for everything but payments from Invoices.  
When an Invoice is paid, it gets recorded into A/R, where there appears to be nothing in the “Item” field (see “Acc Rec.” screenshot). And if I double-click on it to edit it, it simply opens the Invoice, which has “music consulting” listed in the Item field (see “Invoice Example” screenshot).
So I don’t understand what A/R needs to see that I’m not already telling it.
btw, hanks for the quick response, SkinnyRaven.  
(attached the files to the initial post as I couldn't see a way to attach them to this comment.)
qbteachmt
December 11, 2018

Right here: "Why would I check that this service is performed by a subcontractor when it’s not- it’s performed by me, the sole proprietor?"

It doesn't have to be checkmarked, then. But you NEVER link an item to AR; you are going to put it on a Sales Receipt, or an invoice, and that item is your Income. Using an invoice is creating AR, already.

"And what should the expense account be?  My main biz checking account?"

You seem to be confusing Source of funds and the Reason or the Why funds left. I am giving you an attachment that is a handout I use to teach the Basics of the account types. When someone mentions assigning to Income, that means Revenue, not Bank. Bank would be the Destination, but Income is the Reason. When someone mentions "that is an expense account" that means Expense, not Bank. Bank would be the Source of the Spending and "office supplies expense" is an example of the Reason funds are being spent.

"I mean, I can’t ever see using an invoice for “purchases” as I’m not that kind of a biz.  I’m just a recording studio owner who bills artist clients through invoices."

Let's review: you show using DEP for income; that would be Sales Receipt using that same Service item for what you did. The same thing that you would list on an invoice, is listed on a sales receipt.

Sales receipt = I am also already paid for this date.

Invoice = I am charging them, it isn't paid yet, and the funds will come separately and later.

Both of these are your Sales processes. Both of these result in Funds to Banking.

"The fact I have to lie about it"

It's not a Lie. The recommendation was to set it up as a Provision. You don't have to do anything anyone tells you, here. We are explaining the tools. The point is, never link to AR because you overlooked Income. That item for "what I did for you, that you owe me for" is your Income activity.

"and say I’m using a subcontractor and link it to an expense account leads me to believe the QB Invoicing system is not for me."

Do not get out of control over this. A text based forum means we work together and back and forth, to narrow  down functions you use, how you use them, functions you didn't realize work better for you once we learn what your needs and operations are.

"Especially if invoices can’t “shake hands” with my downloaded bank reports as qbteachmt suggests"

Your Banking info is Verification. A Sales Receipt or a Payment against in invoice will be part of the Banking. We all use these tools.


Did you ever see the video tutorials and the Support articles for your product:

May 9, 2019

I am having some similar issues confusing income accounts (from chart of accounts) with bank accounts...but I am muddling through... I will post a question relating to my specific issue as soon as I can articulate it correctly. in the meantime, I am VERY INTERESTED in the information you shared with the recording studio business person. Was it a link or pamphlet? Could you share again please, or tell me where to find it? Thanks in advance

December 15, 2018

You must be entering something incorrectly. 

When you create the invoice, and before the client pays  that is when the money should go into account receivables. When it is paid, and once you match the bank transaction to the open invoice  it will remove the balance from receivables. The accounts receivables is an asset so it was already on the balance sheet before you got paid . The payment only will affect your cash but you wouldn't see assets increase further. The cash asset would increase and receivables asset will decrease for a zero net change there..

May 31, 2019

Many of the responses to this question seem to have overlooked the fact that the OP said they are using cash-basis. With cash-basis there isn't really supposed to be accounts receivable or accounts payable. Income is earned when funds are received, not when billed through an invoice.

 

What I've found is that QBO does have a AR account, some reports make reference to it, and you can look at it in the chart of accounts. So. Lots of opportunity for confusion.

 

What I do is create an invoice, and send it out (I like that QBO does that legwork for me). When I receive funds (e.g. through direct deposit) from a customer, instead of "add"ing the transaction as a deposit, I first go to the invoice, and do "receive payment". When I go back to the Banking page and look at transactions, it offers to match the bank transaction with the "Payment" I made.

 

After doing all that, on a P&L, I will see income reported. When you click on it, you'll be taken to the Invoice (even if it was from only a partial payment), not the deposit, or whatever transaction shows in the bank account register. Note that I don't have to do anything to the AR account. I suspect it is being manipulated behind the scenes by QBO. But it doesn't show up in P&L, nor Balance sheet. I get the appearance of real cash-basis accounting.