Use filters to view transactions during reconciliation

Use filters to view different types of Sage Intacct and bank transactions. By default, all unmatched Intacct transactions appear when you first access the account reconciliation page.

You can either import bank transactions or connect to a bank feed.

You can also view bank transactions on the Banking cloud tab on the account record and Bank transactions page.

View matched or partially matched transactions

View which transactions were already matched and which transactions remain to be matched.

Subscription

Cash Management

Sage Cloud Services enabled for bank feeds or Sage Cloud Services enabled for Bank transaction assistant file import

User type

Business
Permissions

Reconcile bank: List and View

Reconcile credit card: List and View

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

  2. Enter account information, then select Continue.
  3. On the account reconciliation page, select either the Intacct tab or the Bank tab to view transactions.

    Transactions that already exist in the system appear on the Intacct tab. Bank transactions appear on the Bank tab.

  4. In the State dropdown list, select Matched or Partially matched.
  5. Select Apply filters.

Select Clear filters to remove filters.

View transactions by type

Use filters to view specific transaction types like deposits and credits, cheques and debits, and more.

Subscription

Cash Management

Sage Cloud Services enabled for bank feeds or Sage Cloud Services enabled for Bank transaction assistant file import

User type

Business
Permissions

Reconcile bank: List and View

Reconcile credit card: List and View

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

  2. Enter account information, then select Continue.
  3. On the account reconciliation page, select either the Intacct tab or the Bank tab to view transactions.

    Transactions that already exist in the system appear on the Intacct tab. Bank transactions appear on the Bank tab.

  4. From the Transaction type dropdown list select a transaction type.
    • For bank reconciliation, select Deposits and credits or Cheques and debits.
    • For credit card reconciliation, select Chargesor Payments.
  5. Select Apply filters.

Select Clear filters to remove filters.

View bank feed transactions

View bank feed transactions during reconciliation. You can view bank transactions that have been matched for reconciliation (and which Sage Intacct transactions they matched to) and those that are still unmatched.

Are you missing bank feed transactions?

Subscription

Cash Management

Sage Cloud Services enabled for bank feeds
User type

Business
Permissions

Reconcile bank: List and View

Reconcile credit card: List and View

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

  2. On the Reconciliation window check the Bank feed status field to make sure that your account is connected.

    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 bank feed status descriptions and how to troubleshoot bank feeds.

  3. If you already imported a bank file, remove the import file before you continue.

    If you're connected to a bank feed and continue to the reconciliation page with an import file, the file overrides any matching that has already occurred from a bank feed.

    To remove an import file, select Import. Then, select the trash icon.

  4. Select Continue.
  5. On the account reconciliation page, go to the Bank tab.

All unmatched transactions appear. To view matched transactions, From the State dropdown list select Matched and then select Apply filters . Learn more about filtering and sorting transactions.

View draft matched transactions

View a draft match of a journal entry. To complete the match, approve and post the journal entry.

Create a draft journal entry from a bank transaction and link the two transactions together to eliminate the possibility of creating a duplicate journal entry for a bank transaction. When the journal entry is approved and posted, these two transactions automatically match for reconciliation.

You can only create a draft matched journal entry for bank transactions that occur after the beginning balance cut-off date for the reconciliation.

For example, you have a bank transaction from 10/31/2023 and your beginning balance cut-off date is 11/1/2023. You cannot create a draft matched relationship between that bank transaction and a draft journal entry. You can still create a draft journal entry, but the two transactions will not be linked and the bank transaction will not have a state of Draft matched; it will show as Unmatched.

Subscription

Cash Management

Sage Cloud Services enabled for bank feeds or Sage Cloud Services enabled for Bank transaction assistant file import

User type Business
Permissions

Reconcile bank: List and View

Reconcile credit card: List and View

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

  2. Enter account information, then select Continue.
  3. On the account reconciliation page, go to the Bank tab.
  4. In the State dropdown list, select Draft matched.
  5. Select Apply filters.
  6. To view the associated draft journal entry, select Match.

    On the Match transactions page, the draft journal entry appears in the Matched to transactions section.

Make sure that the bank transaction date falls after the beginning balance cut-off date for the reconciliation period. You can only create a journal entry draft match for bank transactions that fall after the beginning balance cut-off date.

For example, if you have a bank transaction from 1/31 and the beginning balance cut-off date is 2/1, you cannot create a draft match relationship between that bank transaction and a draft journal entry. You can still create a draft journal entry, but the two transactions will not be linked and the bank transaction will not have a state of Draft matched.

View all transactions

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

  2. Enter account information, then select Continue.
  3. On the account reconciliation page, select either the Intacct tab or the Bank tab to view transactions.

    Transactions on the Intacct tab are transactions that already exist in the system.

    Transactions imported using Bank transaction assistant file import or received from a bank feed, appear on the Bank tab.

  4. Select Allfrom the States dropdown list.
  5. Select All from the Transaction types dropdown list.
  6. Select Apply filters.