Need help and guidance

I have been using F.E. since May 2023. I have not been trained on it. I'm basically having to figure it out as I go. Our financial reports consists of a 13 tab spreadsheet, which I import our trial balance into each month. Because it has so many tabs, I spend days just trying to figure out the formulas from the tabs to see why it is not balanced. I spend at least 3 full days just working on that alone and we have to have the books closed in 5 days. If anyone has any suggestions please let me know. We use F.E. to process A/P, journal entries and to post R.E. batches. I'm also trying to learn Workday as well because that is where payroll is run, so I have to make those entries each month for support services.

Comments

  • @Lakisha Davis sounds like a heavy lift!

    In my experience, the trial balance report in FE is a different animal than the balance sheet report (I'm assuming that you are running these reports in the GL module). The first things I'll check when a report isn't correct are the following:
    1. What chart template are you using and have you validated it to make sure that it's capturing all of the accounts?

    2. Ensure that the filters that the report is using are what you want to show (is it including not yet posted transactions, etc..)

    3. Are the report definitions correct? (Occasionally another employee will change a setting and save the report - I've done it myself!)

    I am a bit curious as to why it's exported to a spreadsheet rather than just printed/pdf from the system - but everyone is different!

    Best of luck!

  • @Robin Waldinger

    Thank you Robin. To your first question no, I don't know anything about the chart template. I don't ever change it when I'm running the reports, nor have I validated it to make sure it is capturing all of the accounts.
    The filters are good and I haven't checked the report definitions. Where would I find that?


  • @Lakisha Davis sorry to her your troubles, there are good training videos in FE when you go to help :)

    If you are using FE NXT, you can filter Journal Entries by “Out of Balance” and that saves a lot of time :)

    One thing usually causing to be out of balance on the financials, is when GL accounts are created and not added to the Chart Organizer. So, you can run a report to find out which GL accounts have been created since the last month you were in balance ;)

    I hope this helps!

    ?

Categories