Import Tab of the Bank Reconciliation Form

The Import tab lists bank records that were imported.

This tab displays if you select the Import Enabled checkbox on the Options tab of the Banks form in Settings > Cash Management > Banks.

Contents

Field	Description
<Bank Name and Code> - <Statement Date> (<Statement Number>), Fiscal Period, <Active Company>	These fields display the bank name, bank code, and statement date for the bank reconciliation, followed by the fiscal period in which the bank statement was created. If `Vantagepoint` is set up for multiple companies, the name of the active company also displays.
Import Transactions	Click this option to import new bank transactions to the bank reconciliation. This option only appears if you select the Import Enabled checkbox from the Options tab of the Banks form in Settings > Cash Management > Banks.
Close Statement	This option displays if the current bank reconciliation state is still in progress. When the reconciliation is completed, select this option to mark the reconciliation as closed. Closing a reconciliation removes the statement date from the list of "in progress" statements on the Bank Statement Selection dialog box, to make it easier to select statements in the future. It also disables options on the other tabs on the Bank Reconciliation form. However, you can choose Reopen Statement at any time to reopen the reconciliation.
Reopen Statement	This option displays if the current bank reconciliation record is closed. When the reconciliation is closed, select this option to reopen the reconciliation. Reopening a reconciliation moves the statement back to the "in progress" state, which allows you to make changes and view the reconciliation.
Other Actions/Actions	If you enable the Import function, click Other Actions and select an action. If not, click Actions and select an action. Create Transaction Entries: Select this action to create bank statement entries for bank fees, interest, and other user-defined bank entries in Settings > Cash Management > Banks. Print: Select this action to generate the Bank Reconciliation report for the currently displayed reconciliation. Post Cash Receipts: Select this action to display the Cash Receipts dialog box and then select cash receipts to post. This action is available if you have access rights to post cash receipts and you set the Enable Transaction Center Approvals option to No in Settings > Accounting > Transactions. Match Transactions: This action is available if records were imported through a bank feed. Select this action to automatically match bank transactions with posted records that have the same amount or description. Refresh Bank Transactions: This action is available if you set up bank feed for the bank associated with the bank reconciliation record. Select this action to update the Import Records grid with bank transactions that were posted after the daily import. Errors Report: Select this action to import a report that identifies any errors that were encountered during the last import that you performed for the statement currently open in Bank Reconciliation. Import History: Select this action to display the Import History dialog box and then view or undo imported bank transactions. You can undo transactions if you have imported them into the wrong bank statement.

Summary Grid

Field	Description
Type	This field indicates the type of bank records that were imported: Receipts, Payments, or Total.
Matched	This field displays imported bank records that match records that were posted.
Unmatched	This field displays imported bank records that do not match any records, including bank transaction that were imported through a bank feed. Transactions imported through bank feed are not associated with a statement date.
Total	This field displays summarized information on all bank records.

Import Records Grid

Field	Description
Clear Matched Transactions	Select this option to clear the associated receipt and payment records on the Receipts and Payments tabs with the matched transactions. This option is only available if Automatically Clear Matched Transactions is not selected on the Import tab of Settings > Cash Management > Banks; when that option is selected, receipt and payment records are cleared when the record is matched.
Matched	This checkbox is selected automatically if a match between a posted transaction and an imported bank record is found during the import process. This checkbox is updated if you manually match a bank record to a posted record on the Match Transactions dialog box. You can also select this checkbox if the imported bank transaction matches a journal entry that is not part of a bank statement.
Type	This field displays the bank transaction type, such as Payment or Receipt.
Number	This field displays the reference number (for example, the check number) of the imported transaction. The value of this field is used to match the bank transaction with a posted record for check-type transactions. For non-check related transactions (deposits, electronic fund transfers, and wires), this field may be blank and may not be used for automatic matching.
Description	This field displays the description of the bank record as shown in the imported file.
Transaction Date	This field displays the date of the receipt or payment as indicated in the imported bank record. The value of this field is used to match the transaction with a posted record. By default, non-check related transactions are matched based on transaction date and amount.
Receipt	This field displays the amount of the receipt, as indicated in the imported bank record. The value of this field is used to match the transaction with a posted record.
Payment	This field displays the amount of the payment as indicated in the imported bank record. The value of this field is used to match the transaction with a posted record.
	To open the Match Transactions dialog box, hover over the grid row and click this icon at the end of the row.
	This option displays if: The imported record is a receipt. You have access rights to enter cash receipt transaction records. The administrator did not enable approvals for Cash Receipts in Transaction Settings. Select this option to open the Invoice Lookup dialog box, on which you can view and modify the cash receipt transaction record associated with an invoice.
	This option displays if: The imported record is a receipt. You have access rights to enter cash receipt transaction records. The administrator did not enable approvals for Cash Receipts in Transaction Settings. Hover over the grid row, click this icon, and select one of these options: Match Transaction: Select this option to open the Match Transactions dialog box. Invoice Lookup: Select this option to open the Invoice Lookup dialog box and create or modify the cash receipt associated with the invoice.

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

