ABCDEFGHIJKLMNOPQR
1
Lavender
2
3
4
5
Instructions
6
7
8
B O O K B U D G E T
9
10
11
Thank you for your purchase! 😊 Take a moment to review this instruction guide, where you’ll find everything you need to set up your
12
spreadsheet. You’ll also find answers to common questions. If you have additional inquiries, don’t hesitate to contact me.
13
I’ll respond as quickly as I can. I hope this template supports you in achieving your bookish goals! Happy book tracking! ❤️
14
15
16
P L E A S E N O T E
17
18
19
20
⚠️ INCOMPATIBLE WITH EXCEL
21
22
This spreadsheet is specifically designed for Google Sheets and may not function correctly in Excel. Although Google Sheets and Excel share similarities,
23
there are significant differences in their formatting and formula structure.
24
25
📆 DATE FORMAT
26
27
The template's default date format is mm/dd/yyyy, but you can easily switch it to dd/mm/yyyy.
28
To do so, click File in the top left > Settings > Choose your country from the dropdown menu > Save your settings.
29
30
31
32
33
C U S TO M I Z A T I O N S E T U P
34
35
36
37
38
STEP 1. ENTER THE YEAR YOU WANT TO TRACK YOUR EXPENSES
39
40
Double click and select simply the year you wish to track your reading progress.
41
You'll notice that on some tabs the year you chose is displayed and automatically
42
changes according to your input.
43
I wrote 2025 for the year to come, but feel free to change!
44
45
46
47
48
49
50
STEP 2. SET YOUR THEME
51
52
You can choose among 3 themes:
53
Columbia Blue
54
Lavender
55
Tea Green
56
57
58
59
60
61
62
63
64
T H E B O O K B U D G E T S E T U P T A B
65
66
67
68
69
STEP 3. SET YOUR CURRENCY
70
71
Choose the currency you would like to use for your Book Budget.
72
 You can copy and paste one from this list: $, £, ¥, €
73
74
The predifined currency is £.
75
76
77
78
79
STEP 4. SET YOUR BUDGET GOAL FOR THE YEAR AHEAD
80
81
Set your budget goal for book purchases by entering the desired amount in
82
the designated cell. The tracker will calculate your spending and compare it to
83
your budget, helping you stay on track.
84
Review your progress regularly to manage your expenses!
85
86
87
88
89
90
91
STEP 5. CUSTOMISE YOUR SUBCATEGORIES (AGAIN!)
92
93
There are four categories: Bought, Borrowed, Downloaded, and Gifted.
94
You can add subcategories in the tables provided beneath each category.
95
As you can see, I already wrote down some ideas but you are welcome to add,
96
remove and change them.
97
98
99
100