In bank reconciliation, how to I view the check numbers so that I can reconcile?

Hi there, @d-sylvain-coughl.

Thank you for posting in the Community. I'd be happy to help and walk you through on how to see the check number when reconciling. 

You can add the Reference number column to view the check numbers on the Reconcile window.

Here's how:

1. At the top menu, click the Gear icon. 
2. Select Reconcile.
3. From the Account drop-down menu, select the appropriate bank account.
4. Click Start reconciling or Resume reconciling.
5. Enter the information requested.
6. Click Start reconciling.
7. On the Reconcile page, click the small Gear icon. 
8. Under Edit columns, put a check in the Ref no. box.

I've attached an article and screenshot for additional reference: How to reconcile accounts.

That should take care of it. I believe that you'll see the check numbers on the reconcile page in just a few clicks.

Also, The phone support agents will be able to assist you in getting this resolved.

Here's how you can reach them: 

1. Go to https://help.quickbooks.intuit.com/en_US/contact.
2. At the top right, select your QuickBooks version.
3. Select a topic.
4. Click on the Get Phone Number or Start a Message button.

Drop me a comment below if you have any other questions about reconciling in QuickBooks Online. I'll be happy to help you further. Have a great day.

My issue is that the 'reference number" that displays when I issue a refund is the refund number, not the check number.  How do I change this?

Hello, @CRSMcHild999.

You can open each refund transaction and change the reference number manually. Let me guide you how to do it.

1. Go to the Accounting menu.
2. Choose the Chart of Accounts tab.
3. Click the View Register link from the Actions column.
4. Locate the refund transactions.
5. Click each one to open.
6. Edit the Reference Number.
   • You can also click the Edit button. By doing this, you'll be routed to the Refund page and you can modify its reference number from there.
7. Click the Save button.

On the other hand, you can run the Transaction Details by Account report. Then, filter this to show only your refund transactions. This way, you'd see which has a reference number or not. Just click on each transaction to update it. 

Let me know if you have other questions about managing your transactions in the bank register. I am always here to help.

This is selected and I still do not show any check numbers.  I have tried deselecting and it still does not show check numbers.  

Thanks for getting back to us, Eagle17.

I appreciate the effort you've made to sort this out.

Let's try to run adding the column on a private window. It helps to determine if you experience browser-related issues. You can use these keyboard keys to open one:

• For Google Chrome: Ctrl + Shift + N
• For Mozilla Firefox: Ctrl + Shift + P
• For Microsoft Edge: Ctrl + Shift + P
• For Safari: ⌘+ Shift + N

If it works, you can go back to a regular browser and clear its cache. You may also switch to a different browser like Google Chrome, Mozilla Firefox, Safari, or Microsoft Edge.

Also, if you want to add or remove data on a report, you can customize it. Here's an article as your guide: Modify reports in QuickBooks Online.

Feel free to post again if you need help with any of your QuickBooks concerns. I've got your back!

Hi there,

I can view all check numbers in my bank reconciliations except for the paychecks. How can I get my paycheck numbers to show in the ‘ref no.’ column of the bank rec? 

Welcome back to the QuickBooks Community, R3b3l0. Let's perform some steps below to ensure you'll be able to see the paycheck numbers on the Reconciliation page.

To prevent issues when reconciling an account, make sure that all necessary details of your transactions are entered. With this, I recommend that you enter a paycheck number in the Check number box. This information will then appear in the bank reconciliation section's Ref no. column.

Here's how:

1. Click each paycheck entry on the Reconciliation page.
2. Choose the Edit button.
3. Enter the paycheck number on the Check Number box on the Paycheck list/Paycheck section under Net Pay.
4. Click OK to save the changes.

Once done, you can now view paycheck numbers as a ref. Then, you may click this article to see detailed steps on how you can reconcile your accounts to avoid discrepancies: Reconcile an account in QuickBooks Online.

Lastly, I'm adding this article to view various guidelines that help fix any reconciliation problem that you might encounter: Learn the reconcile workflow in QuickBooks.

Don’t hesitate to click the Reply button below if you have other banking or reconciliation concerns. I’m always here to help you out, R3b3l0. Take care!

Thanks for your reply,

I do however see the cheque numbers under the pay cheque list. They just don’t show up in the ref number box of the reconciliation. 

Never mind, I realise the paycheque information is from the payrolls I imported from Sage50 when I switched ,

thanks.

For the money QuickBooks charges, why is it so complicated to simply display check/reference? numbers? No one reconciles without check numbers on planet Earth.  Asking clients to 'drill down' to distinguish, better off using a paper ledger. 

Hello, @tom. Thanks for joining the thread and posting your concern about displaying a check reference number when reconciling.

Please know that this isn’t the kind of impression that we'd like you to have. However, for you to add check reference numbers to show in the reconcile window, we can follow the steps given by my peer above. I'll guide you on how: 