Import Tab of the Bank Reconciliation Form

The Import tab lists bank records that were imported.

This tab displays if you select the Import Enabled checkbox on the Options tab of the Banks form in Settings > Cash Management > Banks.

Contents

Field	Description
<Bank Name and Code> - <Statement Date> (<Statement Number>), Fiscal Period, <Active Company>	These fields display the bank name, bank code, and statement date for the bank reconciliation, followed by the fiscal period in which the bank statement was created. If `Vantagepoint` is set up for multiple companies, the name of the active company also displays.
Import Transactions	Click this option to import new bank transactions to the bank reconciliation. This option only appears if you select the Import Enabled checkbox from the Options tab of the Banks form in Settings > Cash Management > Banks.
Close Statement	This option displays if the current bank reconciliation state is still in progress. When the reconciliation is completed, select this option to mark the reconciliation as closed. Closing a reconciliation removes the statement date from the list of "in progress" statements on the Bank Statement Selection dialog box, to make it easier to select statements in the future. It also disables options on the other tabs on the Bank Reconciliation form. However, you can choose Reopen Statement at any time to reopen the reconciliation.
Reopen Statement	This option displays if the current bank reconciliation record is closed. When the reconciliation is closed, select this option to reopen the reconciliation. Reopening a reconciliation moves the statement back to the "in progress" state, which allows you to make changes and view the reconciliation.
Other Actions/Actions	If you enable the Import function, click Other Actions and select an action. If not, click Actions and select an action. Create Transaction Entries: Select this action to create bank statement entries for bank fees, interest, and other user-defined bank entries in Settings > Cash Management > Banks. Print: Select this action to generate the Bank Reconciliation report for the currently displayed reconciliation. Post Cash Receipts: Select this action to display the Cash Receipts dialog box and then select cash receipts to post. This action is available if you have access rights to post cash receipts and you set the Enable Transaction Center Approvals option to No in Settings > Accounting > Transactions. Match Transactions: This action is available if records were imported through a bank feed. Select this action to automatically match bank transactions with posted records that have the same amount or description. Refresh Bank Transactions: This action is available if you set up bank feed for the bank associated with the bank reconciliation record. Select this action to update the Import Records grid with bank transactions that were posted after the daily import. Errors Report: Select this action to import a report that identifies any errors that were encountered during the last import that you performed for the statement currently open in Bank Reconciliation. Import History: Select this action to display the Import History dialog box and then view or undo imported bank transactions. You can undo transactions if you have imported them into the wrong bank statement.

Summary Grid

Field	Description
Type	This field indicates the type of bank records that were imported: Receipts, Payments, or Total.
Matched	This field displays imported bank records that match records that were posted.
Unmatched	This field displays imported bank records that do not match any records, including bank transaction that were imported through a bank feed. Transactions imported through bank feed are not associated with a statement date.
Total	This field displays summarized information on all bank records.

Import Records Grid

Field	Description
Clear Matched Transactions	Select this option to clear the associated receipt and payment records on the Receipts and Payments tabs with the matched transactions. This option is only available if Automatically Clear Matched Transactions is not selected on the Import tab of Settings > Cash Management > Banks; when that option is selected, receipt and payment records are cleared when the record is matched.
Matched	This checkbox is selected automatically if a match between a posted transaction and an imported bank record is found during the import process. This checkbox is updated if you manually match a bank record to a posted record on the Match Transactions dialog box. You can also select this checkbox if the imported bank transaction matches a journal entry that is not part of a bank statement.
Type	This field displays the bank transaction type, such as Payment or Receipt.
Number	This field displays the reference number (for example, the check number) of the imported transaction. The value of this field is used to match the bank transaction with a posted record for check-type transactions. For non-check related transactions (deposits, electronic fund transfers, and wires), this field may be blank and may not be used for automatic matching.
Description	This field displays the description of the bank record as shown in the imported file.
Transaction Date	This field displays the date of the receipt or payment as indicated in the imported bank record. The value of this field is used to match the transaction with a posted record. By default, non-check related transactions are matched based on transaction date and amount.
Receipt	This field displays the amount of the receipt, as indicated in the imported bank record. The value of this field is used to match the transaction with a posted record.
Payment	This field displays the amount of the payment as indicated in the imported bank record. The value of this field is used to match the transaction with a posted record.
	To open the Match Transactions dialog box, hover over the grid row and click this icon at the end of the row.
	This option displays if: The imported record is a receipt. You have access rights to enter cash receipt transaction records. The administrator did not enable approvals for Cash Receipts in Transaction Settings. Select this option to open the Invoice Lookup dialog box, on which you can view and modify the cash receipt transaction record associated with an invoice.
	This option displays if: The imported record is a receipt. You have access rights to enter cash receipt transaction records. The administrator did not enable approvals for Cash Receipts in Transaction Settings. Hover over the grid row, click this icon, and select one of these options: Match Transaction: Select this option to open the Match Transactions dialog box. Invoice Lookup: Select this option to open the Invoice Lookup dialog box and create or modify the cash receipt associated with the invoice.