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
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.
The reference number from invoices, bills, checks, payment and credit card transactions, etc., flow to the Num column.
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.
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.
For additional details when customizing reports, check out this reference:
Should you have more questions, please let me know. I’ll be here if you need me. Have a lovely day!
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?
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:
The invoice, check, and reference number from invoices, bills, checks, deposits, and payments show in the Num column.
Please know that I'm just a post away if you have any other questions. Have a great day ahead.