Reconciliation: About reconciling in Sage Intacct

Keywords: Reconciliation, Transactions, Reports, Money, Accounts, Sage

Credit:–  Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

Reconciliation: When to reconcile

Most companies perform a reconciliation at the end of the month. However, you can match transactions throughout the month or even perform daily or “soft” reconciliations to help eliminate your month-end close. Users with the appropriate permissions can then finalize the reconciliation when all transactions are accounted for. Before you finalize a reconciliation, make sure that all transactions are entered into Intacct and that all charge payoffs are completed.

Where to reconcile and entity restrictions

Where you reconcile an account depends on the following:

  • Whether the account was created at the top level or within an entity.
  • Whether there are restrictions set up for the account.
    Notes
  • To reconcile a restricted bank account, you must have restrictions that are equivalent or greater than the restrictions on the account.
  • Reconcile the account in the same entity in which it was created.
  • To prevent top level users from viewing reconciliation histories, including outstanding items, for an account based on their entity location restrictions, configure Cash Management to Enable user entity restrictions for bank accounts.

Separate tasks with permissions

Make sure that reconciliation tasks are delegated to the appropriate representative in your company with reconciliation permissions. For example, a bookkeeper has permissions to match transactions. A staff accountant reviews matched transactions and records the reconciliation. Finally, a controller views reconciliation reports. To reopen a reconciliation and make changes, you need permissions for both Reopen and Report.

Reconciliation methods

There are three ways to reconcile an account.

Manually

Manually match (or clear) Intacct transactions based on a physical bank statement. When the Amount to reconcile field is zero, select Reconcile to complete the reconciliation.

Import a bank file

Automatically match transactions with Bank transaction assistant file import. Imported transactions appear on the Bank transaction file imports page. Bank transactions match =against Intacct transactions for reconciliation using the account’s rule set. While you can 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. After transactions match, manually match (or clear) any that remain. You might need to create additional transactions to match what’s in the bank. When the Amount to reconcile field is zero, select Reconcile to complete the reconciliation. Upload multiple files for daily or weekly imports to save time during the month-end close process. Avoid duplicate transactions and only upload the delta (the new transactions). Ignore duplicate transactions.

Bank feeds

Connect an account to a bank feed and download bank transactions directly into Sage Intacct. You can connect checking accounts, savings accounts, and credit card accounts to a bank feed. Your account needs an applied rule set to match transactions. Manually match (or “clear”) any unmatched transactions. You might need to create additional transactions in Intacct to match what’s in the bank. When the Amount to reconcile field is zero, select Reconcile to complete the reconciliation.

Terminology

A transaction is considered Matched if the following conditions are met:

  • The transaction automatically matched against incoming data from an import file or bank feed using a rule set.
  • You manually matched an Intacct transaction and a bank transaction on the Match transactions page.
    This functionality is only available when you’re matching a transaction from an import or bank feed.
  • You’re reconciling against a physical bank statement (there are no bank transactions in Intacct to match against) and you manually select the Intacct transaction and then select Clear transactions on the account reconciliation page.
    This cleared transaction is considered Matched when you filter for it on the reconciliation page. In register reports, the transaction displays as “Cleared” only after you finalize the reconciliation by selecting the Reconcile button. Until then, it appears as “In Transit”. A transaction is considered Cleared on the Bank transactions list and in register reports only after you select Reconcile.

Start a reconciliation

Reconcile an account in the entity in which it was created. Depending on your company’s configuration, there might be additional restrictions in place. Start a reconciliation by going to Cash Management > All > Reconciliation and select either Bank or Credit card, depending on the account you want to reconcile. The Reconciliation popup window appears where you enter basic information about the account you want to reconcile. If you’re reconciling with an import file or bank feed, make sure you have an applied rule set for the account to determine how to match incoming transactions.

If you’re reconciling an account for the first time, there are some extra steps to do that you will not have to do in later reconciliations. For example, you might need to enter initial open items.

Match (or clear) transactions

After you select the account to reconcile, you continue to the account reconciliation page. The default view on this page is unmatched Intacct transactions. However you can filter for more transactions. If you’re reconciling with an import file or bank feeds, a tab appears above the transaction table labeled Bank. Select this tab to view bank transactions. You can start matching from either tab; Intacct or Bank.

If you’re reconciling with a physical bank statement (there are no bank transactions in Intacct), select the Intacct transactions and then select Clear transactions.

Filtering and sorting

When you access the account reconciliation page all unmatched transactions appear. Use filters to find the transactions you need to complete your reconciliation. The most commonly used filters appear above the transaction grid so they’re immediately available and visible when you reconcile. For more granular filters like Payee and General Ledger posting date range, select to Show more filters. Make sure to select Apply filters after you select your filter. Select any column head to sort that column alphanumerically.

Create additional transactions

If your account is out of balance, you might need to create additional transactions within Intacct to complete the reconciliation. Depending on your permissions, you can create these transactions from different access points. Use creation rules to create journal entries and credit card transactions in Intacct from bank data.

