Skip to main content

Posts

Showing posts with the label Bank Reconciliation

Reverse a Wrongly Posted Payment in Business Central (Open or Closed Month)

A customer or vendor payment was posted wrongly in Business Central: wrong amount, wrong bank, posted twice, or it never happened at all. Now you need to undo it without messing up the vendor balance, the bank reconciliation, or a month that Finance has already closed. Quick answer Payment's month still open → Reverse Transaction from General Ledger Entries. BC reverses everything on the original date. (Method 1) Payment's month already closed → post a reversal journal dated in the current month, then apply it to the original payment. (Method 2) Either way: unapply the payment from its invoice first, and clear the two bank entries in your next bank reconciliation. First, do you really need to reverse? Reversing is for a payment that is wrong as a whole. Smaller mistakes have a cleaner fix: What's wrong Best fix Only the dimension (e.g. wrong department) Correct Dimensions on General Ledger Entries. Nothing is reversed. Wrong vendor or customer...

How to Perform Bank Account Reconciliation in Microsoft Dynamics 365 Business Central

To make sure the bank statement’s listed transactions are same with records that registered in Microsoft Dynamics 365 Business Central (BC), you can perform Bank Account Reconciliation to ensure the accuracy. Page: Bank Account Reconciliation 1.        Enter the Bank Account Statement Date and the Bank Account Statement Balance for the bank account that you need to reconcile. ( Take note that the Balance Last Statement will auto reflect the last posted bank reconciliation, do not apply anything into this field. ) 2.        To get the system to replicate the posted bank ledger entries in BC into Bank Statement Lines, you can select Suggest Lines options to do so. 3.        In this Suggest Bank Acc. Recon. Lines option, you can filter the bank ledgers entries from the Starting Date and Ending Date options. To make sure all open entries are included, you can leave the Starting Date field blank, while ...

How to Start with Bank Account Reconciliation in Microsoft Dynamics 365 Business Central

A company has move to Microsoft Dynamics 365 Business Central (BC) from legacy system, other than migrating the outstanding documents from Accounts Payable and Accounts Receivable to BC, you can also migrate the unreconciled bank transactions such as unpresented cheques and deposit in transit to BC. For example, I need to perform June’s 2022 Bank Recon in BC, and will need to setup the following in BC before I can proceed with bank reconciliation in BC.  Bank Statement amount for the last performed bank reconciliation from legacy system. It will be May’s 2022 Bank Statement for this case, and the amount printed in the May’22 Bank Statement is $68,000.   All the unpresented cheques for the last performed bank reconciliation in legacy system. Say there is 1 cheque payment with amount of $9,800. All the deposits in transit for the last performed bank reconciliation in legacy system. Say there is 1 payment from the customer with amount of $10,200. Step 1 – Register the outstanding...