Hello. I am a fairly new QBO user. I have my American Express account linked and have successfully been matching expenses and payments. However, on my P&L Statement for the previous month, it shows not only all of the various expenses (e.g. Telephone or Postage charges) but it also shows the payment of the Amex bill itself, as an "Unapplied Cash Bill Payment." When I go to the Amex register, there is just the one bill payment transaction. There is not a duplicate payment to be excluded. How do I remove this bill payment from the P&L Statement? Thanks.
Welcome to the QuickBooks Community, nschlag.
I can help you figure this out and remove the bill payment from your Profit and Loss statement.
Running the Profit and Loss using the Cash accounting method will display the Unapplied Cash Bill Payment Expense. This account shows up when:
When you see it on your Profit and Loss report, click the total amount. Take note of the vendor and amount for each bill payment in the list. Then, follow these steps below to remove them from your report:
Otherwise, follow these steps below to create it:
Once done, rerun your Profit and Loss report.
If you need help customizing your report, you can read through this article for the detailed information: Customize reports in QuickBooks Online.
I've got your back if you need more with your reports in QuickBooks. Just let me know in the comment section so I can assist you right away.
Thanks for your quick response. Unfortunately, that solution doesn't work. I had already previously entered a bill for this payment, and matched it to the bill payment in the banking screen. And yet the cash payment still shows up on the P&L report. Is there another thing to try?
Hi there, nschlag.
I'm here to share some possibilities as to why the bill payment shows up on the Profit and loss report.
The transaction may be a duplicate, or you experience browser-related issues.
You can verify if it's a duplicate by clicking the amount on the report. Ensure that it's not linked to any transaction. From there, you can delete it.
If it's not a duplicate, you can follow the steps below to resolve browser issues.
Try running the report on a private window. Here is a list of keyboard shortcuts to open one:
If everything's good, you can go back to a regular browser and clear its cache. Piled browser history can be the reason for some issues on the page.
You may also switch to a different browser like Google Chrome, Mozilla Firefox, Safari, or Microsoft Edge.
In addition to this, if you want to add or remove data on the report, you can personalize it. Here's an article for reference:
Also, you may visit our Self-Help page for tips in managing your account.
Keep me in touch as to how these troubleshooting work on your end. You can always mention my name in your Reply whenever my assistance is in need.