Showing results for 
Search instead for 
Did you mean: 
NEW Connect to DBS IDEAL direct bank feeds Click here
Level 1

Sales receipt data missing from P&L

I used to enter my sales thru invoices. But since I enter multiple sales collection on a daily basis, I now use Microsoft excel which links my collections numbers to QBO using the SaasAnt -Excel Transaction program.  I see my data on the sales transaction but it does not get reflected on the P&L. I know that this is missing because on the month I switched to using teh sales receipts (SaasAnt program), the revenue data was missing. 

I tried both switching the report between the cash and accrual basis and I also double checked the time frame which was correct. Can you please help me out?

3 Comments 3
QuickBooks Team
QuickBooks Team

Sales receipt data missing from P&L

We appreciate you performing some troubleshooting steps to show the sales receipts in the report, Marco_bau.


You can try reviewing the sales receipts if you correctly map the file data in the SaasAnt Excel Transactions program. Then, make sure you set up the products and services and the item's affected account correctly in QuickBooks Online (QBO).


Once done, try importing the transactions into QBO again.


If the same thing happens, I'd suggest contacting SaasAnt Excel Transactions Support Team. They'll check what's causing this issue and help you import the data file in QBO to reflect them in the Profit and Loss report.


I have articles here about managing your reports in your Online account:


Just add some details below if you need anything else in the Profit and Loss report. I'm always here to help.

Level 1

Sales receipt data missing from P&L

Thanks for the reply. I just checked the sales transaction history and the item is there (as well as the others I uploaded thru SaasAnt) so I know it was able to successfully sync my excel data into QBO. The data is not being picked up in the P&L report (please see attached file). Would there be other suggestions you may have please?


Sales receipt data missing from P&L

Thank you for the quick response, @Marco_bau.


Let's go over to your sales transactions and make sure the correct income account is selected. 


Here's how: 

  1. On the left pane, select Sales.
  2. Click the All Sales tab. 
  3. Select the Filter drop-down menu.
  4. From the Type drop-down menu, choose your desired transaction type and date.
  5. Hit Apply.
  6. Select the transaction.
  7. Click More and select Transaction journal.
  8. Check the posting account if it's an income account. 

If the account is incorrect, you need to change the account for that product/service item. If it's the right income account, it's possible the data entered is damaged. To fix this, you can delete and recreate the transaction in QuickBooks. 


Please know that I'm just a post away if you have any other questions. I'll be happy to help you out. Have a great day.