closup / process-xbrl

3 stars 1 forks source link

Template Notes from Marc - 5/3/2024 #39

Closed joffemd closed 1 month ago

joffemd commented 1 month ago

I found some issues and am making changes to the workbook. I think I will send you a revised workbook including not only the Clayton data but formula and name changes as well.

Some formulas under Total Primary Government are missing Noncurrent Assets Dropdown is Wrong; Its Showing Deferred Outflows The XLOOKUP Net Position range should be extended to cell 608. It is ending at 514 now.

On the Governmental Funds Balance Sheet, the validation ranges sometimes contain blanks because we don't have matching modified accrual elements for each full accrual element. We're going to have to maintain separate lists on separate worksheets.

PropFund Stmt of Rev Exp and Ch - This doesn't seem like we got the tags from the right part of the taxonomy. This sheet will have to be reworked to support Clayton only for now.

On Statement of Activities, we have a spec challange. Within General Revenues, the Clayton ACFR has a subtotal called "Total Taxes". If I include that, the grand total would include a lot of double counting. I have left it blank for now, so that we can tie out.

kwheelan commented 1 month ago

On the Governmental Funds Balance Sheet, the validation ranges sometimes contain blanks because we don't have matching modified accrual elements for each full accrual element. We're going to have to maintain separate lists on separate worksheets.

@joffemd FYI this is something Sarrah is fixing in #36

Generally, are you planning to make all these changes yourself or are these edits you want us to implement?

joffemd commented 1 month ago

I just made a whole bunch of changes to get Clayton 2022 close to working. At this point, I suggest that you and Sarrah use my update as a base and keep the Clayton data in.


From: Katrina Wheelan @.> Sent: Friday, May 3, 2024 9:49 PM To: closup/process-xbrl @.> Cc: Marc Joffe @.>; Mention @.> Subject: Re: [closup/process-xbrl] Template Notes from Marc - 5/3/2024 (Issue #39)

On the Governmental Funds Balance Sheet, the validation ranges sometimes contain blanks because we don't have matching modified accrual elements for each full accrual element. We're going to have to maintain separate lists on separate worksheets.

@joffemdhttps://github.com/joffemd FYI this is something Sarrah is fixing in #36https://github.com/closup/process-xbrl/issues/36

Generally, are you planning to make all these changes yourself or are these edits you want us to implement?

— Reply to this email directly, view it on GitHubhttps://github.com/closup/process-xbrl/issues/39#issuecomment-2093952863, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAL6CRJHSLKQZGNXQTSGXUTZAQ5C5AVCNFSM6AAAAABHGG7JMGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJTHE2TEOBWGM. You are receiving this because you were mentioned.Message ID: @.***>