Revenue shows invoices twice - as accounts receivable and as checking

I'm here to assist you in removing the duplicate transactions in QuickBooks Online (QBO), Jewel. 

When you match the invoice to a bank deposit in QBO, only one account will show on the Profit and Loss report. However, if two accounts are showing, there could be two possible reasons. It could be due to incorrect categorization of transactions or manually creating a bank deposit while matching the invoice to the bank deposit from the bank statement within QBO.

To start, let's check your bank statements to see if any duplicate transactions can cause double amounts on the report. If we find any, we can simply undo and exclude them, so they won't show up in the bank feeds again. 

However, if there are no duplicate transactions and you manually created a bank deposit while matching the invoice to your bank statement, deleting the deposit is the way to remove the duplicate. Here's a step-by-step guide to help you:

1. Click the Magnifying glass icon, then select Go to Transactions search.
2. Locate the bank deposit you created.
3. In the Bank deposit window, click More.
4. From there, select Delete, then click Yes to confirm.

Once you've deleted the bank deposit, you can run your report again to see if there are still duplicate transactions present. 

Furthermore, you can check out these helpful articles to guide you on how you can personalize and manage your reports within QuickBooks:

• Customize reports in QuickBooks Online.
• Memorize reports in QuickBooks Online.
• Print reports in QuickBooks Online.

I also recommend you regularly reconcile your account to make it accurate and balanced.

Feel free to click the Reply button if you need more help managing your reports in QuickBooks Online. I'm still here to back you up. Keep safe always!

@jewel_lea 

"I match the invoices to the checking account deposit"

Do you match the deposit to the invoice in bank feeds?  What report did you post?  Is that the HOA's income or bank account?  Are your income and bank accounts overstated?  It appears deposits were recorded as income separately which, obviously, you don't want to do.  That happens if bank feeds are assigned to an income account instead of being matched to an invoice/payment or deposits are created before payments are received on an invoice (New > Receive payment).  You can run an Open Invoices report to see what, if any, invoices did not have a payment applied to it.  Forgive me if you know most of this.           

Do you match the deposit to the invoice in bank feeds?  Yes. What report did you post? That was the Profit/loss statement I previously posted.  Is that the HOA's income or bank account?  The report I posted showed the HOAs income. Are your income and bank accounts overstated? Yes that report overstates everything. It shows my invoices/pledges, but also shows the bank check deposits.  It appears deposits were recorded as income separately which, obviously, you don't want to do. exactly...not sure how to change that though. I want to match the invoices to the deposits from the bank and only have the payment show up once.  That happens if bank feeds are assigned to an income account instead of being matched to an invoice/payment or deposits are created before payments are received on an invoice (New > Receive payment).  You can run an Open Invoices report to see what, if any, invoices did not have a payment applied to it.  Forgive me if you know most of this.    nope im cluless thanks!       

its not that there are actually duplicate deposits, its just that the invoices I create show up under Income. 

@jewel_lea 

"Yes that report overstates everything. It shows my invoices/pledges, but also shows the bank check deposits."

OK, got it.  You shouldn't see deposits on that report so that indicates you're not matching the deposits to invoices and are recording deposits to an income account separately, thereby duplicating the income that was already recorded on the invoice.  When looking at that report, whenever you see "Checking" listed under "Account", that means that that income was booked directly from a checking account deposit.  If those same amounts are also showing up with A/R (accounts receivable) listed under "Account", then you are duplicating entries.  If you create an invoice for every assessment, then you need to match the bank feed to the appropriate invoice or, if you record the payment received manually (New > Receive payment), match it to the received payment.  Never create a separate deposit assigned to income (that's what appears to have happened based on your screenshot).  Also, 'Invoices' are what should show under 'Transaction Type' on your P&L if you're on accrual basis.  If you're on cash basis, 'Payments' are what should show under 'Transaction Type'.  If you see 'Deposit', that's no good

To fix this, you need to determine how much the bank/income account are overstated (should be the same amount) and make a journal entry: debit the income account and credit the bank account for the amount of the overstatement.  

@jewel_lea 

"its not that there are actually duplicate deposits, its just that the invoices I create show up under Income."

Invoices should show up under Income since that is where you placed the item of income (assessment).  It is the deposits that shouldn't show under Income unless those deposits are separate from the payments on the invoices.  But, you indicated in your original post that you "create invoices for everyone in my HOA". 

I see what you mean. However, I am not creating the deposits assigned to income - they automatically come in thru the bank feed.  Even if I fix this via journal entry, the deposits are still coming in as people pay their dues. and they are still getting sent to the same spot. how can I change the rule that routes everything to Income? I want to make everything that says "Deposit" go from "Checking" to another spot.

also, this is where the Deposits appear to be going - Accounts Receivable, if that helps. Should I send these to another account?

additionally, when I change the profit/loss statement to Cash, this other item under Income appears- Unapplied Cash Payment Revenue. I feel like the cash deposits from my checking account are just messing everything up..im not adding any deposits. im just matching my open invoices to the checking account feed deposits,.

Did you ever find a solution to stop this from happening going forward?