Mugo,

Cash Management feeds entries to GL, not the other way around. If you have to post a bank charge, or a cash transfer between accounts that you maintain in CM, you would book the entries in CM, and in the case of bank charges or other miscellaneous debits that hit your accounts, or miscellaneous deposits that aren't entered through Accounts Receivable, you indicate the offsetting GL accounts. There is a bank transfer function within CM that utilizes a "Cash Transfer Clearing" account that you specify in the CM > Settings.

I don't exactly understand your question about AP needing a clearing account. Checks written in AP automatically post detailed entries to the CM bank account used to write checks, with an offsetting summary entry posted to the GL Accounts Payable account.

To keep your CM bank accounts in agreement with the respective GL accounts, you would never want to use GL > Record Entries to affect a GL bank account balance.

Art Minds
Independent Consultant
Pasadena, CA

thanks a lot .. i'm fairly new to this system , i was trying to understand the mechanics behind it .. As for my AP question , i noticed AP posted payments to a clearing account and then someone would post the entries from clearing account to the actual bank account in CM .. which i think was an added step which is unnecessary and slows the bank reconciliations ...
So the best way to fix a CM transaction entered in G/L would be to enter a reversal entry in G/L and enter the correct entry in CM, correct ?
Is there a way i can obtain documentation for end user on Bank Recs (CM) , the help feature isnt helpful i find ..

thanks again ,
Mugo

Mugo,

The GL assignment for each CM bank account is found under CM > Setup > Bank Account on the "GL Cash Accounts" tab. There is an option for each bank account to use separate cash accounts per application, where you can link a bank account to specific GL accounts for AP, Payroll, Receivables, Property Management and Residential Management. I have not used separate cash accounts in any installation that I've performed, nor do any of my current clients use separate bank accounts. I have also not seen a configuration where the bank account is assigned to a GL clearing account rather than the actual GL account representing the bank account.

I'm not sure I understand what you're describing regarding AP posting payments to a clearing account, and then someone posts those entries to the actual bank account. When writing checks in AP, the bank account selected to print checks is a CM bank account. Each and every check written in AP from a specific bank account will be entered in detail in CM to that bank account as a "subtraction" and a summary total of the check run will be credited to the GL Cash Account specified on the CM Bank account setup. The debit account for a check run is usually the GL Accounts Payable account.. There is no need for any manual entries in CM arising from a check run in a normal configuration.

Your access to various settings in the system are controlled by security permissions, and if you don't have access to some of the settings I'm describing you may not have sufficient security permissions.

I would be happy to speak with you by phone if you would like further explanation or have additional questions. You can send a private email to me with contact information.

Regards,
Art Minds
[email protected]

Hi Mugo,

We have a knowledgebase article with a workflow to perform a bank transfer using a physical check. This workflow uses a clearing account. The article ID is 29756.

As far as reconciling your bank statements, knowledgebase article 31675 has instructions for that.

You can access the knowledgebase at https://support.na.sage.com

April Dahl