I need a finance report template in Excel

Hi there

PLEASE DO NOT SEND A PROPOSAL IF YOU HAVE NO EXCEL OR FINANCE EXPERIENCE,

I need someone who can create an automated excel spreadsheet.

I have 6 budget codes and i need to keep track of Purchase order numbers that are raised against the budget and also the invoices that i have processed against each PO.

I do not need a function for incoming funds as this is only for outgoings.

I need the spreadsheet to produce reports graphs. i.e I need a pivot table for POs raised (expected spend) and another for invoices processed (actuals). I have attached an example.

Any time i raise an invoice against a PO number i would like the PO number to update with the remaining balance.

I would like the budget codes to be dropdown lists and would like to invoices and po's to be on seperate tabs.

I also need a function to add new rows that will automatically keep the format of the formulas for example an 'add row' button if this is possible.

I'm not sure what something like this will cost so please put your fee.

If you have the skills to be able to do this please do send a proposal.

Happy to discuss the project in more detail.

Please type: STLUCIA in your proposal so i know you have read the full description.

Thanks