How can I get a listing of the FACTS transactions that were outstanding as of a specific date?

To create an outstanding transaction listing you would run either the FACTS Transaction History listing, the Transaction Entry listing or a combination of both.

For example, let us assume your foundation is a calendar year foundation ( December year end).
Assume it is now April and you have reconciled January thru March statements.

• If all of the transactions that existed on December 31st have been cleared, then you only need to run the transaction history listing.
• If some of the transactions have cleared, but a few are still outstanding ( perhaps the pool is a checking account), then you will need to run both the transaction entry AND the transaction history listing to get all the outstanding items.
• If you haven't processed the January cycle yet, then you can use just the transaction entry listing.

When you process a cycle the transaction move from the Entry Listing to the History Listing. So one or both reports might be needed depending upon the circumstances.

To run the report(s):

Select Reports > FACTS > Transaction History Listing or Transaction Entry Listing
Select:

• Pool ID - enter ID in Selections
• Trans Date - enter range of dates that you believe were in transit at the end of the month in question (December 31 if you are using a calendar year) This might be a January thru December 31st range.  Essentially you are capturing all of the transactions that might have been outstanding as of your cut-off date.
• Confirm Date - enter range of dates from January 1 (or beginning of new fiscal year) through present or the day after the cut-off date through today
• Run Report

So you are selecting on all the transactions created before the cut-off that have confirm dates after the cut-off.
You have the option of sorting by any of the selections you've made.