Excel VBA / Access on Accounting report

CLOSED
Bids
31
Avg Bid (USD)
$2465
Project Budget (USD)
$1500 - $3000

Project Description:
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 required:
Excel, Microsoft Access
Additional Files: Lead+shedule+linked+up.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 1666
in 30 days
Hire mrbrave
$ 1684
in 5 days
Hire winghei
$ 2222
in 20 days
$ 1666
in 30 days
Hire pkcyber
$ 20000
in 6 days
$ 2580
in 12 days
Hire FLtowhid
$ 1666
in 3 days
$ 1600
in 5 days
Hire sudewa
$ 2777
in 20 days
$ 1500
in 7 days