Manual Bank Statement Import

(0) Share

Report

Posted on by Kae

150

Hi to all.

How is the importing process in the Payment Reconciliation Journal differ from the newly launched extension of BC "Simplified Bank Statement Import"? The manual import in the Payment reconciliation journal is already simple for us to use, so we wondered what can this new extension does more?

Also, are Dynamics Nav and (SaaS) Business Central the same? I got confused with the terminologies I read in this forum (we're just starting to learn everything on our own). All replies are highly appreciated. Thank you.

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Community Member on at

Like (1)

Report

J-Vae,

The new Simplified Bank Statement Import was added for those Banks that are not available for import using AMC Banking or Yodlee Banking Service feature. It allows for the Bank Statement downloaded to Excel and Imported for reconciliation.

I am attaching an overview.

As for Dynamics NAV and Business Central SaaS, Dynamics NAV was the previous Name of the software prior to Business Central updated name/release. The functionality has come from NAV to BC and prior NAV releases, that are not supported, do not receive updates. SaaS version is also auto-updated with monthly updates and semi-annual Major updates.

Hope this helps.

Thanks,

Steve

0564.Bank-Simplified-Import-Wizard.docx

Was this reply helpful? Yes No
Kae 150 on at

Like (0)

Report

Thanks a bunch, Steve!

Was this reply helpful? Yes No
Hendrik Stapelberg 25 on at

Like (0)

Report

Hi Steve

I see the Simplified Bank Statement Import still does not provide for Header information to be imported, say for example the opening balance of the statement that is on the Statement header. I tried to map a header record fields to the Bank Acc reconciliation table, but the import statement does not like it.

Is there a way to import a header record? It seems the only option for header records is to count them, and have the definition ignore the header records on import.

Thanks.

Hendrik

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hendrik,

Can you attach a sample so I can see what you are describing.

Thanks,

Steve

Was this reply helpful? Yes No
Hendrik Stapelberg 25 on at

Like (0)

Report

Steve

See attached screen shot of the header lines, there are 3. Line 3 containes the opening balance, but you cannot map the header lines to to table 275 Bank Statement, even if you create a header record under line definitions.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hendrik,

Yes, this is correct. The OPEN line type to the Header since the Simplified Import only references the lines. The Data Exchange excludes Header and Footer.

I would hate to customize this as it would not be logical. I would say notate in the Data Exchange the Line rows start at 4 and manually enter the Bank Statement Balance.

Thanks,

Steve

Was this reply helpful? Yes No