Begin reconciling an account

Learn how to begin reconciling a bank account or credit card account.

Before you begin

Decide how you want to reconcile the account. The following are the three methods that you can use to reconcile:

• Manually (against a physical bank statement).

• With an import file using Bank transaction assistant file import.

  Although you can currently use the classic import experience, this method is going away no earlier than May 2026. This change does not impact any custom integrations that use the Intacct API.

• With a bank feed.

To match incoming transactions from an import file or bank feed, create rules and add them to a rule set, then assign that rule set to the account.

Reconcile the account within the level or entity in which it was created. For example, if you created the account at the top level, reconcile at the top level. If you created the account in an entity, slide into that entity to reconcile.

Set up entity and user restrictions correctly so that the appropriate user can transact against and reconcile the appropriate accounts.

Reconcile an account

1. Go to Cash Management > All > Reconciliation > Bank or Credit card.

2. In the Reconciliation window select the account to reconcile.

   I do not see the account that I need in the Account to reconcile dropdown list.

   The following are reasons why you're not seeing an account in the list:

   • Is your account set up appropriately?

     Check to be sure that the GL account is associated with the bank.

   • Where was the account created?

     Accounts created at the top level can only be reconciled at the top level. Accounts created at the entity level can only be reconciled within that entity.

     How do I know where an account was created?

     Slide into an entity. On the account list, any account that you have Edit capabilities for is an account that was created within that entity.

     Accounts designated as Not owned were created in another entity.

   • There might be restrictions or permissions required to access the account.

     Only unrestricted users can reconcile accounts at the top level. To reconcile an account within an entity, user entity restrictions need to be equivalent to or greater than those of the account.

     Example

     If an account is restricted to Entity A and Entity B, a user needs to have restrictions for both to reconcile the account. The user can also have access to other entities, even though they aren't included in the account's location restrictions. However, if the user only has access to Entity A (and not Entity B), the user cannot reconcile the account.

     If your company is configured to Enable user entity restrictions for bank accounts and you are a restricted user, you will not see bank accounts for entities of which you do not have access.

3. If your account is connected to a bank feed, check the Bank feed status to make sure that your account is connected.

   Before you proceed to the account reconciliation page, remove any attached CSV or QIF import files. These files override any matching done by a bank feed.

   Do you see a bank feed status of Auth required?

   Some banks require you to reauthorize your bank feed connection before you receive new transactions. This is a security process put in place by your bank. You'll know if you need to reauthorize if you see a bank feed status of Auth required.

   Learn more about how to troubleshoot bank feeds.

4. Enter the Statement ending date and Statement ending balance.

   Find this information on your bank statement.

   If you're using a bank feed, the Statement ending date determines which bank and Intacct transactions are shown while you are reconciling the account.

   Example

   If you are using a bank feed, transactions download based on the statement ending date.

   For example, it's February and you're reconciling for January with a statement ending date of January 31. Only bank feed transactions with dates on or before January 31 appear to reconcile.

   If you have a Sage Intacct transaction dated in January and a bank transaction dated in February, reconcile that transaction in February.

5. If you're reconciling with an import file using the Classic import experience, Import that CSV or QIF file here.

   If the account is connected to a bank feed, importing a CSV or QIF file overrides any existing matching done by bank feeds.

   Incoming transactions match against transactions in Intacct. If you use multiple import files to reconcile, make sure to only upload the delta (the new transactions) to avoid uploading duplicate transactions.

   The classic experience for import transactions is going away in a future release. This change does not impact any custom integrations that use the Intacct API. Try Bank transaction assistant file import for a more robust experience.

6. Select Continue.

Next step: If you're reconciling with an import file or bank feed, transactions match based on the account's rule set. Manually match remaining transactions and create additional transactions as needed.

When the Amount to reconcile is zero and with the appropriate permissions, finalize the reconciliation.