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?
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.
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?
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.
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.