Closed

EXCEL CHECKS

To create a check register/disbursement journal to detail and summarize checks written for a fixed period. Strong knowledge of Excel programming required. Everything will be done by user with numeric keypad and enter key entering all information in drop down menus which will all open automatically.

Menu 1 will select client name or add "enter new name" option.

Menu 2 will contain individual 12 months or enter "add new custom period" option.

Menu 3 will have 2 entry lines for entering check numbers, "Beginning Ck". and "Ending Ck"******at this point column 1 of worksheet will display series of check numbers from Beginning # to Ending #.

Menu 4 will automatically open for each check (following completion of menu 5 ), it has 2 entries, Date, ( just the numeric date of the month***example January 3rd= "3" or simply use the enter key to remain the same day date number as the previous check), Amount, enter the amount of the check, ****no decimal points entered, program will automatically multiply amount by 1% to realize the cents

Menu 5 is for selection of Payee name and account number ( this oversized menu displays a list ot payees and account number used in posting the previous month's checks, or, if this is the initial check register or a new payee name or a new account combination to be charged for this check. Completion of this check will update the appopriate row for that check identified in column 1.. THRUOUT THE ENTIRE ENTRY PROCESS OF CHECKS, -9 WILL BE USED TO CORRECT TO PREVIOUS MENU [url removed, login to view] WILL RESUME AND RETURN TO THE ENTRY PROCESS FOR THIS CHECK. IT WILL ALWAYS RETURN TO A NEW BLANK MENU 4 FOR RE-ENTERING THIS CHECK.INFORMATION. IT WILL ALSO BLANK ANY INFORMATION DISPLAYED FOR THE ROW OF THAT CHECK.

After posting the final check :

Menu 6 will pop up offering a selection for "Print and Save Checks for Period"

Menu 7 will offer "Print Check Register"( listing of all checks posted in ck number order) and "Print Disbursements Journal"( which will be a listing of checks by account charged).

NOTE: FORMAT FOR CHECK REGISTER OR DISBURSEMENT JOURNAL FILE ATTACHED

Skills: Accounting, Excel, Visual Basic

See more: checks excel, worksheet in accounting, Update resume, the month of january, same day resume, programming in excel, programming for excel, posting in accounting, month of january, list of accounting entries, key selection, january is the month of, january is month, for the month of january, excel c# programming, excel add in programming, example resume, custom number format in excel, custom list in excel, custom excel programming, combination resume, ck 12, account numbers in accounting, accounting resume, accounting name

About the Employer:
( 14 reviews ) boynton beach, United States

Project ID: #1304328

31 freelancers are bidding on average $164 for this job

schandraram

Hello - Thank you for the invite. I am submitting my detailed bid via PMB. Regards. Chandra Ram

$250 USD in 10 days
(86 Reviews)
6.4
koolsidz

Excel Whiz here ;) Please see PMB for more details

$180 USD in 2 days
(125 Reviews)
6.0
Krusche

Hello. We are a German Company with 2 dedicated specialists in MS Office applications based on the VBA programming. Please check your PMB

$240 USD in 4 days
(30 Reviews)
5.7
gshiels

Please see PM

$250 USD in 5 days
(12 Reviews)
5.1
chriskerpini

Please check your PMB.

$160 USD in 5 days
(17 Reviews)
4.6
kulhanekd

I have 15 years exp in Excel. I would like to bid on your Porject. Thanks Donna

$150 USD in 5 days
(12 Reviews)
4.6
mars8246

Hello, Sir. I am a specialized excel and office programmer with experiences of over 8 years. I will work on your project asap. I send you my some previous demos. Thanks Best regards.

$150 USD in 3 days
(2 Reviews)
4.0
FLtowhid

I am a professional accountant having an experience of working with some of the world's renowned organizations for last 8 years. Currently I work as an international staff member with world's one of the most prestigiou More

$100 USD in 7 days
(4 Reviews)
3.8
guevanjr

Please consider my bid.

$90 USD in 2 days
(4 Reviews)
2.4
sumshank

Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of More

$200 USD in 10 days
(3 Reviews)
2.4
ma7oda

Hello sir, ready to start right now.

$70 USD in 2 days
(4 Reviews)
2.3
MonicaVBA

I am an expert Excel, VBA developer with more than 10 years of experience building similar applications. I have designed and built many Excel applications that have user forms as interfaces where users enter/view data. More

$250 USD in 5 days
(0 Reviews)
0.0
elkunzhe

I am accounting supervisor and I have more than average skills in excel application. I have created petty cash reporting using excel programming: user can pick expenses that available in the combo box and for printing More

$150 USD in 12 days
(0 Reviews)
0.0
borakinfo

Hi: I've 10+ years of software development experience on Visual Basic, SQL Server, Access, Crystal Report on windows platform. I've developed ERP software as well. I'm flexible to work with you. Plz allow me... ARIF

$120 USD in 30 days
(0 Reviews)
0.0
AmbreenAhmed

i have understood your requirements, I am deft in excel programming. I have seen the assignment and can do it easily. I can start the work immediately. You can rest assured of the quality of deliverables. Looking forwa More

$180 USD in 7 days
(0 Reviews)
0.0
Reyati

please send more details

$120 USD in 5 days
(0 Reviews)
0.0
NazirN

I have an associate degree in IT and a certificate in Business accounting. My typing skills are excellent and i believe in good work ethics.. I am sure working with me would be a pleasure.. looking forward..I accept pa More

$60 USD in 3 days
(0 Reviews)
0.0
delowardidar

Hi, I am an accounts executive at a well known limited company in Bangladesh & I also have good knowledge in visual basic & excel spreed sheet. I can complete your project carefully properly. Thanks & bye.

$250 USD in 30 days
(0 Reviews)
0.0
Niribily

hi, i am very good in excel

$250 USD in 15 days
(0 Reviews)
0.0
extraincome

Sir, I can do the job. Hope your will provide me an chance to serve and satisfy you. Looking forward for positive response from your end.

$100 USD in 5 days
(0 Reviews)
0.0