Urgent Help Needed for MS Excel Database
Budget: $30 – $250 USD
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features.
1- A list of all invoices (Master List).
2- A list of all Contracts.
3- A list of all Purchase Orders.
4- A list of Approvers who is approving the invoices.
5- A list of Accounts.
5- All of these list should be linked with each other.
There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database.
For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add the Contract/PO ID, from the dropdown list. The dropdown list should be searchable to easily find a contract/po. Once the invoice processed it invoice should be shown in the master list and also in the Contract/PO list under it's elated contract or PO. To make it clear, when I go to the Contracts/PO list and when I open a specific Contract/PO I should also be able to see all of the invoices related to that Contract/PO. Also, the amount of the invoice should be deducted from the FundRemaining of the contract. Same if it’s a PO invoice.
Also I should be process invoice if they are not related to a Contract/PO as well.
As I mentioned, there should be an Approvers list, and when I am entering an invoice into database, I need a field to select the name of the person who approved the invoice. And when I go to the Approvers list, and click on a person name, all of the approved invoices by that person should be shown under their name/page.
For Account Number, it should also be drop down list in the Add Invoice page, and searchable to easily find an account. Same with Accounts List page, when I open a specific account, I want to see all of the invoices and summary (total spend, monthly and yearly), related to that account.
For accounts, when processing an invoice, the amount of invoice should be deducted from the that specific amount. Exp, if the invoice is Office Supplies account, the amount of the invoice should deduct from the available amount in the Office Supplies account.
Of course, there should be a report page, yearly and monthly. I need to know for a specific contract how many invoices processed during that month/year. And same for approvers list.
For those invoices that is not a Contract/Po, I just need a report monthly and yearly.
I am happy to discuss these features more in details. If you at least have an idea exactly what I want, please reply with "inv log" word when messaging.
Automatic replies will not be considered.
1- A list of all invoices (Master List).
2- A list of all Contracts.
3- A list of all Purchase Orders.
4- A list of Approvers who is approving the invoices.
5- A list of Accounts.
5- All of these list should be linked with each other.
There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database.
For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add the Contract/PO ID, from the dropdown list. The dropdown list should be searchable to easily find a contract/po. Once the invoice processed it invoice should be shown in the master list and also in the Contract/PO list under it's elated contract or PO. To make it clear, when I go to the Contracts/PO list and when I open a specific Contract/PO I should also be able to see all of the invoices related to that Contract/PO. Also, the amount of the invoice should be deducted from the FundRemaining of the contract. Same if it’s a PO invoice.
Also I should be process invoice if they are not related to a Contract/PO as well.
As I mentioned, there should be an Approvers list, and when I am entering an invoice into database, I need a field to select the name of the person who approved the invoice. And when I go to the Approvers list, and click on a person name, all of the approved invoices by that person should be shown under their name/page.
For Account Number, it should also be drop down list in the Add Invoice page, and searchable to easily find an account. Same with Accounts List page, when I open a specific account, I want to see all of the invoices and summary (total spend, monthly and yearly), related to that account.
For accounts, when processing an invoice, the amount of invoice should be deducted from the that specific amount. Exp, if the invoice is Office Supplies account, the amount of the invoice should deduct from the available amount in the Office Supplies account.
Of course, there should be a report page, yearly and monthly. I need to know for a specific contract how many invoices processed during that month/year. And same for approvers list.
For those invoices that is not a Contract/Po, I just need a report monthly and yearly.
I am happy to discuss these features more in details. If you at least have an idea exactly what I want, please reply with "inv log" word when messaging.
Automatic replies will not be considered.