How to: Export Positive Pay Files

  • Article

To make sure that your bank only clears validated checks and amounts, you can export a Positive Pay file that contains vendor information, check number, and payment amount, which you send to the bank for reference when you process payments.

Microsoft Dynamics NAV is preconfigured to support Positive Pay files for Bank of America and City Bank. To add support for other banks, you must configure new data exchange definitions. For more information, see How to: Set Up Data Exchange Definitions.

To enable a data exchange definition for Positive Pay

  1. In the Search box, enter Bank Export/Import Setup, and then choose the related link.

  2. On the Home tab, in the New group, choose New.

  3. Fill the fields as described in the following table.

    Field Description

    Code

    POSPAYBANK

    Name

    Positive Pay Bank of America

    Direction

    Export–Positive Pay

    Posting Exch. Def. Code

    BANKOFAMERICA-PP

  4. Choose the OK button.

To set up a bank account for Positive Pay

  1. In the Search box, enter Bank Accounts, and then choose the related link.

  2. Open the card for the bank that you want to use Positive Pay for.

  3. On the Transfer FastTab, in the Positive Pay Export Code field, enter POSPAYBANK.

  4. Choose the OK button.

To export a Positive Pay file

  1. In the Search box, enter Bank Accounts, and then choose the related link.

  2. Select the bank account that you want to export a Positive Pay file for.

  3. On the Home tab, in the Process group, choose Positive Pay Export.

    The Positive Pay Export window opens displaying payments that have been made for the bank account since the last upload date, as shown in the Last Upload Date and Last Upload Time fields.

  4. In the Cutoff Upload Date field, specify a date before which payments are not included in the exported file.

  5. On the Home tab, in the Process group, choose Export.

  6. In the Export File window, choose Save, and then save the file to a convenient location.

  7. Upload the file to your electronic bank site.

  8. Write down or copy the confirmation number that is displayed when the file upload is successful.

To view exported Positive Pay records

  1. In the Search box, enter Bank Accounts, and then choose the related link.

  2. Select the bank account that you want to view Positive Pay export records for.

  3. On the Navigate tab, in the Bank Acc. group, choose Positive Pay Entries.

    In the Positive Pay Entries window, you can see all the Positive Pay export records for the bank account.

  4. In the Confirmation Number field, enter, for each export record, the confirmation number that you receive when the file upload to the bank is successful. (See step 8 in the “To export a Positive Pay file” procedure.)

  5. To view the related payment lines, on the Navigate tab, in the Bank Acc. group, choose Positive Pay Entry Details.

To reexport Positive Pay files

  1. In the Search box, enter Bank Accounts, and then choose the related link.

  2. Select the bank account that you want to reexport Positive Pay files for.

  3. On the Navigate tab, in the Bank Acc. group, choose Positive Pay Entries.

  4. Select the line for the Positive Pay export file that you want to reexport.

  5. In the Positive Pay Entries window, on the Home tab, in the Process group, choose Reexport Positive Pay to File.

See Also

Tasks

How to: Reconcile Bank Accounts by Using Bank Statements

Concepts

Electronic Payments for United States, Canada, and Mexico

Other Resources

Data Exchange
How to: Set Up Data Exchange Definitions