Credit Card Processes

 5 Replies
 3 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
toria1248
New Member
Posts: 1
New Member
    Hello,

    I was wondering if anyone had any suggestions on how to import credit card transactions? We currently upload every credit card by month separately as a Journal Entry. And the more we grow, the more users receive credit cards and it came up in discussion - how do other companies handle their credit card purchases?

    From what I've seen there's a P-card module? We currently don't utilize it. How useful is the module? Or does anyone use an external software to track their detail and upload it into the GL? Or is a good method doing it by journal entry directly into the GL?

    Any suggestion helps!

    Thanks everyone!
    Toria
    Gary Stone
    Basic Member
    Posts: 11
    Basic Member
      Hi Toria,
      We essentially do the same as you with uploading the credit card information into GL. I attempted to work with the PCard module because we wanted to track overall vendor spend. Some of the problems we had with doing that it was hard to trace spending back to miscellaneous purchases as well as the user of cards. The reports available through the PCard module were not sufficient for us to use for audit. By utilizing the Journal entries, we are able to track expense back to the individual. As you can tell, we elected not to use the PCard module and continue to use the upload process. Hope you find success in processing those transactions.
      Thanks,
      Gary Stone
      NicoleGrass
      New Member
      Posts: 2
      New Member
        Hi Toria
        We use Concur for our Pcard and employee out-of-pocket reimbursements. A daily file is sent from Concur, which we import into Lawson AP. Detailed reports we build in Concur.

        =]nicole
        Emilio Delgado
        New Member
        Posts: 1
        New Member
          We here at CSU (Colorado Springs Utilities) have worked with Kinsey to develop a small COBOL interface program that takes the raw transaction data we download from our bank's secure web site and prepares it (makes a csv file) for use with the delivered Lawson PD570 - The process is pretty simple.
          Lawson also has the PD130 that automatically creates the invoice to pay the bank.
          We've used Design Studio to work with the reconciliation screens (PD20) and process flow to actually process "member lists" (the banks record of who has what credit card number) (essentially replicating the PD00, PD10 and so on process for adding cards).
          This is all in development for us at this point.
          John W 123
          Basic Member
          Posts: 5
          Basic Member
            We would be very interested in your implementation of P-cards. At the city we are planning to use the module but will be developing a front end "pre-processing" of the bank file to assign accounting strings based on MCC for transactions <=$75. Our goal is to reduce the manually intensive work done by purchasing to download the bank file and uploading to the Lawson JE.
            Retired, no longer active.
            facendaa
            New Member
            Posts: 1
            New Member
              We process our invoices under a separate process level, cash code and payment code for our credit card process. We use a balance sheet account to manage the reconciliation to the actual statement. We do not use the PCard module as we had this in place years prior to this. We have also had our bank provide us with a file of our single use card transactions so we can reconcile this automatically.