SAP-FICO: Compare FI/GL balances to PCA

SAPIn SAP, the GL can easily get out of balance with Profit Center Accounting (PCA). I can’t remember all of the crazy reasons that we’ve had around here, but I’ll write them down here next time it happens. We use a couple of methods to ensure that our GL balances with PCA each month.

T-code: KE5T – Compare G/L Accounts in FI with Profit Center Accounting

The KE5T t-code gives you the option to narrow your selection by: company code, fiscal year, from period – to period, and Account range. You can also use the check box to only display differences between the two ledgers.

The only trick you need know is that if you want to look at cumulative balances for balance sheet accounts, you need to start with Period: 0.

Here’s a sample of the output:
SAP: t-code KE5T

Comparing Consolidated Income Statement to Consolidated PCA Income Statement

We have an management report that shows consolidated income from PCA, breaking out various groupings of business units, including corporate overhead, distribution network, subsidiaries, and sales organizations. We compare this to our consolidated income statement that is produced for external filings each month. They should always balance. And in the end, they do!

Reasons FI and PCA get out of balance:

As I come across the reasons this occurs, I’ll start logging them here. Post a comment if you can think of any and I’ll add yours too. Thanks.

13 Responses to SAP-FICO: Compare FI/GL balances to PCA

  1. Shailendra Gupta May 7, 2008 at 7:57 pm #

    Hi,

    While finding the solution for my query, I came across to your site. I think, this is very helpfull for the consultants.

    I have an issue, if you could resolve this. I am restructuring the PCA and talling the values from FI GL balances to PCA balances. Few reconciliation accounts are not matching and all billing documents are not getting transfered to PCA, but it gives the message “document posted”, and when I check the report KE5T, balance is still the same as before.

    In FI document line items, profit centers are available for some revenue elements, for some elements dummy profit center and some elements are blank for profit center.

    If you could help me out.

    Thanks,
    With Regards,
    Shailendra Gupta

  2. byron May 7, 2008 at 8:58 pm #

    Hi Shailendra,
    One problem could be that the accounts are not set up to be recorded in PCA. Check out this post: http://www.whypad.com/posts/sap-choose-gl-accounts-pca/106/ to see if that is helpful.

    If billing is not being transferred, the areas I’d check first would be:
    1) Is the right account determination in place?
    2) Is the billing document being posted in FI (there is a way that items can be billed, but the FI doc doesn’t get posted right away)…though from your post, it doesn’t sound like this is the issue.
    3) Are the accounts set up to transfer to PCA in 3KEH (referenced in the post I mentioned above)?

    I feel a bit helpless to help you without having your system at my fingertips to try stumble around for a few hours. But maybe somebody else has some ideas???

    Please let us know if you figure it out. Or if you have any ideas…I’ll keep thinking.

    Regards,
    Byron

  3. Shailendra Gupta May 12, 2008 at 11:01 am #

    Hi Byron,

    I assigned some reconciliation accounts in 3KEH for which I am facing this problem now. (I have removed all the reconciliation accounts now). My creditors and debtors are not matching with FI values for these recon. accounts.
    I was trying to reverse these documents it was not getting reverse. I found a SAP Note”781226″ , which says to delete the PCA line items and they have given the program also. I tried same on my test server. This program deletes the document itself.
    Now I am trying to update the creditors and debtors again by executing the t code F.5D and 1KEK, but there is no impact
    on its updation. Now, How can we update these creditors and debtors? but I can see profit center updation in balance sheet adjustment by selecting the environment in menu in TCode FB03 for recon accounts and other line items can be updated with the 1KE8.

    Please, help me out.

    Thanks,
    With Regards,
    Shailendra gupta.

  4. byron May 12, 2008 at 11:55 am #

    Shailendra,
    Are you running ERP 6.0 (ECC 6)? If so, then this is a bit out of my experience…we are upgrading to ERP 6 later this year. If you are running 4.6 or 4.7, you will not see your balances in the proper profit centers until the 1KEK t-code is run at month end.

    So when a receivable posts from a Sales transaction, it does not affect the proper profit center until 1KEK is run. Same thing on the vendor side.

    I don’t know if that is the problem, but it’s one thing that comes to my mind while reading your comment. I’ll keep thinking.
    Byron

  5. Shailendra Gupta May 13, 2008 at 12:31 am #

    Hi,

    I am working on ECC 5.0 and preparing the profit center wise balance sheet for the fiscal year 2007. Document splitting is not activated. As I said in my last mail this issue is due to my mistake(please refer to my last mail).
    How I can udate the reconciliation accounts through 1KEK. It is considering the reconciliation accounts now, but values are not updating for creditors and debtors. IF you could throw some light on this.

    Thanks,
    Regards,
    Shailendra Gupta.

  6. byron May 13, 2008 at 9:24 am #

    Shailendra,
    I dug around a little bit and found a program for “Redetermine Adjustment Accounts for Balance Sheet Adjustment.” You should be able to run program SAPF180K through t-code: SE38. If you want to read up on what it does, go into F.5D, go to SAP help (Help/Application Help), scroll down to the bottom to the Additional Information section, then click Proceed beneath the section “Redetermining the adjustment accounts if you changed the account determination or it was incomplete at the time of calculation.”

    Here’s a screenshot of the top portion of the SAP Help:
    http://www.whypad.com/wp-content/uploads/sapf180k.jpg

    Maybe that helps?

    Byron

  7. Devanshu March 29, 2009 at 7:59 am #

    Hi! Byron,

    I found difference in balance as per KE5T report & 2KEE…what may be the reasons for same & if iwant to zero all the balance in PCA…which report balnce should i follow…What method should i adopt…

    Devanshu

  8. shailendra Gupta April 4, 2009 at 2:07 am #

    Hi Byron,

    I could not say thanks to you for your help in generating Profit center balance sheet, due to some personal problems.

    Thanks for the help.

    Thanks,
    Shailendra Gupta.

  9. Byron Bennett April 4, 2009 at 7:43 am #

    Hi Shailendra,

    You’re very welcome. Glad to help.
    Byron

  10. swetha January 13, 2010 at 2:25 am #

    Hi,

    I need help in resolving the issue related to FI/PCA imbalance in ke5t….till 2008 all the entries are in balance but the imbalance is in period 0,2009 ,where as period 1 to 16 of 2009 year are in balance.After our analysis we found that some entries was posted to 01/31/2008 on 01/09/2010 by mistake thorugh 1kek.

    My doubts are:
    1) if these entries are posted in jan,2008 then the imbalance should exist in 2008 also, but 2008 is perfectly balanced….
    2) How will the program post to 2008,when already the peirod is closed……..Like in FI,wont there be any control on the period locks……..OKP1 is only for CO periods,will this effect the PCA also or is there any other t-code where we maintain periods/fiscal year locks in profit center accounting……..
    3) Now FI is not effected because of this postings(as its 1kek), but PCA is………….so imbalance is arising.which tables(glpca) to check for the exact comparison as ke5t shows only the line items by profit center wise, not the document wise…………….

  11. Byron Bennett January 13, 2010 at 8:02 am #

    Hi Swetha,

    1) I would agree that if the posting happened in Jan 2008, that should be out of balance as well. You mentioned that the posting occured through 1kek, which, I think, only posts to Period 0 (the beginning balances period), so I wouldn’t think that Jan 2008 would have been affected, unless the posting occured in period 0, 2008.

    2) You are correct, OKP1 doesn’t close PCA, so posting can still be made. It appears that this is a problem for others as well. Take a look at this thread on SAP Fans: http://www.sapfans.com/forums/viewtopic.php?f=10&t=324209

    They mention t-codes: GCP1 and S_ALR_87004395, but they don’t seem to be perfect fixes either.

    3) If the imbalance occurred through 1kek, you probably won’t find GLPCA entries for the records, but I could be wrong…I think the job just rolls up the carry forward balances and posts them to GPCT. (somebody let me know if this is wrong)

    BB

  12. Byron Bennett January 13, 2010 at 8:04 am #

    Swetha,

    GCP1 and S_ALR_87004395 mentioned above are IMG (configuration) t-code, so this is probably not the solution…most production systems will have a “not modifiable” status, so you can’t use it.

    BB

  13. Nina June 25, 2010 at 4:05 am #

    Hi,

    IM currently working on 4.7,and facing similar problem..Diff in PCA & FI balances at the period end.
    These r the steps i hv taken so far:

    1. Completeness check for the period.

    2.Checked if cost elements r maintained in okb9.They are not.

    3.3keh is not maintained either.

    4.So, checked the materials master( balances differ mainly in Consumption a/c, inventory a/c and Price difference a/cs). PCtr is picked from here.

    5. Took a comparision using ke5t.

    I have list of affected accounts with the difference amounts. Yet no solution lurkes at the horizon ..

    Could you please help.

    Thanks.
    Nina.

Powered by WordPress. Designed by Woo Themes