Käynnissä

Write an Excel add-in with user interface

The aim of this addin is to match and reconcile Accounting Database and bank POS statements.

We have a single accounting DB and many bank statements with different formats

Once we download all the csv, xls or xlsx files to a folder, the add in will

-scan the folder,

-import the data from different file formats to a single file (create multiple sheets)

-create an autoincrement index for every sheet

-create a comparable column for every sheet

-create a Match column for every sheet

-create a result sheet

The excel macro will work like this:

The add-in is assigned to a button. When the addin opens it asks for:

-DB file (I can use the already open csv sheet) and profile assigned to it.

-Bank statements (up to 8) and profile assigned to it (all the files in the same folder with DB file are scanned for "filename match" below)

Settings:

-Modify profiles

- - filename match to profile: filename (starts,contains,ends) has .... string then set profile...

- - Add index? (adds an autoincrement index Row number to the right end of the table where the data finishes ). index is used to specify a specific row with sheet name

- - Add Comparable column?

- - - Concatenate following [Column nr & applied function] ( functions: LEFT (N) , RIGHT (N), Multiply by (N), Convert date to YYYYMMDD number, Convert date to YYYYMMDDHHMMSS number )

- - - Add comparable column to Nth column

Add-in Result sheet Algorithm

-Get all the rows on DB

-Create 1 column for every bank and 1 column for error reporting

-If the Comparable column matches with one bank put 1 to that column. If two banks match put 1 to each column (copy that to the errors sheet) write the index of the matching value to the relative rows (in Match column) in DB and bank statement, also mark the DB row and the Bank row yellow.

-If the data is not present in any bank statement then put a 1 to the error column, mark DB row red, insert index value "Error" to result column on DB sheet.

-If the data is present only in bank statement add it (as a new row) to the Result Sheet put a 9 to the bank's column and another 9 to the error column

Resolver For the error results:

time sensitivity shall be asked in minutes. if the comparable column has time it should be removed. Then the process shall be reRun for these error rows. This time if there is a match within the same time sensitivity these transactions shall be matched too.

Point and click matcher:

on the left DB, on the right Bank. Transactions shall be selected with single click. Click from left and click from right. These are matched.

All changes shown on the result sheet.

Taidot: C# -ohjelmointi, Excel, Microsoft Access, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: excel import user interface, write toolbar application android, excel creating user interface, convert cldc blackberry application android, call sending receiving application android, call feedback application android mobile, bluetooth obex application android, prting application android, webex application android, soundboard application android, database application android, application android sip voip, start camera application android, simple database application android, porting iphone application android, windows form application read write text, excel database user interface, timer application android, write program java graphical user interface, create front end user interface excel

Tietoa työnantajasta:
( 32 arvostelua ) Lefkosa, Turkey

Projektin tunnus: #14718352

Myönnetty käyttäjälle:

fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Lisää

$981 USD 10 päivässä
(94 Arvostelua)
7.4

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

maverick44000

Hello, Instead of naive VBA scripting, I can develop a professional .Net VSTO Excel Add-in which shall do the required tasks. Please discuss if you are interested. Thank you, Usman

$2000 USD 15 päivässä
(104 arvostelua)
7.5
lukaszoz

Hello, I'm a developer with over 5 years of experience and work as a regular .Net developer on daily basics. I work with technology like : 1) Access and whole office stack (Excel, Word, Outlook) in terms of V Lisää

$400 USD 10 päivässä
(38 arvostelua)
7.0
XeeChaun

hi. I have 4+ years of experience in Excel add-in development. I have built a number of them. here is video demo of one: ---( [login to view URL] )--- here's another project related to Excel add-ins: ---( https://www Lisää

$750 USD 15 päivässä
(60 arvostelua)
6.4
$555 USD 10 päivässä
(18 arvostelua)
6.5
diorisaguilar

It's a very interesting project. The settings can be placed in a new tab the ribbon. Are you working with Access database? Can you provide an example of a couple of bank statements? What office version would like the a Lisää

$420 USD 9 päivässä
(41 arvostelua)
6.2
$833 USD 10 päivässä
(31 arvostelua)
6.1
TanzeelAhmed

I REVIEWED YOUR PROJECT DETAILS & WOULD LIKE TO OFFER YOU MY SERVICE OF DOING FIRST TASK FOR FREE, JUST TO PROVE MY SELF TO U AND ALSO GET EXCELLENT REVIEWS FROM U, AFTER YOU AWARD ME JOB AND CREATE INITIAL MILESTONE F Lisää

$750 USD 20 päivässä
(29 arvostelua)
5.8
$555 USD 10 päivässä
(47 arvostelua)
5.9
solucionesnet

HI, in the past I worked with office addins and I can build the excel addin that you need. Share me a sample of files if you can. Check my portfolio.

$444 USD 10 päivässä
(19 arvostelua)
5.2
karunakartiwari

Hi, I have gone through in details about the requirement. I would like to under for which MS-office version you are looking for Addins {Office 2013/ 2016}. I have sound experience in VSTO Add-ins development and Lisää

$1666 USD 20 päivässä
(22 arvostelua)
5.2
$500 USD 10 päivässä
(12 arvostelua)
4.9
khanicha

Hello, The add-in would be written in C#.NET by using VSTO library. So your addin will be presented as a commandbar button or a ribbon button. Which one you prefer? This will work for Excel 2007 or above version. Re Lisää

$350 USD 10 päivässä
(5 arvostelua)
4.5
jones417

Over the last 7 years I have developed a wide range of mobile applications for smartphones, tablets and smartwatches. Most of my clients are companies from the small business but I've also worked for Samsung, Shutterst Lisää

$555 USD 10 päivässä
(3 arvostelua)
4.4
nurnga1218

Hi, I've made something like yours. But i'ts not about accounting. It was about excel security system. I think I can make an add in like you want. I hope we'll discuss further. Thanks

$250 USD 10 päivässä
(36 arvostelua)
4.4
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can dev Lisää

$300 USD 10 päivässä
(24 arvostelua)
4.1
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Lisää

$750 USD 2 päivässä
(13 arvostelua)
4.0
$444 USD 10 päivässä
(11 arvostelua)
4.0
imranrazawi

I am experienced Excel Add-in developer. I have developed many reconciliation Excel solutions and other financial solutions with Excel, Access and VBA.

$500 USD 10 päivässä
(5 arvostelua)
3.0
emresurmeli

I am expert in MS Office especially in excel. I can use VBA language in excel. I have experience about 2,5 year in decision support reports to board members At Mlpcare. I am good at making up documents,excel report fo Lisää

$555 USD 4 päivässä
(0 arvostelua)
0.0
snovasys

Hi, This is Srihari from Harrow, London. I am an Excel add-in & marco (VBA and VSTO) specialist. Please don’t go with my new profile here. I have 100+ excellent reviews on my PPH profile - [login to view URL] Lisää

$1120 USD 16 päivässä
(0 arvostelua)
0.0