Excel VBA / Access on Accounting report

Closed

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: excel vba report, vba excel access reports, excel access accounting, 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

Project ID: #4645431

28 freelancers are bidding on average $2526 for this job

illuminesoft

We can have MS Access as front-end and MS Access OR SQL Server or My SQL as back-end. We have created accounting software for business, trust and few other types. We are amongst top 1% global outsourcing providers. More

$1666 USD in 30 days
(238 Reviews)
7.4
mrbrave

Excel/Access/VBA expert with great experience here....I can help you in this project.Lets start off and get it done fast.

$1684 USD in 5 days
(84 Reviews)
5.5
winghei

Hi, I see your needs and I want to help. I'm a CPA and an expert DB Developer.

$2222 USD in 20 days
(29 Reviews)
5.3
MDavidCrompton

I have been working on custom Excel applications for 20 years, recently on Freelancer, please see feedback. I run my own company and prepare all my own accounts wothin Excel. Apologies for the 30 days but I have 2 week More

$1666 USD in 30 days
(23 Reviews)
5.2
pkcyber

Hi, Reporting Expert here, see your PMB, link of previous project related to this and more detail of your project

$20000 USD in 6 days
(17 Reviews)
5.1
xazoo

Consider it done, professionally. Thanks!

$2580 USD in 12 days
(21 Reviews)
4.5
FLtowhid

please see my PM.

$1666 USD in 3 days
(4 Reviews)
3.8
SoftwareEng8876

Hello sir...i am very much interested in this project.i have to do my best to get good positive feedback from you.you can believe to get good results from me.just give me one chance to prove. Thank u!

$1600 USD in 5 days
(2 Reviews)
3.0
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 it is More

$2777 USD in 20 days
(2 Reviews)
2.9
ankurb43

I can do this. Please check my solution in your inbox.

$1500 USD in 7 days
(1 Review)
2.8
Evs1

***We exist in world's Top 10 Virtual Assistant & Data Entry Companies*** Please check PMB for complete details.

$1855 USD in 15 days
(3 Reviews)
2.7
domenicoF79

I'm +10 VBA/excel expert. I manage excel, access and other developer languages. I can provide you with efficiency and professionalism.

$1700 USD in 7 days
(1 Review)
0.0
nehaarora11

Hello Sir, We work in a team.We are free these days and can give all time to your project.

$1667 USD in 7 days
(0 Reviews)
0.0
BIQed

I have over 5 years experience in Excel VBA, Access, and Accounting and many more years in other more advanced IT / BI / DW areas. BIQed.com

$2777 USD in 7 days
(0 Reviews)
0.0
amykerwin

I would like to be considered for the job. Efficient in EXCEL Spreadsheets and Access.

$1511 USD in 3 days
(0 Reviews)
0.0
svuletic

Extensive experience and skills with VBA, MS Access, Excel and accounting

$2000 USD in 3 days
(0 Reviews)
0.0
Leparfait13

Hi, I have been working on Excel and Access applications for many years with efficiency and professionalism. I am very keen to work and really interested on this project. So, ready to give to you my best service on tim More

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

I can do it for you...

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

Hi We are interested in your project and read your requirements.We have completed 150+ big projects in last 5 years including complex processing in excel and Access. Please check private message board for details.

$2577 USD in 22 days
(0 Reviews)
0.0
gabi19

I can do this project in excel or access.

$1500 USD in 5 days
(0 Reviews)
0.0