PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 6/1/2016 11:34 AM by  facendaa
Credit Card Processes
 5 Replies
 3 Subscribed to this topic
 147 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Author Messages
toria1248
Accounting Systems Analyst
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
4/28/2015 3:52 PM
    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
    Business Systems Analyst
    Harford County Public Schools
    Basic Member
    (23 points)
    Basic Member
    Posts:11


    Send Message:

    --
    5/1/2015 1:16 PM
    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
    ERP Business Systems Analyst II
    Group Health Cooperative
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    5/1/2015 2:01 PM
    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
    Private
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    5/1/2015 3:20 PM
    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
    Financial Systems Analyst
    City of Boise
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    5/18/2016 1:48 PM
    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
    Director of Accounts Payable
    NFI Industries
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    6/1/2016 11:34 AM
    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.
    You are not authorized to post a reply.