Automate creating expenses report

Closed

General:

The system should be able to help me filling a table of my receipts by automatically reading the date from a scanned photo then extract date & amount.

I have a OneNote table with the following columns:

• Number (from 1 to 30)

• Image (will be taken from my mobile)

• Date (should be on dd-MMM)

• Amount (decimal number)

• Type (Food, Taxi or others)

• Currency

• Transfer rate at that day (From Current currency to Jordan Dinar)

• Processed by script (Yes/No)

The solution needs to be a powershell script (or a macro that is called by power shell script)

This script should check a certain page on onenote notebook, then iterates through the table rows that has an images without date, amount and transfer rate in the same row; take the photo and send it to OCR service; get the date & receipt value and write it down into Date & Amount cells; then set the "processed by scrip" to "Yes"

Secondly, you have to send the amount to a services that get the transfer rate (From the current country to Jordan Dinar JOD)

Optional:

Fill the type of the receipt (food or taxi)

How to spot the page?

The page will be placed in a pre-defined section in the onenote, and the title will have a certain format

OCR:

It is preferable to be free of charge service, but will accept with some payment if it is ok

Validation:

• The date should be within the range of the date provided by title

OCR, powershell, OneNote, Macros, VB

Two feedback iterations can happen as more cases will appear after delivering the first version of the script.

Please find the attachment that has an empty, half filled & filled OneNote page.

Skills: Microsoft Office, Powershell, Visual Basic

See more: how can i find medical physician that can write an professional medical report in the veterans affairs language, fill state dropdown selected country dropdown html asp net control, fill dropdown states selected country php mysql ajax, fill combo state ajax country php, creating search autotrader type search, creating custom product type zencart, creating custom field type sharepoint, automate captcha type submissions, creating custom group type elgg, software write mq4, software write chip epson, useful software write book, software write web specs, creating modules content type drupal, ajax fill type, free software write user guide, software write edid, free software write company profile, software write websites idea, creating mafia wars type game, software write book images, software write books, sharepoint creating custom field type project, software write protection, free software write book

Project ID: #13471909

11 freelancers are bidding on average $126 for this job

$155 USD in 3 days
(115 Reviews)
7.1
$250 USD in 2 days
(49 Reviews)
5.8
lillysoft

Sir i am really interested in your project . sir i am an expert of software and web development. i have already developed many web and windows applications and some are similar to your project . you can check my portfo More

$133 USD in 1 day
(10 Reviews)
4.4
axiomswb

We have expertise in VBA.Our main motto is to provide client satisfaction for long term relationship.

$100 USD in 1 day
(4 Reviews)
2.9
iqmax99

Hello This bid is to suggest for you a far much better solution that what is proposed that costs zero for 3 users. The solution is web based and is in use today by thousands of people. If you have more than 3 people, More

$30 USD in 3 days
(9 Reviews)
2.8
softsolution1991

### Exact Taxi booking website and application already developed ### Hello sir, We have gone through with your initial requirement and understood that you need to create a taxi app which we have already developed a More

$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
reverential

REST web services based apps + E-commerce apps like Magento, Woocommerce based + Social Networking apps, Geo-Locations based apps, Classifieds apps, + Social Media APIs - FACEBOOK API, TWITTER API, GOOGLE+ API, FLICKR More

$155 USD in 3 days
(0 Reviews)
0.0
rainstreamweb

Automate-creating-expenses-report Hello, This is not copy/paste message. I read your requirements. I am interested for this job. I have expertise in Wordpress, Laravel, Magento, AngularJS, Ruby on Rails, Core More

$155 USD in 3 days
(0 Reviews)
0.0
fearlessduck0

I am an experienced engineer/economist who is highly proficient in data entry, data management and data analysis. I've also written many Excel based programs in the workplace using VBA. Being a respected member of t More

$66 USD in 3 days
(0 Reviews)
0.0
technologicsols

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have More

$200 USD in 6 days
(0 Reviews)
0.0
quickwriter24

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, S More

$30 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0