Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Trial balance for account payable by project shows balances when account balance is zero

Last post 01-25-2008 7:48 PM by Cindy Winslow. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 01-25-2008 7:48 PM

    • Cindy Winslow
    • Top 500 Contributor
    • Posts 22
    • Organization: The Episcopal Diocese of Connecticut

    Trial balance for account payable by project shows balances when account balance is zero

    We converted to FE from AFN mid December. I am recreating our reports in FE and reconciling them to AFN. We require projects on all accounts. We pay all of our bills out of one checking account in fund 100 using interfund sets to create an ofsetting interfund cash entry in each project when the bill is paid. I am having a problem on the B/S with my cash being out of balance by the accounts payable amount when I run a report filtering on a project in a column. I investigated and discovered that if I run a trial balance after we pay all checks it shows 0 for all a/p accounts. If I run the same report selecting under format/detail show distribution by project, the projects are not zero even though all bills have been paid. When I open these projects in GL and drill down to the accounts payable balance on the project it shows a balance. How can this be when everything has been paid? When I run a FE balance sheet filtering on 1 project in each column, A/P is not zero and my cash is out of balance by the amount of the A/P. This A/P is the same as the incorrect A/P on the open project screen for the balance sheet account. I have AFN reports that were correctly showing zero A/P and correct cash on the same date the FE reports were run. I investigated and discovered that this problem is happening when we adjust an A/P invoice account distribution after the check has been cut and posted. I have been dealing with Blackbaud tech support and they have told me that I am the only person that has this problem and there is nothing wrong with the system and nothing changed between FE and AFN. They have a copy of my preconversion AFN database and my FE database and even though they see the differences in the report, they tell me there is nothing wrong and certainly they would have found such a problem before now. 90% of our reporting is done at the project level, with I/S and B/S reports (we have 600+ projects). Has anyone else out there experienced this problem. Can anyone out there who reports on projects that may have been adjusted duplicate this problem, when they know all of their bills have been paid, by running the trial balance at the account level and then run the same report by project and not have them all be zero? This is a huge problem for us and dealing with Blackbaud has been extremely difficult. I have auditors coming in 6 weeks and we can't close our books because we need to spread investment income to projects based upon cash balances. HELP!!!!!!!!!!!!!
Page 1 of 1 (1 items)