A regular step in any financial rhythm is to reconcile bank accounts, which requires that you apply incoming payments to customer or vendor ledger entries to close sales invoices and purchase credit memos as paid.
While most customers in B2B environments pay some time after delivery, leaving the posted sales invoices open for the Accounts Receivable department to close (apply) when payment is received, some sales invoices can be paid immediately, for example with PayPal. Such invoices are immediately applied as paid when they are posted and, therefore, do not appear as payments to be processes in AR. For more information, see, for example, Invoice Sales.
In Business Central, one of the fastest ways to register payments from the Payment Reconciliation Journal page 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.
Other pages exist where you can either apply payments or reconcile bank accounts:
- The Bank Account Reconciliations page, where you reconcile bank accounts by matching imported bank statement lines with your system bank account ledger entries. Here, you can also reconcile cheque payments. For more information, see Reconcile Bank Accounts Separately. Here, you cannot apply payments.
- The Payment Registration page, where you can manually apply payments received as cash, cheque, or bank transaction against a generated list of unpaid sales documents. Note that this functionality is available only for sales documents. Here, you cannot apply outgoing payments, and you cannot reconcile bank accounts.
- The Cash Receipt Journal page, 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. Here, you cannot reconcile bank accounts.
Other aspects of managing receivables include to collect outstanding balances, including finance charges and reminders, and to set bank accounts up to allow customers' payments to be withdrawn from their account automatically.
The following table describes a sequence of tasks, with links to the topics that describe them.
|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 a list of unpaid sales documents on the Payment Registration page.||Reconcile Customer Payments 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.||Reconcile Customer Payments with the Cash Receipt Journal or from Customer Ledger Entries|
|Remind customers of overdue amounts, calculate interest and finance charges, and manage accounts receivable.||Collect Outstanding Balances|
|With your customer’s consent, collect payments directly from the customer’s bank account according, in the Euro currency only.||Collect Payments with SEPA Direct Debit|
|Block a customer from being entered on documents or from posting, for example because of insolvency.||Block Customers|
|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.||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.||Work with Payment Tolerances and Payment Discount Tolerances|
|Predict when payments will be made late for sales documents.||The Late Payment Prediction Extension|
Start a free trial!