ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DatePriceWhatRatingPayment / From
To / Manufacturer
StoreCategoryComments1Comments2
2
2020-Jan-01$1,000.00
Enter income as positive amounts; e.g. funding the savings account with cash
ALISUSD
alliantcreditunion.org
income
3
2020-Jan-03-$23.50enter expenses as negative amounts90%AMAZHoward Leight
amazon.com/Howard-Leight-MAX-1-Uncorded-Earplugs/dp/B0013A0C0Y
healthBlocks more white noise than Mack's
4
5
2020-Feb-01-$23.50paid AMAZon credit card; hover over the cell to see the noteALISAMAZCCpay
6
2020-Feb-07-$3.56Example of entering a groups of purchases in a foreign currency, ...CAPIgroceriesEnter prices in the foreign currency in col. J -->-R$12.00
7
-$3.50... such as the highlights from a grocery billCAPIgroceriesEnter prices in the foreign currency in col. J -->-R$11.80
8
-$1.19
<-- fixed formula in col. B calculates the price in the base currency (e.g. USD)
CAPIfunEnter the total in the base currency in the last I cell of the purchase group ↘-R$4.00
9
-$8.75other groceries (note the formula referencing the total)CAPIgroceries-$17.00-R$29.50
10
2020-Feb-21-$95.00Logitech MX Master 3 mouseAMAZ
amazon.com/Logitech-Master-Advanced-Wireless-Mouse/dp/B07XC2FWD1
longterm
11
12
-$17.00CAPI CC expenses for 2020-Feb
13
-$95.00AMAZ CC expenses for 2020-Feb
14
15
2020-Aug-01$200.00consultingALISincome
16
2020-Sep-01-$500.00transfer from savings to checkingALISALICtransferBalance: $500
17
...add expenses here via right click -> Insert row
18
19
20
Account code
Account balance
Account description
21
AMAZ-$95.00Amazon credit card
22
CAPI-$17.00Capital One credit card
23
ALIS-$323.50Alliant Savings account
24
ALIC$500.00Alliant Checking account
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