Vendor Reconciliation Journal Tab

This section includes the fields and descriptions for the Vendor Reconciliation Journal tab.

Vendor Reconciliation Journal Island

Field Description
Vendor No. This is the vendor number that identifies the vendor. This field also shows the vendor’s name and address, which have been retrieved from the Vendor Information Card.
Main Entry Line No. This field shows the Vendor Entry Line No. Together with the Vendor No., this is a unique reference to the vendor entry
Reconciliation No. This field shows the reconciliation number.
Journal No. This is the number of the journal in which the entry was posted.
Journal Line No. This field displays the number of the line on which the entry occurs in the journal shown in the field “Journal No.”
Company No. This field displays the value of the Company dimension specified for the current vendor entry.

For a description of the “Company” dimension, please see the description of the Company Information window in the G/L module.

Entry Date This is the date on which the entry was entered to the general ledger and accounts payable. The date identifies the posting period.
Trans. No. This is the entry’s transaction number.
Transaction Type This is the entry’s transaction type.
Posted This is the date when the entry was posted to the accounts payable and general ledger.
Removed Reconciliation This field shows if this vendor reconciliation was removed/reverted from a previous reconciliation.
Original Reconciliation No. This field only has a value if there is a removal. Together with the Vendor No. and Main Entry Line No., this field provides a unique reference to the reconciliation that has been removed.
Pay to Vendor No. The vendor number is the sole and absolute identification of a vendor. This field also shows the vendor’s name and address. This information is retrieved from the Vendor Information Card.
Paym. No. This field shows the number of the payment. The number is used as a reference to the Show Automatic Payment, Show Payment Remittance, and Show Payment Reconciliation windows in the Banking module. The number is used for tracing payment information on a vendor entry.

Amounts Island

Field Description
Total Cash Discount, Standard This field shows how much cash discount was given for the payment in the reconciliation. The amount is shown in the vendor’s standard currency.
Total Cash Discount, Base This field shows how much cash discount was given for the payment in the reconciliation. The amount is shown in the vendor’s base currency.
Total Cash Discount, Enterprise This field shows how much cash discount was given for the payment in the reconciliation. The amount is shown in the vendor’s enterprise currency.
Total Exchange Rate Variance, Base This field shows any exchange rate variance calculated by Maconomy for payments in foreign currency. The amount is shown in the base currency of the settling company. The amount corresponds to the difference between the base amount reconciled by the payment and the base amount actually paid, that is, the amount specified in the field “Paid, Base.” A variance occurs if exchange rates have changed from the time that the vendor invoice was received and posted through the time that it is paid. Also, your bank using an exchange rate other than what is specified in Maconomy results in differences that are reflected in this field.
Total Exchange Rate Variance, Enterprise This field shows the exchange rate variance, in enterprice currency. The exchange rate variance in enterprise currency is calculated (as a currency conversion) from the exchange rate variance in base currency.
Exchange Rate Variance Balancing, Enterprise This field shows any exchange rate variance calculated by Maconomy for payments in foreign currency, in enterprise currency. The amount corresponds to the difference between the enterprise amount reconciled by the payment, the enterprise amount actually paid, and the exchange rate variance, in enterprise currency.
Reconciled, Standard This field shows how much of the entry has been reconciled, including cash discount. If the entry is fully reconciled, the amount here is the same as the amount in the “Debit in Standard” or “Credit in Standard” field. The amount is shown in the vendor’s standard currency. An entry can also be reconciled in full by other reconciliations.
Reconciled, Base This field shows how much of the entry has been reconciled, including cash discount. If the entry is fully reconciled, the amount here is the same as the amount in the “Debit in Standard” or “Credit in Standard” field. The amount is shown in the vendor’s base currency. An entry can also be reconciled in full by other reconciliations.
Reconciled, Enterprise This field shows how much of the entry has been reconciled, including cash discount. If the entry is fully reconciled, the amount here is the same as the amount in the “Debit in Standard” or “Credit in Standard” field. The amount is shown in the vendor’s enterprise currency. An entry can also be reconciled in full by other reconciliations.
Unrealized Exchange Rate, Base This field shows the unrealized exchange rate, in base currency.
Unrealized Exchange Rate, Enterprise This field shows the unrealized exchange rate, in enterprise currency
Unrealized Balancing Exchange Rate, Enterprise This fields shows the change in unrealized exchange rate variance. The unrealized exchange rate variance is calculated as the difference between the exchange rate of the vendor invoice (the expected exchange rate at the time of posting) and the fixed job exchange rate from the allocation of the vendor invoice. The unrealized exchange rates reduce for every partial payment, so a fully paid invoice will not have any unrealized exchange rate.