How to Create a Split Expenses Spreadsheet in Notion

​

Managing shared expenses within a group or team can be challenging, with the potential for confusion and miscommunication. Notion, a versatile all-in-one Workspace, offers an excellent solution by allowing users to create collaborative and dynamic split expenses spreadsheets. With its flexibility, real-time collaboration, and robust customization options, you can easily track shared expenses, ensuring transparency and accurate financial management. This guide will walk you through creating a split expenses spreadsheet in Notion using current features and best practices.

​

Getting Started

​

Before diving into the steps, make sure you are comfortable with Notion’s core features. Familiarize yourself with tables, properties, and Formulas in Notion, as these will be essential when setting up and automating your spreadsheet. Notion continuously updates its interface to improve usability—so take a moment to explore any new icons or sidebar options available to you.

​

Step 1: Set Up a New Database

​

In Notion, a database is an organized collection of related information. To create your split expenses spreadsheet, follow these steps:

​

1. Navigate to or create the page where you want your split expenses spreadsheet.
2. Click the + New Page button or the + icon in the sidebar.
3. Choose a Database option; the Table view is recommended for a clear overview of all expenses.
4. Customize the database properties to include key details such as expense description, date, amount, and the person responsible. You can also add additional properties like categories, tags, or payment methods. To add a property, click the + button at the right of the table and select the appropriate type (text, number, select, etc.).

​

Step 2: Capture Expense Details

​

Once your database is set up, start capturing expense details. Each row represents an individual expense:

​

1. Scroll to the end of the table and click on the empty row.
2. Enter the expense details—this includes the description, date, amount, and the person responsible.
3. Continue adding each new expense as it occurs.

​

Step 3: Group Expenses

​

Grouping expenses can simplify tracking and reviewing transactions by category. To group your expenses:

​

1. Identify the property you want to group by, such as “Project” or “Category.”
2. Click on the header of that property.
3. Select the Group By option from the dropdown menu.
4. Your expenses will now be organized according to the chosen property, providing a clear view of your grouped transactions.

​

Step 4: Calculate Individual Contributions

​

One of Notion’s powerful features is its ability to perform automatic calculations using formulas. To calculate each person's contribution:

​

1. Ensure you have properties set for the Amount and Number of People involved in each expense.
2. Create a new property for contributions and set its type to Formula.
3. In the formula field, use an expression like  

   prop("Amount") / prop("Number of People")  

   to automatically calculate each individual's share.

​

Tip: Adjust the formula based on your specific setup or use additional functions if you need more complex calculations.

​

Step 5: Track Settlements

​

As expenses are paid, it’s important to track settlements to keep everyone informed about outstanding balances:

​

1. Add a new property named Payments to record amounts paid by individuals.
2. As payments are made, update the Payments property for each relevant expense.
3. To monitor the net balance for each person, create an additional property called Balance and use a formula such as  

   prop("Contributions") - prop("Payments")  

   to compute each individual's current balance.

​

Step 6: Utilize Filters and Sorts

​

For better insights into your expenses, you can filter and sort your split expenses spreadsheet by different criteria:

​

1. Locate the filter and sort options at the top right corner of your database table.
2. Click the filter icon to choose criteria such as date ranges, specific individuals, or categories.
3. Use the sort option to arrange your entries in ascending or descending order based on properties like date or amount.

​

Conclusion

​

Notion’s flexibility and ever-evolving features make it an outstanding tool for managing shared expenses and financial tracking. By setting up a split expenses spreadsheet and following these updated steps, you can efficiently record expenses, calculate individual contributions, and monitor settlements. With real-time collaboration and customizable views, Notion streamlines the expense management process, ensuring transparency and accuracy in your financial dealings.

​

Take advantage of Notion’s capabilities today and simplify your group’s expense management!