Reporting/Reconciling

GL ending balance does not match Bank Rec "cash account ending balance"

Marianne Henderson — Mon, 05 Oct 2009 21:42:29 GMT

I thought I had the bank rec module figured out, but my friendly auditors have pointed out that I may have missed something. When I run a General Ledger for a single account (the account we created to track a cash account at the bank), the ending balance is X at 6/30/09. Pretty simple, I thought.

When I did the reconciliation report (several months ago, and now I can not re-create that report) the page that shows "Reconciliation of Cash Account to Statement" (NOT to Register) shows a different ending balance labeled "Cash account ending balance 6/30/09". I can not figure out for the life of me where the system is pulling that number from, or why it would be different from the balance on my general ledger and trial balance reports?

Any bright ideas would be greatly appreciated - thanks so much!

Cash Flow Analysis

Cheryl Hair — Thu, 20 Aug 2009 13:28:29 GMT

Anyone have a really cool cash flow analysis (not FASB cash flow statement) that they would be willing to share?

Also, if your cloudy ball is clearer than mine - what does it say about the economy over the next 12 - 18 months?

I don't see a way to attach a report to a response so either someone can tell me how or where to look or my email address: hairc@unitedwayknox.org

Custom Report-I think

Hillary Murphy — Thu, 24 Aug 2006 17:32:36 GMT

