Payment Reconciliation Business Central

Payment Reconciliation Business Central

Payment Reconciliation Business Central helps finance teams review authorized payment activity, compare credit card authorizations with processor deposit totals, and organize transaction analysis inside Microsoft Dynamics 365 Business Central. This page is written for accounting and finance users who need practical credit card reconciliation Business Central guidance, not a general payment processing overview.

Solution Overview

The System Solutions LLC payment processing extension supports credit card, debit card, ACH, preauthorization, card-on-file, automatic payment, receipt, signature, LS Express, and reconciliation workflows in Business Central. For reconciliation, the source guide highlights the Authorized Credit Card Transactions page, transaction filtering, receipt and signature review, document number review, Analysis Mode, and comparison of Business Central authorizations with processor deposit totals.

The finance problem addressed by this page is the recurring need to confirm that payment activity recorded in Business Central aligns with expected merchant deposits. A finance user may need to review today's authorizations, look back at a previous day, subtotal by card type, identify records without a document number, or compare Business Central activity to processor settlement information.

Typical users include controllers, accounting managers, cash application staff, accounts receivable users, bookkeepers, and implementation teams that need a documented workflow for transaction review and merchant deposit reconciliation. This intent page avoids extension version numbers and build details so it remains focused on evergreen finance operations.

Back to Top

Payment Reconciliation Business Central Overview

The source documentation states that approved payments can be seen by searching Authorized Credit Card Transactions in Business Central or through the Related action in the setup page. This list can be searched, sorted, or exported to Excel. It can also be filtered on information such as the last four digits of an account card number to show transactions associated with that card.

For a finance audience, this makes the Authorized Credit Card Transactions page the center of credit card reconciliation Business Central review. The page provides access to transaction records, receipt actions, signature actions where applicable, Pay API email history where emailing is enabled, records without document numbers, and manual document number assignment.

Payment Reconciliation Business Central Features

• Review approved payment activity from the Authorized Credit Card Transactions page.
• Search, sort, and export the transaction list to Excel for finance review.
• Filter on transaction details such as the last four digits of an account card number.
• Use Analysis Mode to create a saved view for today's authorizations or a prior day.
• Use card type as a column and row group to subtotal by Visa, AMEX, Mastercard, and similar card categories where those fields are present.
• Filter authorized payments without a posted document number and assign a document number manually when needed.

Back to Top

Authorized Transaction Review

The Authorized Credit Card Transactions page is the documented starting point for reviewing approved payments. The source guide states that the list can be searched, sorted, or exported to Excel. It also states that users can view credit card payments made to specific customers, posted sales invoices, and posted sales credit memos by opening the relevant page and choosing Actions > Payment Processing > View Payments.

The available actions documented for the authorized transaction list include View Receipt, View Signature for TranCloud or DC Direct platforms when signatures are enabled, View Email for Pay API payments with emailing enabled, Filter Records Without Document No., and Assign Document No. These actions support practical finance review because they connect individual authorization records back to proof, documentation, and posting context.

A finance team should use this review area to confirm that transaction records exist, that supporting receipts or signatures can be reviewed where applicable, and that document assignment issues are visible before deposit reconciliation. This keeps payment review tied to Business Central records instead of relying only on processor reports.

Back to Top

Analysis Mode for Finance Reconciliation

The source documentation includes a specific method to reconcile Business Central credit card authorizations with the processor's deposit total. The documented process begins by opening Authorized Credit Card Transactions, selecting Analysis Mode, creating a New Analysis, and filtering the list by Payment Date using today's value. The analysis can be saved and named so it is available for future use.

The guide also states that the saved analysis can be used to quickly see today's transactions or a prior day by entering the date. For finance teams, this is the bridge between operational payment activity and the daily deposit review process.

Back to Top

Merchant Deposit Reconciliation

Merchant deposit reconciliation is the finance process of comparing Business Central authorization activity with processor deposit totals. The source guide explicitly describes using Authorized Credit Card Transactions Analysis Mode to reconcile D365 Business Central credit card authorizations with the processor's deposit total.

