In the Category column of the Summary by Category table on the first sheet simply replace the existing categories with the categories that you need to track. It will take you just a few minutes to customize it for categories that match what you need for your year-end report. You enter the transactions in the Transactions table and the expenses are summarized by category on the first sheet. If you aren't that familiar with Numbers and don't want to reinvent the wheel then I highly recommend that you have a look at the 'Personal Budget' template at File > New in your menu. If all three conditions are met, the value is included in the sum in the cell containing the formula. January 1 of the year after the year in A1 of 'this table' (Summary)Įxpenses::B,A3 the category in column B must match the category in

January 1 of the year in A1 of 'this table' (Summary)Įxpenses::A,'<'&DATE(A$1+1,1,1), the date in column A of Expenses must be before Summary-1::C2: IF(LEN(A2)='&DATE(A$1,1,1),Expenses::A,'='&DATE(A$1,1,1), the date in column A of Expenses must be on or after In the simpler case above, where all transactions are in the same year, the formula is concerned only with totals for each category. Here's are two small examples illustrating each case. If the document contains transactions during a period of more than a year, you'll need to turn to SUMIFS. If your document lists transactions during a single year, you'll be able to get the totals you want using SUMIF.

Budget templates for mac numbers