Accounting currently uses the invoice detail report to help track outstanding invoices to reconcile with our accounts receivable balances but there is one flaw with the report. When we close a month we have to ask employees from other departments to hold on entering payments for the next month until we have finished the current month. For example when we closed June we have to have all other departments hold off on posting any July payments until we have finished reconciling June. The problem is this can take several days and causes other departments to have to just hold all that work to be processes which doesn’t seem right.
I’m wondering if anyone in the Tessitura community has created an accounts receivable report that can be run during a month end close and ignore future payments posted after the date the report is being run for? This seems like a very standard report and would be really helpful to us.
Thanks!
Annie
Hi Annie -
We face this same problem with the Pledge reports. I just have it set to run automatically during the night on the last day of the month so that I have a Tess report at a fixed moment in time to compare to my GL.
The other report that's useful for pledges (but maybe not for invoices...I've never tested it) is the Fund Activity report. We use it to see if we didn't catch something that was backdated.
Hope that's helpful!
Jessica