Importing client bank statements for 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 Bank Reconciliation window, choose Bank Statement Import from the Edit menu or 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 /_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 Adjustment 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. In the Unmatched Deposits and Other Credits dialog, 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 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, select Adjustment from the 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 select the appropriate GL account and adjustment type from the drop-down lists.
  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 Bank Reconciliation window, and the items that were manually or automatically matched appear as cleared.

Note: If you want to repeat the import process for a statement before advancing to the next period, you will be prompted to rebuild uncleared transactions before beginning the import.

See also

Bank Reconciliation Overview

Bank Reconciliation WalkThrough (PDF)

Top of page

Was this article helpful?

Thank you for the feedback!