Excel file transformation project

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

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.

Contabilidad Procesamiento de datos Excel

Nº del proyecto: #17177640

Sobre el proyecto

33 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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 Más

$40 USD en 2 días
(0 comentarios)
0.0

33 freelancers están ofertando un promedio de $130 por este trabajo

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 Más

$250 USD en 3 días
(244 comentarios)
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 Más

$65 USD en 2 días
(328 comentarios)
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 Más

$60 USD en 1 día
(243 comentarios)
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 en 1 día
(130 comentarios)
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 en 3 días
(37 comentarios)
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 Más

$150 USD en 2 días
(33 comentarios)
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 Más

$100 USD en 3 días
(22 comentarios)
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 Más

$144 USD en 5 días
(21 comentarios)
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 Más

$250 USD en 10 días
(21 comentarios)
4.0
salimmurshed1111

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

$77 USD en 3 días
(2 comentarios)
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 Más

$155 USD en 3 días
(3 comentarios)
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 Más

$30 USD en 1 día
(0 comentarios)
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 Más

$55 USD en 3 días
(0 comentarios)
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 Más

$83 USD en 3 días
(0 comentarios)
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 en 3 días
(0 comentarios)
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 en 2 días
(0 comentarios)
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 Más

$111 USD en 2 días
(0 comentarios)
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 en 3 días
(0 comentarios)
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 en 7 días
(0 comentarios)
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 Más

$333 USD en 3 días
(0 comentarios)
0.0