My accounts receivable (invoices) are included in my income. This duplicates my total income amount. How can I change this?

Hi there, @sbjconstructionl.

Yes, unpaid invoices will show up under your income when running your reports on an Accrual basis. I'm here to help you with customizing your transactions to get the result you need.

At this time, you can open your report on a cash basis to get the accurate total of your income. As stated above, accounts receivable transactions (overdue invoices) are showing up on an Accrual basis.

1. Open your QuickBooks Online account, then click on Reports at the left pane.
2. Look for Profit and Loss Detail, then open the report.
3. Filter the dates, then set the Accounting method to Cash.
4. Tap on the Run report tab to refresh the page.

For more tips about running and customizing reports in QuickBooks Online, you can open this article: Run reports in QuickBooks Online.

You can also skim through the topics from our help articles for more resources while working with QuickBooks in the future. Here's the link: Find QuickBooks help articles, Community discussions with other QuickBooks users, video tutorials, a....

If you have any other questions about your invoices and income transactions, please let me know by adding a comment below. I'm always here to help. Have a good one!

Good morning @Angelyn_T 

Thanks for your answer. I tried what you said, but I still can see the paid invoices in my income and they're still duplicating the total. 

Thanks for trying the steps shared by my peer. You can run two reports to get the data you need, @sbjconstructionl.

Let's ensure that the invoice had been matched to a deposit by running the Transaction List by Customer and Transaction List by Account. 

You'll only need to filter it to show the Cleared status and the Transaction Type.

Here's how: 

1. Go to the Reports on the left panel, then enter Transaction List by Customer/Account in the search box.
2. Click the Customize button in the upper right-hand corner.
3. Maximize the Rows/Columns section, and then click the Change columns link.
4. Check the Clr box, then maximize the Filter section.
5. Check the Transaction Type box and choose Invoice.
6. Checked the Cleared box and select All, then click Run report.

After filtering the report, look for the invoices that don't have a letter C under the CLR column. This means that they are not yet matched to any deposits. Once duplicates are confirmed, follow the steps to learn more about how you can handle your duplicate transactions: How to Void or Delete an Invoice or Other transactions?

For future reference, read through this article to learn more about finding the duplicate invoice, estimate, or sales receipt numbers.

If you have any further questions, just let me know. I'll be here to extend help. 

thank you @katherinejoyceO it was helpful the info you shared, however, after I followed all those steps and I identified all the unmatched invoices, added to undeposited funds, and added to a new bank deposit, when I come back to my profit and loss and check my income, those invoices are still there doing the same mess. So, probably, I've lost at some point. I can't see the letter C in the invoices I've matched to undeposited funds and bank deposit, and I'd appreciate if you can guide me to the next step after identifying the unmatched invoices. 

Hi there, sbjconstructionl. I'd be more than happy to share some information about deleting/voiding transactions.
 

If one was created by accident, it can be voided or deleted. This will prevent it from affecting your account balances and reports. In the event any of them are duplicate recurring transactions, they can be turned off to prevent another record from being created.
 

Here's how:

1. Use your Gear (⚙️) icon.
2. Choose Recurring Transactions.
3. Select the recurring invoice you'd like to manage.

Once you're prepared to void/delete your duplicate records, you'll need to determine which option's appropriate to use. In most cases, it's best to void rather than delete. Voiding will leave a record of it behind, whereas deleting won't. Once an invoice is voided, QuickBooks won't void any payment(s) that've been linked with it. You can apply it/them to a different invoice.
 

Only delete transactions if you're certain you don't need records of them. If one's deleted by mistake, you can use your Audit Log to recover some of it's details, but not the entire record.
 

In the event you're still not sure whether to void or delete a transaction, I'd recommend consulting with an accounting professional. If you're in need of one, there's an awesome tool on our website called Find an Accountant. All ProAdvisors listed there are QuickBooks-certified and can provide helpful insights for driving your business's success.
 

Here's how to void/delete a transaction:

1. In the left navigation bar, go to Sales or Expenses.
2. Locate and open your transaction.
3. If you'd like to include its void/delete date, add a notation in the Memo or Message section.
4. On your footer, click More.
5. Choose Void or Delete.
6. Select Yes to confirm your changes.

Now your duplicate transactions will be voided/deleted.

You'll additionally be able to find many detailed resources about using QuickBooks in our help article archives.
 

I'll be here to help if there's any questions. Have an awesome Friday!

Were you able to find a fix to this issue? I'm currently going through the same trouble. Thanks!

Thanks for checking in with us, UpSquad. 

If you're referring to the paid invoices included on your income and they're still duplicating the total, let's ensure that the invoice had been matched to a deposit. We can check them by running the Transaction List by Customer and Transaction List by Account report. We'll only need to filter it to show the Cleared status and the Transaction Type. Here's how: 

1. Go to the Reports on the left panel, then enter Transaction List by Customer/Account in the search box.
2. Click the Customize button in the upper right-hand corner.
3. Maximize the Rows/Columns section, and then click the Change columns link.
4. Check the Clr box, then maximize the Filter section.
5. Tap the Transaction Type box and choose Invoice.
6. Hit the Cleared box and select All.
7. Press Run report.

After filtering the report, look for the invoices that don't have a letter C under the CLR column. This means that they are not yet matched to any deposits. Once you know the duplicates, follow the steps in this article on how to handle duplicate transactions: Void or delete transactions in QuickBooks Online.

Feel free to visit our Sales and customers page for more insights about managing your company's income and customers.

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Feel free to reply to this post and I'll get back to you. You have a good one.

Thank you @sbjconstructionl for posting this. I am having the same issue and I have gone through all the steps...and I am still unable to clear the duplicate Accounts Receivable. I had this issue before and paid hundreds for a QB Accountant to remedy.

I have followed all the steps which "fixed" the issue last time, but it appears QBO has a mind of its own and my P&L is not accurate.

I need a real solution, maybe QB's can change the software to make this insanity stop.

Please advise.

That shouldn't have happened, Nina Oxide. I'll help ensure to get rid of the duplicate from your books.

Here's how:

1. Go to the Bookkeeping menu, then select Chart of accounts.
2. Select Account History for the account with the duplicate transaction/s in the Action column.
3. Locate the transaction you wish to delete, then select it to show more details.
4. Select Delete.
5. Repeat the steps for any other transactions you'd want to remove.

For future reference, check out these links below to help you learn about managing managing your transactions in QuickBooks:

• How accounts are affected by debits and credits
• Fix issues at the end of a reconciliation in QuickBooks Online

Feel free to message me again if you have additional concerns about fixing the duplicates in your account. Take care!

@Nina Oxide 

The OP @sbjconstructionl has 'Transaction Type: Deposits' on their P&L screenshot which indicates they were most likely not receiving customer payments properly.  Payments received from customers on invoices must be recorded as a payment received (New > Receive Payment) and matched to the invoice.  This reduces A/R by the same amount as the payment.