For this, you need a template on two sheets: a transaction log and a summary report with formulas. You enter expenses with categories, and the system calculates totals for the period.

The main work is done by the SUMIFS function. It sums expenses by a given category and date, for example, all expenses on "Transport" for January.

To avoid distortions, it is important to develop the habit of entering data on time and correctly. For analyzing the structure of expenses, it is convenient to use pivot tables. Read more about working with the SUMIFS function in Excel with formula examples in our guide.

🔗 Source: excel.rf