Managing Receivables

A regular step in any financial rhythm is to reconcile bank accounts, which requires that you apply payments to customer or vendor ledger entries to close sales invoices and purchase credit memos.

In Dynamics NAV, one of the fastest ways to register payments from the Payment Reconciliation Journal window by importing a bank statement file or feed. The payments are applied to open customer or vendor ledger entries based on data matches between payment text and entry information. You can review and change the matches before you post the journal, and close bank account ledger entries for ledger entries when you post the journal. The bank account is reconciled when all payments are applied.

There are, however, other handy places to apply payments and reconcile bank accounts:

  • The Bank Account Reconciliations window, which also lets you check ledger entries. For more information, see How to: Reconcile Bank Accounts Separately.
  • The Payment Registration window, where you can apply and manually check payments received as cash, check, or bank transaction against a generated list of unpaid sales documents. Note that this functionality is available only for sales documents.
  • The Cash Receipt Journal window, where you manually post receipts to the relevant general ledger, customer, or other account by entering a payment line. You can either apply the receipt or refund to one or more open entries before you post the cash receipt journal, or from the customer ledger entries.

Another part of managing receivables is to collect outstanding balances, including finance charges, and issue reminders. Dynamics NAV offers ways to do those things as well. For more information, see How to: Collect Outstanding Balances.

The following table describes a sequence of tasks, with links to the topics that describe them.

To See
Apply payments to open customer or vendor ledger entries based on an imported bank statement file or feed, and reconcile the bank account when all payments are applied. Applying Payments Automatically and Reconciling Bank Accounts
Apply payments to open customer ledger entries based on manual entry in a list of unpaid sales documents. How to: Reconcile Customer Payments Manually From a List of Unpaid Sales Documents
Post cash receipts or refunds for customers in the cash receipt journal and apply to customer ledger entries, either from the journal or from posted ledger entries. How to: Reconcile Customer Payments Manually
Remind customers of overdue amounts, calculate interest and finance charges, and manage accounts receivable. How to: Collect Outstanding Balances
Ensure that you know the cost of shipped items by assigning added item costs, such as freight, physical handling, insurance, and transportation that you incur after selling. How to: Use Item Charges to Account for Additional Trade Costs
Set up a tolerance by which the system closes an invoice even though the payment, including any discount, does not fully cover the amount on the invoice. How to: Work with Payment Tolerances and Payment Discount Tolerances

See Also

Dynamics 365 Business Central
Sales
Managing Payables
Working with Dynamics NAV
General Business Functionality