Reporting by Credit Card Billing Date

[SKruger]

For reconciliation purposes, I need to be able to run reports that include the credit card billing date/statement date for transactions. We often have team members include expenses from a different billing cycle and managing that through excel is getting too cumbersome as we continue to grow our team. Is there a canned report that includes this or something we'd need a custom build on? Thank you - 

[KevinD]

@SKruger I believe you would need to build this as not all billing cycles are the same from card to card and company to company. You can create a report in Cognos that would show you transactions for the statement periods. 

I don't know what your Cognos experience is, but this would be a pretty straightforward report to build. Well, I say that not knowing what all you want the report to show. You can build one report that has a prompt built into it for dates, where each time you run the report, you enter the date range of data you want to see. That way the report can be run each month and alleviates the need to build one report to run each statement period.

Do you have Cognos experience at all?