ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
BASIC INFO
2
Date & Version2019-04-14, v. 0.1
3
AuthorAntosha V. Trantin (anton@yorso.com)
4
Disclaimer0. All number are a complete fool and taken out of the head of the author just for example purposes
1. No responsibilities are taken by the author for any mistakes in the calculations: feel free to copy, pase, redistribute, modify, etc.
2. Everything is on your own risk
3. All currency conversions are approximate but not real: in real cases it doesn't need to have the best precision for decision making process
5
HOW TO FOR DUMMIES
6
SETTINGSThe starting tab, one must put the operational accounts, expenditure and revenue categories; the "Other cash flows" categories are used for transferring money between accounts and cross-currency convertation (in both cases category CONVERTATION is used);
The account MUST contain the currency in the name, supported currencies are EUR, USD, RUB
7
EXPENDITUREThe tab contains information about your expenditures, where:
- "COLUMN A" - is a date of the operation, must go in the format "YYYY-MM-DD"
- "COLUMN B" - the amount of spendings in the currency of the account
- "COLUMN C" - the account is used to spend the amount of money from column B
- "COLUMN D" - the category for expenditure, the list is provided by "SETTINGS" tab
- "COLUMN E" - just a comment/description of the operation
- COLUMN F - COLUMN L - additional columns to be used for cross-currency calculations
8
REVENUEThe tab contains information about your revenues, column meanings are the same as for EXPENDITURE but the "COLUMN B" is only about incomes from different sources

P.S. Some "zanudas" will tell me that "Investments" are not "Revenue" but I DON'T CARE, the reason for this document is to know the real money flow in convenient way but not for government reports
9
OTHER CASH FLOWSThe tab contains other cash flow operations, such as:
- CONVERTATION - when money are transfered between different accounts or converted from USD to RUB or other
- CREDIT TAKEN/RETURNED - when money are spent by someone or there is a debt to someone (for instance, when I spend money from my bank card for the flights in advance, the company owes me this money and they are put into CREDIT)
- DEBT GIVEN/RETURNED - when money are expected by someone to be paid (for instance, when we completed the trading and the company owes us money, i.e. it is a booked revenue)
10
SUMMARYJust a full information about revenues, expenditures, debts and credits, account balances;

!!!!The important inforation!!! - all debts and credits are added manually since the names of the creditors have infitine combinations
11
WEEKLY SUMMARYAn example of how this information can be summarized and put into weekly summary to have the report to someone; multy currency is used
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100