I have made a deposit detail report. what does the column Cleared mean? How do I clear a deposit? Right now, every deposit shows up twice. How do I clear?

I would like to discuss some relevant information about the Deposit Detail report, Barb.

The Cleared column in the report usually indicates whether a deposit has been reconciled with your bank statement. This column helps you identify whether each line item is Reconciled, Uncleared, or Cleared. 

When a deposit is marked as cleared, it means that the bank has processed and recorded the deposit amount, and it matches the amount that you recorded in your QuickBooks Online (QBO) account. 

To mark a deposit as cleared, here's what you'll need to do:

1. Go to the Chart of accounts tab from the Bank transactions menu.
2. Look for the account that affects the deposit transaction.
3. From the Action column, select View register.
4. Locate the deposit.
5. If it's reconciled, you'll see an R in the checkmark ✔ column.
6. Click the entry to expand the line and tap the box with the R until you'll see the C tag. 
7. Click the Save button and select Yes to confirm the action.

If there are other deposits that you want to clear, just repeat the same steps above. 

However, if you notice a deposit appearing twice, it could be due to duplicate entries in your records. In such a case, I recommend reviewing your register to identify any duplicate entries and removing them. If you are unsure how to do this, it is advisable to consult with your accountant or bookkeeper for assistance. 

If you wish to use your report outside of QuickBooks, you can easily export the report to Excel.

Please let me know if you need any further assistance with reports in QBO by adding a comment below. I am always here to help you out, Barb.