CUBS: Other: Balances not what they used to be - How do I fix?

Note: I read the "CUBS is live" message and I still have a question (well, in fact, I have a BUNCH of questions but I thought I would create a separate thread for each question so as to keep things short and simple).

Question: Our "Other:" categories no longer show what they used to have in them, what do I do?

Possible answer (from page 5 of 9 of the Message I printed out from CHQ):

Q. All my balances in budget, other, and ward missionary are different than they were. How can I get them
back to normal? Can you give me step-by-step instructions on how to fix these?
A. When viewing the Income and Expense Report, select All as the date range and focus on the ending
balance.
Balances in subcategories can be re-created by using the finance document printed out prior to the transition and using the Transfers function in MLS. To access the Transfers function in MLS:
1. Go to the Finances menu and click More. Then click Enter Transfers.
2. Add a reason for the transfer, such as "Re-creating subcategory balances."
3. Move amounts from categories in "Transfer source" (left side) to categories in "Destination" (right side).
4. The category totals at the bottom should match.
5. Click Save to save the transfer.
6. Saved transfers cannot be undone. An opposite transfer must be entered to reverse the previous incorrect transfer.

Is that right? But what do I use as the transfer source/destination when doing this for "Other:" categories?

Do I do it like this:

Transfer source: "Other:" category that has too much money
Transfer destination: ????

I ask because I felt like I understood everything before but now I am confused again. I didn't expect our "Other:" categories/accounts to go from zero dollars to an amount now showing they have money in them and so I just want to make sure I correct these balances properly.

Thanks~!

You are on the right track. The Transfer destination is the category that doesn't have enough money.

coloradotechie wrote:Note: I read the "CUBS is live" message and I still have a question (well, in fact, I have a BUNCH of questions but I thought I would create a separate thread for each question so as to keep things short and simple).

Question: Our "Other:" categories no longer show what they used to have in them, what do I do?

Possible answer (from page 5 of 9 of the Message I printed out from CHQ):
Is that right? But what do I use as the transfer source/destination when doing this for "Other:" categories?

Do I do it like this:

Transfer source: "Other:" category that has too much money
Transfer destination: ????

I ask because I felt like I understood everything before but now I am confused again. I didn't expect our "Other:" categories/accounts to go from zero dollars to an amount now showing they have money in them and so I just want to make sure I correct these balances properly.

Thanks~!

Just out of curiosity, did the total in your Other category after the transition match the total in your Other category before the transition. I seem to have lost a few hundred dollars in the conversion.

nutterb wrote:Just out of curiosity, did the total in your Other category after the transition match the total in your Other category before the transition. I seem to have lost a few hundred dollars in the conversion.

Yeah... we lost $192.13 in the conversion when you add all the "Other:" categories together.

