Personal Finance Manager // Baserow

Personal Finance Manager

Summary

This table gives you a summary of your cash flow for each accounting period (i.e., for every month). It adds up everything you’ve earned and everything you’ve spent, then shows you the balance. Most of the fields are set up with formulas to handle all of your income and expenses. As you start logging income and expenses, you’ll notice this table start to take shape automatically.

Fields

Period. A unique period of time identifier for this summary period row following a year and month format (i.e., YYYY-MM).
Estimated income. A formula for the sum of all the estimated earnings for this period, which is computed from the Amount est: income lookup field.
Actual income. A formula for the sum of all the actual income for this period, which is computed from the Amount: income lookup field.
Living expenses. A formula for the sum of all the actual living accommodation expenses for this period, which is computed from the Amount: living expenses lookup field.
Food expenses. A formula for the sum of all the actual food expenses for this period, which is computed from the Amount: food expenses lookup field.
Transportation expenses. A formula for the sum of all the actual transportation expenses for this period, which is computed from the Amount: transportation expenses lookup field.
Personal expenses. A formula for the sum of all the actual personal care expenses for this period, which is computed from the Amount: personal expenses lookup field.
Entertainment expenses. A formula for the sum of all the actual entertainment expenses for this period, which is computed from the Amount: entertainment expenses lookup field.
Loan payments. A formula for the sum of all the actual loan expenses for this period, which is computed from the Amount: loans lookup field.
Contributions. A formula for the sum of all the actual savings contribution expenses for this period, which is computed from the Amount: contributions lookup field.
Other expenses. A formula for the sum of all the actual other expenses for this period, which is computed from the Amount: other expenses lookup field.
Total estimated expenses. A formula for the sum of all the estimated expenses for this period.
Total actual expenses. A formula for the sum of all the actual expenses for this period.
Estimated balance. A formula for the difference between the estimated income and all the estimated expenses for this period.
Actual balance. A formula for the difference between the actual income and all the actual expenses for this period.
Odd or even. This is a formula field that computes whether the numeric month, from Period, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.
Related income. This field is linked to the Income table, associating all income from a time period with this summary. Hidden by default.
Related living expenses. This field is linked to the Living expenses table, associating all living accommodation expenses from a time period with this summary. Hidden by default.
Related food expenses. This field is linked to the Food expenses table, associating all food expenses from a time period with this summary. Hidden by default.
Related transportation expenses. This field is linked to the Transportation expenses table, associating all transportation expenses from a time period with this summary. Hidden by default.
Related personal expenses. This field is linked to the Personal expenses table, associating all personal care expenses from a time period with this summary. Hidden by default.
Related entertainment expenses. This field is linked to the Entertainment expenses table, associating all entertainment expenses from a time period with this summary. Hidden by default.
Related loans. This field is linked to the Loans table, associating all loan expenses from a time period with this summary. Hidden by default.
Related contributions. This field is linked to the Contributions table, associating all savings contribution expenses from a time period with this summary. Hidden by default.
Related other expenses. This field is linked to the Other expenses table, associating all other expenses from a time period with this summary. Hidden by default.
Amount est: income. A lookup field fetching data from the Estimated income field from the Related income link-to-table field. Hidden by default.
Amount est: living expenses. A lookup field fetching data from the Estimated cost field from the Related living expenses link-to-table field. Hidden by default.
Amount est: food expenses. A lookup field fetching data from the Estimated cost field from the Related food expenses link-to-table field. Hidden by default.
Amount est: transportation expenses. A lookup field fetching data from the Estimated cost field from the Related transportation expenses link-to-table field. Hidden by default.
Amount est: personal expenses. A lookup field fetching data from the Estimated cost field from the Related personal expenses link-to-table field. Hidden by default.
Amount est: entertainment expenses. A lookup field fetching data from the Estimated cost field from the Related entertainment expenses link-to-table field. Hidden by default.
Amount est: loans. A lookup field fetching data from the Estimated cost field from the Related loans link-to-table field. Hidden by default.
Amount est: contributions. A lookup field fetching data from the Estimated cost field from the Related contributions link-to-table field. Hidden by default.
Amount est: other expenses. A lookup field fetching data from the Estimated cost field from the Related other expenses link-to-table field. Hidden by default.
Amount: income. A lookup field fetching data from the Actual income field from the Related income link-to-table field. Hidden by default.
Amount: living expenses. A lookup field fetching data from the Actual cost field from the Related living expenses link-to-table field. Hidden by default.
Amount: food expenses. A lookup field fetching data from the Actual cost field from the Related food expenses link-to-table field. Hidden by default.
Amount: transportation expenses. A lookup field fetching data from the Actual cost field from the Related transportation expenses link-to-table field. Hidden by default.
Amount: personal expenses. A lookup field fetching data from the Actual cost field from the Related personal expenses link-to-table field. Hidden by default.
Amount: entertainment expenses. A lookup field fetching data from the Actual cost field from the Related entertainment expenses link-to-table field. Hidden by default.
Amount: loans. A lookup field fetching data from the Actual cost field from the Related loans link-to-table field. Hidden by default.
Amount: contributions. A lookup field fetching data from the Actual cost field from the Related contributions link-to-table field. Hidden by default.
Amount: other expenses. A lookup field fetching data from the Actual cost field from the Related other expenses link-to-table field. Hidden by default.

