Customer Payment Statistics Import Format

A

1

Billing Customer Code

12

Character

Yes

Enter the billing customer code.

B

2

Date Sort

6

YYYYMM

Yes

Enter the calendar year followed by the calendar month (with no formatting).

Example 202012

C

3

Total Payment Amount

14

->>,>>>,>>9.99

No

Enter the total amount of payments (in the general ledger currency).

D

4

Number of Payments

8

>,>>>,>>9

No

Enter the number of payments (count).

E

5

Total Write-off Amount

14

->>,>>>,>>9.99

No

Enter the total amount of write-offs (in the general ledger currency).

F

6

Number of Write-offs

4

>,>>9

No

Enter the number of write-offs (count).

G

7

Total Cash Discount Amount

14

->>,>>>,>>9.99

No

Enter the total amount of cash discounts (in the general ledger currency).

H

8

Total Absorption Amount

15

->>>,>>>,>>9.99

No

Enter the total amount of absorption (in the general ledger currency).

I

9

Net Invoice Amount

15

->>>,>>>,>>9.99

No

Enter the accumulation of total invoice amount less the total credit memo amount.

Note The total invoice amount includes sales taxes, shipping charges, etc., which may be different from the total sales amount.

J

10

Net Open Amount

15

->>>,>>>,>>9.99

No

Enter the net open amount at the end of the year or month. This is used to calculate the days sales outstanding statistic, and only should include invoices, credit memos, unapplied payments, and on-account amounts.

K

11

Highest Accounts Receivable Balance

15

->>>,>>>,>>9.99

No

Enter the highest accounts receivable balance incurred during this year or month.

L

12

Average Days to Pay Accumulator

15

->>>,>>>,>>9.99

No

Enter the accumulation of the days to pay based on the invoice reference date for every invoice (only type IN is used). This is divided by the value entered for the Invoice Count Accumulator field to calculate the average days to pay. For more information, see Payment Statistic Calculations FAQ.

M

13

Average Days Past Due Accumulator

15

->>>,>>>,>>9.99

No

Enter the accumulation of the days to pay based on the invoice due date for every invoice (only type IN is used). This is divided by the value entered for the Invoice Count Accumulator field to calculate the average days to pay. For more information, see Payment Statistic Calculations FAQ.

N

14

Invoice Count Accumulator

6

>>,>>9

No

Enter the accumulation of the number of invoices (only type IN is used). This is divided into the value entered for the Average Days to Pay Accumulator field to calculate the average days to pay, and divided into the value entered for the Average Days Past Due Accumulator field to calculate the average days past due. For more information, see Payment Statistic Calculations FAQ.

O

15

Weighted Average Days to Pay Accumulator

15

->>>,>>>,>>9.99

No

Enter the accumulation of the days to pay multiplied by the invoice amount based on the invoice reference date for every invoice (only type IN is used). This value is divided by the value entered for the Invoice Amount Paid Accumulator field to calculate the weighted average days to pay. For more information, see Payment Statistic Calculations FAQ.

P

16

Weighted Average Days Past Due Accumulator

15

->>>,>>>,>>9.99

No

Enter the accumulation of the days to pay multiplied by the invoice amount based on the invoice due date for every invoice (only type IN is used). This is divided by the value entered for the Invoice Amount Paid Accumulator field to calculate the weighted average days to pay. For more information, see Payment Statistic Calculations FAQ.

Q

17

Invoice Amount Paid Accumulator

6

>>,>>9

No

Enter the accumulation of the invoice amounts paid (only type IN is used). This is divided into the value entered for the Weighted Average Days to Pay Accumulator field to calculate the weighted average days to pay, and divided into the value entered for the Weighted Average Days Past Due Accumulator field to calculate the weighted average days past due. For more information, see Payment Statistic Calculations FAQ.