Troubleshoot reconciliation

To reconcile a bank account with either an import file or a bank feed, make sure that you create a rule set and apply it to the bank account.

Some downloaded transactions are not relevant to your reconciliation and act as visual noise and clutter on the page. These might be zero-dollar transactions or duplicate transactions. Store these transactions out of the way by ignoring them.

Unmatching duplicate transactions created by a creation rule causes the rule to run again and create another Intacct transaction. To avoid this, follow these steps:

1. Inactivate the creation rule that created the transaction.
2. Edit the rule so that only the transactions you expect are created.
3. Unmatch, and then delete, the transaction that has been incorrectly created.
4. Reactivate the rule when you are ready.

If you manually unmatched a transaction, it can't be automatically matched again using a rule set. Instead, manually match the transaction. You can check to see if a transaction has been manually unmatched on the Match transactions page for that transaction. Look for the Unmatched by and Unmatched date fields.

Make sure to partially match transactions before you finalize your reconciliation.

Make sure that there are transactions in Sage Intacct that you can reconcile by checking the Bank register report. Transactions with a state of In Transit have not yet been reconciled.

1. Go to Cash Management > All > Reports > Registers > Bank.

2. In the Time Period section, select the Reporting period.
3. In the filters section, select the Bank.
4. Select Show reconciliation status.
5. Select In Transit for Reconcile state.
6. Select View.

If you're using bank feeds, learn why you might not be seeing bank feed transactions.

Learn more about how to use filters to view transactions for reconciliation.

If you're using bank feeds, learn why you might not be seeing bank feed transactions.

Learn how to unmatch a transaction.

To finalize the match, approve the journal entry if necessary, then post it. The journal entry and bank transaction automatically match for reconciliation and the Amount to reconcile field updates to the correct amount.

Learn how to view bank transactions that are tagged as Draft matched during reconciliation.

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.

Currently, this functionality is not supported.

Instead, manually match the group of Intacct transactions to one bank transaction. Then, ignore the other associated bank transactions.

This can happen when you edit the matched journal entry to change the bank account or the amount. In this case, you can manually match the transaction.

Learn why these transactions are appearing and how to match and reconcile them.

If this is your first time reconciling, check your beginning balance cutoff date. If the bank transaction falls exactly on the beginning balance cutoff date, any transactions you create will be included in the AUTO ENTRY sum of the account's beginning balance.

You can adjust the beginning balance cutoff date to one day prior, for example, to include the created transaction and match it for reconciliation.

If your company is configured to Include zero-amount GL transactions in reconciliations and reconciliation reports, voided unconfirmed checks and standard ACH payments appear as zero-dollar transactions in reconciliations and register reports. Learn how to reconcile voided transactions.

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.

If you discover that one or more journal entries are missing from your reconciliation, the cause can be due to one or more of the following:

• The incorrect GL account was used for the journal entry.

• An incompatible beginning balance cut-off date was used in the first reconciliation.

  Say you finished a reconciliation and have journal entries transacted before the beginning balance cut-off date. These transactions will not appear in the reconciliation.

• You're reconciling a credit card account.

  Manual journal entries do not appear in the credit card reconciliation process. The only transactions that appear are credit card transactions, charge payoffs, and payments with credit card as the payment method.

• (Multi-currency companies) The transaction currency of the journal entry doesn’t match the currency of the bank account, which can occur when the bank account currency is different from the base currency of the company.

Learn about other reasons why a journal entry might be missing.

A zero balance indicates that this is the first time you’re reconciling. Because there’s no previous reconciliation, the balance is zero. Any reconciliation after the first displays the last reconciled amount.

Did you create the transaction in Order Entry or Purchasing, and is the transaction definition configured to post to a bank account? These types of transactions don't appear in reconciliation.

The Amount to reconcile field might not show a zero amount due to a number of reasons, such as uncleared checks or deposits, or an incorrect bank statement.

Learn more about what you can do when the amount to reconcile doesn’t equal zero.

If you're in the middle of a reconciliation and need to start over, first go to the account reconciliation page and filter for matched transactions. Then, select all unmatched transactions and select Unmatch transactions.

Get more details on how to clear a pending reconciliation.

Reopen the reconciliation on the Reconciliation histories page.

You need Cash Management reconciliation permissions for both Report and Reopen to reopen a reconciliation.

There are two options to remove an initial open item:

• Reopen the reconciliation and delete an initial open item, or,
• Create a journal entry to zero out an initial open item.

To adjust these fields for the current, open reconciliation, go to the Reconciliation pop-up window and re-enter the information.

To adjust these values in a prior reconciliation, reopen the reconciliation.

Learn how to edit or void reconciled transactions.

You might have uploaded a bank statement that contains errors. For example, transactions might have incorrect positive or negative signs. Learn how to remove the erroneous import file and transactions from your reconciliation and re-import a new file.

Make sure that your dates are formatted as MM/DD/YYYY.

This error can also occur if there are blank rows or white spaces in the import file.

If the Posting date column in your import file is already correctly formatted as MM/DD/YYYY and you still receive the "Invalid date format" on import, try the following workaround:

1. Open the bank reconciliation import file in Notepad. The file must already have been saved as a CSV file.
2. Find any lines that have 6 commas in a row (, , , , , , ) and delete those lines from the file.
3. Save the file.
4. Try importing the file again.