Omni XL Reports – Expected Transactions Rent, Loans and Contributions

Expected transactions can be generated for rent, regular contributions, loans and also general transactions. Full details are in the main Expected Transactions help file.

On the ‘Bank + Transactions’ tab of XL Reports, there is an ‘Expected Transactions not received’ option. After selecting that option, the next menu allows you to select either Rent, Contributions, Loan Payments, General or All.

Each report shows transactions that were expected before the ‘Effective date’ but have not yet been received (listing the date due and amount due).

As an example, if the program is run on 25^th June and ‘Rent’ is selected using an ‘Effective Date’ of 31^st March, then the Excel report shows all rent transactions that were expected before 31^st March but had not been received by 25^th June in that year. Rent received between the 2 dates is not included. It is not a list of rent that was outstanding on 31^st March 2007.

For Rent, the property and tenant involved are shown. If you subscribe to the Omni Worklog, the items in this report can be added to the Worklog, once the appropriate Omni setting is ticked.

For Contributions, the member and type of contribution (employer or employee).

For Loan Repayments, the borrower and the ‘date the loan was advanced’ are shown.

For General transactions, the bank transaction category and any comment are shown.

If ‘All’ is selected, a tab sheet is produced for each type of transaction separately.

For all spreadsheets, there is a column showing whether the transactions were created by the user or generated automatically.