I have been in an ongoing back and forth with our Finance department over reporting on contribution date vs. post date. In Fundraising we typically do all of our reporting on contribution date. But Finance wants a monthly report based on postdate. With our adjustments this creates a lot of discrepancies between reporting. Does anyone have any recommendations for reporting or how to bridge this gap? Particularly if you have a report in Analytics? I was having trouble finding a way of reporting on postdate in Analytics.
You can run the fund activity report with a posting start and end date and no transaction or contribution date ranges filled in.
We generally do our departmental reporting based on contribution date, but we only edit this date during gift entry under specific circumstances and we would only be backdating things, otherwise we leave it the same as the transaction date. Our finance department posts all batches to the batch date, so our post dates match our transaction dates. When it comes time to reconcile the monthly statements we receive from finance, our reports based on contribution date mostly match those statements. When they don't match, I run a fund activity report where the contribution date range is the month of the statement I'm reviewing but the transaction date range is between the first day of the next month and today. That way I can see any adjustments or backdated gifts that cross months and account for the discrepancies.