Notion操作教程|怎樣做個人賬本(Notion operation tutorial|How to do personal financial management)

即凉Lion
42粉絲
4 次觀看·2024年2月5日
它來啦它來啦,Notion個人賬本教程來啦,一起學起來吧
如果你想更多地看到我
公眾號:即涼
微博:【即涼Lion】https://weibo.com/SuperLiooon
我的知識星球:【即涼的星星之火】https://t.zsxq.com/0fVNpQR8c
Hello everyone Im Jilan
Today Ill share with you how to
use Notion to make a personal account book
So lets start
Todays content I will also be divided into two parts to talk about
the first introduction to my financial management
the second
production tutorial
So lets first look at my financial management
I divided it into three parts
shopping list
personal bills and balance sheet
First of all lets look at my shopping list
I classify it according to work
study and life Every time I have something I want to buy
I will write it down on it
and then go to buy it together when I am free
This has two advantages
one is to prevent me from forgetting
and the other is that it can restrain
me from excessive consumption to a certain extent
Because every time I want to buy something
I may want to buy it at the moment I write it down
but when I calm down for a few days
I dont want to buy it
and then I will delete it
So
I think its very important to have a shopping list
and when I finish buying
I will put a tick here
and I will take a fixed time every
weekend to put it into my bill to do the accounting
Next is my personal bill
I also divided it into three parts
budget
expenditure and income
all the bills are my expenditure and income overview
lets look at them one by one
these data are casually written by me
in order to make it easier to give examples
The first is the budget
at the beginning of each
month will give themselves to set a spending budget to
prevent me from excessive consumption
Next inside defray watch
you still can go here statistic your every months consumptive total
use this budget to subtract your that month consumptive total
can calculate you that month still has how many budget
Lets go back to the summary table
Lets look at it one by one
First of all this item represents what kind of thing your consumption or income is
then the amount of money generated by this thing
and then the classification it belongs to
life work or study This classification is the same as above
Then is your amount type is the disbursement or the income
adds this amount type with this classification
may very directviewing see you have had what kind of expense activity
for instance said is the work disbursement
the work income or the living expense and so on
Then the date of your activity
and finally your notes
And below that Ive added a calculation that takes
your total income and subtracts your total expenses to get a balance
and that balance
is your savings for the month
and if its positive
that means you have savings
If its negative
it means youre living beyond your means
and youre in debt
Then I also added a filter here
I will set the time period of
the month here every month
so this table will only show
my personal bill of the month
Then at the end of each month
I add the deposits to the balance sheet
For example if you plan to deposit your savings in Alipay
you will add this value to this value
and then your balance sheet will be updated
Next lets look at our expenditure table
the bill of expenditure all of its fields are the same
the only difference is that
it counts your expenditure type here
so what it shows here is your total expenditure
My income table is the same
and the fields are the same
The only difference is that the amount it counts is income
so the total amount is your total income for the month
so this is my personal bill
Next lets look at the balance sheet
which is divided into the assets statement and the balance sheet
and the overview of assets and liabilities
Lets take a look at these fields one by one
First of all
this platform represents where your money is placed
or where you owe money
then this amount is your specific amount
then assets are positive
liabilities are negative
then your amount type is divided into assets and liabilities
assets include your deposits
your funds your stocks and so on
So if you are in debt
for example your credit card consumption
or car loan then the remark is your additional
explanation of this asset or liability
The following amount is your net assets
that is your assets minus liabilities
and the rest is really your money
Lets take a look at this asset table alone
The fields of this asset table are the same
The only difference is that it counts your total assets
and there is no subtraction of your liabilities in the total assets
Then this balance sheet counts your total liabilities
and its other fields are the same
Lets go back to
the summary table
and then at the end of each month
you can take a day to reconcile
add your deposits to your asset platform
add your liabilities to your liability platform
and you can have realtime control of your financial situation and assets
In this way
our financial management process for a whole month has been completed
and then we will enter the second part of the production tutorial
Before making I first knock the key points
todays production has several new operations
first about the amount
how to design the amount and use the amount in the form
Second the calculation function of the table
how to count your amount of data
Third view management how to create a variety of views and
set the properties of the view
Lets create a new page
click to expand first enter a title
financial management
add an Icon click to add a cover
Lets start by creating a shopping list
First
enter three s and a space to activate a number three heading
Enter the shopping list
after the input is good
enter the following three categories
work study and life to set the color of their block
click its block settings
Set the color to your liking and drag
it around in turn
Click on the block you want to learn and drag
it to the far right to
release it
Once were done
we type aselect todolist under the work
and forget to adjust
the width and font size of the page
Enter aselect todolist below the same learning
then go back to
the lower space line of
the work and enter three
to activate a
divider that is now below the work
We drag it down until
it cant be dragged
release it and then it will continue to occupy the whole
picture Lets create a new personal bill
enter three numbers plus spaces
activate a number three title
enter the budget of this month
every month will fill in your
consumption budget here
enter a line feedselect the first form under
the database type
enter the name of
personal bill
Lets now design its fields
First change the name of the first field to Item
and then establish the second field Amount
Select the number form of the
After selecting it
click it again and it will appear a setting
Select its display form in the second option
There are many display forms here
including digital form
percentage form and then the unit of amount of each country
Select this yuan that is our RMB
Then you input a number
then it is displayed in the unit of RMB
Next
create a third field in the form of a category selection radio label
Lets create several new categories
work study and life
Next establish the fourth field
the amount type selection and the single selection tab
Create two tabs Expense and Income
Next create the fifth field Date
Select Date Format
Create the last field
remarks and select the text form
then the field of our personal bill is ready
Now lets add some data
First we add some items
and then pay attention to this amount
If you need to use its calculation function
then you can fill in the positive number of income
but you must add a sign to your expenditure
and fill in the negative number
If you fill in a positive number
it will be miscalculated
So remember this detail
set its classification
set its amount type
and set its date
Then we select sorting in the attribute filter
select the date form and select descending order
Then it will display the latest date first
Next
we select filter conditions in the table settings
add a filter condition
select a date
select isafter
select a specific date
and set it as the bill of the current month
Add another filter
and select is before
Select a specific date
before February
and it will show the data for that month
You can change the date here once a month
and let it show you the bill of the month
so that our total bill is ready
Next we make our category view
we add a category view here
created as expense bill
In the expense bill
we click these three points in the table settings to
select the filter criteria
Add a filter to select
the amount type
The choice is to choose the expenditure
so it will only show our expenditure type
Continue to add a view
add a revenue view
select filter conditions in the
table settings with the method just mentioned
add a filter condition
select the amount type
and select revenue
then it will only show your revenue data
Lets change the name of the default view
Click these three points
Here you can change its name
to All Bills
Below you can also choose to copy or delete
If you make a mistake or dont want this view
you can just click delete
Next lets go back to all my bills
Next we will carry out the last step of personal bills
that is to count our amount
We click on statistics and click on it
We will see that there are many options
Dont panic I will tell you one by one What does it mean
From here on the above are
all statistical nonnumerical data
what does it mean That is
not statistics this numerical statistics is your label or your content data
First of all None is not statistics
You dont need to show it
You can choose not to count
So countall counts all your data
so now there are three
so the following
is to show 3
So countvalues is the statistics you
have filled in the content data
Countuniquevalues is the statistical data of
the categories of your tags
For example the label of your work
it appears twice here
and then it only appears once in life
Then click on the statistics to see
so it will only count one
that is the data of the type of your label
So countempty is to count how many
pieces of data you have that are empty
Now there are none
Then count not empty is to count how
many pieces of your data
are not empty
Presentempty is the percentage of
your data that is empty
percent not empty counts the percentage
of your data
that is not empty
The following statistics relate to our values
sum is the sum
average is the average
Media is the median min is the minimum
Max is the maximum
and range is the range of the variable
So our personal bills actually
only need to use the total function
and you can know a little about the rest
Then we go to our expenditure page
and set its statistical selection sum here
and also select the statistical selection sum in the income table
so our personal bills are ready
Next lets make a balance sheet
First we type three s here
activate a divider
and then type
aunder it we select the
table form under database
Create a new name for it balance sheet
Then we change the name of the first field to the platform
and set up the second field to choose the
number form of the amount
Then click on
it and select yuan in
its style settings
Create a third field
the Amount Type
Selection Single Select tab
Create the 4th Field Comment
Select text form of the
Then we add two labels of assets and liabilities
under the data of the amount type
and lets fill in some data
Remember we have to fill in positive numbers for assets
and negative numbers for liabilities
because you need to use its calculation function
Then we select the total amount in the calculation function
Next we will create a second view
the asset table click Add
the view is named Asset Table
select the form of table and click Create
and then select the table in the asset table to set the
selection filter criteria
Add a filter condition
select the amount type
and select assets
then it will only show the data of your assets
Select Calculate Sum here in Calculate
Next
lets create a third view sheet
Click Add View to create a new one called Sheet
Select the form of table
click Create
and select the filter criteria in the table sheet settings
Add a filter to select
the amount type
Select Yes Select Liability
Then it will show you the data of your debt
Selective calculation Select Sum
Then go back to the view page
change its default name to overview
and go back to the summary table
so our financial management is ready
Ok thats all for todays content
Thank you for watching
Ill share the next video
How to use concept to manage English learning
If you think its useful for you
remember to like share and follow it
So Ill see you next time
