Bank Statement Import . . . Unmatched Transactions

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

The Unmatched Transactions dialogs open during the bank statement import only if items exist in the bank statement file for which the application is unable to find a match in the bank reconciliation, or if there are items matched that require review. The dialogs allows you to assign cleared items in the statement file to matching uncleared items in the bank reconciliation or to assign them as adjustments. These dialogs are the Unmatched Deposits and Other Credits dialog and the Unmatched Checks and Other Debits dialog.

See also: Bank Reconciliation Overview

Top of page

Unmatched Deposits and Other Credits

Matching deposits and credits: All deposits and credits with a corresponding matched item are automatically cleared on the Deposits and Other Credits tab. Deposits and other credits are matched by amount, clearing the oldest item found first.

Multiple deposits for the same amount: If there are multiple deposits or other credits for the same amount, an uncleared deposit or credit for the same amount is listed in the Apply to field, matching first the oldest transaction in the file with the oldest transaction for the same amount in the Bank Reconciliation. These appear in red to alert you that these should be reviewed and edited if necessary.

Adjustments: You can specify a transaction as an adjustment by selecting Adjustment from the drop-down list in the Apply to field. When the Adjustment dialog appears, edit the type and user description and select the GL account. If an item was selected as an adjustment in a previous import and the description is the same, the application will automatically select Adjustment in the Apply to field on the Unmatched Deposits and Other Credits dialog. The selection appears in red to alert you that it should be reviewed and edited if necessary. Note that if the adjustment is selected automatically, the user description, type, and GL account fields are populated based on the previous import's first adjustment with the same description.

Split deposits: To apply a deposit to part of a single deposit in bank reconciliation, assign the deposit on the bank statement to the original deposit selected from the Apply to field drop-down list and then mark the Split checkbox. The application automatically creates separate deposit amounts that are equal to the total of the deposit selected in the Apply to field.

If a transaction is applied to a transaction for a different amount, the amount of the bank statement transaction is entered in the Clear for column, and the adjustment is automatically created.

Top of page

Unmatched Checks and Other Debits dialog

Matching checks: All checks and other debits with a corresponding matched item are automatically cleared on the Checks and Other Debits tab. Checks are matched by check number and amount. All non-check debit transactions are matched by amount, clearing the oldest transactions first.

If a check number matches but the amount does not, the matching check is displayed in red in the Unmatched Checks and Other Debits grid Apply to field to alert you that it should be reviewed and edited if necessary.

Multiple non-check debit transactions: If there are multiple non-check transactions for the same amount, the matching uncleared transactions are automatically selected in the Apply to field, oldest date first. These amounts appear in red to alert you that these should be reviewed and edited if necessary.

Adjustments: You can specify a transaction as an adjustment by selecting Adjustment from the drop-down list in the Apply to field. Enter the type, user description, and GL account in the Bank Statement Import Adjustment dialog when it opens. If a transaction was selected as an adjustment in a previous import and the description is the same, the application will automatically select Adjustment in the Apply to field on the Unmatched Checks and Other Debits dialog. The selection appears in red to alert you that it should be reviewed and edited if necessary. Note that if the adjustment is selected automatically, the user description, type, and GL account fields are populated based on the previous import's first adjustment with the same description.

If a transaction is applied to a transaction for a different amount, the amount of the bank statement transaction is entered in the Clear for column, and the adjustment is automatically created.

Top of page

Fields & buttons

Top of page

Share This