x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 239 subscribers
  • Views 361 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
188
topics
442
replies
WarrenH

What are the differences with CM the Status codes C or R and how are they created?

SUGGESTED
Posted By

Somehow we have many of our reconciled transactions showing up as a C rather than an R. I'm not sure why or how, but I'm curious how the system treats a C vs an R. In terms of reports, cleared balances, ect, how are they handled differently? 

My understanding is the C status is for importing cleared checks (which we've never used). I wonder if we should look at it. I'm not sure if it could help us or not.

So that said, I'm not sure how we have C status items in our register. I'm guessing somebody had to manually assign them a "C" in an edit register session? Most of the transactions we've analyzed are on our bank statements and should have been an R from when the account was reconciled. 

I think a C only created by importing or edit register. And is R only created by reconciling or edit register. Is that correct?

Thanks!

  • 0
    SUGGESTED

    Hi Warren,

    It will also show "C" if you have a Reconcile in progress that has not been Finished yet.

    The Cleared status is used to indicate items cleared between bank statements. So you are correct about Import Cleared Checks will assign them to C. Also in Edit Register if you are manually clearing items between bank statements where you may check your bank account online for items that have cleared and mark them as such.

    Then in the Reconcile task, if you mark the box to automatically reconcile cleared items, anything with a Cleared Date on or before the Statement Date will get updated to Reconciled "R".

    But they don't update to the "R" status until that Reconcile session is Finished.

    Another thought, if someone unreconciled items for error correction and did not re-reconcile them (did not change them back to "R" status and only marked as Cleared), that will create a problem too.

    This Sage Knowledgebase article helps explain how those statuses affect the balances on the bank How are Cash Management bank account balances derived? (55050)

    Does that information help?

    April Dahl

*Community Hub is the new name for Sage City