Excel/VBA - Fund Accounting/PO processing

Make the attached file into a stand alone Fund Accounting / Purchase Order Tracking file.

Here on the opening screen I need to be able to enter Budget codes. The format for the coded is

Fund.Function.Object-Subobject-Organization-Financial Year-PrI-Discretionary1-Discretionary2

Ex. 199.11.6399.85-002-2-11-0-00

All of my funds are the 199 fund, but I use different functions, objects, etc. So I would need to be able to enter the account code, and what I have budgeted for that code. The way I have it now, I have to go in and manually change everything each year. This is slow.

Once I have the accounts set up, I need to be able to enter purchases for each code. You can select a tab to see a transaction sheet.

This is REALLY inefficient. What I need to be able to do is assign each transaction a PO number and be able to track spending with the PO numbers.

Also, I want to be able to enter Vendors and hopefully have them stored somewhere so I can just select the vendor when doing the transaction. Entering the Vendor name, address, phone and fax would be great.

Basically, I am looking for a simple Fund Accounting program so I can be more efficient with my budget.

Please contact me if you need/want more info.

David Applegate

[url removed, login to view]

Must haves:

(need a basic understanding of Fund Accounting and Purchase orders to complete job)

Able to enter the Fund Codes and Change them each year

Able to enter the budgeted ammount for each code.

Description for each Object and full code.

Transfer funds between codes.

Enter Individual transactions for each fund.

Track Purchase order numbers for each transaction.

Track the transaction process, ie, Requisition, Encumbered, Expended, accrued.

Be able to enter several transactions per Purchase Order.

Keep track of Open(Standing) POs and transactions within.

Maybe something else I havent thought of.

Compétences : Excel, Visual Basic pour les apps

en voir plus : excel fund accounting, fund accounting excel, vba fund accounting, purchase order excel basic accounting, what financial accounting, vba with, my accounting, functions in excel vba code, format pri, account numbers in accounting, accounting see, accounting pos, accounting name, accounting it, accounting accounting, excel vba budget accounting, excel vba purchase order accounting, fund accounting job, what is vba in excel, what is vba, what is financial accounting, what is a po number, vba codes, me vba, excel vba with

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #2362716

11 freelance font une offre moyenne de $407 pour ce travail


Consider it done. Check your PM for my bid details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(49 Commentaires)

Our team of 3 VBA developers possesses the key skills needed for this project. Please check your PMB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(21 Commentaires)

Hi there! Nice project, sounds interesting to me. Let me collaborate.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(15 Commentaires)

Hi. I'm really interested in your project.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(9 Commentaires)

Hi David, I am interested in developing the sheet for you. Please check PM. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(10 Commentaires)

Hi, I am willing and ready to take this interesting project and can start immediately. I can give my best quality and output to the project. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(2 Commentaires)

Hi, I have worked on an Excel Purchase Order validation tool using Vba scripts without any form. That is, I find it a lot more flexible if everything (controls, entry fields...) is located onto the worksheets. I fin Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(5 Commentaires)

Dear Buyer, We are highly interested to work on your project , please send the full project details so that we can provide you the delivery time and cost. We have very vast and good knowledge of visual basic , .n Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)

Hi Iam expert vba developer using various office pplications including excel, word, access, powerpoint, etc. I can develop the solution as required by you with very intuitive and user friendly interface. Iam also a B Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

Dear Sir / Madam, With reference to your job posting at Freelancer.com, I would like to offer my services as Freelance Excel / Access VBA Programmer. I am working as a Freelance Excel / Access Programmer for last 5 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)

Hi I understood your requirement and I can do this very efficiently and effectively. I have the expertise in the skills required for this project about 4 years. And having good typing speed with 100% accuracy. I assur Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)