QuickBooks HelpQuickBooksHelpIntuit

Troubleshooting your Profit and Loss report

by Intuit•5• Updated 1 week ago

Learn how to identify and fix common issues, such as missing transactions or unusual account balances on your Profit and Loss report in QuickBooks.

Why are transactions missing from my Profit and Loss report?

If you expect to see an income or expense transaction but it's not on your P&L, check the following two things first.

Your report might be set to the wrong accounting basis.

  • A Cash basis report shows income and expenses as of the payment date.
  • An Accrual basis report shows them as of the invoice or bill date.

On the Profit and Loss report screen, switch the Accounting method between Cash and Accrual and select Run report again to see if your transaction appears.

The Profit and Loss report only shows transactions involving income and expense accounts. Transactions that only move money between balance sheet accounts (like bank accounts, credit cards, loans, Accounts Receivable, and Accounts Payable) will not appear.

Example: Paying a bill moves money from your bank (Balance Sheet) to Accounts Payable (Balance Sheet). The transaction that appears on the Profit and Loss is the original bill, which posts to an expense account.

To check a transaction, find and open it, and review which accounts were used in the transaction detail.


How to fix 'unapplied' balances on a cash basis Profit and Loss

When running a Profit and Loss on a Cash basis, QuickBooks may show balances in system-generated accounts called Unapplied Cash Payment Income or Unapplied Cash Bill Payment Expense. Here’s how to resolve them.

This account appears when you record a customer's payment before creating the corresponding invoice, or when a payment isn't linked to a sales form.

Follow this link to complete the steps in product Open this link in a new window

  1. Run the Open Invoices report.
  2. In the Transaction Type column, look for any Payment transactions. These are the source of the unapplied income.
  3. For a Payment that should be applied to an existing Invoice on the list:
    • Select the payment's Date to open it.
    • Under the Outstanding Transactions section, tick the checkbox for the matching open invoice.
    • Select Save and close.

If the payment does not have a matching invoice, you need to create one:

  1. Select + New, then Invoice.
  2. Create a new invoice for the same customer, date, and amount as the payment.
  3. Select Save and close.
  4. Return to step 4 to apply the payment to the newly created invoice.
  5. Repeat these steps until no Payment transaction types are left on the Open Invoices report.

This account appears when you record a bill payment before entering the corresponding bill from your supplier.

  1. From your Profit and Loss report, select the total amount next to Unapplied Cash Bill Payment Expense to open a detailed view. Note the supplier and payment amounts.
  2. Select + New, then Pay bills.
  3. Look for any open bills that match the payments you noted. Tick the checkbox next to the matching bills and payments, then select Save.
  4. If you have a bill payment without a matching bill, you must create the bill first:
    • Select + New, then Bill.
    • Fill out the form with the same supplier, date, and amount as the bill payment.
    • Select Save and close.
    • Return to the Pay bills screen to match the payment to the new bill.

After clearing all unapplied payments, run the Profit and Loss report again. The 'Unapplied' accounts should no longer appear.


Browser errors when running reports

Occasionally, a web browser issue can cause errors (such as the 'Aw, Snap' error in Chrome) when running reports. If you experience this, follow the steps below:

  1. Update your browser: Ensure your web browser (Chrome, Firefox, Edge, etc.) is updated to the latest version. This resolves most display issues.
  2. Clear your cache: Clearing your browser's cache and cookies can fix loading problems.
  3. Try another browser: If the issue persists, try running the report in a different web browser to confirm if the problem is browser-specific.

More help

QuickBooks Online App for AndroidQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start