Field descriptions: Banking cloud tab

The following is a table of the fields on the Banking cloud tab on the account record:

Banking cloud tab field descriptions
Field Description

Connect

Start the process of connecting your account in Sage Intacct to your online banking system.

Intacct

The bank account record information that exists in Sage Intacct.

Banking cloud

The name of the online bank account to which the account in Sage Intacct is connected. Bank feed transactions are downloaded from this online account.

Last bank feed

The date of the most recent bank feed refresh for this account.

Last transaction date

The date of the last transaction received from the most recent bank feed.

Last reconciliation type

How you reconciled previously. For example, you used an import file or bank feed to bring in bank transactions and match them for reconciliation.

Status

The status of the account's connection to a bank feed.

Create a custom view on the account list page to view the status of each account's bank feed connection. When creating the custom view, include the Bank feed status column.

Refresh

Refresh bank feed data for this account.

Confirm

This option appears after you select an online bank account to connect to.

Check to make sure that you selected the correct account before you select Confirm. To select a different account, select Cancel. For some connections, this cancellation process can take some time.

Cancel

Appears before your bank account connects to Sage Intacct. Select to cancel the attempted connection. For some connections, this cancellation process can take some time.

Edit login information

If your login information has changed at your bank, edit that information here to maintain your bank feed connection.

Reauthorize

The bank might require you to reauthorize your account. You'll know if you need to reauthorize if you have a status of Auth required.

Disconnect

Only disconnect a bank feed in the following scenarios:

If you disconnect and change your mind, the reconnection process can take weeks to complete. If you're having trouble refreshing a bank feed, do not disconnect the bank feed. Instead, wait until you see a bank feed status of Partial success or Failed and refresh the bank feed.

If you do decide to disconnect an account, Sage Intacct removes any unreconciled and unmatched bank feed transactions for that account. Any matched transactions become unmatched and the bank transactions are removed from Sage Intacct.

After you select Disconnect, your bank is alerted that you want to stop receiving a bank feed. The rest of the disconnection process depends on actions by the bank. Depending on the type of connection, if yours is an AUS or UK bank, this process can take some time.

For security reasons, we wait up to 5 days after the bank disconnects until we update the bank feed status. The entire disconnection process can take up to a few weeks.

Learn how to troubleshoot bank feeds.

Bank transactions section

This section is only visible if your account is connected to a bank feed, and you selected View from the account list. This section does not appear in Edit mode.

If you have the proper permissions, you can create Sage Intacct transactions and manually match transactions for reconciliation from this tab.

Filters section

Filters field descriptions
Field Description

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.

Make sure to select Apply filters to view transactions.

Transaction type

Select to view Checks and debits or Deposits and credits.

Bank amount

This filter appears on the Bank tab on the Reconcile credit card account page.

Check or doc no. range

To set a range by which to display transactions, in Checkor 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.

Check or doc no.

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

Date range

To set a range of transaction dates by which to display transactions, in the first 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.

Payee

Filter for the vendor or customer related to a transaction.

Description

 

Bank amount range

Display a range of bills by amount. 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.

Amount

Enter a specific amount to find the associated transaction.

Bank transactions list

Bank transactions field descriptions
Field Description

Date

The date the transaction posted to the bank.

Match sequence

The match sequence of the transaction.

Last reconcile

 

Check no. or doc no.

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

Bank amount

The total amount of the transaction.

Amount to match

The amount remaining to match for this transaction in reconciliation.

Payee

The vendor or customer associated with the transaction.

Description

Filter by a description entered on the bank transaction.

Txn type

For bank accounts, the transaction types can be: Deposits/Credits and Checks/Debits.

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

Currency

The currency of the transaction.

Payee

The vendor or customer related to the transaction.

Txn curr.

The currency in which the transaction was created.

Txn amount

The amount of the transaction.

Match

Manually match the transaction to a transaction that already exists in Sage Intacct.

Action

Create Intacct transactions to match to a bank feed transaction for reconciliation.