Credit Card statments with job cost

Hi Can I have someone reach out to me I have questions on how to enter credit cards transactions with job # and cost codes as well as GL #'s in AP without entering over 100 lines manually?  

  • 0

    We have this issue also.  I have about 25 employees with a credit card.  We make them turn in their receipts with the job number on it and enter it that way into a "dummy" GL account so it can post to the job in real time (or as soon as they turn in the receipt)  Then when our credit card bill comes in we just summarize all the charges per ledger expense account ex travel expense, sundries, etc.   It's the easiest way I've found to do it.  you are still entering each receipt to the job but it helps when you have to reconcile the actual bill.

    If you find a better way, let me know.  It's been an obstacle for us forever.

  • 0

    We also use the credit card feature. What I've found most helpful is to set up credit cards for each person. When they make a charge you can then enter the receipt for each item as they come in. When the statement arrives, you can use the 'Verify Statement Balance' by selecting each transaction and create an invoice for each card. We used to use an Excel spreadsheet to separate everthing and then enter all the lines manually. This has saved much time and frustration.

  • 0

    Hi we import our transactions (Wells Fargo) using a CSV file direcly into Paperless.  Once they are in there we create individual invoices (per card holder) and we are able to route the invoices for coding and approval.  Receipts are uploaded using Ecapture and matched after the individual credit card invoices are created.