Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Reconcile a Bank Statement That Contains Imported Transactions

After you import bank statements, you can review the summary and detailed information for the bank records, and reconcile the statements.

To reconcile a bank statement that contains imported transactions:

  1. In the Navigation pane, select Cash Management > Bank Reconciliation.
  2. On the Bank Reconciliation form, select an existing bank reconciliation record.
  3. Click Import Charges.
  4. On the Import Statement dialog box, click Browse and open the .txt or .csv file that you want to import.
  5. Click Save.
    The import process begins and automatically matches imported records to posted records that are associated with the active bank statement.
  6. On the Import tab of the Bank Reconciliation form, review the summary and details of imported bank records.
    Option Description
    To view imported records that matched posted records Set the Matched option to Matched.
    To view imported records that do not match posted records Set the Matched option to Unmatched. Select the row of the imported record and click the amount (which displays as a hyperlink) to match it with a posted record.
  7. If you did not select Automatically Clear Matched Transactions on the Import tab of Settings > Cash Management > Banks, select the Clear Matched Transactions option on the Matched Transactions dialog box to clear the posted records that have a matched imported record.
  8. If there are imported transactions that remain unmatched, manually match them to posted records.
  9. After you match bank statement records with posted transactions and enter miscellaneous transactions, click the Summary tab and use its fields and options to verify that the calculated closing balance ties out to the closing balance on the statement.
  10. If you want to mark the statement as closed, click Other Actions > Close Statement.