In Progress

Check Journal

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 [url removed, login to view] 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"

Skills: Accounting, Excel, Visual Basic

See more: check journal, worksheet accounting, posting accounting, line accounting, list accounts accounting, list accounting entries, key selection, january month, month january, excel add programming, custom list excel, custom excel programming, account numbers accounting, accounting name, print menus, print knowledge, written list excel, numeric, journal, create excel worksheet, ck, check, accounting program example, visual basic accounts, excel accounting worksheet

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

Project ID: #1302744

5 freelancers are bidding on average $50 for this job

Lodhikhan

i can do it but also need some format for jounals and print

$50 USD in 3 days
(0 Reviews)
0.0
umerfaruq

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.

$40 USD in 5 days
(0 Reviews)
0.0
ashishchry

I am Ca Final Student. I am intrested in this project,and i am sure that you be satisfied with my work and accuracy. Thank you.

$50 USD in 2 days
(0 Reviews)
0.0
abucejo

Dear Sir/Madam, I have an experienced in this kind of program. But that was General Accounting. I can do this job. Pick me.

$60 USD in 7 days
(0 Reviews)
0.0
GustavoTerrell

Do you want something like Microsoft Money? I have a large experience with Excel and VBA (Visual Basic for Applications)

$50 USD in 4 days
(0 Reviews)
0.0