Views

All summaries. Displays summaries for all financial periods, without any filters, sorted from the most recent to the oldest.
Add new financial period. Displays a form view that facilitates adding a new period to this table.
2022 summary. Displays a summary for financial periods in the specified year (i.e., 2022), filtered using the Period field, sorted from the oldest to the most recent.
2022 Q1 summary. Displays a summary for financial periods in the specified quarter (i.e., Q1 of 2022), filtered using the Period field, sorted from the oldest to the most recent.
2022 Q2 summary. Displays a summary for financial periods in the specified quarter (i.e., Q2 of 2022), filtered using the Period field, sorted from the oldest to the most recent.
2022 Q3 summary. Displays a summary for financial periods in the specified quarter (i.e., Q3 of 2022), filtered using the Period field, sorted from the oldest to the most recent.
2022 Q4 summary. Displays a summary for financial periods in the specified quarter (i.e., Q4 of 2022), filtered using the Period field, sorted from the oldest to the most recent.

Income

You can keep track of all of your earnings using this table. It doesn’t matter if you have one or multiple sources of income. Enter your expected income into this table and your spending in the other tables, and your finances will be automatically calculated and shown in the Summary table. To record additional income, you can fill out the Add income form.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this income.
Summary period. This field is linked to the Summary table, linking earnings to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to receive this income.
Income type. This selection field indicates what sort of income this record is about.
Estimated income. This specifies how much money you expect to receive on this type of income.
Actual income. This field indicates how much money you earned on this particular income.
Difference. The formula that computes for the difference between Actual income and Estimated income.
Notes. A brief description of the earnings can be helpful in identifying this income record.
Attachment. An upload file field that allows users to attach supporting documents or paystubs.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All income. Displays all earnings without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add income. Displays a form view that facilitates adding new income to this table.
2022 income. Displays earnings filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.

Living expenses

Use this table to keep track of all of your living expenses. Transactions can either be planned in advance or logged at a later time. New living accommodation expenses can be entered via the Add expense form. Grid views show all records with the green bar on the left side of the grid as expenses that are less than your estimate. The records with a red bar on the left border show expenses that exceeded your estimated cost.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this expense.
Summary period. This field is linked to the Summary table, linking expenses to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to pay for this expense.
Expense type. This selection field indicates what sort of expense this record is about.
Estimated cost. This specifies how much money you expect to spend on this type of expense.
Actual cost. This field indicates how much money you spent on this particular expense.
Difference. The formula that computes for the difference between Estimated cost and Actual cost.
Notes. A brief description of the expenditure can be helpful in identifying this expense record.
Attachment. An upload file field that allows users to attach supporting documents or receipts.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All living expenses. Displays all living accommodation expenses without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add expense. Displays a form view that facilitates adding new living accommodation expenses to this table.
2022 expenses. Displays living-accommodation expenses filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.

