Sage 100

What am I missing - the customer is asking best practice for processing credit card payments of open AR invoices. I have gotten them to use a clearing account for the credit cards applied on SO or IN. Then we move the amount from clearing over to the cash account with another CR. However, with a regular cash receipt if a customer pays by CC that $$ seems to go directly to the cash account even if I specify that the payment type was credit card (I was hoping that it would pull that amount to the CC clearing account). Do people create a separate bank account code to deal with credit card payments on account? Or have I missed a step? It seems like I'm overlooking something simple here as to how I get the credit cards transactions used to pay open invoices bundled into one amount via the use of a clearing account.

I have users enter 2 GL lines as part of the cash receipt entry against the card. As you found, cash receipts automatically debits cash so after they pick the invoice, I have them entering a GL line that credits cash and another GL line that debits the credit card clearing account.

I think I may have found the problem. The customer was using an older TST company where I hadn't changed the CC payment GL accounts to equal the clearing. Once I changed the payment GL account to point to clearing it all seems to work just fine. If I enter a cash receipt and specify that it is a CC type payment then Sage looks to the payment type GL as to where to post. It also appears that if I specify the payment as CC type that Sage won't double count the $$ in the cash receipts report (since I'm picking that up when I move it from clearing to regular cash via a second CR). TL;DR: I was trying this on an old TST company code. Once I went into payment type maintenance and changed all the CC types to point to a CC holding account things worked as I expected.

I went back and looked at my notes. In my situation they're entering cards that were processed outside of the system. Since they do credit card processing both inside of Sage and outside, they can't flag it as a credit card receipt or it would get doubled up. So they have to hit cash and then back it out again.

I think Sage missed the boat in not developing a separate cash management module.

That's not the only boat they missed!