Đang Thực Hiện

153770 Invoice Generator in Excel

The description of the project is a synopsis of the total project. More details will be given to the qualified bidder.

Please post details of how you can assist in completing project. Do Not post general company information as I am looking for specific information on how you or your company will accomplish fulfilling the requirements of this project. I am looking for a fast turnaround and someone experienced in creating accounting programs & scripts as well as someone skilled in formulas and algorithms and using those formulas in scripts to create the desired result for the customer. Successful completion of this project will result in another project immediately following completion and more work down the road.

Must be available via instant messenger and available for me to call by phone for clarification


a. Randomly select a customer from a list

b. Auto generate 2 invoices per customer by randomly selecting products or service items from a list and arrange the data in a pre-designed excel template (All invoice fields must be populated)

c. Auto generate 2 payments per invoice in an separate pre-designed excel template each invoice being paid within a specific range of days as to satisfy invoice amount & invoice balance percentages (program must have an imput area for specifying % of Invoice amount to invoice balance(ie. 10% will have an invoice amount from 20,000 -25,000 and a balance owed less than 5% of that amount - and the script will randomly choose the amounts and the customers to apply this too, but it will fall within those ranges), % of product and service categories

d. Ability to select certain companies for manual data manipulation

e. Program will randomly select data but must allow program to specify % of Invoice amount to invoice balance, % of product and service categories

f. Create additional payment terms in customer categories: Anticipate, Discount, Discount- Prompt, Prompt, Prompt-Slow, etc.

g. %'s of Termed customers: Anticipate, Discount, Prompt, Slow etc

h. Benfords law used to prevent duplicate data from being used

i. Rule to disallow any whole dollar amounts

j. Only actual credit limits can possess whole dollar amounts

Kĩ năng: Bất kì công việc gì, Thiết lập Bản thảo

Xem nhiều hơn: invoice generator, program algorithms, product list excel template, looking for duplicate data in excel, list of accounting programs, information in accounting, how to do algorithms, how to create algorithms, how to create accounting, how do algorithms work, excel 16, dollar days, do anything for a dollar, description of product or service, customer data excel template, company invoice template excel, balance in accounting, anything for a dollar, algorithms-programs, algorithms programs, less than excel, excel less than, terms used in accounting, invoice template in excel, invoice generator excel

Về Bên Thuê:
( 9 nhận xét )

ID dự án: #1899953