Food expenses

Manage all your food expenses with this table. You may either plan ahead of your transactions or log old expenses. You may use the Add expense form to add new food expenses. In grid view, all records with the green bar by the grid’s left border are expenses that are below your estimated cost. Records with a red bar by the left border are expenses that exceed your estimates.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this expense.
Summary period. This field is linked to the Summary table, linking expenses to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to pay for this expense.
Expense type. This selection field indicates what sort of expense this record is about.
Estimated cost. This specifies how much money you expect to spend on this type of expense.
Actual cost. This field indicates how much money you spent on this particular expense.
Difference. The formula that computes for the difference between Estimated cost and Actual cost.
Notes. A brief description of the expenditure can be helpful in identifying this expense record.
Attachment. An upload file field that allows users to attach supporting documents or receipts.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All food expenses. Displays all food expenses without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add expense. Displays a form view that facilitates adding new food expenses to this table.
2022 expenses. Displays food expenses filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.

Transportation expenses

Use this table to keep track of all of your transportation expenses. There are two ways to record transactions: in advance or after the fact. The Add expense form may be used to enter new transportation expenses. In grid views, the green bar on the left side of a record indicates that an expense is less than your estimate. Red bars on records indicate expenditures that exceeded your expectations.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this expense.
Summary period. This field is linked to the Summary table, linking expenses to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to pay for this expense.
Expense type. This selection field indicates what sort of expense this record is about.
Estimated cost. This specifies how much money you expect to spend on this type of expense.
Actual cost. This field indicates how much money you spent on this particular expense.
Difference. The formula that computes for the difference between Estimated cost and Actual cost.
Notes. A brief description of the expenditure can be helpful in identifying this expense record.
Attachment. An upload file field that allows users to attach supporting documents or receipts.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All transportation expenses. Displays all transportation expenses without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add expense. Displays a form view that facilitates adding new transportation expenses to this table.
2022 expenses. Displays transportation expenses filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.

Personal expenses

You can keep track of all your personal care expenses with the help of this table. Transactions can either be planned in advance or logged at a later date. Adding new personal care expenses is easy with the Add expense form. The grid view shows all records with the green bar on the left border of the grid as expenses that are less than your estimate. The red bar indicates expenses that went above and beyond what you expected.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this expense.
Summary period. This field is linked to the Summary table, linking expenses to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to pay for this expense.
Expense type. This selection field indicates what sort of expense this record is about.
Estimated cost. This specifies how much money you expect to spend on this type of expense.
Actual cost. This field indicates how much money you spent on this particular expense.
Difference. The formula that computes for the difference between Estimated cost and Actual cost.
Notes. A brief description of the expenditure can be helpful in identifying this expense record.
Attachment. An upload file field that allows users to attach supporting documents or receipts.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All personal expenses. Displays all personal care expenses without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add expense. Displays a form view that facilitates adding new personal care expenses to this table.
2022 expenses. Displays personal care expenses filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.

Entertainment expenses

This table makes it easy to keep tabs on everything you spend on recreational activities. One of two options exists: transactions can be pre-planned or manually entered at a later time. The Add expense form makes it simple to add new entertainment expenses. All records that have a green bar on the left border of the grid indicate that the expenses are below your estimate. Red indicates additional costs beyond what you had anticipated.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this expense.
Summary period. This field is linked to the Summary table, linking expenses to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to pay for this expense.
Expense type. This selection field indicates what sort of expense this record is about.
Estimated cost. This specifies how much money you expect to spend on this type of expense.
Actual cost. This field indicates how much money you spent on this particular expense.
Difference. The formula that computes for the difference between Estimated cost and Actual cost.
Notes. A brief description of the expenditure can be helpful in identifying this expense record.
Attachment. An upload file field that allows users to attach supporting documents or receipts.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All entertainment expenses. Displays all entertainment expenses without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add expense. Displays a form view that facilitates adding new entertainment expenses to this table.
2022 expenses. Displays entertainment expenses filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.

