---
description: >-
  This page provides all the details related to our account reconciliations
  module.
---

# Account Reconciliations

## General

Our account reconciliation module is the heart of Equility. The first step of every bookkeepers job is to ensure that the accounts are reconciled properly. This ensures data fidelity between the accounting system and the actual business transactions.&#x20;

Equility helps to ensure that your business transactions and balances are properly recording within the accounting system, which for our purposes would be QuickBooks Online. We do this by identifying the transaction details that are recorded within QuickBooks and making sure that these details match those within your online banking portal.&#x20;

We are presently looking at the following details, which can be found both of QuickBooks Online and within your online banking portal, in order to identify matches:

* Transaction Dates
* Transaction Amounts
* Transaction Ref Numbers/Check Numbers
* Transaction Descriptions

As our platform analyzes more of your business data, we will be able to suggest more detailed matches based on our machine learning capabilities.&#x20;

## How To Reconcile Your Account

### Step 1: Start Reconciliation Process - Within QuickBooks Online



There are two ways to start your reconciliation process using Equility. The first thing that you'll need to do is to make sure that you've installed [install our plugin](https://chromewebstore.google.com/detail/equility-extension/agpmjpajjhdifpfdbmlllhcinbafkalc?hl=en\&authuser=0\&pli=1), which works on the Chrome, Edge, and Brave browsers. This allows us to add a 'Reconcile with Equility' button directly within your QuickBooks Online reconciliation module for easy access to our platform:

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2FSbJXa2Wt0zYvIAPpkMbY%2FScreenshot%202025-06-24%20210007.jpg?alt=media&#x26;token=daad7124-741a-4175-979a-2f632a81886d" alt="" width="563"><figcaption></figcaption></figure>

Once you click the 'Reconcile with Equility' button, you will be taken directly to our reconciliation's 'Run' page. By using the plugin, the application will be able to fill out a large majority of information needed to complete your reconciliation.&#x20;

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2Fgl6wAZsLpF52B7LEV9pa%2FScreenshot%202025-06-25%20112041.png?alt=media&#x26;token=ab9aa48f-a8c6-4f78-a8de-0c9f07285c52" alt="" width="563"><figcaption></figcaption></figure>

### Step 2: Enter Reconciliation Details



In order to proceed with the reconciliation, you will need to fill out the following details on the reconciliation's 'Run' screen above. These details include:

* General Ledger Account
  * Choose the general ledger account that you'd like to reconcile.
* Last Completed QuickBooks Online Reconciliation Date
  * Please enter the ending date for the last completed reconciliation within QuickBooks Online for the general ledger account that is being reconciled. If the account has never been reconciled then please input 2000-01-01 as the date.
* Ending Date For This Reconciliation
  * Please enter the ending date for the last completed reconciliation within QuickBooks Online for the general ledger account that is being reconciled. If the account has never been reconciled then please input 2000-01-01 as the date.
* Beginning Balance
  * Enter the beginning balance for this reconciliation.&#x20;
* Ending Balance
  * Enter the ending balance for this reconciliation.
* Matching Date Range
  * Specify the number of days before and after a transaction's date Equility should look for potential matches between bank and QuickBooks data.&#x20;
  * This is important part of the matching process. You might write a check on January 1st but it might not get cashed and show up on your bank statement until January 4th. In this case, we want the matching date range to be at least three days, to ensure that the application knows that the date differential is within our margin of error.

Once these details are entered, you will be ready to link the transactional source data that you'd like us to use for this reconciliation.

### Step 3: Link Transactional Source Data

For reconciliation purposes, this source data is your bible or single source of truth. If you connect Equility directly to your bank account, we will be able to automatically grab your transactions once you click on the appropriate account listed under the 'Source Data Import' section:

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2FsxrziqAu4v8oUbmg4rGw%2FScreenshot%202025-06-25%20113216.jpg?alt=media&#x26;token=d2582fa0-65d0-48d0-bef7-95a38803701a" alt="" width="563"><figcaption></figcaption></figure>

If you're banking institution does not support our direct connection, then you have the option of uploading your transaction information via CSV file using the 'Upload' button on the left side of the screen.&#x20;

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2FOqaevqGV4PGl10RNtWGr%2FScreenshot%202025-06-25%20113606.jpg?alt=media&#x26;token=f85d6f45-3dd8-434e-ad5a-e427cc9b1821" alt="" width="563"><figcaption></figcaption></figure>

A video tutorial of this upload process can be accessed by clicking the 'View CSV Upload Tutorial' button within the application or by [clicking this link here](https://assets.equilityhq.com/documentation-videos/CSV-Upload-Instructions.mp4).

Once the transactional source data is connected, simply click the 'Run Reconciliation' button on the bottom right part of the screen and Equility will start it's matching process. Once this has been completed, you will be redirection to our 'Results' section, where you will (you guessed it!) see the results of our automated reconciliation process.

### Step 4: View Auto Reconciliation Results & Complete Reconciliation

#### QuickBooks Online Transactions

After our system has completed its auto-matching process, you will be taken to our results screen where you can get details about the matches that we were able to make. On the left side of the screen, you will see a list of the QuickBooks transactions, which you can toggle based on the status of the transactions: Matched, Unmatched, or All.

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2FbviLzipCv0oZhFs5oMhG%2FScreenshot%202025-06-25%20115731.jpg?alt=media&#x26;token=6121ba75-98c8-4fe1-bd93-576d1cf8e1a8" alt="" width="563"><figcaption></figcaption></figure>

The details associated with the transactions in each of these sections are as follows:

* Matched
  * We were able to find a match for these transactions from within your transactional source data.&#x20;
  * If you'd like to see the details associated with any of the matches, then click the green checkmark icon under the 'Matched' column and a 'Matched Transaction' pop-up window will appear. In this pop-up, you will be able to see the details associated with the match. You can also click the 'unmatch' button if you feel like this match was made in error.

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2F6JqUPI0quFRcYkseIVHP%2FScreenshot%202025-06-25%20124505.png?alt=media&#x26;token=582b9d10-f882-4ed0-87b9-9799ba41acd4" alt="" width="563"><figcaption></figcaption></figure>

* Unmatched
  * We were unable to find a match for these QuickBooks Online transactions from within your transactional source data.
* All
  * This section shows all of your transactions, regardless of their match or unmatch status.&#x20;

#### Source Data Transactions

On the right side of the screen, you will see a list of the source data transactions, which you can toggle based on the status of the transactions: Matched, Unmatched, or All.

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2FvjGTB6vL1QxFboLkaWhy%2FScreenshot%202025-06-25%20125204.jpg?alt=media&#x26;token=41fd15d7-d033-4189-80d6-25bc3ec9ae55" alt="" width="563"><figcaption></figcaption></figure>

The details associated with the transactions in each of these sections are as follows:

* Matched
  * We were able to find a match within QuickBooks Online for these source data transactions.
  * If you'd like to see the details associated with any of the matches, then click the green checkmark icon under the 'Matched' column and a 'Matched Transaction' pop-up window will appear. In this pop-up, you will be able to see the details associated with the match. You can also click the 'unmatch' button if you feel like this match was made in error.
* Unmatched
  * We were unable to find a match with QuickBooks Online for these source data transactions.
  * If you believe that there is not a match within QuickBooks Online for any of these transactions, then you can choose to add this transaction to your QuickBooks Online general ledger. To do this, click the blank square to the left of the transaction(s) date to activate the green checkmark associated with each transaction. You can then click the 'Add to QuickBooks' button.
  * You will then see an 'Export To QuickBooks' pop-up where it lists all of the transactional details that you can define before adding the transactions to QuickBooks Online: account, name, class, and type.

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2Fxpl6IaiAn2eQkyDVAvUE%2FScreenshot%202025-06-25%20125820.jpg?alt=media&#x26;token=531658aa-3b1a-40a6-99db-f0014e8a8bfd" alt="" width="563"><figcaption><p>'Add to QuickBooks' button</p></figcaption></figure>

<figure><img src="https://3391941760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaIjClKmMtUftFUZwWGHO%2Fuploads%2FYm642vQ7LJreBiSfyUIs%2FScreenshot%202025-06-25%20130354.png?alt=media&#x26;token=f0a16d8c-23ff-4aa1-b6cb-0dcb243eb495" alt="" width="563"><figcaption><p>'Export to QuickBooks' pop-up</p></figcaption></figure>

* All
  * This section shows all of your transactions, regardless of their match or unmatch status.&#x20;

### Step 5: Complete Reconciliation & Export Results to QuickBooks Online

Once you've gotten your reconciliation's difference to $0.00, you will be able to click the 'Done' button to export these results to QuickBooks Online. If you're difference is $0.00 but the 'Done' button is still disabled, then this is likely due to the fact that you have unmatched source data transactions that either need to be a) matched to a transaction with QuickBooks Online or b) added to QuickBooks. A video representation of this type of issue and how to resolve it [can be found here](https://www.loom.com/share/9fe9349f21cd46f5bb4a18f830ad22cc).

After you click the 'Done' button, you can export your results back to QuickBooks Online, where our application will automatically add a blue checkmark next to all of the reconciled transactions, so that you're difference in QuickBooks Online is shown as $0.00 as well. A video of this process can be found [here](https://www.loom.com/share/ef916c90070f4c5c942bdb591b2c2886).