The documented card type review is especially useful for finance users because the guide states that Card Type can be added to columns and dragged to Row Groups to subtotal by type, including examples such as Visa, AMEX, and Mastercard. This supports a practical credit card reconciliation Business Central workflow when processor deposit reporting separates activity by card brand or funding category.

Batch Summary also belongs in the finance review conversation. The source documentation states that the Batch Summary page allows the user to request a summary of the batch and close it. It also notes that automatic closing is usually set up, so the action normally does not need to be done except for certain situations when advised by Datacap or the processor.

Back to Top

Document Number and Exception Review

Finance reconciliation often fails because a transaction is present but not connected clearly to a posted document. The source guide includes two relevant actions: Filter Records Without Document No. and Assign Document No. The first action filters the list to show authorized payments that were not updated with a posted document. The second action manually assigns a document number to the selected payment.

The source documentation also explains that payments made from specific customers, posted sales invoices, and posted sales credit memos can be reviewed through Actions > Payment Processing > View Payments. This helps finance users investigate payment activity from the customer or document side when the authorized transaction list alone is not enough.

For reconciliation purposes, exception review should focus on records without document numbers, transactions that require receipt confirmation, payments that need email review under Pay API, and signatures where signature capture is part of the payment process. These are the documented tools that help finance teams connect payment records to supporting Business Central context.

Back to Top

Batch and Receipt Review

The payment processing setup page includes a Related action for Authorized Transactions and a Batch Summary page. Authorized Transactions shows the list of authorized credit card transactions. Batch Summary opens the batch summary page, which allows users to request a summary of the batch and close it where that operational step is needed.

Receipt review is also documented. The Authorized Credit Card Transactions page includes View Receipt. Receipt options in the guide include printing a simple credit card receipt from the Credit Card Authorization page and printing the last receipt from the Posted Sales Invoice page. These receipt actions help finance users retrieve supporting documentation during review.

For platforms with signature support, the authorized transaction list includes View Signature. For Pay API payments with emailing enabled, the list includes View Email. These supporting records can be useful during reconciliation when finance staff need to understand which customer payment record, receipt evidence, or email notification relates to a merchant deposit item.

Back to Top

Source Screenshot

The following preserved source screenshot shows the documented Credit Card Payment page used by the payment processing workflow. It is included because payment reconciliation begins with payment transactions created by the same extension before those transactions are reviewed in Authorized Credit Card Transactions.

Back to Top

Example Business Workflows

Payment Reconciliation Business Central Daily Review

A finance user opens Authorized Credit Card Transactions, turns on Analysis Mode, filters by Payment Date for the day under review, and compares the resulting authorization activity with the expected processor deposit total.

Credit Card Reconciliation by Card Type

A controller adds Card Type to the analysis columns and drags it to Row Groups. The analysis subtotal helps compare Business Central authorization activity by card type to processor reporting categories such as Visa, AMEX, and Mastercard where those values are available.

Merchant Deposit Reconciliation Review

An accounting manager reviews the processor deposit total, opens the saved Business Central analysis for the same payment date, and checks whether authorized payment totals align with the processor deposit information that finance is reviewing.

Records Without Document Number Review

A finance user chooses Filter Records Without Document No. on the authorized transaction list to find authorized payments not updated with a posted document number. When appropriate, the user uses Assign Document No. to manually assign the document number to the selected payment.

Receipt, Signature, and Email Support Review

During reconciliation questions, a user opens the authorized transaction and reviews the receipt. If the platform and setup support it, the user may also review the captured signature or the Pay API email record to help support the payment record.

Back to Top

Conclusion

Payment Reconciliation Business Central gives finance teams a focused way to review authorized payment records, analyze transactions by date, subtotal activity by card type, investigate missing document numbers, and compare Business Central authorizations with processor deposit totals. The strongest fit is for accounting teams that need a repeatable daily or prior-day review workflow for credit card reconciliation Business Central operations.

For implementation planning, confirm how finance users will access Authorized Credit Card Transactions, save Analysis Mode views, use Payment Date filters, export lists when needed, review Card Type subtotals, handle records without document numbers, and use Batch Summary only when processor or Datacap guidance requires it.

Back to Top