Loans

Keeping track of your loan payments is made much simpler with this table. You can plan and record transactions ahead of time, or you can enter them manually later. You can easily add new loan expenses by using the Add expense form. Expenses that have a green bar on the row’s left border indicate that they are lower than your estimate for each record. Expenditures that have a red bar indicate additional costs that were not anticipated.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this expense.
Summary period. This field is linked to the Summary table, linking expenses to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to pay for this expense.
Expense type. This selection field indicates what sort of expense this record is about.
Estimated cost. This specifies how much money you expect to spend on this type of expense.
Actual cost. This field indicates how much money you spent on this particular expense.
Difference. The formula that computes for the difference between Estimated cost and Actual cost.
Notes. A brief description of the expenditure can be helpful in identifying this expense record.
Attachment. An upload file field that allows users to attach supporting documents or receipts.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All loans. Displays all loan expenses without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add expense. Displays a form view that facilitates adding new loan expenses to this table.
2022 expenses. Displays loan expenses filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.

Contributions

This table makes it much easier to keep track of your savings contributions. Transactions can either be planned and recorded ahead of time, or they can be entered manually after the fact. The Add expense form makes it simple to add a new savings deposit. In grid view, a green bar on the row’s left border indicates lower costs than you had estimated. There are additional costs that were not anticipated in the expenditures with a red bar.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this expense.
Summary period. This field is linked to the Summary table, linking expenses to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to pay for this expense.
Expense type. This selection field indicates what sort of expense this record is about.
Estimated cost. This specifies how much money you expect to spend on this type of expense.
Actual cost. This field indicates how much money you spent on this particular expense.
Difference. The formula that computes for the difference between Estimated cost and Actual cost.
Notes. A brief description of the expenditure can be helpful in identifying this expense record.
Attachment. An upload file field that allows users to attach supporting documents or receipts.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All contributions. Displays all savings contribution expenses without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add expense. Displays a form view that facilitates adding new savings contribution expenses to this table.
2022 expenses. Displays savings contribution expenses filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.

Other expenses

This table will help you keep track of all your other expenses. Transactions can either be planned in advance or logged at a later date. Other expenses can be entered into the Add expense form. Grid views show all records with the green bar on the left side of the grid as expenses that are less than your estimate. A red bar on the left side of a record means that it cost more than you expected.

Fields

Record number. An autogenerated primary key that serves as the unique identifier for this expense.
Summary period. This field is linked to the Summary table, linking expenses to specific time periods in order to group or associate them.
Transaction date. The date of the transaction on which you expect to pay for this expense.
Expense type. This selection field indicates what sort of expense this record is about.
Estimated cost. This specifies how much money you expect to spend on this type of expense.
Actual cost. This field indicates how much money you spent on this particular expense.
Difference. The formula that computes for the difference between Estimated cost and Actual cost.
Notes. A brief description of the expenditure can be helpful in identifying this expense record.
Attachment. An upload file field that allows users to attach supporting documents or receipts.
Odd or even. This is a formula field that computes whether the numeric month, from the Transaction date, is odd or even. This makes it easy to color-code rows by month and organize your data into groups to make it easier to work with. Hidden by default.

Views

All other expenses. Displays all other expenses without any filters, sorted by Transaction date from the most recent to the oldest, then by Expense type from A to Z.
Add expense. Displays a form view that facilitates adding new other expenses to this table.
2022 expenses. Displays other expenses filtered by Transaction date and sorted by the same field from the most recent to the oldest, then by Expense type from A to Z.