Loading Financial Data

We are small Accounting Company based in Melbourne. Over last year our customer base had grow twice and it is still growing. We spend a lot of time thinking how we can optimise our business processes. First thing we did created standard Excel templates for everything.  For example standard expenses form will consist of customer id, employee id, expense date, category and amount. Using standard forms saved us a lot of time but once all the forms are filled in they had to be processed manually. Our people ware constantly under the pressure and we had to employ an agency staff on temporary basis.

Not any more.

During routine Google search we discovered Advanced ETL Processor Ent which quickly becomes a corner stone for automating our business processes.     

By using Advanced ETL Processor Ent we were able to eliminate most of our manual tasks  

It is like spider which sits in the middle connected to all our systems.

For example, for expenses form the process is follows.

A customer emails us expenses form
Advanced ETL Processor Ent package connects to mail server, downloads attachment,
Loads Excel file into our accounting system,
runs sql script to validate submitted data,
emails report back to the person who submitted expenses from
At the end of month summary report emailed to the company automatically.

Carl Barret,
Accountant

More Information:

The Advanced ETL Processor can be used to automate the process of transferring and transforming data from one database to another, or from several databases to several other databases. The Advanced ETL Processor is a specialised tool designed for this task.

For the Advanced ETL Processor the above tasks are very simple. It can perform tasks much more complex than this, but it does provide a flavour of what the processor can achieve. Additional validation checks can be built into the process, and any problems can be reported to an error log. The process can be made to halt on error, or it can continue, so that any problem areas can be re-executed at a later time.

Once you are ready to go, it is a simple matter to start the Advanced ETL Processor and allow it to perform its tasks. Stages in the process can be changed or amended for different environments and systems. The processing stages can also be changed depending on what happens during the process, so it can make intelligent decisions based on what the creator of the process would like to happen during execution. Therefore “what if” situations can be handled and alternative processing routes included.