To create an Excel 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 open automatically.
Menu 1 will select client name or add "enter new name" option.
Menu 2 will contain 12months 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 2 entries Date( just the numeric date of the month***example January 3rd= "3" or just 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 will automatically open for selection of Payee name and account number ( this oversized menu displays a list ot payees and payee accounts which were posted in previous month, or if this is the initial check register an entry line for new payee name and account to be charged for this [login to view URL] each entry into the menus, each row will confirm the information entered or selected in each menu. After posting the ending check number,
Menu 6 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).
Application will automatically save entire check register on "C:\Acctg\(client named in menu1\2012\ period mentioned in menu 2
+"cks"****Example="C;\Acctg\Boynton\2012\Jancks"
I have nine years experience of a public organization where are reports are prepared & maintained records in MS Excel
Make sure that I will perform this project timely and efficiently.