Restricting a column on reporting only a specific date instead of an entire period

I'm hitting a wall. My client wants a column in Sage Intelligence to pull only total of net activity for a specific day instead of a period. It has to do with accruals. They don't want to enter accrual journal entries. They want to keep the expenses dated at the end of the year and not accrue them if they are for the next year.  So the situation is that they want to print 12 months but include Dec 31 entries.  Weird way of doing accounting but this is one of the unusual requests I've had. Hopefully somebody out there has had the same request? Thank you in advance.