Excel file transformation project
$30-250 USD
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.
Nº del proyecto: #17177640
Sobre el proyecto
Adjudicado a:
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
33 freelancers están ofertando un promedio de $130 por este trabajo
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
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
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.
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.
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
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
i can make this software for you.....................................................................................................
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
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
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.
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.
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
I will allocate all my knowledge skill and experience to work with maximum accuracy and integrity in right time for you
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.
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