Balance due workflow

A user can trigger the balance due operation for a freight bill detail charge in any of the following scenarios:

  • A carrier has not included an expected charge for the freight bill detail.
  • The amount for a freight bill detail charge is less than the corresponding voucher charge amount.

A balance due charge can be created for a charge ID of a matched voucher if the amount for the freight bill detail charge is less than the voucher charge amount.

The following are the immediate outcomes for the charge ID when the user triggers the balance due operation:

  • A balance due charge is created as a negative voucher adjustment and is equal to the difference between the approved amount for the freight bill detail charge and the voucher charge amount.
  • The voucher charge amount is reduced to match the freight bill detail charge amount.

When the freight bill associated with the freight bill detail is subsequently processed by the A/P Transaction Generation process, an additional voucher with the same reference number as that of the freight bill detail is created. The additional voucher has balance due charges that offset the negative balance due charges of the original voucher. The additional voucher can be used to settle any additional freight bills that the carrier may later send for the same freight movement.

Example for the balance due workflow

Consider a voucher, VCHR-100, with the reference number as Load-XYZ. Let CHG1 and CHG2 be the charge IDs for VCHR-100. The freight bill detail associated with the voucher has a charge amount of 100 only for the CHG1 charge.

The following tables provide an overview of the voucher charges and freight bill detail confirm page after a freight bill detail has been created and matched to VCHR-100:

Voucher charges

Voucher number

Reference number

Charge ID

Charge type

Voucher charge amount

Voucher status

Voucher type

VCHR-100

Load-XYZ

CHG1

Original

200

Accrual Pending

Initial

Freight bill detail confirm page

Charge ID

Net amount(Freight bill detail amount)

Voucher amount

Variance amount

Variance %

Freight bill detail status (Assumed)

Is the creation of balance due charges allowed

CHG1

100

200

-100

-50

Matched Variance

Yes

CHG2

NA

150

-150

-100

Unmatched

Yes

Since the freight bill charge amount is less than the voucher charge amount for CHG1 and CHG2, the user can trigger the balance due operation for these charge IDs.

When the balance due operation is performed, the balance due charges are created on the matched voucher as a negative amounts for CHG1 and CHG2. The balance due charges are equal to the difference between the freight bill charge amount and the voucher charge amount of CHG1 and CHG2 respectively. The voucher charge amount for CHG1 and CHG2 is reduced to match the corresponding freight bill charge amount.

The following tables provide an overview of the voucher charges and freight bill detail confirm page after the balance due charges are created:

Voucher charges

Voucher number

Reference number

Charge ID

Charge type

Voucher amount

Status

Voucher type

VCHR-100

Load-XYZ

CHG1

Original

200

Accrual Pending

Initial

Freight bill detail confirm page

Charge ID

Net amount(Freight Bill detail amount)

Voucher amount

Variance amount

Variance percentage

Balance due amount

Status

CHG1

100

100

0

0

-100

Approved

CHG2

 NA

0

0

0

-150

Unmatched

Since CHG2 does not have the corresponding freight bill detail charge, the status of CHG2 remains Unmatched though a balance due charge is created for CHG2.

When the freight bill associated with the initial voucher VCHR-100 is processed by the A/P Transaction Generation process, the original and balance due charges that are created for CHG1 and CHG2 are closed. A post charge voucher, VCHR-101, with the reference number as Load-XYZ is created. The post charge voucher has balance due charges CHG1 and CHG2, which offset the negative balance due charges of the initial voucher VCHR-100. VCHR-101 can be used to settle any additional freight bills that the carrier may later send for the same load.

The following tables provide an overview of the status for the initial and post charge vouchers after the A/P Transaction Generation process is run:

Initial voucher status

Voucher number

Reference number

Charge ID

Charge type

Voucher amount

Status

Voucher type

VCHR-100

Load-XYZ

CHG1

Original

200

Closed

Initial

CHG2

Original

150

Closed

CHG1

Balance Due

-100

Closed

CHG2

Balance Due

-150

Closed

Post-charge voucher status

Voucher number

Reference number

Charge ID

Charge type

Voucher amount

Status

Voucher type

VCHR-101

Load-XYZ

CHG1

Balance Due

100

Accrual Pending

Post Charge

See Also