P&L Statement Has Different Totals From Quickbooks Invoices

bjazz · ‎May 14, 2021

Hello. I'm having some trouble with getting the P&L statement to reflect the correct totals that were charged for invoices paid through Quickbooks online. I have several transactions that show the invoice number and each of those invoices has a total that does not included the taxes that were charged. I do have an example of one invoice the shows the actual correct total deposited into my checking account, but it appears to be a duplicate charge since both the total without tax is present and so is the deposit that has the correct amount with tax (see red box on screenshot). How do I go about removing the invoice total so that the total with tax is only included in the P&L statement and avoid duplicate transactions being included? Thanks.

MichelleBh · ‎May 15, 2021

I recognize the importance of having accurate books for your business, @bjazz.

I appreciate you for providing screenshots and all the steps you've done in resolving your duplicate transactions in QuickBooks Online. I'm here to help you determine where the 04/28/21 deposit comes from.

You'll want to access the Audit Log report to determine the transaction source. Let me guide you how:

Go to the Gear icon, then choose Audit Log.
Click the Filter drop-down arrow and select All user in the User box.
Pick 04/28/21 in the date field.
Choose Transactions in the Show only these events.
Tap Apply.

Once you confirmed that the transaction is duplicate, then you'll want to delete it. Moreover, as my peer mentioned above, you can communicate with your account to check if you should be deleting the deposit. This way, your books are accurate.

If you're unable to delete it, please call our QuickBooks Specialist. They have can help you remove the transaction.

Here's how:

Go to the Help menu, then click Contact Us.
Type your concern in the box and tap Let's talk.
Choose either Get a call or Start a chat.
Complete the required data and submit the request.

Make sure to call them within business hours to ensure we can cater to your concern immediately.

Lastly, feel free to visit these articles below about how to reconcile accounts, handle your banking transactions, and other related topics.

Let me know in the comment section if you have a follow-up question about your transactions. I'm happy to serve you. Keep safe.

View solution in original post

JenoP · ‎May 14, 2021

Good day, bjazz.

Let me help with your question about running reports in QBO.

Can you tell us which part of the Profit and Loss Statement was zoomed in to get the transaction report or list of invoices and deposits? Please note that sales taxes are not reported in your Profit and Loss because they're part of your liabilities. They will be shown in your Balance Sheet instead.

I'd also like to ask how the Deposit recorded was recorded? Did you click the Receive payment option or did you make a bank deposit? If so, this can be the reason why both the invoice (without tax) and the deposit (with tax) are shown separately in your report.

If that's the case, I'd recommend reaching out to your accountant and check if you should be deleting the deposit. Although, you can also change the account used to Accounts Receivable. Then, follow the steps in this article on how to link them together: How To Link A Deposit To An Invoice.

Let me also share these articles for additional details about running reports in QBO:

Please add a reply below to add more details. I'll jump right back to help you again.

JenoP · ‎May 15, 2021

Hi bjazz,

Hope you’re doing great. I wanted to see how everything is going about the different totals in your Profit and Loss statement. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!

bjazz · ‎May 15, 2021

Hi JenoP. Thanks for reaching out and my apologies for the delayed reply. The placed I started with was the Sponsorship link on the P and L statement (box in red). From there it took me to the screen that has the breakdown I had in the first screenshot you saw in the initial post.

As for the Deposit that is a duplicate of the invoice transaction, I'm trying to figure that part out as well. I believe the deposit was received initially via invoice through Quickbooks and then auto-deposited into my checking account. I made no manual deposits for any transactions included. Once this happened, I had the option to match the transaction to a deposit that was in linked to my checking account so I selected that option. I did this for the remaining invoices that are also included in the first screenshot and it seems to have worked properly with none of those being duplicated. However, this single transaction has a duplicate for some reason. .

I do believe the deposit with tax is showing up accidentally but I'm not sure why. I have checked my categorized transactions but don't see a duplicate there so I'm not sure where it originates. However, I also followed the steps in the link you included about linking a deposit to an invoice (thank you for sharing that) and was able to see both transactions in the Chart of Accounts section (see screenshot below).

After seeing this, I was able to link the transaction to the deposit similar to how it shows up for the other sponsorships that were paid using the Quickbooks invoices. However, this still didn't completely fix the problem since that duplicate deposit remains (see screenshot below).

It looks like deleting the transaction on 04/28/21 would be the next logical step, but I'm not sure if that's best. Any other suggestions how to determine where the 04/28/21 deposit comes from and if it's able to be deleted for this issue?

MichelleBh · ‎May 15, 2021