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
31 freelancers are bidding on average $164 for this job
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.
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
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.