Statement of Activities

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
GaboroneBaptist
Posts: 17
Joined: Fri Aug 25, 2017 9:38 am

Statement of Activities

Post by GaboroneBaptist »

Here is the underlying entries:

Entered transaction in Fund Accounting
RF-1220-000 Call Account 2400.00CR
RF-9010-000 Trf to Capital Fund 2400.00DB
RF-4870-007 Seminary Release 2400.00DB
RF-4999-000 Temp Restricted Release 2400.00CR
01-1220-000 Call Account 2400.00DB
01-9520-000 Trf from Reserve Fund 2400.00CR

When I run the income and expense statement by fund, everything is reporting perfectly. The releases are showing under the RF fund column. However, when I run the Statement of Activities report, the 4870-007 is reporting under the RF Fund and the 4999-000 is reporting under the 01 Fund. I have checked all the Account Activity reports and everything is perfect. It is just that on this SOA report, the 4999-000 Temp Restricted Release is reporting in the wrong column. Every other report puts it in the correct column.

By chance is there an error with this report? Or did I not enter something correctly? How can I get the SOA report to put the 4999-000 amount in the correct column?

Thanks,
James

NeilZ
Posts: 10216
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Statement of Activities

Post by NeilZ »

GaboroneBaptist wrote:Here is the underlying entries:

Entered transaction in Fund Accounting
RF-1220-000 Call Account 2400.00CR
RF-9010-000 Trf to Capital Fund 2400.00DB
RF-4870-007 Seminary Release 2400.00DB
RF-4999-000 Temp Restricted Release 2400.00CR
01-1220-000 Call Account 2400.00DB
01-9520-000 Trf from Reserve Fund 2400.00CR

When I run the income and expense statement by fund, everything is reporting perfectly. The releases are showing under the RF fund column. However, when I run the Statement of Activities report, the 4870-007 is reporting under the RF Fund and the 4999-000 is reporting under the 01 Fund. I have checked all the Account Activity reports and everything is perfect. It is just that on this SOA report, the 4999-000 Temp Restricted Release is reporting in the wrong column. Every other report puts it in the correct column.

By chance is there an error with this report? Or did I not enter something correctly? How can I get the SOA report to put the 4999-000 amount in the correct column?

Thanks,
James
Make a backup and try this:

Reverse this transaction. Then create a transaction just to TRANSFER the funds. Then create another transaction to release the funds in the RF account. You really don't have to do both in the same transaction.

Post the reversal, then the two replacement transactions, see if you get the same result.
Neil Zampella

Using PC+ since 1999.

GaboroneBaptist
Posts: 17
Joined: Fri Aug 25, 2017 9:38 am

Re: Statement of Activities

Post by GaboroneBaptist »

I found the error, it was my understanding of the report. The Statement of Activities report is a consolidated report, not a "by fund" report. The RF-4870-107 release is reporting under TEMPORARILY RESTRICTED column, and the RF-4999-000 is reporting under the UNRESTRICTED column. So everything is good.

I guess I needed to look closer at the column headings. I've been looking at the balance sheet by fund report and my mind assumed the first column was my 01 account and the second column was the RF account. But that was completely wrong understanding on my part. Sorry to bother you.

Post Reply