Bank reconciliation "North American" method in Microsoft Dynamics 365 Business Central

By -

If you're not using the Auto Match functionality to reconcile your bank accounts then you're using the "North American" method as Microsoft calls it. This blog outlines the steps to complete the bank reconciliation using this method. I will also post a blog on how to process bank reconciliation using the Auto Match functionality. 


1. Search for Bank Account Reconciliations


2. Process > New


3. Select ‘CHECKING’


4. Update the Statement Date to the date you pulled for and update the Balance on Statement to be the ending balance for that day.


5. Process > Suggest Lines


6. Both > OK


7. Proceed with checking off the items cleared bank within the ‘Checks’ and ‘Deposits/Transfers’ sections of the Bank Rec. Worksheet.


8. Once you’ve checked everything off there may be some misc items you couldn’t find to check off. Those items will need to be investigated to see why missing from Business Central. Once you’ve entered them into the system you can go back into the Bank Reconciliation and click Process > Suggest Lines > OK. Proceed to check those items off in the respected sections of the Bank Rec. Worksheet. You can also enter any adjustments within the Adjustments section of the Bank Rec. Worksheet. 

      9. Once You’ve checked off everything verify that the Bank Rec. Worksheet has a $0.00 difference by clicking on Process > Recalc G/L Balance. Look for the Difference to be 0.00.


10. Once difference is 0.00 then you can print the Bank Rec. Test Report for your backup. Actions > Posting > Test Report.


11. Select all options and Print.


12. Post Bank Reconciliation. Posting > Post

13. Yes




14. OK

Written by: Kristen Hosman, Microsoft MVP




Comments

Sherry said…
Hi, Kristen: One of question from me is that how we can reverse the bank reconciliation if it is done through the worksheet

Thanks,
Sherry
January 3, 2023 at 4:23 PM
Post a Comment

Popular posts from this blog

Microsoft Dynamics 365 Business Central: adding new licensed users to BC

By -
Image
Adding a new licensed user isn't hard to do within Business Central (BC).  Prerequisite: license is purchased and available to assign to user. You also must be an Internal Admin or have proper security within BC to complete these tasks.  Microsoft 365 admin center Assign BC license to user. Dynamics 365 Business Central Navigate to Users page. Select Process > Update users from Microsoft 365 Update users from Microsoft 365 > Next Update users from Microsoft 365 > Next Update users from Microsoft 365. Review the updates within this window and click finish. Lastly assign user group or permission sets and assign company access.  Version: US Business Central 22.1 (Platform 22.0.58213.0 + Application 22.1.55890.56216) Written by: Kristen Hosman, Microsoft MVP
Read more

Dynamics 365 Business Central - Is this a feature or a bug? Filtering and posting General Journal lines

By -
Image
This blog is inspired by something I just learned from James Bowles .  Scenario: I have a General Journal with multiple lines and only want to post certain transactions/lines.  In my example I am going to filter on the Posting Date field so only the 04/30 transaction is posted. Once the posting is completed you will see the remaining lines in the journal.  Review the General Ledger Entries and you see only entry posted was the 04/30. Written by: Kristen Hosman, Microsoft MVP
Read more

Invited External Accountant in Dynamics 365 Business Central now what?

By -
Image
This blog describes what comes next after you invite an External Accountant. If you need to invite an External Accountant than visit this blog:  Invite External Accountant in Dynamics 365 Business Central (kristenhosman.com) You've invited an External Accountant now what? What happens after you've successfully invited an External Accountant? You receive the below message in Dynamics 365 Business Central and your external accountant receives an email.  Steps your External Accountant should take Have your external accountant look for an email with a subject line: You have been invited to Microsoft Dynamics 365 Business Central. The external accountant should click on the link provided in the email. They will be redirected to a Microsoft sign in window. In my case the external accountant email isn't listed so I'm going to select use another account. Enter email. Next window suggests that a code was sent to email. Go pull code from email and enter into next window. Accept t
Read more