Field descriptions: Reconcile bank account and Reconcile credit card account pages

Account to reconcile

Select the bank account to reconcile.

Cannot see the account?

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.

Beginning balance cutoff date

The cutoff date can be the day before you transitioned to Sage Intacct or another date if you do not want to do a complete reconciliation that goes all the way back to when you first started using Sage Intacct. Typically, it's the day before the statement start date. For example, if the statement start date is February 1, January 31 is the beginning balance cutoff date.

This field appears only for accounts that have not been previously reconciled in Sage Intacct.

Statement ending date

The ending date from your statement. You can adjust the statement ending date. If you never reconciled this account, the default is today's date. When you perform subsequent reconciliations, the date increments by one month.

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.

Statement ending balance

Enter the ending balance from your bank statement.

Reconciliation status

The status of the reconciliation.

Last saved

The date when the reconciliation was last saved. You can save a reconciliation and return to it later to complete your work.

Created by

The user who began the reconciliation.

Last saved by

The user who last saved the reconciliation.

Last bank feed date

For accounts connected to a bank feed. This date is when Sage Intacct last checked if there were bank transactions at the bank to bring into Intacct.

Last bank feed transaction date

For accounts connected to bank feeds. This is the date of the last transaction received through a bank feed.

Last reconciliation type

How the account was previously reconciled (manually, with an import file, or with a bank feed).

Bank feed status

For accounts connected to a bank feed. View bank feed status descriptions.

Applied rule set

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.

Import

Upload and import your bank file for reconciliation. You account needs to have a rule set for transactions to match, or to create new Sage Intacct transactions from bank data.

Initial open items

This link appears during the first reconciliation for the account, but you can manually enter or import the open items at any time. Initial open items are cheques, deposits, and other items that were not reconciled in the previous accounting system.

You can also enter initial open items to account for a minor discrepancy that you cannot otherwise resolve. In this case, describe the initial open item as an adjustment.

Initial open item transactions do not affect the general ledger and only appear in the Bank register.

Edit

Access the initial Reconcile popup window.

You can edit the following fields:

• Beginning balance cut-off date

• Statement ending date

• Statement ending balance

• Attachment

Save

Save your progress. To access your work, return to the Reconciliation page and select the same account to reconcile.

Refresh

Refresh your changes. If your account is connected to a bank feed, this button manually refreshes the feed.

Reconcile

Complete the reconciliation. This signifies that transactions cleared the bank. Only a user with the Cash Management reconciliation permission for Reconcile can view and select this button.

Cancel

Exit the page.

More actions

If you have bank transactions that do not have a matching Sage Intacct transaction in Intacct, you can create additional transactions here. For example, if someone has written a manual cheque that was not recorded in Sage Intacct, select Create manual payment and enter that transaction.

Select Refresh for newly created transactions appear for reconciliation.

Statement ending date

The statement ending date from your bank statement.

Last reconciled

The date of the previous reconciliation.

Bank feed status

For accounts connected to a bank feed. View bank feed status descriptions.

Last bank feed date

For accounts connected to a bank feed. This is the date of the most recent download of transactions from a bank feed.

Last bank feed txn date

For accounts connected to a bank feed. This is the date of the last transaction received through a bank feed.

Bank refresh status

For accounts connected to a bank feed.

• Success: All available transactions were successfully downloaded into your company.
• Failed: Something happened and your request to download data failed. Select Refresh to try again.
• Partial success: Some transactions were downloaded successfully. Select Refresh to try again.
• Refreshing: Intacct is still downloading your transactions. This can take a few minutes.

Learn more about refreshing a bank feed.

Unmatched transactions

The number of transactions that still need to be matched for this account to be reconciled.

Unmatched amount

The total amount that remains to be matched.

Matched cheques and debits, Matched deposits and credits, Matched charges, and Matched payments

Sage Intacct keeps separate running totals of matched cheques and debits and deposits and credits so that you can compare this total to the one on your statement.

For credit card reconciliation, you can view the total amount of matched credit card charges and the total amount of matched credit card payments.

Beginning balance

The statement ending balance of the previous reconciliation.

Book balance

The account balance is taken directly from the General Ledger. This sum does not include any initial open items, or the compensating entries for those items.

If you're reconciling at the top level, the book balance is the sum of the balances for all entities.

Although compliance journal entries appear in the reconciliation process, compliance transactions do not affect the Book balance total. A compliance book is used solely to create financial adjustment journal entries for reporting purposes only.

Statement ending balance

The ending balance from your statement that you entered into the first page of the reconciliation process.

Difference

The amount remaining after the statement ending balance is subtracted from the book balance.

Uncleared

The sum of all uncleared items that affect the General Ledger. This sum does not include initial open items, or the compensating entry for those items.

