Need an excel program developed that will convert an exported class report from Quickbooks (excel format) and generate a report. The attached file is a sample, and should be used to generate the program.
Every month, I will update the "QB Class Report" sheet with a new import from Quickbooks. Which should automatically update the Functional Expense Report Sheet.
Below is the programming mapping needed between the QB Class Report Sheet and Functional Expense Report Sheet:
Class Report Sheet = Functional Expense Report Sheet
0100 = Seminars & Lectures
0145 = Seminars & Lectures
0146 = Seminars & Lectures
0160 = Seminars & Lectures
1000 = Seminars & Lectures
1001 = Seminars & Lectures
1002 = Seminars & Lectures
1003 = Seminars & Lectures
1004 = Seminars & Lectures
1005 = Seminars & Lectures
1006 = Seminars & Lectures
1015 = Seminars & Lectures
1020 = Seminars & Lectures
1021 = Seminars & Lectures
1022 = Seminars & Lectures
1023 = Seminars & Lectures
1024 = Seminars & Lectures
1025 = Seminars & Lectures
1030 = Seminars & Lectures
1031 = Seminars & Lectures
1032 = Seminars & Lectures
1037 = Seminars & Lectures
1040 = Seminars & Lectures
0400 = Books & Publications
0200 = Books & Publications
0410 = Books & Publications
0415 = Books & Publications
0420 = Books & Publications
0430 = Books & Publications
0700 = Website Outreach
0500 = Fund Raising/Development
0800 - Management & General
*Please note that 0001, 0600, and 0820 need to be allocated according to the allocation schedule sheet.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
All windows environments. It needs to be programmed in excel 2003.