Excel file transformation project

Lengkap Disiarkan 5 tahun lepas Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

READ BEFORE BIDDING

The attached file has an example of an invoice (input) that must be transformed into multiple accounting entries (output). The goal is to create a csv file with multiple accounting entries generated from many invoices that can be uploaded into an accounting sofware.

Pls describe briefly how you will implement the solution for a windows desktop user.

Perakaunan Pemprosesan Data Excel

ID Projek: #17177640

Tentang projek

33 cadangan Projek jarak jauh Aktif 5 tahun lepas

Dianugerahkan kepada:

varghesearunct

As one invoice maps to 6 Accounts, I can create an R or Python script which transforms the input file to the desired output file. It is a simple mapping as the 6 accounts remains same for all the invoices. For mapping Lagi

$40 USD dalam 2 hari
(0 Ulasan)
0.0

33 pekerja bebas membida secara purata $130 untuk pekerjaan ini

schoudhary1553

Hello, I can help with you in your project Excel file transformation. I have more than 5 years of experience in Accounting, Data Processing, Excel. We have worked on several similar projects before! We have worke Lagi

$250 USD dalam 3 hari
(244 Ulasan)
7.5
SBITServices

Hello mauricio0630, I have checked the file but i need some more clarification on requirements.I can achieve this with Excel Macro. I have 5 years experience in Excel VBA programming and can complet Lagi

$65 USD dalam 2 hari
(328 Ulasan)
7.2
watersev

Hi there, I would suggest to create a reference table that will provide all possible invoice entries and their appropriate accounting reflection in the csv. All that will be working on VBA script that will produce o Lagi

$60 USD dalam sehari
(243 Ulasan)
6.4
gangabass

I can provide you simple desktop GUI program that will allow your user to select input Excel file and after you click Start button it will generate CSV file with multiple accounting entries just like you want.

$60 USD dalam sehari
(130 Ulasan)
6.0
tiaratechies

Hello, we are a team of qualified chartered accountants and CPA, we do have software experience that is an added benefit on this project, We hope you will consider us and drop a message to discuss further.

$250 USD dalam 3 hari
(37 Ulasan)
5.2
archanaoswal

I have excellent command on MS Excel. I can write a macro to transform the data in "Datos Entreda" sheet into "Datos Salida" sheet. The basic idea will be for each row in the input (if there are multiple rows), multipl Lagi

$150 USD dalam 2 hari
(33 Ulasan)
5.0
kahilH

Hello I propose to implement a solution in java ,it will be a simple GUI program that has a textfield to join multiple excel files and once the start button is clicked the program will perform the transformation neede Lagi

$100 USD dalam 3 hari
(22 Ulasan)
4.9
TechnoGuruu

Hi, As per your project descriptions and attached excel file, if I understand your requirement correctly you are looking for an invoicing solution which will provide you tow different tables as Invoice master(contai Lagi

$144 USD dalam 5 hari
(21 Ulasan)
4.2
jkc2018

Hi there, Accounting entries has to be passed for each invoice in the format which your accounting software recognizes it. First, you need to get sample template for accounting entries so that accounting entries are g Lagi

$250 USD dalam 10 hari
(21 Ulasan)
4.0
salimmurshed1111

i can make this software for you.....................................................................................................

$77 USD dalam 3 hari
(2 Ulasan)
1.7
marloufin

Hi, I've been in excel vba and ms access for 3 years and currently creating company tools for users reporting. I can help you with your project by creating vba macro for you. Please let me know to discuss further Lagi

$155 USD dalam 3 hari
(3 Ulasan)
1.7
expertworld1

I’m excited to share with you the proposal , i am an expert in project you mentioned , Imagination and creativity can change the world . I guarantee you to submit the work within timeline and as per your expecta Lagi

$30 USD dalam sehari
(0 Ulasan)
0.0
RTableauExpert

Hi, Using macros , I will extract the accounting journal entries from the input format into a format that can be uploaded to the accounting software. I have experience in excel and have used accounting softwares lik Lagi

$55 USD dalam 3 hari
(0 Ulasan)
0.0
JJJuan

Good day! I have made projects before that included extracting data from an excel file. I could design you a .NET desktop application that would simply require you to input an excel file and have it decoded and rec Lagi

$83 USD dalam 3 hari
(0 Ulasan)
0.0
igor95filipovic

I've already worked on requirements like this one in my school projects (data manipulation in Excel with creating different outputs) and I'm highly motivated and confident to do this job as well.

$45 USD dalam 3 hari
(0 Ulasan)
0.0
Victor02

I think that can done easily in java. My program will read your input file and output it in the CSV format with the predefined columns.

$30 USD dalam 2 hari
(0 Ulasan)
0.0
marcianoullmann1

Having a broad experience in Report consolidation, analysis, automation and manipulation, I believe I have the necessary skills for you requirement. To continuously enhance my knowledge and abilities has always been my Lagi

$111 USD dalam 2 hari
(0 Ulasan)
0.0
TharishThaha

I will allocate all my knowledge skill and experience to work with maximum accuracy and integrity in right time for you

$155 USD dalam 3 hari
(0 Ulasan)
0.0
kpvyas93

I have a sound experience of using different accounting software where we have uploaded all the different CSVs for sales, experiences, bank transactions by formatting the Excel file.

$111 USD dalam 7 hari
(0 Ulasan)
0.0
rajnishkhare1970

Hi, PL see the below table (an outcome of Pivot in excel) where just by re-arranging the headings with GL account, these accounting entries are arrived, For you reference , i have added one more invoice 320832 input d Lagi

$333 USD dalam 3 hari
(0 Ulasan)
0.0