Find Jobs
Hire Freelancers

Write a small billing tool that can ingest two XLS files and output a CSV or XLS

$15-25 AUD / hour

Terminado
Publicado hace casi 7 años

$15-25 AUD / hour

I need a simple billing tool written that will do the below. I would prefer it written in something that can be easily updated such as Access but any solution that works is acceptable. It must run on Windows. - Once a month, I get a XLS pricelist from a vendor with less than 1000 subscription products in it, with a cost and RRP price. Each product has a unique SKU - Once a month, I also get a CSV billing output, which has a list of customers, subscriptions, qty and totals based on my cost price - The tool will merge the data as per below and output it as XLS or CSV The tool needs to be able to do the following once a month via a manual process: - ingest each months price list, and save it as the purchase and sell price for any subscriptions with a purchase date in that month (the purchase date is listed in every billing file, so it does not need to be recorded) - ingest and examine the "start date" of each months recon file, look up the appropriate buy price and sell price, and collate to an output that includes the cost AND sell price for each line item, and a total for each customer - provide a separate lookup table where we can manually put in an internal customer ID, PO for each customer that is output - generate an internal SKU from the vendor SKU (it's a simple modificaiton of the vendor SKU) - Ideally we should be able to record an over-ride Sell price for any customer, save that in the DB, and the tool reports the cost, RRP and Actual sell price for every customer Please provide estimates of initial build cost. Ongoing modifications will probably be required as the vendor changes file format from time to time.
ID del proyecto: 14495413

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
p.s. If u prefer to have it directly via Ms excel - sure I can do it also via Ms Excel , but more comfortable via Ms Access though Hi, I hope all's well with you. I see you're looking for a developer proficient in Ms Access/Excel . Really all my projects here I've developed for Ms Office/VB projects. In my view via Ms Access GUI with Ms Excel automation- will be a best solution for your current project. If so here you can read my introduction: I’m a ms Access/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel,Ms Word, VBA, ADO, SQL including projects for start-up companies and small [login to view URL] over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$16 AUD en 40 días
4,6 (59 comentarios)
6,2
6,2
15 freelancers están ofertando un promedio de $21 AUD /hora por este trabajo
Avatar del usuario
A proposal has not yet been provided
$16 AUD en 40 días
4,9 (377 comentarios)
8,1
8,1
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3).
$20 AUD en 40 días
4,9 (325 comentarios)
7,8
7,8
Avatar del usuario
Hi, I would like to suggest you a Microsoft Excel application which enables you to manage monthly billing in a spreadsheet. You can record the information by hand or by uploading files, into a master file with a possibility to review/update them in the excel. There is a search engine with high search capability. During the process, Excel validates the information prepares reports and export files based on parameters and criteria. There is a report generator which enables to develop templates independently. The system secured with usernames and passwords. The structured app managed by tables like a client list, a product catalog (with pictures), a set of bills of price, a primary database with the orders and it's status (delivered, invoiced, paid, etc.). Excel can send a customized catalog or/and a personalized order_form to each customer (by Microsoft Outlook). about me: I am a financial professional and guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.)
$22 AUD en 40 días
4,9 (91 comentarios)
7,2
7,2
Avatar del usuario
Hey Mate, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$22 AUD en 40 días
4,9 (183 comentarios)
6,6
6,6
Avatar del usuario
Hi there - I had a look at your excel sheets and CSV and I can develop this billing tool. please reply, we can discuss further and hopefully get it started soon. Thank you!
$20 AUD en 5 días
4,8 (166 comentarios)
5,9
5,9
Avatar del usuario
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can start working on the project immediately and complete the job within two, maybe three days. Regards
$15 AUD en 20 días
4,9 (64 comentarios)
5,7
5,7
Avatar del usuario
I can help you. My estimate of the financial cost of the project, as it has been raised so far, is approximately US$650. I am the right individual to help with your Access project. I am very good at designing database solutions and have worked extensively with user interface. You can see examples of my work in my freelancer profile. I like practical solutions; simple but covering all of the client's requirements. I work fast because I have a lot of experience in the field. I have more than 500 hours in training, certifying and lecturing personnel in all phases of Access. I have sent you a very affordable proposal. If you hire me you will not regret it. Please contact me. Thank you. Camilo
$18 AUD en 40 días
5,0 (4 comentarios)
4,2
4,2
Avatar del usuario
Dear , I'm a data engineer with many years experience using MS Excel / Access for data processing . Could help you on this project by using VBA code. Regards,
$24 AUD en 20 días
4,7 (14 comentarios)
3,9
3,9
Avatar del usuario
Hi, Im on vacation and will be free to work on your project. Proposed solution using Excel VBA with integrated GUI for your daily/monthly usage. Please contact for further consultation. Thank you.
$27 AUD en 20 días
5,0 (3 comentarios)
2,8
2,8
Avatar del usuario
Java architect/developer here with more than 16 years of experience. Thanks.
$24 AUD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am database developer with automation experience using xls/csv files I propose to work with you. Broadly my solution is 1. load csv/xls files into local mysql database 2. process as needed by requirements 3. output csv/xls file as needed (database mysql or any other tools needed will be installed.) If using xls files, either client to have (their own) MS office license or to use community tools like Libre/open office. All tools used in the development process are open source or license free GUI based development will be given priority. Full source code is delivered Expected effort 40 Hours Delivery in 10 working days. You have any queries or specific requirements, Please let me know. Regards Sankar
$25 AUD en 40 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Redfern, Australia
5,0
6
Forma de pago verificada
Miembro desde jun 29, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.