Welcome to Forums
Sign in
|
Join
|
Help
|
Forums
in
Reporting/Reconciling
Product Forums
(Entire Site)
Search
Higher Education
Human Services
Healthcare
K-12 Schools
Arts & Cultural
Faith-Based
Foundations
Environmental
Animal Welfare
Associations
Fundraising
Constituent Relationship Management
Financial Management
Education Administration
Website Management
Direct Marketing
Ticketing
Consulting Services
Blackbaud Interactive
Training
Data Enrichment Services
Blackbaud OnDemand
Custom Report Solutions
Staffing Solutions
Maintenance
Disclaimer
Donor Acquisition
Prospect Research
Performance Benchmarking
Data Enrichment Services
Higher Education
Human Services
Healthcare
K-12 Schools
Arts & Cultural
Faith-Based
Foundations
Environmental
Video Interviews
Latest News
Knowledgebase
FAQs
Case Central
Downloads
Forums
Support Newsletters
User Guides
System Recommendations
Blackbaud Conferences
Industry Events
Regional Seminars
Web Seminars
User Groups
Who We Are
Contact Us
Careers
Press Room
Philanthropy
Nonprofit Resources
Partners
Investor Relations
Home
Blogs
Forums
Photos
Downloads
Forums
»
Product Forums
»
The Financial Edge
»
Reporting/Reconciling
»
Trial balance for account payable by project shows balances when account balance is zero
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:
Oldest to newest
Newest to oldest
Previous
Next
01-25-2008 7:48 PM
Cindy Winslow
Posts
21
Organization: The Episcopal Diocese of Connecticut
Trial balance for account payable by project shows balances when account balance is zero
Reply
Contact
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)