cancel
Showing results for 
Search instead for 
Did you mean: 
schmalts
Level 1

Profit and loss way off, is this why?

I had a major cleanup because of duplicate and missing bank transactions.  I am at the point where I reconciled up to November but my profit and loss is way off and I think I know why but want to make sure I do not mess anything up fixing it. My bank balance shows correct but QB balance is way off and my P&L is also way off.   So here is the question:

  If I look in my bank register I can see the transactions with "R" for reconciled.  But I have just as many in there from a month that was already reconciled that are with a "C" or with no letter.   Are these transactions changing my QB balance and P&L?  If so do I just go through and delete all transactions in register that are not marked with "R" if that month was reconciled?     

Question 2, what about transactions on the transaction page that are put into the "excluded" column, if I reconciled that month should those be deleted?

7 Comments 7
Jelayca V
QuickBooks Team

Profit and loss way off, is this why?

I understand that you want to fix the issue, @schmalts. Let me share some insights with you so that you have the necessary information to understand the problem and how to solve it. 

 

First, it's essential to note that when previously reconciled transactions are modified, QuickBooks Online (QBO) may mark them as uncleared and show them again for reconciliation. This can lead to discrepancies in your financial reports. 

To ensure that your transaction records are accurate while reconciling, it is recommended that you refer to the bank statement as a reference. This will enable you to compare the transactions with the records in your QuickBooks system. Therefore, it's crucial to review your bank register transactions and ensure that all reconciled transactions are accurately marked as "R." 

 

If you find transactions from a month that was already reconciled with a "C" or no letter, these transactions might be affecting your QuickBooks balance and profit and loss statement. In this case, it's recommended to consult an accountant before making any changes to ensure that your books are correct, and your reconciliation balances are accurate. 

 

For transactions that are put into the "excluded" column, you may consider deleting them, but only after careful review and if you have already reconciled the month to which these transactions belong.

 

To learn more about reconciling your accounts so that they match your bank and credit card statements in QBO, you can visit this article guide: Reconcile an account in QuickBooks Online

 

You may also refer to this article for future reference: Why are my income and expense transactions missing from my Profit and Loss report?

 

If you have any further questions about the reconciliation in QBO, please don't hesitate to reach out. I'm here to help you out.

                                               

schmalts
Level 1

Profit and loss way off, is this why?

I found another reason.  Under my P&L I show close to double the income I really have.  In accounts and reports I have many duplicates of the same amount in both "sales of products"  and "services"    How can this be fixed?

jeanbiverly_
QuickBooks Team

Profit and loss way off, is this why?

Hey there, @schmalts.

 

I'm glad to assist you with fixing duplicate amounts in both "sales of products" and "services" on your profit and loss report. Before proceeding, I'd like to ask a few questions to address your concern accurately.

 

First, did you manually add transactions or link your bank accounts to QuickBooks Online (QBO)? Second, what income accounts were used in your products and services? Was it income or bank?

 

I'm looking forward to your response. Take care, and have a great day!

schmalts
Level 1

Profit and loss way off, is this why?

Sales of products income is set to "income"    Services is set to "income"

schmalts
Level 1

Profit and loss way off, is this why?

 And yes, I had my accountant delete past reconciled months and started over by manually importing my bank transactions from my bank's website. I now have my QBO setting to no get transactions automatic anymore to keep this mess from happening. The auto was disabled because of problems logging in.

schmalts
Level 1

Profit and loss way off, is this why?

See my response for account settings, is this the problem? If so how do I fix it and what should they be?

JessT
Moderator

Profit and loss way off, is this why?

Let me continue to help you, schmalts.

 

The account settings are fine. Just make sure there are no duplicate entries, or the transactions are linked together.

 

Ideal scenario: You created an invoice, recorded a payment, deposited the payment to the bank register, and matched the downloaded payment from the Banking page to the bank deposit in the bank register. Breaking it down, there are 4 transactions that should be interconnected: the invoice, the payment, the bank deposit, and the downloaded transaction matched to the bank deposit.

 

Most of the time, duplicates often occur when downloaded bank transactions are added instead of being matched to the corresponding transactions in your books. This can create errors in your Profit and Loss and other reports. To fix this, you need to find the duplicates and delete them.

 

Also, if you've reconciled your bank transactions but forgot to match some downloaded transactions within the reconciled period, simply exclude those downloaded transactions. Once reconciled, they no longer serve a purpose.

 

Feel free to go back to this thread if you have any follow up questions.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us