| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Share your ideas and feedback 🙏 | |||||||||||
2 | ||||||||||||
3 | TRANSACTIONS | |||||||||||
4 | Only fill in the white cells (date, settled, account, value, category and optionally description). Grey cells will automatically be filled for you! | |||||||||||
5 | DATE | MONTH | SETTLED | ACCOUNT | VALUE | CATEGORY | TYPE | DESCRIPTION (optional) | CURRENCY | BASE VALUE | ||
6 | 14/01/2022 | January | AMEX | (50.00) | Grocery | expense | USD | -50.00 | ||||
7 | 18/02/2022 | February | AMEX | (100.00) | Drinks and Restaurants | expense | USD | -100.00 | ||||
8 | 11/03/2022 | March | AMEX | (150.00) | Insurance | expense | USD | -150.00 | ||||
9 | 11/03/2022 | March | Cash | 50.00 | Other income | income | CHF | 63.59 | ||||
10 | 11/03/2022 | March | AMEX | 500.00 | Paycheck | income | USD | 500.00 | ||||
11 | 18/02/2022 | February | AMEX | (250.00) | Grocery | expense | USD | -250.00 | ||||
12 | 14/01/2022 | January | AMEX | (50.00) | Drinks and Restaurants | expense | USD | -50.00 | ||||
13 | 14/01/2022 | January | AMEX | (1,000.00) | Exclude | exclude | I am lending to someone. We exclude this since it is not an expense... | USD | -1000.00 | |||
14 | 04/02/2022 | February | AMEX | 1,000.00 | Exclude | exclude | Then I got paid back. We exclude this since it is not an income... | USD | 1000.00 | |||
15 | 28/02/2022 | February | AMEX | 500.00 | Paycheck | income | USD | 500.00 | ||||
16 | 07/01/2022 | January | AMEX | 500.00 | Paycheck | income | USD | 500.00 | ||||
17 | 08/04/2022 | April | AMEX | 250.00 | Paycheck | income | USD | 250.00 | ||||
18 | 08/04/2022 | April | AMEX | (500.00) | Housing | expense | USD | -500.00 | ||||
19 | 08/04/2022 | April | AMEX | (350.00) | Utility | expense | outstanding utility bill | USD | -350.00 | |||
20 | 08/04/2022 | April | Cash | 300.00 | Exclude | exclude | get back from friend (he borrowed some money). | CHF | 381.54 | |||
21 | 22/04/2022 | April | PayPal | 30.00 | Other income | income | Grandma gift | EUR | 34.90 | |||
22 | 18/03/2022 | March | PayPal | 35.00 | Other income | income | Streaming | EUR | 40.72 | |||
23 | 12/05/2022 | May | Cash | (20.00) | Transportation | expense | CHF | -25.44 | ||||
24 | 12/05/2022 | May | Cash | (20.00) | Grocery | expense | still need to pay groceries | CHF | -25.44 | |||
25 | 12/05/2022 | May | AMEX | (35.00) | Gifts | expense | USD | -35.00 | ||||
26 | 12/05/2022 | May | PayPal | (20.00) | Gifts | expense | Donation to Larsen and Maja for this awesome goolge sheets template! | EUR | -23.27 | |||
27 | 18/02/2022 | February | PayPal | (36.00) | Utility | expense | EUR | -41.88 | ||||
28 | 10/02/2022 | February | AMEX | (68.00) | Transportation | expense | USD | -68.00 | ||||
29 | 10/03/2022 | March | PayPal | (35.00) | Drinks and Restaurants | expense | Restaurant | EUR | -40.72 | |||
30 | 16/03/2022 | March | Cash | (12.00) | Drinks and Restaurants | expense | Drinks | CHF | -15.26 | |||
31 | 25/03/2022 | March | AMEX | (14.00) | Transportation | expense | Bus | USD | -14.00 | |||
32 | 13/05/2022 | May | PayPal | (13.00) | Insurance | expense | EUR | -15.12 | ||||
33 | 23/06/2022 | June | Cash | (20.00) | Clothing | expense | T-Shirt | CHF | -25.44 | |||
34 | 17/06/2022 | June | PayPal | (50.00) | Drinks and Restaurants | expense | EUR | -58.17 | ||||
35 | 20/04/2022 | April | Cash | (35.00) | Utility | expense | CHF | -44.51 | ||||
36 | 21/04/2022 | April | AMEX | (200.00) | Transfer | transfer | savings | USD | -200.00 | |||
37 | 21/04/2022 | April | Savings | 200.00 | Transfer | transfer | savings | USD | 200.00 | |||
38 | 05/05/2022 | May | Cash | 100.00 | Exclude | exclude | Friend needs to pay for dinner | CHF | 127.18 | |||
39 | 05/05/2022 | May | AMEX | (1,000.00) | Housing | expense | USD | -1000.00 | ||||
40 | ||||||||||||
41 | ||||||||||||