Importing bank statements for impound bank reconciliation

Show expandable text

Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

  1. In the Impound Bank Reconciliation dialog, choose Bank Statement Import from the F3 or right-click context menu.
  2. In the Bank Statement Import dialog, enter the path and filename of the statement in the Location of Statement field or click the Browse button to search for it.
  3. To view the statement on screen, click the Preview Statement button. To print the statement, click the Print /_images/acct_pr/csa/prnrpt.gif button or use the F3 or right-click context menu. Click the Done button to close the Preview Statement dialog.
  4. In the Bank Statement Import dialog, click the Next button to begin the import.

    Note: Any, all, or none of the following dialogs may display depending on the status of the account. If no items are unmatched, the account is reconciled and neither the Unmatched Transaction dialogs nor the Bank Statement Import Adjustments dialog will display.

  5. If the statement dates in the electronic bank statement and those for the current bank reconciliation do not match, a message prompt appears. If the dates in the file are correct, click the Yes button to continue with the import.
  6. If there are unmatched deposits or credits, theUnmatched Deposits and Other Credits dialog opens automatically. Click in the Apply to field and choose an uncleared item from the drop-down list to which the deposit or credit should be applied. If the amount is an adjustment, choose Adjustment from the drop-down list. If you select Adjustment, the item will later appear on the Bank Statement Import Adjustments dialog. Click the Next button to continue.

    Note: Recurring transactions or items that have been matched automatically by the application appear in red in the Apply to field. Be sure to double-check these fields and modify them when necessary. Clicking on the red text changes it to black, marking it as reviewed.

  7. If there are unmatched checks or debits, the Unmatched Checks and Other Debits dialog opens automatically. Click in the Apply to field and choose an uncleared item from the drop-down list to which the check or debit should be applied. If the amount is an adjustment, choose Adjustment from the drop-down list. If you select Adjustment, the item will later appear on the Bank Statement Import Adjustments dialog. Click the Next button to continue.
  8. If you have selected Adjustment in either of the previous dialogs, the Bank Statement Import Adjustments dialog opens automatically. Enter a description for the adjustment and enter the appropriate GL account and adjustment type.
  9. When the statement import is complete, click the OK button (or the Done button if the import concludes with the Adjustments dialog). The total deposits and other credits, total checks and other debits, and total other bank items are entered on the Summary tab. Adjustments transfer automatically to the appropriate tab in the Impound Bank Reconciliation window, and items that were manually or automatically matched appear as cleared.

See also: Impound overview and procedures

Was this article helpful?

Thank you for the feedback!