cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Frequent Explorer *

Profit & Loss Detail report is not showing check number

Hi,

I'm running Profit & Loss Detail report, I customized it by adding check# column, but it's not showing the check numbers for both received payments (income) or paid bills (expenses). 

Any idea? Thanks

5 Comments
Moderator

Re: Profit & Loss Detail report is not showing check number

Hi there, Bisho.

 

The Check # column is designed for transactions, such as sales receipts, from which you receive full payment at the time of the sale.11.PNG

 

The reference number from invoices, bills, checks, payment and credit card transactions, etc., flow to the Num column.12.PNG

For future reference, let me share these articles that will help: 

Keep me posted if you have any follow-ups or further questions. I'll be here to help. Have a wonderful day.

Frequent Explorer *

Re: Profit & Loss Detail report is not showing check number

Thank you JaneD for your reply.

I wanted a P&L Detail report that shows me the check# I have entered while paying a vendor bill or receiving a customer payment.

 

Is it possible?

 

Check
Moderator

Re: Profit & Loss Detail report is not showing check number

Thanks for coming back to the Community, Bisho.

 

Yes, this it is possible. The Profit & Loss Detail report already shows the transaction number for bills and customer payments.

 

As shared by my colleague JaneD, the numbers for sales receipts show under the Check # column. The reference numbers for invoices, bills, checks and other transactions appear to the Num section.

image.png

For additional details when customizing reports, check out this reference:

Customize company and financial reports.

 

Should you have more questions, please let me know. I’ll be here if you need me. Have a lovely day!

Frequent Explorer *

Re: Profit & Loss Detail report is not showing check number

Thank you PreciousB, but I really can't get them to show on the report. I went to Customize Report ---> Display ---> Columns and I checked all of them but the desired check# are not showing.

 

The Num column shows the invoice# that's automatically generated when created, I want to show the Check No. that I manually enter when I receive a payment or record a deposit from a customer.

 

Same thing, when it comes to bills, the Num is owing the automatically generated bill number, where I want to show the Check No. that I manually enter when I pay a bill. 

By the way, I don't use Sales Orders, I directly create Bills. 

 

Am I missing anything?

Moderator

Re: Profit & Loss Detail report is not showing check number

Thank you for the quick response, @Bisho.

 

The Profit & Loss Detail report shows year-to-date transactions for each income and expense account. Thus, this report won't show the check number you enter when creating the invoice and bill payments. 

 

As a workaround, you can run the Custom Transaction Detail report and filter it with paid invoices and bills. Let me show you how: 

  1. From the top menu, select Reports.
  2. Click Custom Reports.
  3. Choose Transaction Detail.
  4. In the Display tab, set the date range. Then, mark Paid Date and Amount Paid.
  5. Go to Filters.
  6. Enter Transaction Type in the Search Filters field.
  7. Highlight the Transaction Type and choose Multiple Transaction Types in the drop-down arrow.
  8. Select InvoicesPaymentBill, Bill Payment and Deposit. Then, click on OK.
  9. Click on OK to close the Modify Report window.

The invoice, check, and reference number from invoices, bills, checks, deposits, and payments show in the Num column.

 

I've also attached a link which contains some references while working with QuickBooks Desktop: Help articles. 

 

Please know that I'm just a post away if you have any other questions. Have a great day ahead.

Need to get in touch?

Contact us