Completed

Format Excel File for Jonas Construction Software AP Import

We are an electrical wholesale distribution company. We try and provide valuable services to our customers. I have a customer that would like to import invoices automatically into their system. Typically this is pretty easy to do but this particular customer uses software that has some very unique requirements for importing. I need to have an excel file manipulated automatically with a VBA macro in Excel to allow importing data into the Jonas Construction software. I will provide the raw data from our ERP system in an Excel or CSV file. I would like to have a macro run that will do all the formatting and data manipulation necessary to allow the file to be imported. There are certain values that the user will need to be prompted to enter before formatting. I've attached an example file. This one was manually compiled. The file must start with a H (header) record followed by ab I (invoice record - provided from our ERP system (second attachment) and then a D (Distribution) record. The distribution record is in reference to the I record above it. This D record is used to distribute the invoice to the correct GL account. Then the file will continue with additional invoice and distribution records.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: salary slip format excel file, changing format excel file perl script, format excel file using visual basic, jonas accounting software manual, jonas login, jonas software training, jonas premier construction software, launch jonas, jonas premier login, premier construction software pricing, jonas premier reviews, excel, accounting, financial analysis, bookkeeping, microsoft excel, book format excel file, import excel file magento, import data excel file perl, import large excel file multiple worksheets

About the Employer:
( 0 reviews ) Danville, United States

Project ID: #15698128

Awarded to:

Harun1986

Hello, I am excel expert and I can make a useable excel that can follow automatically. I will follow your instruction and make exact macro what you want. Relevant Skills and Experience I have the best experience with More

$294 USD in 10 days
(173 Reviews)
6.4

13 freelancers are bidding on average $428 for this job

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En More

$705 USD in 5 days
(530 Reviews)
8.0
seaanddream

Hi, my name is Sevinc. I read your "Format Excel File for Jonas Construction Software AP Import" project descriptions carefully before bidding. I checked the attached templates as well... I got what you need and read More

$350 USD in 3 days
(264 Reviews)
7.5
someka

Hello. I have checked your raw data and import data. I have recently completed two quite similar projects. User enter parameters, clicks the button and macro makes the manipulation automatically and gives you a .CSV ou More

$345 USD in 7 days
(146 Reviews)
7.0
Vlzinch

Hi, JesterRU! I saw your requirements and I'm 100% confident that I can do this task. I have 10 years experience in Excel and VBA with hundreds of successfully completed projects. Relevant Skills and Experience I hav More

$500 USD in 5 days
(51 Reviews)
6.8
$588 USD in 5 days
(139 Reviews)
6.1
shoguna2m

Hello, my name is Andrés. First of all, thank you for considering my bid. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within this More

$350 USD in 7 days
(53 Reviews)
6.1
$260 USD in 10 days
(99 Reviews)
6.1
dgled

Hi, I have experience in transferring and manipulating accounting databases to [login to view URL] files and vice versa. Relevant Skills and Experience I am a professional financial and a guru in Excel and VBA. I create creat More

$750 USD in 10 days
(37 Reviews)
5.8
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications Relevant Skills and Experience Excel VBA More

$470 USD in 5 days
(62 Reviews)
5.8
vw7209238vw

Hi, I can develop the bridge you need to parse the needed data from the excel or csv file . Just need all material to start. Th csv as sample is not showing data Relevant Skills and Experience I have all skills you re More

$350 USD in 10 days
(30 Reviews)
5.0
vsprybhanu

Hi, I can format your excel file according to upload the file into software. I have excellent knowledge and experience of manipulating data and apply formatting through VBA programming. Relevant Skills and Experience More

$352 USD in 10 days
(72 Reviews)
5.3
nurnga1218

Hi, I don't have any idea with Jonas Construction Software but, if you provide your exact format to be imported (you already attached) well I can make it as you want. Relevant Skills and Experience I am an excel and m More

$250 USD in 3 days
(32 Reviews)
4.3