How to subtotal transactions by conditional date ... month. Now, let’s move on to a yearly balance. How to get a yearly balance in Excel Our simple data set has transactions for only one year ...