1. Go to the Gear icon and choose Reconcile.
2. From the Account drop-down menu, select the appropriate bank account.
3. Click Start reconciling or Resume reconciling then, enter the information requested.
4. Click Start reconciling.
5. From the Reconcile page, click the small Gear icon.
6. Under Edit columns, put a check in the Ref no. box.

If that's not the case, may I know which part you're referring to when trying to view the check numbers? This way, I can provide you with the best resolution.

Moreover, you'll want to check out this article for future reference about printing checks: Print a check in QuickBooks Online.

In addition, here's an article that can help you along the way in case you encounter issues when reconciling your account: Fix issues when you're reconciling accounts in QuickBooks Online.

I’m always ready to assist you if you have any other questions or concerns about managing your bank transactions. Tag me in your reply and I’ll sprint back into action. Have a wonderful day and stay safe at all times.

In quickbooks 2020 desktop pro, there is no gear icon. There is no accounting menu. I've always seen the check numbers when I'm reconciling my bank accounts and today the check numbers were not there. I need them to show as a column when I'm reconciling.

Hello Mishmash,

Thank you for reaching out to the QuickBooks Community. The instructions that were shared previously were for QuickBooks Online. But no worries, let's go ahead and rebuild and verify your company file. When strange behavior such as this occurs, we recommend checking for data damage. Here's how:

1. Choose File, Utilities then Rebuild Data.
2. Press OK to back up the file.
3. Choose the location for the file and press OK.

The process for the rebuild will take place once the backup is completed. From there, run the verify tool, which can be found in this article. 

Once the rebuild and verify process has been done, go back to reconciliation and see if you are able to see those check numbers in the column,

I will be awaiting your response! Please let me know if you have any other questions! Take care. 

Hello

Unfortunately, this did not work. It seems like it should be in some type of view setting and somehow I turned off. When I did the rebuild and the verify I got an error 195, which has to do with online banking, which I don't use. A column that shows the check number/EFT is somehow turned off in reconciliation.

Welcome back, Mishmash.

I want to make sure this gets reported to the right department. 

Since you already tried all possible solutions for this, we highly recommend contacting our support team. They are the ones who can create escalations to our engineers to review and fix problems in QuickBooks Online. 

To contact us, follow the steps below:

1. Open your QuickBooks Account.
2. At the top right, click the Help icon.
3. Click Contact Us.
4. Under What can we help you with?, enter your concern.
5. Click Let's Talk.
6. You'll be routed into the Choose a way to connect with us page.
   Start a chat with a support expert.
   Get a callback from the next available expert.
7. Select how you want to contact them and fill in the information.

Also, the support for QuickBooks Online Plus, Essentials, Simple Start M-F 6 AM to 6 PM PT and Saturday 6 AM to 3 PM PT. 12:14 EST would be 9:14 PST. Our support is available during this time. However, we're experiencing high volume of calls. I suggest calling us back at a later time. 

You can check out this article for our most updated contact information: Support hours and types.

In the meantime, you'll want to check out our Help Articles to help you with the tasks and tips when using QBO.
 

Get back to me if you need further help managing reconciliation. I'll be around to assist you. Have a good day.

Actually the problem was very simple. In the reconciliation screen there is a button on the right that says Display Columns. Took care of the problem for me. Thank you.

Happy to hear that you figured out what was causing your issue, @Mishmash. 

Thanks for sharing your workaround so that other users can see the solution if they encounter the same issue. It's users like you that make the QuickBooks Community so beneficial. Sharing problems and solutions to help each other learn and grow is always the goal.

Feel free to reach out at any time. Have a good one! 

Did this resolve the problem? I'm having the same issue. I wondering if its because they were entered as bills manually and then matched to the payment through the bank feed?

Thanks,

Brandi

Hello there, @Brandi.

I'd like to collect further details. Or a screenshot of the issue encountered. Furthermore, when you match the bill, only the bill payment number and check number will show under the reconciliation process.

Feel free to add your comment here again. I want to make sure this is taken care of. 

Where???? I am having this same issue

Hello there, @dynamicfresno.

I'd love to help you achieve your goal, but would you mind sharing more details about it? Like adding a screenshot of your concern? It can help us get on the same page and provide accurate resolution.

I'll wait for your reply, or if you have any other questions, please let us know. We're always here to help. Have a great day.

As of 10/5/23, I followed your advise. I rechecked the Ref # (it was checked) and nothing changed. Getting very frustrated with all these quirks.

Hello there, Kim.

Let me get the help you need in displaying the reference number of your transactions on the Reconciliation page in QuickBooks Online (QBO).

The numbers that'll show depend on the type of a specific transaction and if there's a reference number entered. To further investigate why there are no reference numbers showing on your transaction, I recommend opening the transaction by clicking on edit. 

If you encounter problems when reconciling your accounts in the future, refer to this handy article to resolve them: Fix issues at the end of a reconciliation in QuickBooks Online.

You're always welcome to comment below if you have follow-up questions when handling your transactions. I'm just around to help. Take care always.

I am having an issue with this. The reference box is checked, but still not showing on the reconciliation dashboard list. Is there an update that occurred since last month. It was on there before this month.