Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Is there a report for Transactions that have been processed and marked as paid, but not reconciled to the bank feed or credit card feed?

 
1 Comment
Moderator

Is there a report for Transactions that have been processed and marked as paid, but not reconciled to the bank feed or credit card feed?

I'm glad you made it here, aaron39.

 

You'll have to run two reports to achieve this. To see the list of transactions that have been paid, you can run the Invoices and Received Payments report. This shows all the payments you’ve received and the invoices that go with them.

 

Here's how:

 

  1. Go to Reports.
  2. Enter Invoices and Received Payments in the search field.
  3. Customize the necessary filters.
  4. Click Run report.

Here's an article made handy about modifying columns on the report: Customise and modify columns on reports.

 

For the unreconciled transactions, you can customize an Account QuickReport. This helps you filter the status. Here's how to accomplish this:

 

  1. Go to Account and choose Chart of Accounts.
  2. Locate the bank and click on the Account history drop down.
  3. Choose Run report.
  4. Click on Customise.
  5. Set the date under Report period.
  6. Go to Filter.
  7. Mark to select Cleared box and choose Uncleared.
  8. Select Run report.

Then, you can export the report into a worksheet to get the sorting you need. I'll show you how to do it:

  1. Open the report.
  2. Click the Export icon.
  3. Select Export to Excel.
    1.PNG 2.PNG

To give you more information about exporting reports in QuickBooks Online (QBO), here's an article that you can refer to: Export your reports to Excel from QuickBooks Online.

 

I'm also adding this resource to help you with the future task and tips when using QBO: Help Articles.

 

Let me know if you have any follow-ups or other questions. I'm always here to help. Wishing you a good one.

Need to get in touch?

Contact us