Fermé

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

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 ont fait une offre moyenne de 407 $ pour ce travail

Teloquence

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

500 $ USD en 5 jours
(49 Commentaires)
5.2
Krusche

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

720 $ USD en 5 jours
(21 Commentaires)
5.1
selopezr

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

300 $ USD en 5 jours
(15 Commentaires)
4.2
jaimecruz

Hi. I'm really interested in your project.

350 $ USD en 4 jours
(9 Commentaires)
4.2
Engineer85

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

360 $ USD en 3 jours
(10 Commentaires)
4.2
Creativitydoesit

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.

300 $ USD en 5 jours
(2 Commentaires)
2.2
bpascal123

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

300 $ USD en 6 jours
(5 Commentaires)
2.0
btslx

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

400 $ USD en 10 jours
(0 Commentaires)
0.0
mraccess

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

250 $ USD en 15 jours
(0 Commentaires)
0.0
ahmed4xl

Dear Sir / Madam, With reference to your job posting at [url removed, login to view], 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

400 $ USD en 6 jours
(0 Commentaires)
0.0
bilalaa654

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

600 $ USD en 20 jours
(0 Commentaires)
0.0