Overview of Cross Year Reports

If you want to produce a report for the current fiscal year, but the prior year is still open and awaiting audit entries, the Pseudo Close process allows a report to be printed as if the prior year had been closed. To run a report for the current month, fill out the Setup tab as follows.

Since the previous year has not been closed, but you want to include balances from another fiscal year, you must request balances (in the Account Balances Begin box) from the unclosed fiscal year (2011), while requesting data from the current fiscal year (in the Current Reporting Year Begins box).

Notice that the system displays the date for the beginning of the fiscal year in the Account Balances Begin box. This date is from last year, since the fiscal year has not been closed, while the Current Reporting Year Begins date is the date for the beginning of the current fiscal year.

This report is an example of a cross year report based on the organization's fiscal year. The current organization was set up with a fiscal year-ends date of 6/30/12. This fiscal year has not been closed; therefore, the system records the fiscal year as 7/1/11 through 6/30/12.

For example, you want to run a report for "This Month," the current month being August 2012. So, you are reporting for the month of August, the organization's fiscal year-ended in June, and the fiscal year is not closed.

Notice that the Setup tab displays 7/1/11 as the Account Balances Begin date since the prior fiscal year has not been closed (7/1/11 through 6/30/12). Additionally, the system displays 7/1/12 as the Current Reporting Year Begins date since you are currently reporting on 8/1/12 through 8/31/12 (This Month), and the range is after your prior fiscal year range. Consequently, since the Account Balances Begin date and the Current Reporting Year Begins date are not the same date, the system performs a Pseudo Close.

Current Fiscal Year Ends	6/30/12
Prior Fiscal Year Open	7/1/11 thru 6/30/12
GL Account Balances (as of 06/30/12)
Cash	6,000.00
Net Assets	(5,000.00)
Revenues	(12,000.00)
Expenses	11,000.00
GL Account Activities (thru 08/31/12)
Cash	(2,000.00)
Accounts Payable	(500.00)
Net Assets	0.00
Revenues	(1,000.00)
Expenses	3,500.00

In addition to providing Account Balances, the table below outlines the data that has been discussed thus far.

Using the values above, the resulting report would be as follows. The revenues and expenses as of 6/30/12 would be aggregated into the Net Assets balance as if the prior fiscal year had been closed. This leaves the revenues and expenses as of 8/31/12 unchanged since we want the report year to begin on 7/1/12 (revenues and expenses should be from 7/1/12 through 8/31/12).

Social Security Agency as of August 31, 2012
Cash	4,000.00
Accounts Payable	(500.00)
Net Assets	(6,000.00)
Revenues	(1,000.00)
Expenses	3,500.00

The following data is used to output two different reports. The first report is a cross year report based on the fiscal year of an outside source (Grant). The second report is a cross year report based on the fiscal year of the organization. The current organization was set up with a fiscal year-ends date of 6/30/12. The organization's fiscal year has not been closed; therefore, the system records the fiscal year as 7/1/11 through 6/30/12.

For example, your funding source wants a "Custom" report from 10/1/12 through 3/31/13. So, you are reporting for the last quarter of 2012 and the first quarter of 2013, the organization's fiscal year ended in June, and the fiscal year is not closed.

The Setup tab displays 7/1/11 as the Account Balances Begin date since the prior fiscal year has not been closed (7/1/11 through 6/30/12). Additionally, the system displays 10/1/12 as the Current Reporting Year Begins date since you are requesting a report that starts on 10/1/12, and the range is after the prior fiscal year range. Consequently, since the Account Balances Begin date and the Current Reporting Year Begins date are not the same date, the system performs a Pseudo Close.

In addition to providing Account Balances, the table below outlines the data that has been discussed thus far.

Organization's Fiscal Year Ends	6/30/12
Current Grant's Fiscal Year Ends	10/1/12 thru 9/30/13
Prior Organization's Fiscal Year Open	7/1/11 thru 6/30/12
GL Account Balances (as of 6/30/12)
Cash	3,000.00
Net Assets	(2,000.00)
Revenues	(6,000.00)
Expenses	4,000.00
GL Account Activity (from 7/1/12 thru 9/30/12)
Cash	2,000.00
Net Assets	0.00
Revenues	(2,000.00)
Expenses	1,000.00
GL Account Activities (from 10/1/12 thru 3/31/13)
Cash	(1,000.00)
Accounts Payable	(300.00)
Net Assets	0.00
Revenues	(1,600.00)
Expenses	2,050.00

Based on FY of Outside Source (Grant) With Prior Year Open: Using the values above, the resulting Cross Year report based on the fiscal year of a grant, is as follows. The revenue and expenditures as of 6/30/12, as well as, the revenues and expenditures from 7/1/12 through 9/30/12 are aggregated into the Net Assets balance as if the prior fiscal year had been closed. This leaves the revenues and expenses from 10/1/12 through 3/31/13 as the revenue and expenditures for the Grant's fiscal year since we want the report year to begin on 10/1/12.

Social Security Agency as of March 31, 2013
Cash	4,000.00
Accounts Payable	(300.00)
Net Assets	(5,000.00)
Revenues	(1,600.00)
Expenses	2,050.00

Based on FY of Organization With Prior Year Open: Using the values above, the resulting Cross Year report for the organization's fiscal year is as follows. The revenues and expenditures as of 6/30/12 are aggregated into the Net Assets balance as if the prior fiscal year had been closed. This leaves the revenues and expenditures from 7/1/12 through 3/31/13 as the revenues and expenditures.

Social Security Agency as of March 31, 2013
Cash	4,000.00
Accounts Payable	(300.00)
Net Assets	(4,000.00)
Revenues	(3,600.00)
Expenses	3,050.00