Map General Ledger Accounts to a reference Chart of Accounts

g in with the best idea for an algorithm.

Map General Ledger Accounts to a reference Chart of Accounts

The situation

In most countries organizations are free to design their own Chart of Accounts Schema in their financial books. A sample:

No Account

2900 Liquid Assets

2910 Cash

2920 Bank, LCY

2930 Bank Currencies

2940 Giro Account

2990 Liquid Assets, Total

2995 Current Assets, Total



3100 Stockholder's Equity

3110 Capital Stock

3120 Retained Earnings

3195 Net Income for the Year

3199 Total Stockholder's Equity

4000 Allowances

4010 Deferred Taxes

4999 Allowances, Total

5000 Liabilities

5100 Long-term Liabilities

The disadvantage is that it is almost impossible to combine or compare financial information over com-panies.

To address this (some) governments regulated the Chart of Accounts OR have a Reference Chart of Accounts to map to. In both cases the software vendors of financial bookkeeping software had to change their software. In case of the Reference Chart of Accounts facilitating a possibility to map the organizations Chart of Accounts to the Reference Chart of Accounts.

The callenge

Our challenge lies in those countries that are not standardized as yet. We are aiming to facilitate our own Reference Chart of Accounts and a clever mechanism to connect the organizations Chart of Accounts. This helps the organization by suggesting a mapping instead of mapping each individual account (which is a lot of work in an administration with 1000+ accounts).

The Chart of Accounts as well as the will in generally be an Excel list or database table containing the information below, + an Excel list with the reference schema.

The algorithm has to be:

• Looking at language semantically – the probability of a 1:1 match is too small

• Self-learning – based on previous human corrections

• Optionally multi lingual

Our request

Build a smart(er) algorithm as described above as a Proof-of-Concept.

The algorithm will be documented in a way that is readable for non-specialists.

The Proof-of-Concept is implemented following these requirements:

• Is a webservice with at least one method requiring two arguments (ChartOfAccounts, RefChartOfAccounts) and returning a suggested mapping

• Every Account can only be mapped to one Reference Account

• The reference general ledger account knows at least the following accounts:

• Asset account

• Bank account

• Cash

• Creditor account

• Debtor account

• Expense account

• Neutral account

• Revenue account

• Stock account

• VAT account

• Microsoft C#.Net or VB.Net based, .Net framework 4.0 or higher

• All source code will be supplied as the including intellectual property


The implementation of our request will be worth $500.

Acceptance takes place at a 70%+ match rate of our sample database to the Reference Chart of Accounts above.

We will select the developer writin

Færdigheder: .NET, Amazon Web Services

Se mere: general ledger mapping, mapping general ledger, excel map general ledger accounts, general ledger account mapping, general ledger mapping excel, chart accounts reference, general ledger chart accounts database schema, general ledger database design, mapping chart accounts, chart account database schema, mapping general ledger sample, chart accounts database schema, chart accounts excel, general ledger chart accounts, map general ledger chart accounts, mapping general ledger chart accounts excel, database chart accounts ledger, mapping general ledger excel, chart accounts sample, chart accounts, chart accounts database design, map ledger, chart account source code net, mapping general ledger accounts, work reference

Om arbejdsgiveren:
( 0 bedømmelser ) Netherlands

Projekt-ID: #4051313

10 freelancere byder i gennemsnit $617 for dette job


Hi, ASP.Net,MVC,HTML5,JQuery,.Net,C#,VB expert here. Please have a look at private message for my portfolio and similar work done. Looking forward to hear from you. Thanks

$750 USD in 15 dage
(30 bedømmelser)

We can work in your Map General Ledger Accounts. I am a leader of the team expert in several tecnologies like PHP, .NET, Oracle, SQL, Movil applications. I have 14 Years of experience in Software development Windows an Mere

$500 USD in 20 dage
(18 bedømmelser)

Hi, I am interested to work on this project. I have a great experience on 4, 4, Windows service, Web service, COM, CSS, HTML5, XML, Java Script, Ajax, Jquery, Crystal report 10,[url removed, login to view], MSSQL Server Mere

$700 USD in 15 dage
(1 bedømmelse)

Dear Sir,We are very much interested your nice project. Sincerely AdaSoft

$599 USD in 39 dage
(0 bedømmelser)

ready to start the project. I want to introduce our self, we are a group of freelancers have experience in web application development and design for different domain, please go through the attach portfolio for Mere

$720 USD in 24 dage
(0 bedømmelser)

For more details please check PMB.. Thanks

$601 USD in 15 dage
(1 bedømmelse)

Hello Team, Greetings From Expedite Informatics Pvt Ltd !!!! We are an IT consulting and services company providing Technology and Functional consultants to our clients and executing projects on a turn-key basis. Mere

$750 USD in 60 dage
(0 bedømmelser)

we will provide you complete Solution as per your need. For more detail please check our message where you can find our previous work too

$250 USD in 4 dage
(0 bedømmelser)

Hello, I have couple of guys who would be perfect fit with extended technological background & experience with custom software development. Examples of our projects: [url removed, login to view] Please contact me to Mere

$750 USD på 1 dag
(0 bedømmelser)

Dear Client, we guarantee job satisfaction and on time delivery with sustainable outcomes. Please see message box for details. Thanks.

$550 USD in 40 dage
(0 bedømmelser)