Open Forum

Expand all | Collapse all

Account Schedules

  • 1.  Account Schedules

    Posted Nov 13, 2019 05:52 PM
      |   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)

    Academy - Online Interactive Learning from Experts


  • 2.  RE: Account Schedules

    GOLD CONTRIBUTOR
    Posted Nov 13, 2019 11:28 PM
    Do you close accounting periods?   is there a possibility that you close by month and stopped at 1/31/18?

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

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Account Schedules

    Posted Nov 14, 2019 10:01 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Account Schedules

    Posted Nov 15, 2019 02:18 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Account Schedules

    Posted Nov 15, 2019 02:55 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Account Schedules

    Posted Nov 15, 2019 04:04 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Account Schedules

    TOP CONTRIBUTOR
    Posted Nov 18, 2019 09:06 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Account Schedules

    NAVUG ALL STAR
    Posted Nov 19, 2019 09:36 AM
    @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
    ------------------------------

    Academy - Online Interactive Learning from Experts


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