Need formula in Excell
3093
$$
- Posted:
- Proposals: 0
- Remote
- #923558
- Archived
Description
Experience Level: Intermediate
Hi to all
i have three templates :
1) to track pending and paied invoices
2)another one for "fix costs" ( For fix costs i'm referring to costs that do not change a lot during the month Example : telephone costs ,Office rent etc...)
3)another one for vat return
What i need is :
A) Linked 1 and 2 template in order to forecast my liquidity over a specific period
What i usualy do is : Invoices sent +cash payments from customers - (invoice received - expenses- fix costs) = Liquidity over determinated period
B) linked 1 and 3 (when I insert data in 1 I need that appear also on the 3, otherwise I'll have to manually insert again all datas to calculate vat balance
Thanks,
Regards
i have three templates :
1) to track pending and paied invoices
2)another one for "fix costs" ( For fix costs i'm referring to costs that do not change a lot during the month Example : telephone costs ,Office rent etc...)
3)another one for vat return
What i need is :
A) Linked 1 and 2 template in order to forecast my liquidity over a specific period
What i usualy do is : Invoices sent +cash payments from customers - (invoice received - expenses- fix costs) = Liquidity over determinated period
B) linked 1 and 3 (when I insert data in 1 I need that appear also on the 3, otherwise I'll have to manually insert again all datas to calculate vat balance
Thanks,
Regards
Roberto I.
98% (8)Projects Completed
13
Freelancers worked with
12
Projects awarded
37%
Last project
14 Nov 2021
Italy
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies