Accounts Payable Payment Reconcile Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Accounts Payable Payment Reconcile Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Cash Account

29

Character

No

Enter a valid cash account for the payment reconciliation. If this is blank, it defaults to the default cash account.

B

2

Payment ID

20

Character

Yes

Enter a valid payment ID you want to reconcile.

C

3

Cleared Date

10

99/99/9999

No

Enter the date the payment cleared. If this is blank, it defaults to the current date.

D

4

Payment Amount

18

>>>,>>>,>>>,>>9.99

Yes

Enter the payment amount for the payment ID entered in the Payment ID field.

Prerequisites

Before using this import, the following must be set up: