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

QB Desktop Reconcilling Bank statement

when my coworker do bank recon in QB desktop, both beginning and Ending balances are correct and there is no discrepancy. But, after running the reconciliation report, beginning and Ending balance are different and not match with bank statement. if we go to Banking> Reports >Reconciliation Discrepancy for check, there is no discrepancy. it is pretty weird. If I do the same reconciliation from my account, the reconciliation report is correct and there is no discrepancy. How should we fix up the issue? Can we reach to any support agent's phone directly?

3 Comments 3
Kevin_C
QuickBooks Team

QB Desktop Reconcilling Bank statement

It's great to see you here in the Community today, @SShaw2. I can share some information to help you fix the issue with your bank reconciliation in QuickBooks Desktop (QBDT).

 

I appreciate you for running the Reconciliation Discrepancy report to check for some issues. You can also run these reports in QBDT that show you if anything has been changed, deleted, or added. 

 

Follow these steps to check for any missing checks. These may be throwing off the ending balance of your reconciliation.

 

  1. Navigate to the Reports menu. 
  2. Hover over Banking and select Missing Checks.
  3. Choose the account you're reconciling and then select OK.
  4. Review the report. Look for any transactions on the report that aren't on your bank statement. If they aren't on your bank statement, they shouldn't be on your reconciliation.

 

Next, you can run this report to see if any transactions changed:

 

  1. Go to the Reports menu. Hover over Custom Reports and select Transaction Detail.
  2. Select the Display tab. In the Date From field, select the earliest date in QuickBooks for the account. You can also leave it blank.
  3. In the Date to field, select the date of your last reconciliation.
  4. Proceed to the Filters tab. In the Account field, select the account you're reconciling.
  5. In the Entered/Last Modified field, set the Date from to the date of your last reconciliation. Then set the Date to field to today's date.
  6. Select OK to run the report.
  7. Look for any discrepancies or transactions that don't match what's on your bank statement. Edit the transaction as needed.

 

For more details on how you can review your transactions in QBDT, please refer to this article: Fix issues when you're reconciling in QuickBooks Desktop.

 

If the issue persists, I suggest contacting our Customer Care Team. They have tools such as screen-sharing (remote access) that can pull up your account in a secure environment and check the cause of these issues. You'll first have to check out our support hours to ensure we can assist you on time.

 

Here's how you can get in touch with an agent:

 

  1. In QuickBooks Desktop (QBDT), press F1 on your keyboard to open the Help page. 
  2. Click the Contact Us button.
  3. Enter your concern in the box and select Continue
  4. Choose either Start messaging or Get a callback

 

Once everything's good with your balances, you can now reconcile your accounts seamlessly. To be guided through the process, you can refer to this article: Reconcile an account in QuickBooks Desktop.

 

Please let us know how it goes about fixing your bank reconciliation. We're always delighted to assist you more. Keep safe, SShaw2!

SShaw2
Level 1

QB Desktop Reconcilling Bank statement

Seems like I need to give permission to my coworker to run the custom report from her QB desktop.

Which user role do I need to give to my coworker? Which permission do I need to grant her to run the custom report by herself?

 

JamaicaA
QuickBooks Team

QB Desktop Reconcilling Bank statement

Thanks for joining this thread, @SShaw2. I'd love to walk you through the steps to ensure you're able to assign restrictions to your coworker.

 

Before proceeding, may I know what version of QuickBooks Desktop you’re using? Is it QuickBooks Desktop Enterprise? If so, you’ll want to follow the instructions below.

 

Yes, you can limit your coworker’s access to certain areas. This way, they will only be allowed to access the report that they need to complete their tasks. Let’s start from creating new roles so you’ll have the freedom to control which areas of your accounts can be accessed. 

 

Here's how:

 

  1. Go to the Company menu and hover your mouse to Users, then click Set Up Users and Roles.
  2. Go to the Roles List tab and select New to add a new role.
  3. Enter a role name.
  4. From the ROLE ACCESS section, select Reports under the Area and Activities column.
  5. Select which report you’ll want your coworker to access. Choose either None or Partial under the Activity Access Level. 
  6. Click OK

 

2.png

 

After that, we can assign the specific role we've created from the above steps to your coworker. I’ll show you how:

 

  1. Select the User List.
  2. Click New and enter the necessary information.
  3. From the Available Roles list, select the Role.
  4. Tap Add, and then OK

3.png

 

To know more about user about user permission, please feel free to view these articles:

 

 

Additional details about user permission regardless of the version can be found here: QuickBooks Desktop Users and Restrictions. This includes steps on how you can set up users and roles, hide account balances from unauthorized users, as well as troubleshooting steps to resolve unexpected results. 

 

Do you have other questions about the the process? If you have other concerns regarding users, please let me know by replying to this thread. I'll be here to help you.

Need to get in touch?

Contact us