Closed

Excel VBA / Access on Accounting report - repost

Job Description

Our client, an accounting firm, is looking for an Microsoft Excel and Access developer with accounting background to provide semi-automation for their clients' reports. This involves trial balance, leadschedule and supplementary.

Requirements

- 2 types of categories

a) account categories – sheet1 and sheet2 (page 3 and 14)

b) asset/liability categories – sheet 2 (page 1 and 2)

- Automate trial balance report (sheet1), extracting data into leadschedule (sheet2).

- Extract data from supplementary (sheet3) based on exact keyword match with sheet2. Data will be auto-filled in sheet2.

- Every client has its own unique accounts # and categories.

- Grouping can be done locally on computer, before uploaded to database.

- Grouping of account # into different account categories.

- Grouping of account categories into different asset/liability categories.

This allows the grouping to be done automatically instead of having to manually key in the process all over again, when next accounting needs to be done. It needs to have the abilility to group new account # and save to the central database.

- Ability to set template for different account categories

Eg. Sheet 2

Row 68 – 75

Row 119 – 133

Row 171 – 182

Row 195 – 199

Row 230 – 236

Row 282 – 291

- Ability to extract grouping from central database within local network.

- Key validation – there should be a key validation that is valid for x month. The key file would be located locally in the staff computers/laptops. This key file would communicate daily at a certain timing or upon login of Windows. Should the key file not updated for more than x month, the staff would not be able to open up the excel files.

Please provide us your experience working in a similar capacity.

Skills: Excel, Microsoft Access

See more: login account excel, vba access developer, types of accounts in accounting, types of account in accounting, trial balance in accounting, trial balance accounting, on semi, microsoft excel job, microsoft excel group, microsoft access job, microsoft access database developer, looking for job at excel, liability in accounting, key auto group, excel vba developer job, excel vba developer, excel balance sheet template, exact staff, daily access, balance sheet in accounting, balance in accounting, accounting to trial balance, accounting it, accounting accounting, access group

About the Employer:
( 0 reviews ) United States

Project ID: #4647444

24 freelancers are bidding on average $2198 for this job

gshiels

I am a CIMA accountant with 20 years experience, very strong Excel/VBA skills, and great feedback. Please see PM

$1958 USD in 14 days
(10 Reviews)
5.1
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$1578 USD in 15 days
(18 Reviews)
5.0
srinichal

I like to discuss various aspects and take up the project

$2368 USD in 28 days
(3 Reviews)
4.6
FLtowhid

Please see my PM

$1666 USD in 25 days
(4 Reviews)
3.8
Aronvitki

I have over 10 years experience with all MS Office products and I guarantee my work. I also have my BS in Business Administration, so I'm familiar with financial statement preparation. I'm also known to go over and ab More

$1500 USD in 14 days
(6 Reviews)
3.6
sudewa

Hi, I am very keen to work on this project. Since your clients requirements are complex I think vba is not the best way to go. It has the following drawbacks. 1. Since vba is not a fully fledged computer language i More

$2500 USD in 20 days
(2 Reviews)
2.9
FATHY84

ready to take this opportunity

$2500 USD in 3 days
(0 Reviews)
0.0
qualifiedcoders

Hi We are interested in your project and read your [url removed, login to view] have completed 150+ big projects in last 5 years including complex processing in excel and Access. Please check private message board for details.

$2268 USD in 20 days
(0 Reviews)
0.0
mikelance

I am an IT professional with more then 10 years experience in MS Access database programming. So far I have made several MS Access applications in the field of sales, auto service, spare parts sales, markets, educatio More

$2222 USD in 15 days
(0 Reviews)
0.0
floridasitepu

I want this job

$2222 USD in 30 days
(0 Reviews)
0.0
Damayanti001

Experience in Global Market Over 5 Years. (Currently Provide Service in Australia, Newzeland, United Kingdom, United States of America, South Africa and United Arab Emirates) Experienced and Qualified Web Designer & More

$2500 USD in 7 days
(0 Reviews)
0.0
makhan786

check your pm

$2500 USD in 7 days
(0 Reviews)
0.0
CDServices

I've spent a least a decade with MS Access based assets management systems and prepare many reports and from your description output the interactive reports you describe.

$2500 USD in 5 days
(0 Reviews)
0.0
andriy3s

Hi sir, will be glad to help you with.

$3333 USD in 30 days
(0 Reviews)
1.4
mattc123sl

I have a very strong background in finance, working full time in a high level accounting position for 6 years, along with VB development. Reviewing T&B, reconciling G/L accounts. and automating EDI payables. I have mad More

$2200 USD in 16 days
(0 Reviews)
0.0
EGordonMacon

I've worked as a finance analyst for nearly two decades and as Finance Controller for the past 8 years. I have years of experience automating Excel reports and codifying data sets as pulled from various local data / a More

$2000 USD in 7 days
(0 Reviews)
0.0
zylady

I do this for living. I have been a CPA for over ten years. I will deliver in a timely manner.

$1611 USD in 3 days
(0 Reviews)
0.0
NovaUMD

Hello! I worked as a financial statement developer on my last project. I have strong background on accounting and finance and also the experience creating financial report in high quality. Confident and trustworthy, I More

$1666 USD in 5 days
(0 Reviews)
0.0
ddraganvw

Ok, ready...

$2500 USD in 10 days
(0 Reviews)
0.0
nagarajm

Quality work at best price

$2222 USD in 7 days
(0 Reviews)
0.0