I am new to our organization, so apologize in advance if this has been posted in a previous thread. Our organization is preparing for its June year-end close. We typically run a Pledge Receivable by Period report in Tessitura with parameters for: "fiscal years" in period, calculation date set to the end of the fiscal year and the contribution date range set to run from 1/1/1900 through the end of the fiscal year.
If we run this report, any donor who made a payment prior to the end of the fiscal year, but for whom the pledge payment wasn't entered until after the fiscal year (with a post date appropriately set to 6/30), is showing as having paid after the end of the fiscal year. Is there any way to adjust this report to run by posting date and not entry date? If not, is there another report people have been using?
Our current process is is to use this report and then to manually check each payment close to year-end to see if we need to make a separate accounting adjustment.
Any suggestions/help would be appreciated.
I run our Pledge report after all entries for the fiscal year have been made and before any new pledges/payments have been entered in the new fiscal year. This works pretty well but occasionally I have to run a Fund Activity Report to verify pledge transactions in the first week or two of the new year.