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
Oct 4, 2022 2:38 AM UTC
Question

Unpaid invoices appear in Sales Account and Income Account?

Hello, I have 5 unpaid invoices.  My questions are with regard to the Profit & Loss Report and the account location of these unpaid invoices.

4 of the 5 unpaid invoices appear in the row (line) called "Sales" (or the Sales Account) rather than the actual income account line that applies to the product/service.  1 of the 5 unpaid invoices appears in the actual income account line that applies to the product/service and not in the Sales Account line.

I can't figure out or understand why the difference.  I have seen research stating that the "Sales Account" appears to be the correct location until the invoice is paid.  If this is the case, then why is 1 of the 5 unpaid invoices handled differently and not showing in the Sales Account?

Thanks for your help.  It is greatly appreciated. 

15 replies

Moderator
Oct 4, 2022 4:12 AM UTC

Hi there, @worldtrav9.

 

Let me share insights on how products and services accounts are allocated in the Profit and loss report. 

 

Once you create an item, you'll have to select an income account. This will be the one you use to track sales and what reflects on your P&L report.

 

You'll have the option to use an income account QuickBooks already set up for you. Or else, add a new one to your Chart of Accounts. 

 

Depending on your accounting method (cash or accrual), the totals in the P&L report may vary. Also, not all products and services will appear on sales accounts even if the transaction is already paid. This will always depend on the income account that you used during the setup.

 

Here's how to check the type of income account you used for each item:

 

  1. Go to Sales and select Product and services.
  2. Look for the item you want to check, then click Edit.
  3. From the Product/Service information window, you'll see the Income account used for the item.

 

For additional reference, you can check out these articles:

 

Moreover, you can run other financial reports to track your sales and inventory status. 

 

If you have further questions on how QuickBooks tracks your transactions, please share them with us. We're always here to help. Have a good one. 

Oct 4, 2022 4:54 AM UTC

Thank you for your quick reply.
This applies to the P/L Report.
The product/service setup shows the correct income account applicable for the product/service (not sales account). I use an accrual basis.  All the 5 invoices are unpaid. 1 of the 5 appears in the correct income account setup for that product/service and not in the Sales Account.  However, the remaining 4 unpaid invoices are appearing in the Sales Account and not the correct income account that was set up for that product/service.  I would think all 5 unpaid invoices would be reflected in the same manner.

Thanks for your additional thoughts and help.

Oct 4, 2022 7:03 AM UTC

Thanks for the prompt reply, @worldtrav9.

 

Following the steps provided by my colleague above should resolve the incorrect posting of unpaid invoices in QuickBooks Online (QBO).

 

Moreover, I want to ensure that we’re working on the same page to get this sorted out and get you back to business in no time. That said, I’d like to ask for some snapshots of how the product and services are set up and the transaction journal of every transaction.

 

Here’s how you can check the transaction journal:

 

  1. Go to the Sales menu and select the All Sales tab.
  2. Find and click the transaction.
  3. At the bottom of the page, click More.
  4. Select Transaction Journal.

 

I’ll wait for your response to ensure that everything is corrected. Have a good one!

Oct 4, 2022 8:45 AM UTC

Thank you for your note.  I could not follow your steps noted above.  The step to  - at bottom of page, click "more" - does not exist in my QBO.  However, I have attached 7 PDF files that are screen prints of the following pages of information, which I hope will help you:
1) The Transaction List that shows the 6 (I thought it was a total of 5, my apology) invoices, of which the first invoice for $10,000 appears in the Income Account (4010) associated with that Product/Service.  The second invoice for $2869.92 appears in the Sales Account (4300) rather than the Income Account associated with that Product Service. This also occurs (where it appears in Sales Account (4300) for not only the second invoice, but for the second through sixth invoice. 

 

2)  Invoice #555 for $10,000 info --- Invoice details --- Product/Service Information -- Product/Service Quick Report.  This is the one that appears on the P/L report in the Income Account 4010 affixed to that Product/Service.  This is the only one of the 6 transactions where this occurred.  The remaining 5 transactions all are shown in the Sales Account 4300. 

 

3)  Invoice #554 for $2869.92 info -- Invoice details -- Product/Service Information - Product/Service Quick Report.  This is the transaction that shows in the Sales Account 4300.  The same situation occurs or the remaining 5 transactions.

4)  The only difference between these transactions is --- The $10,000 invoice is Open and the remaining are Overdue.  Does that have anything to do with this situation?

Thanks for all of your help.  This is a time sensitive situation.  Your help is greatly appreciated.  I hope all 7 attachments are in fact included.

Oct 4, 2022 9:30 AM UTC

I see only 1 of the 7 attachments appear with my reply.  So, I am going to send the remaining 6 attachments each as a separate reply.  My apology for the confusion.
You already have 2 of the 7 attachments.  Here is 3 of 7.