Amount to reconcile

The amount remaining to resolve before you can finish the reconciliation. It should be 0. The Amount to reconcile is the uncleared balance minus the difference. As you match transactions, this number changes. It also changes according to whether you’re clearing cheques or deposits.

Is the Amount to reconcile field not zero?

State

Transaction states include:

• Unmatched: This is the default view, so you see transactions that need to be matched first.
• Matched: Transactions that have been matched for reconciliation
• All: All transactions, regardless of state.
• Partially matched: Transactions that have been partially matched from the Bank tab.
• Draft matched: View draft journal entry transactions that you created for matching that have not yet been posted. After you post these transactions, the state becomes Matched.

Transaction type

The default view is Cheque and debits. You can also select Deposits and credits or All to see all transaction types. Select Apply filters to apply a filtered view.

Bank amount

This filter appears on the Bank tab on the Reconcile Credit Card Account page.

Enter a specific amount to find the associated transaction, then select Apply filters.

Cheque or doc no. range

To set a range of cheque or doc number by which to display transactions, in Cheque or Doc no. range select >=, =, or >, then enter a bottom-of-range amount in the second field. In the next field select <= or <, then enter a top-of-range amount in the last field.

Show more filters

Select to view more filters to use to find transactions.

Clear transactions

If you're reconciling against a physical bank statement and want to clear a transaction for reconciliation, select the transaction and then select Clear transactions. The transaction is considered "Matched" for reconciliation.

To view your cleared transaction, use the State dropdown to filter for Matched transactions. Make sure to select Apply filters. In register reports, the transaction will display as Cleared after you finalize the reconciliation by selecting the Reconcile button.

This updates the Amount to reconcile field.

Unmatch transactions

Unmatch transactions that have been matched or cleared for reconciliation. This updates the Amount to reconcile field. Learn more about unmatching transactions.

Apply filters

After you select a filter in the filter fields, select this button to apply them.

Clear filters

Select to clear any applied filters.

Selection checkbox

From the checkbox on the left-hand side of the transaction table, select the down arrow to either Select all or Select all on this page.

GL post date

The date the transaction posted to the General Ledger.

Match sequence

If your bank or credit card account is set up for match sequences, that sequence appears here.

Cheque no. or doc no.

The cheque number, reference number, or document number of the transaction.

Payee

The supplier or customer associated with the Accounts Payable or Accounts Receivable transaction. Journal entry transactions using dimensional values are excluded.

If a payment is associated with multiple customers, the payer name appears instead of the customer name.

Bank amount

The amount of the transaction. Appears for bank reconciliation.

Description

An optional description entered on the transaction.

Txn date

The date the transaction was created.

Txn type

For bank reconciliation, the transaction types can be: Deposits and credits and Cheques and debits.

For credit card reconciliation, the transaction types can be: Charges and Payments.

Pymt type

The origin of the payment. For example, an AR receipt.

Txn curr

The currency in which the transaction was created.

Txn amount

The amount of the transaction. Appears for bank reconciliation.

Base amount

For multi-currency companies. The amount of the transaction in the base currency amount.

State

The state of the transaction. A transaction can be:

Unmatched: No transactions have been matched to this transaction yet.

Partially matched: There remains an amount to match on this transaction.

Matched: The transaction has been completely matched.

Draft match: The transaction is pending matching. Currently, this state only applies to draft journal entries.

Match

Select to match a transaction to one from an import file or bank feed.

Learn more about manually matching transactions.

Transaction date range

Set a range of transaction dates by which to display transactions. In the first Transaction date range field, select the calendar icon and select a start date. Then, select the second calendar icon and select an end date in the second field.

GL posting date range

To set a range of transaction GL posting dates by which to display transactions, select the calendar icon and select a start date. Then, select the second calendar icon and select an end date in the second field.

Payee

Filter for the supplier or customer associated with a transaction.

Description

Filter by a description that was entered on the transaction.

Bank currency

If your company uses multiple currencies, set the Bank currency for the transactions.

Bank amount range

Display a range of AP supplier invoices by amount. In the Bank amount range select >=, =, or >, then enter a bottom-of-range amount in the second field. In the next field select <= or <, then enter a top-of-range amount in the last field.

Transaction currency

If your company uses multiple currencies, set the Transaction currency for the transactions.

Transaction amount range

To set a range of transaction amounts by which to display transactions, in Transaction amount range select >=, =, or >, then enter a bottom-of-range amount in the second field. In the next field select <= or <, then enter a top-of-range amount in the last field.

Voided

Filter for all voided transactions. You'll see both the original transaction and the voided transaction for easy reconciliation.

Reversed

