14 Nov

Account statement processing (Versino Financial Suite)

Versino Financial Suite

the Account statement processing (Versino Financial Suite) is a module of the Versino Financial Suite that imports electronic account statements into SAP Business One and provides them as draft documents in the bank statement processing system. This module replaces the previous bank import add-on.

Status

The module is still under development and has not yet been released to customers. All information is based on the current state of development. Changes are possible before release.

Context

The account statement processing reads account statements in the CAMT 053 format, the XML variant of the electronic account statement. In addition, it uses import formats from Business One, insofar as it is able to run them.

The extract files are located in one or more input folders. A Windows service on the SAP server retrieves them according to a schedule, without requiring a user to be logged in. The interval applies to each folder and is set in minutes. Completed files are moved to a storage folder, problematic files to an error folder. Additionally, a manual import via a window in Financial Suite in Business One is possible.

The Financial Suite finds the client and the home bank account via the IBAN of the statement. This also works across clients, provided that all clients are on the same database server. New home bank accounts appear initially disabled in the account reconciliation. An administrator turns them on. If the same IBAN appears in several active clients, the module does not import it and displays a red error.

After importing, the assignment rules run through the lines of the design. In addition, the module generates an import log for each file and each extract. If a scheduled run fails to complete something, it sends a message to the specified recipients in Business One. No one will know about the problem without the registered recipients.

As prerequisites, depending on the development status: SAP Business One 10.0 on Microsoft SQL Server, all target clients on the same database server, a module license, and one technical user in all target clients. Additionally, each target client requires the installed bank statement processing with open billing periods.

Demarcation

Account statement processing does not build a second booking world in addition to Business One. The imported statement is stored as a draft in Business One. There, accounting processes the rows, assigns them, and posts them. What is in Business One remains the basis. A statement is never created twice: a second import of the same file receives the status „already present“.


 

Versino Financial Suite Webinars.

Experience liquidity planning in SAP Business One live: The webinars on the new Versino Financial Suite

Predictability in unpredictable times: Every management team wants reliable liquidity planning. There is agreement on this. That’s the ideal world. The difficult part...
Financial chat for SAP Business One: How he answers questions about numbers and when he prefers not to answer

Financial chat for SAP Business One: How he answers questions about numbers and when he prefers not to answer

Anyone who does not book in SAP Business One on a daily basis often faces closed doors when it comes to questions regarding the financial system...
Versino Financial Suite Major Release: End of the SAP window cage

Versino Financial Suite Major Release: End of the SAP window cage

Anyone who has two monitors on their desk also uses them. That goes without saying. In the SAP Business...
Account statement processing in SAP Business One: The account statements flow from an input basket via a sorting line to a draft that the accounting department checks with an orange check mark.

Account statement processing: What the Versino Financial Suite will offer in the future — a preview of accounting

An account statement is quickly read. That is the manageable part of the work. The work lies behind that. The statement must be sent to the...
E-invoice check

E-Invoice check by Versino Financial Suite

An e-invoice is quickly generated. SAP Business One includes the XRechnung feature as standard, and those who use cks.eINVOICE or the ...
Cash flow forecasting SAP B1

Cash flow planning in SAP Business One: What the Versino Financial Suite does differently

Cash flow planning is considered a done deal in many medium-sized companies. After all, there are bank statements, there are open items, ...
SAP Business One Netting and Accounts Payable

Netting in SAP Business One: What makes the Versino Financial Suite different

When a business partner is both a customer and a supplier, that sounds like a comfortable situation. You know each other, you trust...
Susa-in-the-Versino-Financial-Suite

Trial Balance in SAP Business One: What the Versino Financial Suite does differently – and why tax advisors notice

The Trial Balance is one of the oldest reports in accounting. Every accounting program has it, and SAP Business One itself...
Wird geladen …