Bank Account Reconciliations in Desktop /Enterprise

I've got ways in reconciling your client Excel file in QuickBooks Desktop (QBDT), @TracieBoltres.

While there's no direct way to import a client's bank account transactions in an Excel file to QBDT, you may consider performing any of the following options:

• Convert your file (i.e., Excel) to Intuit Interchange Format (.IIF), so you can import them to QuickBooks.
• Use a third-party migration tool/service.
• Manually enter your JE transactions (bank fees).

Regardless of the option you choose, I encourage you to back up your files every time. This way, you're able to restore your company data in case of unintended loss and for future use.

Once done, you can reconcile the same account in QuickBooks, then do it monthly or quarterly for a quicker reconciliation in the system.

To learn more about transferring info to and from QBDT, you can refer to this article: Import and export data in QuickBooks Desktop. It also includes topics about the things to keep in mind when you import or export data.

Please know that you're always welcome to get back to me if you have other importing and file management concerns. I'm available to help anytime. Have a nice day ahead!

@TracieBoltres 

Additional option, utilize this app to reconcile.

https://www.moneythumb.com/?ref=110

HI,

All transactions from excel sheet are entered into QB by journal entries so it is reconciled to excel sheets but not through the QB software.  They want to stop using excel and use the QB Bank Reconciliation tool but are not sure how to start this process with out reconciling the past 12 years in QB.  Is there a way to do this without reconcile past years in QB.

Thanks,

tracie

Hello Tracie,

Thank you for posting. I'm happy to answer your question about your client's reconciliation.

I know 12 years of transactions is a lot. However, if they are already in QuickBooks, you'll really need to reconcile starting from the oldest one. It's okay if some of them are recorded as journal entries as long as they post to the correct accounts, especially to the bank register.

You can do a monthly or yearly reconciliation until you reach the current year. There isn't a shortcut unless you create a new company file and only enter the transactions starting from the last year or since January this year, or depending on your client's fiscal year.

To reconcile a year worth of transactions:

1. Enter an opening balance. This should be the oldest transaction and this only applies to the very first reconciliation, but do not enter one when you already have it.
2. Go to Banking, then Reconcile.
3. Choose which bank account you're working with.
4. In the Statement Date field, enter the last day of the year that you're reconciling.
5. Enter the Ending Balance on the last transaction of that year.
6. Click Continue.
7. Click the Mark All button and confirm your Difference section shows $0.00.
8. Select Reconcile Now.

Please refer to this article for more information: Reconcile an account in QuickBooks Desktop.

Feel free to reach back out if you have other questions about reconciliation. The Community team is already here to help you. Take care!

Hi, thanks for the info,

.

However, My company uses CCC One software in our body shop business, and it pushes data into Quickbooks Desktop Enterprise.

This is accrual base, and how do I reconcile my bank account without duplicating data that is pushed in by CCC One.  

Thanks, Gary Reynolds

Accountant for Pro Auto Collision

Can anyone help me?

Good day! There are a couple of options to choose to make sure there are no duplicate transactions, Gary.

You can ignore or delete the duplicated transactions so they won't show up on the Reconciliation page. I'd be glad to share the steps with you.

First, go to the Bank Feeds Center and use the Ignore function. This will remove duplicate downloaded or imported transactions. Here's how: 

1. Go to the Banking menu and look for Bank Feeds Center.
2. Look for the account where the transactions are showing up.
3. Select all duplicate transactions by checking the boxes before them.
4. Click the drop-down box for Batch Actions, then choose Ignore.

Second, proceed to your bank register if they're already added to it. You can open the transactions one at a time to delete them. Here's how:

1. Open the bank or credit card register.
2. Double-click on the transaction to open it.
3. Click the Delete button and choose Delete.
4. Select Yes to confirm that you want to delete it.

Allow me to share these articles for more details and guidance:

• Remove Duplicate Transactions in QuickBooks Desktop
• Add and Match Bank Feed Transactions in QuickBooks Desktop

Don't hesitate to reply to me and let me know if you're able to remove duplicate transactions. I'd be glad to join you again in this thread and offer my help if you need it again.