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

Reconciliation

I ran a reconciliation descrepency report and it said one of the transactions were deleted from January but I  looked up the bill and it says paid and it is still on the check register. Could anyone help ne figure out why its coming up as a discrepency? Thanks!

1 Comment 1
ReyJohn_D
Moderator

Reconciliation

Thanks for getting back to us, @bluelightaccounting.

 

The reconciled paid bill might have been deleted. This is the possible reason it's showing on the discrepancy report. We can run the Audit Trail report and then compare the bill transactions if they have the same details. Here's how:

 

  1. Click the Reports menu at the top, and then select Accountant & Taxes.

    C19.PNG
  2. Choose Audit Trail, and then pick the date you want to show in the Date Entered/Last Modified and From and To drop-down ▼.
  3. Click the Refresh button to apply the changes.

    C20.PNG

If they do have the same info, you may perform a mini-reconciliation to help fix this. Please have this checked with your accountant for further guidance to ensure your books are accurate. Once ready, here's how to get started:

 

  1. Go to the Banking menu, and then select Reconcile.

    C21.PNG
  2. Choose the bank account with the transactions you need to reconcile.
  3. In the Statement Date field, enter date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation, and then pick Continue.

    C22.PNG
  5. Check off the transactions you are fixing and re-reconciling in the Reconcile window.
  6. Ensure the Difference field shows $0.00.
  7. When everything looks good, hit Reconcile Now.

    C23.PNG

For more info about it, visit this article: Min-reconciliation in QuickBooks Desktop.

 

I'll be adding this link for more tips on how to resolve reconciliation issues in QuickBooks Desktop: Fix reconciliation issues.

 

You can also customize your reports to make them personalized. Browse this resource for more details: How to customize reports.

 

I'm always around to lend a hand if you have more questions about managing your reconciliation or any QuickBooks-related concerns. Take care and have a great day.

Need to get in touch?

Contact us