How to manually process a Bank Reconciliation in Business Central?

Bank Reconciliation in Business Central

The following guide will walk you through on how to manually process a bank reconciliation in Business Central.

Microsoft Dynamics 365 Business Central | Bank Reconciliation

By: Lupe Haro – Microsoft Dynamics ERP Consultant

The following guide will walk you through on how to manually process a bank reconciliation in Business Central using the Bank Account Reconciliation window.

  1. In the Global Search , enter “Bank Account Reconciliation” and select the option in red.Bank Reconciliation in Business Central
  2. In the Bank Account Reconciliations window, select New > New.Bank Reconciliation in Business Central
  3. Select the bank account you want to reconcile and click OK.Bank Reconciliation in Business Central
  4. Enter the Statement Date you are reconciling and the Balance on the Statement in the corresponding fields.Bank Reconciliation in Business Central
  5. Under Process > Select “Suggest Lines” to populate the bank reconciliation with all posted bank transactions.Bank Reconciliation in Business Central
  6. Under Record type to process, select “Both” and you can also add a posting date filter, so the system only pulls transactios for the given period. Click “Ok” to pull the transactions.Bank Reconciliation in Business Central
  7. The system will pull the transactions and add them to the corresponding sections. At this point, you will need to mark all the transactions that cleared in the given period.Bank Reconciliation in Business Central
  8. Once you have completed the marking of cleared transactions, the “Difference” should be zero. If there is a difference or a transaction is missing it can be added within the Adjustments section of the reconciliation window. (NOTE: The reconciliation cannot be posted until the difference is zero)Bank Reconciliation in Business Central

NOTE: If the balance is not zero, here are a couple things to watch out for:

  1. Transactions posted directly to the general leder cash account and not to the bank ledger.
  2. Missing transactions in the bank reconciliation (These can be recorded in the Adjustments section.
  3. Transactions mistakenly marked as cleared or not cleared in the grid.

 

  1. Once all transactions are marked and the reconciliation difference is zero, you can post the reconciliation under Posting > Post.Bank Reconciliation in Business Central

Once posted you can reference posted reconciliations within the bank account card under Navigate > Bank Acc. > Posted Reconciliations.

Bank Reconciliation in Business Central

 

Visit us at our DemandDynamics website or schedule a free consultation.

0

Leave a Reply

Your email address will not be published. Required fields are marked *


Notice: ob_end_flush(): failed to send buffer of zlib output compression (0) in /home/demanddynamics/public_html/wp-includes/functions.php on line 4609

Notice: ob_end_flush(): failed to send buffer of zlib output compression (0) in /home/demanddynamics/public_html/wp-content/plugins/https-redirection/https-redirection.php on line 47