| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | powered by | ||||||||
2 | FUEL | Payment calendar is a tool for planning the movement of money through accounts and balances. Allows you to see cash gaps in advance. | |||||||
3 | |||||||||
4 | File structure: | ||||||||
5 | Planning tab. All scheduled transactions are entered there and then a payment calendar is built based on them. It is obligatory to fill in all the columns, except for the status (if it is empty, transaction wasn't paid) In the heading of each column there is a note with a hint as to what and how to enter. Use the filter to find the transactions you want | ||||||||
6 | |||||||||
7 | Payment calendar tab – a payment calendar is collected from all planned transactions. Only transactions with status "paid" are uploaded. The balance is also displayed. By the remaining balance, you can see where it is in the negative. Also, occasionally, it is necessary to manually set the actual balances of funds on the accounts instead of the calculated ones. | ||||||||
8 | |||||||||
9 | Handbook tab – initial setup – a list of all categories of income and expenses, as well as accounts that will be further used | ||||||||
10 | |||||||||
11 | Start of work: | ||||||||
12 | 1. Add to the Handbook tab all accounts through which money will move and all categories of income and expenses | ||||||||
13 | 2. On the Payment calendar tab, arrange all categories of income and expenses so that the amounts for them will be ulpoaded. | ||||||||
14 | 3. Enter the starting account balances in the balance lines and the total balance | ||||||||
15 | Everything is ready and you can fill in planned transactions | ||||||||
16 | |||||||||
17 | |||||||||