Foreign currency banks

Create or record transactions with your foreign currency bank only in that bank’s currency. For example, with a Canadian bank you should generally transact only in Canadian dollars. This enables you to reconcile all transactions correctly to your bank statement.If you accidentally enter a General Ledger journal entry to your Canadian bank account in a transaction currency other than Canadian dollars, that transaction will not appear for bank reconciliation. You’ll have to account for such a transaction manually in your bank reconciliation process.

Your bank might use an exchange rate that differs from how you record transactions in your accounting system. In this case, adjust the exchange rate differences by booking a GL journal entry for your bank reconciliation to complete your month-end bank reconciliation.

Change a closed reconciliation

You might need to change or correct a transaction error that’s in a reconciliation that has already been closed. In this case, you need to reopen a reconciliation.

You need Cash Management permissions for both Reopen and Report for Reconcile bank or Reconcile credit card, depending on the account.

Set up to reconcile: Restrict reconciliation in a multi-entity company

Limit who can reconcile and transact against an account in a multi-entity company. Follow the steps below to enable restrictions in your company for bank reconciliations. Only users with Admin privileges can set up restrictions.

Notes

  • To reconcile a restricted bank account, you must have restrictions that are equivalent or greater than the restrictions on the account.
  • Reconcile the account in the same entity in which it was created.
  • To prevent top level users from viewing reconciliation histories, including outstanding items, for an account based on their entity location restrictions, configure Cash Management to Enable user entity restrictions for bank accounts.

Enable restrictions in your multi-entity company

  • At the top level of your company, go to Company > Admin > Subscriptions > Multi-Entity Management > Configure.
  • Under Entity restrictions, select Checking accounts, Savings accounts, or both depending on your requirements.
  • Select Save.

Restrict entity access to the bank account

Select the entities that can transact against the account.

  • Go to Cash Management > Setup > Accounts, and select either Checking or Savings.
  • Find the appropriate account and select Edit.
  • On the Restrictions tab, select Restricted.
  • Select Add or Edit and move the appropriate locations from the Available items pane to the Selected items pane.
  • Select Save.

Restrict user access to the same entities

Restrict users to the same entities as the entities defined in step 2. To reconcile the account, user restrictions must be equivalent to or greater than the restrictions defined on the account record. Say a checking account is restricted to Entity A and Entity B. To reconcile the account, a user needs to be restricted to both Entity A and Entity B. If the user is only restricted to Entity A and not Entity B, they cannot reconcile the account. If the user is restricted to Entity A, Entity B, and other entities, they can reconcile Entity A and Entity B.

  • Go to Company > Admin > Users.
  • Find the user and select Edit.
  • On the User entities tab, select the appropriate entities.
  • Select Save.
  • Enter your password to verify your identity then select Done.
  • Select Save.

Grant permissions to reconcile

A user with equivalent entity restrictions and reconciliation permissions can reconcile a restricted bank account. Users with appropriate permissions can reconcile an account created within the entity to which the user is restricted.

  • Go to Company > Admin > Users.
  • Find the appropriate user and select Subscriptions.
  • Select Cash Management, if it is not already selected, and select Permissions.
  • Find Reconcile bank or Reconcile credit card and grant permissions for reconciliation.
    To match transactions, grant permissions for List, View, and Add. To reconcile the account, user permission to Reconcile.

Reconcile an account: Begin reconciling an account

Reconcile a checking account, savings account, or credit card account. Is this the first time that you’re reconciling the account? Learn about initial open items, beginning balance cut-off dates, and the AUTO CONTRA and AUTO ENTRY fields. 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.
    While you can 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

  • Go to Cash Management > All > Reconciliation > Bank or Credit card.
  • 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. 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.
  • If your account is connected to a bank feed, check the Bank feed status field 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.
    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 or 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.
  • 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.
  • 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.

Reconciliation histories list: Outstanding items report

The Outstanding items report contains the following information:

  • The list of transactions that you have not yet cleared.
  • Information about the reconciliation such as: opening balance, book balance, ending balance, and uncleared balance.

Any user with Cash Management Reconciliation permissions for Report and List and appropriate account restrictions can view reconciliation reports. To prevent a user from seeing all reconciliation reports, remove the Report permission. To prevent top level users from viewing reconciliation histories, including outstanding items, for an account based on their entity location restrictions, select to Enable user entity restrictions for bank accounts in Cash Management.

  • Go to Cash Management > All > Reconciliation > View reconciliation histories.
  • Find the account.
  • Select Outstanding Items Report.
    A popup appears in which you can select the output type.
  • Select CSV, EXCEL, or PDF.
  • Print the report from the associated application.

Pending reconciliation report

Download a pending reconciliation report for an account from the account list. The report includes the following information:

  • The last reconciled date
  • Statement ending and beginning balances
  • Amount left to reconcile
  • Remaining transactions to match

