Keywords: google sheets, pivot tables, relational database design

This is a set of sheets that allows the user/s to track their expenses and income. You can make a copy of the sheets here!

Sheets

Transactions Sheet

Transactions Sheet stores expenses and income. The columns of the sheet are ID, Person, Amount, Category, Description, Bank Account, Date columns.

Columns

  • ID: ID of the transaction.
  • Person: ID of the person the transaction belongs to. People are defined in the Person Sheet.
  • Amount: The amount of the transaction. The plus sign means the money is earned and the negative sign means it is spent.
  • Category: Category of the expense. Categories are defined in the Categories Sheet.
  • Description: This column is for users who want to see specifically what is going on with the money. It includes detailed explanations, in case the category column is too general.
  • Bank Account: ID of the bank account the transaction is made from or to. Bank accounts are defined in the Banks Sheet.
  • Date: Date of the transaction.

Person Sheet

This sheet keeps the people who are involved in the Personal Accounting Sheets. People can be updated in this sheet. The Person column of the Transactions Sheet is validated using the people listed in this sheet.

Columns

  • ID: ID of the person.
  • Person: A descriptive name for the person.

Categories Sheet

This sheet keeps the categories where the money goes or comes from. The category column of the Transactions Sheet is validated using the categories listed in this sheet.

Columns

  • ID: ID of the category.
  • Categories: A descriptive name for the category.

Banks Sheet

This sheet keeps the bank accounts used in the sheets. The Bank Account column of the Transactions Sheet is validated using the bank accounts listed in this sheet.

Columns

  • ID: ID of the bank account/credit card.
  • Card: A descriptive name for the bank account/credit card.

Summary Sheets

In these sheets the user/s can see details they want from the pivot tables. In the Summary 1, it is shown which person spent or earned how much money date by date in a given date range. In Summary 2, it is shown how much money is spent from each account by each person.