I am trying to find a canned report but I think it may be something I have to create. I need a schedule of my projects for my fiscal year. It needs to be set up in columns and the columns are the project number and desciption. The rows are beginning fund balance of the year then income and expenses for each month and ending fund balance for each month. Our auditors want to see a schedule in this format. I hate to use excel and manually enter this info when it can be pulled from FE. I am familiar with Crystal Reports (Though I'm not an expert). Has anyone built a report like this or is there a canned report I am missing? Thanks, Hillary Murphy Phoebe Foundation Phoebe Putney Health System [Email Removed]

Reconciling Operating Acct Daily?

Kayla Lindberg — Fri, 09 Nov 2007 17:23:44 GMT

We are thinking of reconciling our Operating account in FE daily. Has anyone ever had a problem with this or suggestions on making the transition smooth?

Post Reports - do you keep them?

Cheryl Hair — Fri, 01 May 2009 18:42:38 GMT

We've been printing off the post reports each time we post. In an effort to reduce paper began exporting them as a pdf, but no one ever goes back to look at them...

If we need to research a transaction it's usually done with other reports.

Do you keep your post reports or toss them?

Formatting Issues when Exporting from FE to Excel

Netta Kowalski — Wed, 01 Jul 2009 14:55:46 GMT

We're relatively new to FE so I'm going to ask a question that might have already been addressed, so sorry if that's the case.

When exporting an income statement from FE to Excel, the column headings and subtotals don't line up under the correct columns. This of course means going through the spreadsheet and cutting and pasting a bunch of lines of data. Is there a way to get this to format correctly?

Also, is there a way to get actual subtotal formulas to come over, rather than having "hard" numbers export in? I do alot of scenario planning, which means going through a spreadsheet and changing subtotals to formulas every time I export an income statement.

Thanks!

Netta

Every Child's Hope

F9

Keith L — Thu, 18 Jun 2009 17:04:58 GMT

I received an invitation to a webinar for F9 for Financial Edge. I couldn't make the webinar but I have used F9 with other software and love it. I can't find any instructions on how to get F9 for Financial Edge. Does anyone know how to get it?

Adding budget data to Income Statement

Nicole Roberts — Mon, 20 Oct 2008 19:53:32 GMT

I have created multiple budget scenarios and tried to select one for a new column I added to the standard income statement. When I view the report, the budget data is not populated, but I have confirmed through a query that it is indeed loaded to the scenario I am selecting. Do I have to do something in order for the budget dollars to be picked up and included on my report? I see an option under budget tools to finalize my budget scenario, but I don't want to do that just yet. Do I have to finalize a budget in order to see it on a report? Is there another problem that I might be overlooking? Thanks for your help.

Project Profile Report

Nora Langolf — Wed, 29 Apr 2009 15:35:33 GMT

On the General Tab of the Project Profile Report, there is an option to choose "Pool". Can anyone tell me what this is tied to? When I run the report, I get a column that is headed "Pool ID" but the column is blank.

Year End Report

Bonnie Gross — Wed, 14 Jan 2009 22:01:25 GMT

What reports in Financial Edge would you suggest using to look at overall year-end totals?

Crystal Reports XI

Ron Krakowiak — Wed, 25 Mar 2009 13:15:26 GMT

Just took the Crystal Reports eLearning class on Monday. Just want to make sure I understood a version question I asked.

We have an environment with F/E using 8.5 Crystal run-time. If I install Crystal XI (11), which is what we used in class, will I have any problems running canned F/E reports which I believe are in 8.5 using the run-time version? Currently none of our workstations have a separate installation of Crystal, they have the standard F/E installation. We thought there was an issue with this a while back. We have another application which uses Crystal XI and we thought there was an issue with running standard 8.5 reports. Please let me know if anyone has experienced any problems. Thanks..

General Ledger Report with Budget info?

John McBride — Thu, 15 May 2008 21:47:57 GMT

I am trying to creat a financial report that is basically the same as the General Ledger report, showing transaction level detail, DR/CR amount, & Net Activity. However, I would like to add Budget amount to it. I'm pretty handy with the financial report creator, but the lowest level of detail I can get down to is the Account level, not transaction. Using the General Ledger reporting tool, I can't find a way to add Budget info. Any ideas? Thanks

Query: Net Activity doesnt work in Queries and Exports

Bob Millington — Wed, 07 May 2008 23:15:15 GMT

Dear All,

Has anyone experienced not being able to get net activity in a query or export to return data? We have pre-closed our fiscal years and since then we cannot run a Query or Export that will allow for us to get any prior years income or expense totals. I am working with support and really dont seem to be going very far.

Just wanted to see if anyone else has worked around this issue.

Thanks,

Bob Millington
Director of Information Technology
Veterans Medical Research Foundation

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

Cindy Winslow — Sat, 26 Jan 2008 00:48:49 GMT

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!!!!!!!!!!!!!

Beginning Over

Helen MaCauley — Wed, 12 Dec 2007 17:13:06 GMT

Due to numerous changes in our accounting office, we have not utilized our Financial Edge in well over a year - shameful I know. Therefore, all of our balances are incorrect as well as our postings. Does anyone know how to begin over without losing all of our integration that has been done? Any assistance would be helpful! Thank you so much! Thank you, Helen MaCauley

Adjustments

Kayla Lindberg — Fri, 09 Nov 2007 19:32:12 GMT

When adjustments are made to the GL how can they be found and deleted? There are unreconciled adjustments in our payroll account that need to go away. How can we do this??

open invoice report by fund

Peggy King — Tue, 16 Oct 2007 19:06:57 GMT

I need to run a report as of year-end showing the open invoices by fund. Has anyone figured out how to do this?

Year-end donor reports

Carolyn Rhode — Fri, 05 Oct 2007 14:17:40 GMT

Dear FE Users, How do we generate a year-end report for endowment donors? I want to show starting value, earnings, donations, expenses and then a final value. Thank you! Carolyn

Project Detail Reports

Nora Langolf — Wed, 15 Aug 2007 13:47:20 GMT

We are having a HUGE problem with the Project Detail Reports. We recently upgraded to SQL 2005 and FE 7.70.638.0011. Immediately after our Project Detail Reports were running very slowly or getting hung up or whatever. I have contacted support a number of times with no viable response. Has this happened to others? If so, have you found a resolution? These reports are critical to daily operations and I am not sure how much longer I can keep the wovles away from the front door...Thanks for any help! Nora Langolf Community Foundation for the Fox Valley Region Appleton WI

Reconciling AP to GL

Ed Griffis — Tue, 21 Aug 2007 13:21:24 GMT

For anyone reconciling AP subsidiary ledgers to the GL balance in AP: Blackbaud just acknowledged a small item that reconcilers should be aware of. If an invoice is posted then deleted but the deletion is not yet posted, the deletion transaction will NOT show up as an unposted transaction on the GL report for the AP balance. Obviously if you post everything before reconciling this item can not occur.

Custom Financial Reports

Joseph Mera — Mon, 09 Jul 2007 20:47:22 GMT

Hi. I am trying to build a Cutom Management Report from the Financial Statements area in the Reports section. I want to list certain projects in the rows, and in the columns, i want to show the sum of various accounts. If i enter accounts in to column one (one that includes both a revenue and expense account), it sums it perfectly and the total sits for each project. Once i enter the next column, which will just be a sum of expenses, the first column goes to Zero. I cannot have more than one formula in all of the columns. Can anyone point out what i might be doin wrong? Thanks

Pivot Reports

Ed Griffis — Wed, 11 Apr 2007 12:48:07 GMT

Does anyone use Pivot reports? I have tried in vain to get the Post Date Breakdown box to appear when doing Transaction Pivot Reports. This option enables you to create columns for Months, Quarters, or Years. Without this option i cant create meaningful reports. The Post Date Breakdown is supposed to appear per the BB Pivot Report Guide when you select post date in a transaction query.

Printing the Post Report from Batches

Janet Tucker — Fri, 16 Mar 2007 16:30:08 GMT

Do you print each time you post a batch or as a Monthly process? I'm doing year end batches now and posting back to Dec06 but the report filters don't have an option to print by the month it was posted to only the day/month that it was created. Am I the only one that wishes I could get a summary report of batches posted to Dec 2006 no matter when I entered them?

Exporting to Excel

Janet Tucker — Mon, 19 Mar 2007 19:15:11 GMT

Is there a way to export to excel without having a blank row between every single line? Example: Trial Balance report for auditor so he can import to his system. [i]--- Edited at 3/19/2007 3:16:28 PM by Janet Tucker[/i]

Consolidation Module

Pat Senft — Thu, 15 Feb 2007 19:35:26 GMT

We have multiple databases (one reports in Kenyan shillings)and are considering using the consolidation module for reporting. Has anyone used this module? Did you contract for a Blackbaud consultant to assist in the implentation? What are the upfront issues to consider before implementing?