Enhanced interface

Field descriptions: Bank transactions

Bank transaction page

Bank transaction page field descriptions
Field	Description
Bank account ID	The ID as it appears on the account record in Sage Intacct.
Posting date	The date that the transaction posted to the bank.
Document type	The document type of the transaction according to the bank. You can create a creation rule that filters on document type. Make sure to enter the values exactly as they appear on the bank transaction. Document type descriptions CREDIT: Generic credit DEBIT: Generic debit INT: Interest paid DIV: Dividend FEE: Financial institution fee SRVCHG: Service charge DEP: Deposit ATM: ATM debit or credit XFER: Transfer CHECK: Cheque PAYMENT: Electronic payment CASH: Cash withdrawal DIRECTDEP: Direct deposit DIRECTDEBIT: Merchant initiated debit REPEATPMT: Repeating payment or standard order
Document number	The reference number or document number of the transaction according to the bank.
Currency	The currency in which the transaction was incurred.
Amount	The total amount of the transaction in the transaction's currency.
Payee	The supplier or customer associated with the transaction according to the bank.
Description	A description of the transaction. This value comes from the bank.
Transaction type	The transaction type depends on the account type. Payments and Charges: Associated with credit card accounts. Withdrawals and Deposits: Associated with current accounts and savings accounts.
Reconciliation status	The reconciliation status of the bank transaction. Matched: The bank transaction is matched to one or more Sage Intacct transactions for reconciliation. It has not yet been included in a completed reconciliation. Unmatched: The bank transaction is not matched to a Sage Intacct transaction for reconciliation. Draft matched: A creation rule created a draft journal entry in Sage Intacct based off bank data. Approve the journal entry in Sage Intacct and the two transactions match for reconciliation. Learn more about draft matches. Partially matched: The bank transaction is partially matched to one or more Sage Intacct transactions. There's still a remaining amount to match. Cleared: The transaction is no longer outstanding and is included in a closed reconciliation.
Amount to match	The amount remaining to match for this transaction in reconciliation. If this amount differs from the Amount, check if the transaction is partially matched or unmatched.
Match mode	How the transaction was matched for reconciliation. Manual: A user manually matched this transaction to a Sage Intacct transaction. Auto-match: The transaction was automatically matched to a Sage Intacct transaction using a rule set.
Match date	The date and time the transaction was matched in Intacct.
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 prompted the bank feed either by refreshing the feed or by accessing the reconciliation page. This field displays -- if the transaction is cleared without matching to a bank transaction.
Unmatched date	The date the transaction was manually unmatched.
Unmatched by	The user who unmatched the transaction.

Matched transactions

Matched transactions field descriptions
Field	Description
GL post date	The date the Sage Intacct transaction posted to the General Ledger.
Cheque no. or doc no.	The cheque number, reference number, or document number of the Sage Intacct transaction.
Description	An optional description entered on the Sage Intacct transaction. For example, a bank fee.
Bank amount	The amount of the transaction as entered in Sage Intacct.
Payee	The supplier or customer associated with the transaction as entered in Sage Intacct.
Txn date	The date the transaction was created in Sage Intacct.
Txn type	The type of transaction based on the account type. Deposits and Credits from credit cards. Cheques and Debits from a cash account.
Pymt type	The origin of the payment. For example, an AR receipt.
Txn curr	The currency in which the transaction was created in Sage Intacct
Txn amount	The amount of the transaction in the transaction currency.
Base amount	For multi-currency companies. The amount of the transaction in the base currency of your company.
Matched amount	The amount that's been matched to the bank transaction.

Bank transactions list

Bank transactions list column descriptions
Column	Description
Account type	There are two account types: Credit card: Associated with a credit card account. Bank: Associated with a current account or savings account.
Bank account ID	The ID as it appears on the account record in Sage Intacct.
Bank name	The name of the account as it appears in Sage Intacct.
Posting date	The date that the transaction posted to the bank.
Document type	The document type of the transaction according to the bank. For example, DEBIT, PAYMENT, or XFER (transfer).
Match sequence	If the bank or credit card account is set up for match sequences, that sequence appears here. A sequence of lower case letters means that the transaction has been matched in an open reconciliation. If the sequence is upper case, it means that the transaction has been matched and included in a finalized reconciliation.
Document number	The reference number or document number of the transaction according to the bank.
Currency	The currency in which the transaction was incurred.
Amount	The total amount of the transaction in the transaction's currency.
Payee	The supplier or customer associated with the transaction.
Customer ID	Appears with the Cash in view of the Bank transaction assistant workflow. The ID of the customer as it appears in Sage Intacct.
Customer name	Appears with the Cash in view of the Bank transaction assistant workflow. The name of the customer as it appears in Sage Intacct.
Description	A description of the transaction.
Transaction type	The transaction type depends on the account type. Payments and Charges: Associated with credit card accounts. Withdrawals and Deposits: Associated with current accounts and savings accounts.
Reconciliation status	The reconciliation status of the bank transaction. Matched: The bank transaction is matched to one or more Sage Intacct transactions for reconciliation. It has not yet been included in a completed reconciliation. Unmatched: The bank transaction is not matched to a Sage Intacct transaction for reconciliation. Draft matched: A creation rule created a draft journal entry in Sage Intacct based off bank data. Approve the journal entry in Sage Intacct and the two transactions match for reconciliation. Learn more about draft matches. Partially matched: The bank transaction is partially matched to one or more Sage Intacct transactions. There's still a remaining amount to match. Cleared: The transaction is no longer outstanding and is included in a closed reconciliation.
Amount to match	The amount remaining to match for this transaction in reconciliation. If this amount differs from the Amount, check that the transaction is partially matched or unmatched.

Columns available to include in a custom view.

Data for these fields are provided by the bank.

Matched transactions field descriptions
Field	Description
Payee ID	The ID of the payee as it appears at the bank.
Payee address	The address of the payee as it appears at the bank.
Payee state	The payee state as it appears at the bank.
Payee postal code	The payee postal code as it appears at the bank.
Category	The category of the transaction as defined by the bank. For example, Restaurant, Meals, or Travel.
Category ID	The category ID of the transaction as defined by the bank.
Subcategory	The subcategory of the transaction as defined by the bank. For example, if the category for the transaction is Travel, the subcategory is Airfare.
Extended description	The extended description of the bank transaction. For example, a subset of the data that appears in the Description field.
Bank reference number	A reference number that the bank uses to identify the transaction.
Transaction ID	The ID of the transaction.
Feed type	The source of the bank transaction. For example, from an import file, a bank feed, or a custom API connection.

Bank transactions

Banking cloud tab field descriptions
Field	Description
Connect	Start the process of connecting your account in Sage Intacct to your online banking system. Learn about bank feeds.
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. Are you missing bank feed transactions?
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: You selected the wrong bank to connect to. You do not want to use a bank feed for this account anymore. You need to log in to your account using a different login user name. 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.
Cheque or doc no. range	To set a range by which to display transactions, in Chequeor 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.
Cheque or doc no.	The cheque 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 supplier or customer related to a transaction.
Description
Bank amount range	Display a range of AP supplier invoices 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
Cheque no. or doc no.	The cheque 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 supplier 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 Cheques/Debits. For credit card accounts, the transaction types can be: Charges and Payments.
Currency	The currency of the transaction.
Payee	The supplier 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.