New question: What do I do now that we "lost" money? There must be some way to reconcile this? (I say "lost" in quotes because I'm not sure what to call it... there must be a way to explain the $192.13).

Thanks~!

nutterb wrote:Just out of curiosity, did the total in your Other category after the transition match the total in your Other category before the transition. I seem to have lost a few hundred dollars in the conversion.

I'm not the OP, but my Other account seems to have the same amount of money in it after the conversion. Looks like you'll have to dig through the transaction list to maybe find a transaction you somehow missed.

coloradotechie wrote:Yeah... we lost $192.13 in the conversion when you add all the "Other:" categories together.

New question: What do I do now that we "lost" money? There must be some way to reconcile this? (I say "lost" in quotes because I'm not sure what to call it... there must be a way to explain the $192.13).

None of us has seen an actual new unit financial statement after the CUBS transition. Theoretically, the statement will contain action items to help us resolve any differences. It's possible that your 192.13 will show up on that statement. So one approach is to wait until sometime next week when the statement arrives and see what it says.

However, I would note that for the two wards I've worked with as well as the stake account, we were fortunate to have the total in Other to be correct, so once we made transfers to the subcategories from the parent category, the parent category's balance went to 0 and all the subcategories were correct.

I had the same problem with the Stake account. I had a $44.00 difference. $33.00 was for expenses posted by CHQ after the 17th.

I am still looking for the $11.00.

We are having some of these same issues in our ward. Our Other category after doing transfers to correct some of the subcategories is still out of balance by $87.70. Somehow we lost that money. Not sure where it went.

Our budget category is also out of balance by about $148 (we found that $62 were charges from the distribution center after 10/17). That still leaves it off by about $86. We then dived into that a little more and found that we had voided a check in December 2008 that was issued the beginning of December 2006. Not sure why it took so long to escheat, this is before my time as the ward clerk. So in our transaction history we show the adjustment of $22 from the church but we do not show the orginal check from 2006 to offset against the adjustment since the history is not in MLS anymore for 2006 besides the ending balances.

Same issue with the fast offering category as with the budget category (voided an old check). We are off about $45.

So we still have the $87.70 in other and about $64 in the budget that we have not been able to reconcile.

One thing that I did notice, after comparing reports and past reconciliations, is that these differences seem to be beginning balance problems.

I am not sure how to fix the $22 or $45 problem that we have found...

In my situation, I had put a lot of effort last year to eliminate all but two subcategories in the Other account. For some of the subcategories, I could find no documentation for why the category ever existed. Under advisement from the stake clerk, I transferred any unexplainable amounts into the Girls Camp subcategory. All those categories ahve been returned in the transition with balances. So I'm not sure how they have money in them again, where it came from, or what I did wrong to not eliminate those subcategories before.

I guess I just wasn't as clever as I thought I had been.

nutterb wrote:So I'm not sure how they have money in them again, where it came from, or what I did wrong to not eliminate those subcategories before.

I guess I just wasn't as clever as I thought I had been.

In the transition, every subcategory that had any activity in the current data of MLS (which goes back to 1 Jan 2007 in the US) reappeared, even if it had previously had a zero balance and had been deactivated. So some of these categories may seem like ancient history, but they came back to life in the conversion, and many of them even had balances that showed up. I believe the balances showed up because deposits over the last 4 years tended to keep their subcategories, but expenses did not.

I doubt that you did anything wrong -- it sounds to me like you did everything you should have under the old system. You cannot completely eliminate any category from MLS until the retention period (3 years plus current year in the US) has expired. One unfortunate part of this transition is that you may have been just a couple of months away from some of those ancient categories going away (if their last activity was in 2007), but now if you create any new transfers to clear out these balances, the clock will be reset, and those unused categories can't go away until 1 Jan 2014 at the earliest.

Our stake "Other" balances were off by $100+ so I decided to dig into the reports and find out why. I had a detailed expense report and went through line by line and matched each expense on the pre-CUBS report to the expense on the post-CUBS report.

I found a handfull of FHC DC orders from 2007 that were in CUBS that were not in my pre-CUBS report. . My only guess is that these expenses were entered into MLS as a budget expense which would account for the statement reconcilation to be in balance while masking the truth that we had hidded Other expenses.

Now that I have a good understanding why my Other account was off, I need to dig into the budget being off-balance.

RWoodmansee wrote:I found a handfull of FHC DC orders from 2007 that were in CUBS that were not in my pre-CUBS report. . My only guess is that these expenses were entered into MLS as a budget expense which would account for the statement reconcilation to be in balance while masking the truth that we had hidded Other expenses.

Was it 2007 or were they actually 31 Dec 2006? Pre-CUBS did not include anything before 2007, but CUBS has included some. I suppose this is because year end usually something like Dec 30 at at noon or something like that, and anything entered after that is considered part of the new year.

crislapi wrote:Was it 2007 or were they actually 31 Dec 2006?

The expenses were in Janauary, June and August of 2007.

Earlier posts suggest that we wait for the first CUB's version of the financial statement and see if the missing expenses are listed in the 'Action Items'. Our missing expenses were 'missing' from our pre-CUBs MLS. They were 'found' post CUBS. I doubt that they will show up as action items because CUBS and our current MLS match.

The question is what to do about a short fall in our Other/Payable To Local Unit accout. The only recoure is to determine which 'Other' account is going to get hit with an unexpeted 'expense'. (or we could write a check from our budget to fund the unexpected Other expenses.... but then we would have a budget category with unexplained expenses...)

I had the same issue, too. The Other categories that I zeroed out now had Positive totals in them but the "Other: Payable to the Local Unit" acct had a negative balance. I transferred the balances from the sub accts to to get the Parent to zero and the 3 other accts that I had before the transition now have the same balance as before.

Here is my question: in the Budget categories list, I cannot add any subcategories where all the above accounts were listed, they are frozen.
I am wondering if I am supposed to add a NEW sub category Other acct and transfer the balances.

I guess I thought that I read somewhere that there were several categories/subcategories that would go away about 3 months down the road if they had zero balances.
As I think about it, I believe what I recall was actually referring to Budget subcategories, but I am assuming the same would apply to OTHER.

Hope that made some sense...any help would be great.

ralitaco wrote:Here is my question: in the Budget categories list, I cannot add any subcategories where all the above accounts were listed, they are frozen.
I am wondering if I am supposed to add a NEW sub category Other acct and transfer the balances.

Not sure exactly where you are referring to, but you cannot add new subcategories under Budget. You can add sub-categories to the default budget subcategories CUBS gave you, but you are limited to one level. Any of your old budget categories that carried over are locked. You cannot add subcategories to them (they are already at the lowest level CUBS allows: sub-sub categories), you cannot rename them and you cannot delete them.

ralitaco wrote:I guess I thought that I read somewhere that there were several categories/subcategories that would go away about 3 months down the road if they had zero balances.
As I think about it, I believe what I recall was actually referring to Budget subcategories, but I am assuming the same would apply to OTHER

The official information only specifies that old sub-categories in Ward Missionary would go away after they had been inactive for 2 months. I made a comment that I hoped it would happen for these old budget categories as well, but I don't have high hopes.

My stake appears to have never used Other so I decided to dive into a ward MLS that did. I found they showed a negative balance post-CUBS despite my making sure they were zero at every audit over the past 2 years, and then keeping it zero what I was the ward clerk in that unit for the 2 years preceding that.

A more detailed explanation is posted here but in essence, it seems to be related to checks that are pulling from original Other subcategories that show no income or insufficient income to cover the expense. Basically, donations were made pre-2007 but the checks were cut in 2007. That means their is no income to cover the expense. I'd expect the balance forward from 2006 to take care of this, but it is inadequate.

That seems to infer that there was either a "hiccup" when processing Other, resulting in an incorrect balance forward being supplied (not likely) or some error that got masked pre-2007 that I can no longer investigate has reappeared. That, unfortunately, is more plausible to me.

crislapi wrote:Not sure exactly where you are referring to, but you cannot add new subcategories under Budget. You can add sub-categories to the default budget subcategories CUBS gave you, but you are limited to one level. Any of your old budget categories that carried over are locked. You cannot add subcategories to them (they are already at the lowest level CUBS allows: sub-sub categories), you cannot rename them and you cannot delete them.

crislapi,
After I reread my post, I wasn't sure either, but let me try to be a little more specific although I am not in front of the ward pc and I don't have the screens memorized as I have only been the financial clerk for a few months.

(I am trying to do this from memory so please bear with me)

PRE-CUBS:
In the Budget category list there was an "Other" Category
Below the "Other" Category were 3 subcategories with positive balances: "2010 Food Basket", "2010 Scout Camp", "Head Stone"

POST-CUBS:
I have a category "Other: Payable to Local Unit"
I also have all the sub categories that I had previously. i.e.-"Other:Payable to Local Unit: 2010 Food Basket", "Other:Payable to Local Unit: 2010 Scout Camp", etc
They each have the correct dollar amounts that were in their previously.

What I am trying to figure out is whether or not I am supposed to continue using these "Other:Payable to Local Unit: xxxxxx" categories that were created during the transitions. I am not sure because they are greyed out (so to speak).

OR am I supposed to create "fresh" Other sub-categories and transfer the funds out of the ones created during the transition.

I hope that clarifies it some.
Thanks, for your help.

(Note sure if this needs to be in its own thread or not.
I apologize if I am hijacking this one)

ralitaco wrote:What I am trying to figure out is whether or not I am supposed to continue using these "Other:Payable to Local Unit: xxxxxx" categories that were created during the transitions. I am not sure because they are greyed out (so to speak).

OR am I supposed to create "fresh" Other sub-categories and transfer the funds out of the ones created during the transition.

Those categories are fine to use. Because they can't be deleted or changed at this point, they are definitely what you should use. If you were to create fresh subcategories, then your reports would look like they had duplicate categories.

The categories themselves are not "greyed out" or disabled -- it's only the deletion and renaming of them that is disabled. So go ahead and use them.

Thank you Alan.

Okay, as a final note of what I did:

Yesterday I followed the instructions from the 9 page email and I transferred money out of the "Other:Payable to Local Unit:<sub-category-name>" to "Other:Payable to Local Unit" to re-establish all balances that were in their previously.

(Note: Since I waited to do this until Oct 31 I had to take special care for any income or expenses to each of these categories during the Post-CUBS update and Oct. 31).

I'm left with -$192.13 in "Other:Payable to Local Unit".

How am I going to fix this? I do not know. I was thinking about trying to reconcile the old report with the new one, but I don't have tons of time. I thought about trying to get PDF versions of the reports to to some reconcilation in excel, but I can't seem to convert the PDF data to excel... so it looks like I'm stuck.

Thanks!

coloradotechie wrote: I'm left with -$192.13 in "Other:Payable to Local Unit".

How am I going to fix this? I do not know.

Maybe I can save you some time. I plowed through all my Other data and found that I actually need 2006 data or earlier to fully reconcile the error. Without it, I'm blind. I put a link above, but the detailed explanation is here.

In summary, I tracked my discrepancy to a difference between my 2006 balance forward and my expenses cut in 2007 from donations received in 2006. The discrepancy is either due to an error computing the balance forward or an error from pre-2007 that was cleverly masked and therefore overlooked. CUBS has just unmasked it. I don't know which case is true. All my other "Other" expenses were fully covered by the income shown post-CUBS.

As for what to do, I would first wait to receive the October statement and follow the Action items. If that doesn't work, I'd wait for all the patches MLS is sending down - there should be some this week. If after that it still doesn't go away, I would call LUS.

crislapi wrote:As for what to do, I would first wait to receive the October statement and follow the Action items. If that doesn't work, I'd wait for all the patches MLS is sending down - there should be some this week. If after that it still doesn't go away, I would call LUS.

THANK YOU THANK YOU THANK YOU! I'm going to take your advice and just wait and see. I'm finally feeling confident enough to move forward with this CUBS stuff and just wait for help to get rid of my negative balances in "Budget:Allocations" and "Other:Payable to Local Unit" (even after following the instructions to zero out old budget categories and re-establish "Other:" category balances).

Thanks again for all your help!

coloradotechie wrote:Yesterday I followed the instructions from the 9 page email and I transferred money out of the "Other:Payable to Local Unit:<sub-category-name>" to "Other:Payable to Local Unit" to re-establish all balances that were in their previously.

(Note: Since I waited to do this until Oct 31 I had to take special care for any income or expenses to each of these categories during the Post-CUBS update and Oct. 31).

I'm left with -$192.13 in "Other:Payable to Local Unit".

Colorado,
You may have already done these things, but I figured I'd put it out there anyway.

I suggest you look at the 2 sets of reports that you printed. You need to compare the totals of the "Other" accts (main and subs) from the 17th match the total of the "Other: Payable to Local Unit" accts (main and subs).
If the totals match, you are in great shape.
You just need to do transfers in the amounts that will make the 24th mirror the 17th.

I believe you can do an Income & Expense Report for a custom date and use the 18th so you don't see the data you posted on the 31st.
If not, they use a pen and paper and add / subtract the amounts you entered on the 31st.

I hope that helps,
Jim

crislapi wrote:As for what to do, I would first wait to receive the October statement and follow the Action items.

Because the Other:Payable to Local Unit accts are local, will they be on the Financial statements?

I believe I finally have the stake computer up to speed with transfers in the Other and Budget accounts so I have moved on to help one of the ward computers where the clerk is relatively new dealing with finances.

In trying to zero out the Payable to Unit in Other I have come up with a shortfall that I can't reconcile. I compared the balances between the 17th and 24 and checked to make sure there were no transactions since the 24th but I have found that there seems to be a $32 error. I need to transfer another $32 out of one of the subcaterories to make the Payable to Unit category zero out). Part of the problem may be that the unit computer has a bunch (and I mean a bunch) of subcategories in the Other Account that had negative balances. I tallied all the numbers up on a hand held calculator and for some reason there just seems to be a lingering $32 shortfall. See if the following example makes sense:
Other Boy Scouts - Cub Scouts 17th report shows a -$131.00. The Other Boy Scouts - Cub Scouts 24th report shows a balance of $50.00. So I am thinking that to get the new report to read the correct negative balance of $131.00 I would actually transfer from that category $181.00 so after the transfer it would read a -$131.00

I have to do this with four of their categories (add the 24th balance to the 17th negative balance) to transfer to the Payable to Unit Category. I have done this but no matter how many times I go through the numbers I still come up $32 short. Perhaps this is one of those cases where something way back in 2006 is making the shortfall but how do you find it - and is it worth it trying to back it that far or just take an extra $32 out of one of the positive categories and use that to make the Payable to Unit zero out?

Or, should we just be leaving this type of problem alone and see what shows up on the Unit Finance report when it comes out?

Pilotfly,
does the total of ALL the "Other" categories and subs from the 17th EQUAL the total of ALL the "Other:Payable..." categories and subs from the 24th?

If so, then the -32 has to be an error in the amounts transferred. On my report I had 1 Other subcategory on page 2 of the report and missed it at first.

If the totals are off by the 32, then I would think the issue was pre 2007.

Also, your math seemed right to me.

Hope it helps,
Jim

Ralitaco,

I left all the paperwork on the units desk. I will go back in the morning and check the balances. However, I never did the transfers as I couldn't make the numbers jive. So it makes me think that the issue is something back in 2006 that just doesn't show up in the pre-CUB's reports.

Alan_Brown wrote:Those categories are fine to use. Because they can't be deleted or changed at this point, they are definitely what you should use. If you were to create fresh subcategories, then your reports would look like they had duplicate categories.

The categories themselves are not "greyed out" or disabled -- it's only the deletion and renaming of them that is disabled. So go ahead and use them.

Not trying to be hard headed, but I can't make them inactive by unchecking the box next to active. This makes me think that they will be taken care of much like the Budget:Allocations:<subcategories> that crossed over too.
I would like to inactivate all but 3 Other:Payable... accounts so they stop showing on the list when I write checks.

If I could inactivate the accounts I would be happier. I think I may go ahead and create Fresh accounts with slightly different names in the hopes that the rest of the accounts are deactivated or dissappear.

One last thing for now, why did they created a budget category called other instead of miscellaneous? That was part of my confusion early on.

ralitaco wrote:If I could inactivate the accounts I would be happier. I think I may go ahead and create Fresh accounts with slightly different names in the hopes that the rest of the accounts are deactivated or dissappear.

You're welcome to do that, but I don't have much hope that the rest of the accounts will be deactivated. They have activity in them. It seems extremely likely that they will thus follow the normal rules and stick around for 3+ years.

I'm pretty sure that if you create fresh accounts, you'll just have that many more accounts to deal with -- not fewer.

ralitaco wrote:One last thing for now, why did they created a budget category called other instead of miscellaneous? That was part of my confusion early on.

Just remember that it is under Budget, so it has nothing to do with the top level Other. But I can see how using the word "Other" in two contexts could be confusing.

Alan_Brown wrote: but I don't have much hope that the rest of the accounts will be deactivated. They have activity in them. It seems extremely likely that they will thus follow the normal rules and stick around for 3+ years.

I certainly hope that we can make those accounts inactive b/c I have a ton and it is irritating having to look through all the categories to find the 3 that I use. If I create new ones, I can at least name them something so they will be at the top of the list.

I will let this issue rest, but thanks for all the input.

I would like to add that it would be nice if I could deactivate the items under the other category that are no longer valid.
At this point, I don't see any reason why the other category needs to be locked down like the budget categories were.
Of possible interest, I have a negative $95.22 in my Budget: Administration post CUBS transfer.

ralitaco wrote:
I suggest you look at the 2 sets of reports that you printed. You need to compare the totals of the "Other" accts (main and subs) from the 17th match the total of the "Other: Payable to Local Unit" accts (main and subs).
If the totals match, you are in great shape.

Yeah, I'm off by $192.13 when comparing the two totals. Looks like I'll be waiting for further instruction to see what the issue is. If I don't see any messages in MLS, and if I don't see any action items in the statement, and if the stake finance clerk isn't sure, and no one here is knows what to do, I will probably call Local Unit Support in another week.

Thanks again!

ralitaco wrote:Because the Other:Payable to Local Unit accts are local, will they be on the Financial statements?

Yes, but not in detail. All subcategories under Other will be combined and an overall status will appear on the new statements. The other account will have action items associated with it. While we'll all know soon enough what the new statement looks like, here's the link to a sample one posted by DJC. Notice an action item for Other on the 2nd page of the "category" demo.

Well, I've waited to see if anything changed, but unfortunately I've forgotten how to reconcile the differences and things are swimming in my head again. (e.g. I'm confused)

So, before my head explodes, I thought I could ask for help here. It has now been a month and a half and I've seen two Finance statements with NO action items relating to the unreconciled differences between the two Budget Amounts (Oct 17 and Oct 24) and the Other/AMFA amounts.

So... here are my questions:

Q: How do I check to see if any MLS updates fixed my balance discrepancies between my Oct 17th balances and Oct 24th balances? (I'm guessing just a I&E report using custom dates?)

Q: If there is still a discrepancy, do I just call LUS?

THANK YOU!

coloradotechie wrote:It has now been a month and a half and I've seen two Finance statements with NO action items relating to the unreconciled differences between the two Budget Amounts (Oct 17 and Oct 24) and the Other/AMFA amounts.

So... here are my questions:

Q: How do I check to see if any MLS updates fixed my balance discrepancies between my Oct 17th balances and Oct 24th balances? (I'm guessing just a I&E report using custom dates?)

Q: If there is still a discrepancy, do I just call LUS?

First, I'd be careful of the dates you use. They will make a difference. Although you didn't enter any finances during the week of the 17th, transfers and expenses were posted by CHQ. I would use dates that match up with the Oct CUFS and UFS (old version went through Oct 19; new one picked up starting Oct 20).

I am waiting for updates to fix my balances and nothing has come down yet to correct it. The bug fixes are conveniently not being mentioned in the release notes, so there's no way to know what has been fixed and what hasn't other than playing around in MLS and seeing if your issue is cleared up.

If you run an I&E report from 1 Jan 2010 to 19 Oct 2010, the overall balance of budget should be zero and the overall balance of your Other should match the ending balance on your CUFS for Oct 1 - Oct 19. If you are affected by the bug, your balances will be negative instead (assuming Other was $0). If they are, take note of the difference. Nothing has fixed this yet and there is nothing you can do to fix it. Until they are, just know that your balances are short by the noted difference.

Calling LUS will likely have no benefit for this issue. They are dependent on the programmers fixing it.

Another observation for me, at least - the CFS for my stake shows the correct balance in Budget and Other for all my units, even though MLS is showing incorrect balances. Well, Other is definitely correct. I'll take a closer look at budget, but I'm fairly confident it's correct, too.

If this is your case as well (your statement shows correct balances but MLS does not), you need to wait for the programmers to send down a patch.

If, instead, you problem is that the ending balance of your Oct 19 statement does not match the starting balance of your Oct 20 statement, this is a bit more disconcerting. If you cannot track down the reason for the difference yourself, yes, I would call LUS.

crislapi wrote: If, instead, you problem is that the ending balance of your Oct 19 statement does not match the starting balance of your Oct 20 statement, this is a bit more disconcerting. If you cannot track down the reason for the difference yourself, yes, I would call LUS.

I was informed by LUS that you should match the Oct 19 statement's
Net Available Funds to the Oct 20 statement's beginning balance.

It is contray to the message they sent out, but matches for my unit, so it seems to be right.

- Atticus

atticusewig wrote:I was informed by LUS that you should match the Oct 19 statement's Net Available Funds to the Oct 20 statement's beginning balance.

It is contrary to the message they sent out, but matches for my unit, so it seems to be right.

That does make sense. The 19 October 2010 Ending Balance would not have included checks that were written prior to that date if they had not cleared the bank. But the Net Available Funds figure would include any outstanding checks.

The balance in MLS (both before and after CUBS) reflects all checks that have been written from MLS and all deposits made through MLS, even if those have not been processed by the bank yet. So MLS balances do correspond more accurately with the Net Available Funds balance than the Ending Balance. So the Net Available Funds balance is the one that should be used when comparing pre-CUBS and post-CUBS balances.

I think I have the same problem that's been discussed here, and it sounds like the answer is keep waiting.
My pre-CUBS statement has a balance of $45.62 in all the Other accounts. My post-CUBS I&E reports have a balance of only $13.24 in the Other accounts. But my CUFS both show a balance of $45.62 in Other post-CUBS. (No expenses out of Other post-CUBS). This is something that I just wait for a patch to fix?

Thanks,

kvnstnkr wrote:I think I have the same problem that's been discussed here, and it sounds like the answer is keep waiting.
My pre-CUBS statement has a balance of $45.62 in all the Other accounts. My post-CUBS I&E reports have a balance of only $13.24 in the Other accounts. But my CUFS both show a balance of $45.62 in Other post-CUBS. (No expenses out of Other post-CUBS). This is something that I just wait for a patch to fix?

Yes. I haven't seen a patch yet.

So who is going to explain the disparities in the Other Accounts when the audits are done in February/March with data that doesn't correlate at the end of the year?

I too am waiting for the patch for some of our wards. Not holding my breath though that it will be accomplished prior to the end of the year. That has me wondering what that is going to do to the audits. Expecting some audit exceptions that have no way of being fixed other than by the LUS folks.

Pilotfly wrote:So who is going to explain the disparities in the Other Accounts when the audits are done in February/March with data that doesn't correlate at the end of the year?

I too am waiting for the patch for some of our wards. Not holding my breath though that it will be accomplished prior to the end of the year. That has me wondering what that is going to do to the audits. Expecting some audit exceptions that have no way of being fixed other than by the LUS folks.

Unlike the bug affecting the budget balance, I have not found anything consistent with the bug affecting the other balance. That indicates to me at least that it's going to take a while to identify all the extenuating circumstances that lead to the other balance being off. The fact it's taking this long does not seem to indicate a quick fix

When auditing Other this time (and assuming the audit form has not changed), I would suggest making note of the difference between the Oct 20 MLS balance and the Oct 20 UFS starting balance and add that as an item in your "unresolved administrative office adjustments" section (just before #5 in Reconcile of "Other" Category). It is an "explained difference" and therefore should not be listed as an audit exception.

crislapi wrote:It is an "explained difference" and therefore should not be listed as an audit exception.

You are correct, if you consider that "explained" is an interesting word that does not necessarily mean "figured out" or "resolved". [grin]

Seriously, we will instruct our auditors to take notes and document, and that this discrepancy may be the norm, and not an exception, during this audit cycle.

All of our auditors are scheduled to have training on the new CUBS system before the February audits, as well.

lajackson wrote:You are correct, if you consider that "explained" is an interesting word that does not necessarily mean "figured out" or "resolved".

Good point! It definitely does not mean resolved, but I'd argue that it does mean figured out. You know what is causing the difference and you know what has to happen to fix it. However, it is out of your control to do anything about it. Can we assign audit exceptions to CHQ?

crislapi wrote:Can we assign audit exceptions to CHQ?

I wish! They would deserve one for this if they do not get it corrected. [grin]

I suspect, though, that there has already been a very big exception noted. I certainly hope the folks there are working on a solution. I would hate to think that we would need to flag the problem for them to fix.