The Apply Ledger Entries page

Use the Apply Ledger Entries page to manually apply bank statement lines to open ledger entries during reconciliation. This article describes the page layout, all available fields, and the totals and actions used when completing manual applications.

Page layout overview

The Apply Ledger Entries page is divided into three main sections:

  1. Transaction details (top) — Bank statement line information.
  2. Ledger entries grid (middle) — All available open ledger entries that can be applied.
  3. Totals section (bottom) — Summary of calculated amounts used to complete the application.

Apply Ledger Entries page

Tip

Your column visibility preference (Show More or Show Fewer Columns) is saved automatically per user and persists across sessions.

Transaction details section

At the top of the page, you see information about the bank statement line you're applying:

FieldDescription
DescriptionDescription from the bank statement line (Bank Account Reconciliation).
Transaction TextTransaction text from the payment journal (Payment Reconciliation Journal).

Ledger entries grid

The grid displays all open ledger entries available for application:

FieldDescriptionEditable
Applied AmountAmount applied to the entry.Yes
AppliedSelect to include the entry in the application.Yes
Account TypeCustomer, vendor, employee, bank account, or G/L account.No
Account No.Account number.No
Account NameName of the account.No
Posting DatePosting date of the entry.No
Due DateDue date of the entry.No
Document TypeInvoice, credit memo, payment, etc.No
Document No.Document number of the original transaction.No
External Document No.Vendor or customer invoice/bill number.No
DescriptionDescription of the ledger entry.No
Currency CodeCurrency of the ledger entry.No
AmountOriginal amount of the ledger entry.No
Remaining AmountOpen amount available for application.No
Remaining Amt. Incl. DiscountRemaining amount including discount.No
Pmt. Discount DateLast date to receive the full payment discount.No
Pmt. Disc. Tolerance DateExtended discount date if tolerance applies.No
Accepted Pmt. Disc. ToleranceIndicates whether discount tolerance is accepted.Yes
Remaining Pmt. Disc. PossibleRemaining discount available if paid on time.No
Applied Pmt. DiscountDiscount applied during this application.No
Max. Payment ToleranceMaximum tolerance amount allowed.No
Applied Pmt. ToleranceTolerance applied during the application.Yes
Remaining Amount after ApplicationRemaining amount after the application is posted.No

Additional fields

When you choose Show More Columns, additional fields display showing currency conversion amounts:

FieldDescription
Appln. Applied AmountApplied amount in the application currency.
Appln. Remaining AmountRemaining amount in the application currency.
Appln. Remaining Amt. Incl. Disc.Remaining discounted amount in the application currency.
Appln. Remaining Pmt. Disc. PossibleAvailable discount in the application currency.
Appln. Applied Pmt. DiscountApplied discount in the application currency.
Appln. Max. Payment ToleranceMaximum tolerance in the application currency.
Appln. Applied Pmt. ToleranceApplied tolerance in the application currency.

Tip

Multi‑currency fields prefixed with Appln. display the converted values in the bank account currency.

Totals section

The totals section at the bottom of the page provides an overview of the calculated amounts used when completing the application.

NameDescription
Appln. CurrencyCurrency used during the application.
Statement AmountAmount from the bank statement line.
Transaction AmountAmount from the payment journal line.
Split AmountAmount allocated using a split rule.
Transferred Difference AmountDifference already transferred to a journal.
Applied Pmt. DiscountTotal payment discount applied.
Applied Pmt. ToleranceTotal payment tolerance applied.
RoundingRounding difference for currency conversions.
Applied AmountTotal applied amount across all selected entries.
DifferenceRemaining amount after application. Should be zero for full reconciliation.

Note

The Difference field displays in green when fully applied (zero difference) and red when incomplete.

Page actions

NameDescription
ApplyApplies the selected ledger entries.
UnapplyReverses an existing application.
Transfer Difference to JournalTransfers the difference to a general journal (Bank Account Reconciliation).
Transfer Diff. to AccountTransfers the difference to a selected account (Payment Reconciliation Journal).
Set Manual HandlingMarks the reconciliation line for manual handling outside the system.
Remove Manual HandlingRemoves the manual handling status.
Create Manual Journal LineCreates a manual journal line for reconciliation.
Show More ColumnsDisplays additional fields.
Show Fewer ColumnsHides additional fields.
Show AllShows all available ledger entry types.
Show [Account Type] Ledger EntriesFilters ledger entries by account type.
Show Ledger EntryOpens the related ledger entry.
Show DocumentOpens the posted document.

Applying ledger entries manually
Manual application examples
Manual application FAQ
Introducing manual application