Please help to create accounting sheet.

Good time of the day.

I need to create a relatively simple sheet to aid my simple accounting needs at work. However I couldn't figure out myself how to do it. I hope it is even possible to do at all.

I have 2 tabs. One tab with invoices and another tab with purchase orders (budget).

For example on project order tab I have 3 purchase orders with budgets:
PO00001 - �1000
PO00002 - �1000
PO00003 - X1000

On invoice tab I need to enter new invoice and in column with purchase order I need to see all those 3 POs above. When I choose for example PO00001 it start co correspond to PO00001 in Purchase orders tab.
If my invoice is �300 the line with PO00001 in purchase order tab automatically see that and minus from total budget of �1000 and show that on PO00001 I have �700 left.

The list should be dynamic as purchase orders added to tab constantly.

sorry for messy explanation and thank you for your help.

Aleks

Accounts Follow Up List 2024.xlsx

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Where you have provided a workbook solution, please also include a clear explanation of what you've done and how (including formulae/code as approriate) in the post in question (for the benefit of members unable to download attachments).

This is about making your assistance accessible to all.

Thanks.

@thomglea

Please read post #4.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.