If your company uses foreign transaction currencies, the report is in the currency of the bank, which can be either your base currency or a foreign one. Any user with Cash Management Reconciliation permissions for Report and List and appropriate account restrictions can view reconciliation reports. To prevent a user from seeing all reconciliation reports, remove the Report permission. To prevent top level users from viewing reconciliation histories, including outstanding items, for an account based on their entity location restrictions, select to Enable user entity restrictions for bank accounts in Cash Management.

  • Go to Cash Management > All > Accounts and select the appropriate account type.
  • On the account list, find the account.
  • Select Pending reconciliation.
  • Select the report format (CSV, Excel, or PDF).

Reconciliation report

The Reconciliation report contains a list of transactions that cleared the bank or that remain open, book balance, ending balance, and uncleared balance. If you created an additional transaction from a reconciliation page that’s outside the reconciliation period, that transaction appears as an adjustment in the report. If your company uses foreign transaction currencies, the report is in the currency of the bank, which can be either your base currency or a foreign one. Any user with Cash Management Reconciliation permissions for Report and List and appropriate account restrictions can view reconciliation reports. To prevent a user from seeing all reconciliation reports, remove the Report permission. To prevent top level users from viewing reconciliation histories, including outstanding items, for an account based on their entity location restrictions, select to Enable user entity restrictions for bank accounts in Cash Management.

Cannot see any reconciliation reports?

  • Go to Cash Management > All > Reconciliation > View reconciliation histories.
  • Find the appropriate entry.
  • Select Reconciliation report.
    A popup appears in which you can select the output type.
  • Select CSV, EXCEL, or PDF.
  • Print the report from the associated application.

Reopen a reconciliation

Reopen a reconciliation to edit or change transactions that have already been reconciled.

When do I need to reopen a reconciliation?

You might need to reopen a reconciliation if you entered an incorrect ending date or ending balance, or if a payment was made but never recorded. Or, you might find that a payment that was sent to a vendor was never received and you need to void it.

Alerts:

  • To reopen a reconciliation, you need Reconcile bank or Reconcile credit card permissions for both Reopen and Report.
  • You cannot undo reopening a reconciliation.
  • You need to re-reconcile for the reopened period and any later periods.
    Example: You’re in August and reopen the reconciliation from June. Re-reconcile for June and July.

Reopen a reconciliation

  • Go to Cash Management > All > Reconciliation > View reconciliation histories, and select Reopen.
    A popup appears letting you know how many periods you’re reopening.
  • Select OK.
  • Select the Account to reconcile.
  • Select Continue.
    The account reconciliation page appears. Transactions that were matched in that period appear as matched.

Open and close periods

Closing periods is a regular part of the month-end process and prevents users from posting transactions to the wrong period. To close a period from the Cash Management application, the books for the period must be open. Closing a period enables you to close open Cash Management periods independently of other applications. At the top level, you can close periods for all entities or a single entity. Open periods are not automatically closed when you close a subsequent period. For example, you closed the period for Q1, but not for Q2. If you close the period for Q3, Q2 remains open.

Close a period

  • Go to Cash Management > All > Subledger > Close.
  • Specify a single period or a range of periods in the To the end of period dropdown.
    The dropdown list only contains the open periods that you can close.
  • In a top-level company, choose an Entity or entity group.
    If you close periods at the top level for AP, AR, CM, or GL, leaving the Entity or entity group field blank closes this period for all entities unless it has been closed at the entity level.
    If you open periods at the top level for AP, AR, or CM, leaving the Entity or entity group field blank reopens the period for only the top level. In this case, select each entity or group individually and reopen the period within the entity. However, opening periods at the top level for GL reopens the period for all entities.
    You can select a specific entity or several entities for open and close. To include multiple entities for opening and closing books, use a location group that has been set up with the specific member entities. Groups that contain both entities and locations or that contain dynamic members don’t appear in the list. This helps ensure that an invalid entity group isn’t selected.
    Select Close.

Open periods

To make changes to a closed period (such as creating or changing transactions), first re-open the period. This reopens a closed period for the Cash Management application independently of other applications. Make sure that the books for the period are open before you reopen the period. If you open periods at the top level, leaving the Entity or entity group field blank only reopens the period for the top level. In this case, select each entity or group individually and reopen the period within the entity. However, opening periods at the top level for GL reopens the period for all entities. To include multiple entities for opening and closing books, use a location group that’s set up with the specific member entities. Groups that contain both entities and locations or that contain dynamic members do not appear in the list. This helps ensure that an invalid entity group is not selected.

Open a period

  • Go to Cash Management or, Accounts Payable > All > Subledger > Open.
  • Specify a single period or a range of periods in the To the start of period dropdown.
    The dropdown list only contains the closed periods that you can open.
  • In a top-level company, choose an Entity or entity group.
    Leaving this field blank at the top level only opens the top level period.
  • Select Open.

Check out our Free Additional Articles