Filter for all reversed transactions. You'll see both the original transaction and the reversed transaction for easy reconciliation.

Previous

Go to the previous transaction available for matching.

Next

Go to the next transaction available for matching.

Match

Match the current transaction and return to the reconciliation page.

Match and go to next

Match the current transaction and go to the next transaction available for matching.

Unmatch

Manually unmatch a transaction.

Cancel

Return to the account reconciliation page.

Cheque/debit no.

The cheque number, reference number, or document number of the transaction you selected to match on the account reconciliation page.

Document date

The date the transaction was created.

Txn type

The transaction type.

In bank reconciliation the Txn type can be:

• Deposits and credits
• Cheques and debits

In credit card reconciliation this can be:

• Charges

• Payments

Vendor/payee

The supplier, customer, or payee associated with the transaction.

Match type

How a transaction was matched.

Manual: You manually matched this transaction.

Auto-match: The transaction was matched automatically using a rule set.

Amount

The total amount of the transaction.

Remaining to match

The remaining amount to match for the transaction.

Description

If you're viewing a bank transaction to match, this is the description of the transaction from the bank.

If you're viewing an Intacct transaction to match, this is the description entered on the Intacct transaction.

Rule type

The type of rule that matched or created the transaction:

Match rule: These rules match existing Intacct transactions to incoming bank transactions.

Create rule: These rules create new Intacct transactions and automatically match them to incoming bank transactions.

Learn more about rules and rule sets.

Rule ID

The ID of the rule that matched or created the transaction. This field appears if you are reconciling with an import or bank feed and are using rule sets. Select to drill down to the rule.

Rule name

The name of the rule that matched or created the transaction. This field appears if you are reconciling with an import or bank feed and are using rule sets. Select to drill down to the rule.

Matched by

If the Match type is Manual, this is the user who manually matched this transaction.

If the Match type is Auto-match, this is the user who imported a bank file or refreshed a bank feed, prompting Intacct to use rules and rule sets to automatically match incoming transactions.

Match date

The date and time the transaction was matched. This might be when you last uploaded an import file for reconciliation or when a bank feed was refreshed.

Unmatched by

The user who manually unmatched the transaction.

Unmatched date

The date on which the transaction was manually unmatched.

Rule updated after match

If the rule that originally matched or created this transaction has been updated, that information appears here.

Learn more about updating rules.

Match sequence

If your bank or credit card account is set up for match sequences, that sequence appears here.

GL post date/Date

If you're selecting an Intacct transaction to match, this is the GL post date of the Intacct transaction.

If you're selecting a bank transaction to match, this is the Date that the transaction posted at the bank.

Cheque no/Debit no

The cheque number, reference number, or document number of the transaction.

Bank amount

The amount of the transaction.

Payee

The supplier or customer associated with the transaction.

Description

If you're selecting an Intacct transaction to match, this is the description entered on the Intacct transaction.

If you're selecting a bank transaction to match, this is the description on the transaction from the bank.

Txn type

The transaction type.

In bank reconciliation this can be:

• Deposits and credits
• Cheques and debits

In credit card reconciliation this can be:

• Charges

• Payments

Pymt type

The origin of the payment. For example, an AR receipt or a Funds transfer.

Txn date

If you're selecting an Intacct transaction to match, this is the date the transaction was posted in Intacct.

If you're selecting a bank transaction to match, this is the date the transaction posted at the bank.

Txn curr

The currency for this transaction.

Txn amount

The amount of the transaction in the transaction currency.

Base amount

For multi-currency companies.

This is the amount of the transaction in the base currency amount.

GL post date/Date

If you're viewing a bank transaction that you matched to an Intacct transaction, this field displays the GL post date of the Intacct transaction.

If you're viewing an Intacct transaction that matched to a bank transaction, this field displays the Date that the transaction posted at the bank.

Chequeor debit no

The cheque number, reference number, or document number of the transaction.

State

View the state the transaction is in for reconciliation. States include:

• Matched

• Partially matched

• Unmatched

Description

If you're viewing a bank transaction that you matched to an Intacct transaction, this field displays the description entered on the Intacct transaction.

If you're viewing an Intacct transaction that matched to a bank transaction, this field displays the description of the transaction from the bank.

Bank amount

The amount of the transaction using the bank's currency.

Amount to match

If you partially matched this transaction, the remaining amount to match appears here. After you complete the match, the amount becomes zero and the Remaining to match amount is updated.

Payee

The supplier or customer associated with the transaction.

Txn type

The transaction type.

In bank reconciliation the transaction type can be:

• Deposits and credits
• Cheques and debits

In credit card reconciliation the transaction type can be:

• Charges

• Payments

Remaining to match

The total amount remaining to match for your selected transaction.