Open Forum

Expand all | Collapse all

Account Schedules

  • 1.  Account Schedules

    Posted 27 days ago
      |   view attached
    I am in the process of building out our balance sheet in the account schedule area and am having issues with pulling the previous fiscal year information.  The current year MTD and YTD information is pulling correctly, but the Previous MTD and Previous YTD information is not.  When drilling down, I see that these two areas are only pulling information through 01.31.2018, not through the current date of the previous year.

    My comparison period formula shows as:  -1FY[1..CP]

    Any information on how to fix this would be greatly appreciated!

    Thanks!





    ------------------------------
    Sara Sharkey
    Accountant
    Compax
    Salt Lake City UT
    ------------------------------

    Attachment(s)

    Conference-BCNAVUG_200x200


  • 2.  RE: Account Schedules

    SILVER CONTRIBUTOR
    Posted 27 days ago
    Do you close accounting periods?   is there a possibility that you close by month and stopped at 1/31/18?

    ------------------------------
    Jamie Constantine
    Columbus Global
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Account Schedules

    Posted 26 days ago
    We close every month- that process is continual, so I don't believe that is the issue.

    ------------------------------
    Sara Sharkey
    Accountant
    Compax
    Salt Lake City UT
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Account Schedules

    Posted 25 days ago
    The formula for we use for PY MTD is -1FY[CP]...it looks like you have the prior YTD in both lines and our Prior Year YTD is Net Change not Bal @ date.  Here is our setup:

    Account Schedule Formulas



    ------------------------------
    Jillian Bishop
    Grundens
    Poulsbo WA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Account Schedules

    Posted 25 days ago
    Hi JIllian--

    I changed our setup to mimic yours, but it created even more issues.  Now my prior year-to-date columns are pulling the same information as my year-to-date columns, with the column that I left blank calculating numbers from an unknown area.

    I selected a random amounts in the MTD and YTD columns to drill down on, and it shows me that the filter is pulling dates from 01/01/2019 through 12/31/9999.  The PMTD and PYTD columns are now pulling information from 01/01/2018 through 01/31/2018.

    Thanks for trying to help!

    ------------------------------
    Sara Sharkey
    Accountant
    Compax
    Salt Lake City UT
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Account Schedules

    Posted 25 days ago
    Well, that stinks, sorry! The one other thing that comes to mind is the schedules are really picky about the date filter when you do the overview.  Best of luck!!

    ------------------------------
    Jillian Bishop
    Grundens
    Poulsbo WA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: Account Schedules

    TOP CONTRIBUTOR
    Posted 22 days ago
    Sara,
    Check and make sure your Accounting Periods are created. Getting that '12/31/9999' date will often happen when your periods don't exist. ​

    ------------------------------
    Crystal Tollison
    Consultant
    ArcherPoint Inc.
    Lawrenceville GA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 8.  RE: Account Schedules

    NAVUG ALL STAR
    Posted 21 days ago
    @Sara Sharkey - take a look at the link below. @Kerry (Rosvold) Peters has put together a pretty extensive blog specifically for account schedule builds.

    https://dynamicsnavfinancials.com/account-schedule-examples/
    ​​​

    ------------------------------
    Amanda Mayer
    New View Strategies
    Milwaukee WI
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role