Reconciliation Adjustment Entry

Menu Path: None

To use Reconciliation Adjustment Entry, click the Reconciliation Adjustments button in the ribbon in Voucher Entry or Voucher Edit.

NOTE If you access this window from Voucher Edit, you can only edit the displayed reconciliation adjustment voucher if your user ID is authorized to create reconciliation adjustment vouchers. If you are not authorized to create reconciliation adjustment vouchers, all buttons are disabled except for the Exit button in the ribbon.

Purpose

Enter manual accounts payable reconciliation adjustment vouchers.

Overview

Use Reconciliation Adjustment Entry to enter adjustment vouchers for accounts payable reconciliation accounts.

EXAMPLE $.05 was accidentally left in the accounts payable clearing account. You can create an adjustment voucher to remove this amount from the accounts payable clearing account.

Reconciliation adjustment vouchers are displayed on reports output in Accounts Payable Clearing Account Report, Drop Ship In Transit Reconciliation Report, and Prepayment Account Reconciliation Report.

To import adjusted data, use Accounts Payable Voucher Import.

Creating a Reconciliation Adjustment Voucher

To create a reconciliation adjustment voucher:

  1. Select the reconciliation type for which you want to make a reconciliation adjustment entry.

  2. Enter the accounts payable clearing account, in transit account, or prepayment account for the reconciliation adjustment entry.

  3. Enter the offset account or VAT clearing account for the reconciliation adjustment entry.

  4. Enter a remark to describe the reconciliation adjustment entry.

  5. Enter the receipt number, purchase order number, purchase order line number, release number, and/or voucher number associated with the entry.

  6. Enter the amount to adjust for the accounts payable clearing account, in transit account, or prepayment account.

  7. Click the Add Item button.

  8. Repeat steps 1-7 for each reconciliation adjustment entry you want to include in the voucher.

  9. Click the Enter Voucher button in the ribbon to save the voucher. The voucher is created, and the voucher number is displayed.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Reconciliation Adjustment Entry window.

Delete

Click this button to delete the selected adjustment entry.

Enter Voucher

Click this button to create the adjustment voucher.

Main Tab Fields and Buttons

Field or Button

Description

Reconciliation Type

Select the type of adjustment entry you want to create. You can create one of the following:

  • A/P Clearing - Adjust amounts in an accounts payable clearing account and an offset account.

  • VAT Clearing - Adjust amounts in an accounts payable clearing account and a VAT clearing account.

  • Drop Ship - Adjust amounts in an in transit account and an offset account.

  • Pre-payment - Adjust amounts in a prepayment account and an offset account.

A/P Clearing Account / In Transit Account / Prepayment Account

Enter the accounts payable clearing account, in transit account, or prepayment account for the reconciliation adjustment entry, or click the Lookup button to select the account. The type of account you enter is based on the selected reconciliation adjustment entry type.

Offset Account / VAT Clearing Account

Enter the offset account or VAT clearing account for the reconciliation adjustment entry, or click the Lookup button to select the account. The type of account you enter is based on the selected reconciliation adjustment entry type.

Remark

Enter a remark to describe the reconciliation adjustment entry.

Receipt#

Enter the receipt number for the reconciliation adjustment entry, or click the Lookup button to select a receipt number. This field is only enabled if the A/P Clearing or VAT Clearing radio button is selected.

P.O.#

Enter the purchase order number for the reconciliation adjustment entry, or click the Lookup button to select a purchase order number.

Line#

Enter the purchase order line number for the reconciliation adjustment entry. This field is only enabled if the Drop Ship radio button is selected.

Release#

Enter the release number for the reconciliation adjustment entry. This field is only enabled if the A/P Clearing or VAT Clearing radio button is selected.

Associated Voucher Number

Enter the associated prepayment voucher number for the reconciliation adjustment entry, or click the Lookup button to select a prepayment voucher number. This field is only enabled if the Pre-payment radio button is selected.

Amount

Enter the amount of the adjustment for the selected accounts payable clearing, in transit, or prepayment account. This can be a positive or negative amount. The opposite amount is adjusted for the offset or VAT clearing account.

Add Item

Click this button to add the reconciliation adjustment entry to the voucher.

Clear

Click this button to clear all fields.

Adjustment Entries

This grid displays reconciliation adjustment entries that you have entered for the voucher.