• Michael Intravartolo

Microsoft Dynamics 365 Business Central: Reconcile Bank Accounts



In this demonstration we'll show you how to reconcile bank accounts with Microsoft Dynamics 365 Business Central.


YouTube Transcript

in this demonstration we'll show you how

00:04

to reconcile bank accounts you can

00:07

import electronic bank statements from

00:09

your bank to quickly fill in the payment

00:11

reconciliation journal so that you can

00:13

then apply payments and reconcile the

00:16

bank account will use the yodel II Bank

00:19

feed service which is installed and is

00:21

included with the license it's setup as

00:24

an extension to business central and is

00:26

typically ready and enabled or it can be

00:29

configured through the assisted setup in

00:32

the scenario we will link a bank account

00:34

will establish the automatic bank import

00:37

match the transactions and then

00:40

reconcile so first let's go ahead and

00:43

link the bank account so I'm logged in

00:45

to business central hard coded on the

00:48

home page is the bank are the bank

00:50

accounts and so first I'll do is I'll

00:53

select on the bank statement service I

00:55

want to create a new linked bank so in

01:00

the online bank account linking window

01:03

you can search that you can choose your

01:06

current bank or if you don't see it in

01:08

the list you can select on the search

01:10

this happens to be our our sample bank

01:12

account and then I'd enter in the

01:16

username the password that you'd use to

01:18

log onto the online bank and then choose

01:20

the next button right and then click

01:25

Next and then I could say ok we've got

01:27

some accounts that are linked so I

01:30

brought in a couple of counts from my

01:33

online bank feed and then I can next

01:37

step is to establish the import so I've

01:40

made the link and now I need to

01:42

establish that automatic import if I

01:44

want to import my bank statements as

01:46

that feed so here in the link you see in

01:51

the ribbon I have the automatic bank

01:52

import setup so with the bank feed setup

01:55

you're all ready to import this is just

01:58

scheduling though so I'll select the

02:00

schedule I'll enable it and then sit in

02:03

the number of days so when the bank feed

02:05

is enabled you could set up to

02:07

automatically import that into the

02:08

payment journals and now you see that's

02:12

that

02:13

is linked now the next step around

02:17

manage or match transactions you have to

02:20

regularly reconcile your bank your

02:22

receivables and payables by applying

02:24

payments that are recorded in the bank

02:26

to their unpaid invoices and credit

02:29

memos or open entries in Business

02:31

Central's so you're going to perform

02:33

that task in the payment reconciliation

02:36

journal window so here is the payment

02:39

reconciliation journal I'll select on

02:42

the checking and from this window you

02:46

immediately see the level of confidence

02:48

meaning low medium and high the

02:50

application has for those matching

02:52

entries right the confidence level is

02:54

driven by the transaction amount the

02:56

date this description or text and then

02:59

from the actions I can go ahead and

03:01

enable the additional options from the

03:04

drop-down menu so go ahead and I'll

03:06

select the test report and I just want

03:09

to sake make sure with this PDF it shows

03:12

me the potential impact so I can preview

03:15

this before I do the the posting of the

03:17

reconciling and then the goal here is to

03:22

provide you guys again with a single

03:24

location next I'll go ahead and perform

03:26

it so month then close it's time to

03:28

reconcile all the banks with the ledgers

03:31

I can go in and open the transactions

03:33

make the necessary adjustments or

03:35

reconciliations and then move on to the

03:39

next task

03:40

so the goal that scenario was to show

03:43

you how the ability of automating and

03:46

linking banking to Dynamics 365 business

03:49

central the benefits clearly to help

03:52

improve efficiency and accuracy and

03:54

remove the need for manual entry while

03:57

staying current with your bank accounts

#Videos

Contact Us

Solution Systems, Inc.

3201 Tollview Dr. 

Rolling Meadows, IL 60008

Office: 847-590-3000

Email: info@solsyst.com

Support: 224-345-2020

Support Email: support@solsyst.com

Connect With Us
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Chicago
  • Manufacturing Software | Illinois
  • Microsoft Business Podcast
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
Join our Mailing List

© 2020 Solution Systems, Inc.