Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHaving the weirdest issue. I run the P&L report, and the Sales line shows an amount (which is correct). When I click in to view the Transaction Report for the Sales line, the amount is less. If I go and run a different Sales report (Sales by Customer Summary, for example), it shows me the correct amount. I have no idea what's going on...
Welcome to the Community, @hoopitz.
I appreciate the detailed steps you took when viewing your sales in the P&L report. The amounts may differ depending on the accounting method used in the report. Let's figure this out and check.
View your Transaction Report again and verify if you choose Accrual as your Accounting method. I've included a sample screenshot below.
If you choose Accrual on your P&L report, the amounts should be the same.
However, it would differ if you choose Cash as your Accounting method. In the example below, the P&L is in the Accrual method while the Transaction Report is in Cash.
An accrual-basis report shows income regardless of whether your customers have paid your invoices, while a cash basis report only shows income if you have received cash.
This may be the reason why you're seeing a less amount on the Transaction Report while everything else shows the correct amounts.
Feel free to get back to me if you have other questions. I'm here to help. Have a good one.
Hey @IntuitLily - thanks so much for taking the time to help.
I use cash basis accounting, so that is how I am run the P&L report. When I click into the Sales number, I confirmed that is showing cash basis, as well. Weirdly, when I change both to Accrual, they match. I dove a little deeper into the issue and found the two payments ($1000 each) that are missing from the Sales Transaction report. They were entered in correctly, and I even deleted them and re-entered them to be sure.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.