Paying AP Invoices by Credit Cards

Currently we enter AP Invoices under the company name then on the due date we pay by credit card and make a flip to remove from the vendors name into the appropriate Credit card AP account..  Is there an easier way to complete the flips without entering DM to the Vendor and reentering the AP voucher under the CC companies account?

  • 0 in reply to BKM

    Current plans, subject to change and all that is this year :). I don't want to be more specific than that just yet.

  • 0 in reply to dbcoles

    I am really looking forward to the 2015 release.  A lot of  good upgrades are suppose to be coming.  Cant wait

  • 0
    Since the latest release of 500 didn't address this issue as expected, we found a workaround, which is actually much easier to manage than the solution that our Sage partner had available. It requires that you treat your credit card payable as a separate liability on your balance sheet rather than treating it as another vendor in your AP.

    We set up the credit card liability accounts as banks, which allows us to cut "checks" to our AP vendors via the credit card "bank account". (I was surprised the system would allow us to assign a liability account to a bank, but it did.)

    I designed a new check form for Crystal Reports that lists all the invoices being paid via that credit card and has verbiage directing the vendor to charge the credit card on file (last 4 digits included), with a spot for an approval signature (just as if it were a check). When we're paying a vendor by credit card, we simply choose that "bank" and print the "check" using that form, then send (usually via email) to the vendor for processing. The vendor invoice is marked "paid", and the records indicate that we paid it by credit card. Additionally, the credit card liability is increased by the amount of the payment.

    One thing I didn't like about the DM solution was that you couldn't run reports on total spend by vendor - they were always zero because everything had been offset by the DMs.

    To record non-AP credit card purchases, I created an Excel workbook (with macros) which uses the transaction download from our credit card company. The user simply marks the items that were AP payments and assigns a GL account to the other purchases, then the macro creates a Journal Entry import file which records those expenses and the credit card liability. The comment field of each line includes the vendor name so that you can see that detail in your GL reports. The macro ignores the AP payments since those were already posted via the AP check process described above. If your non-AP vendor credit card purchase volume is relatively low or if you don't require the purchase detail in your GL, you could simply enter a summary journal entry manually for the non-AP credit card purchases each month.

    The result is MUCH easier AP payment via credit card, better history of vendor payments & purchases, and more detailed information about non-AP credit card purchases in our GL. I'm happy to share more details about this if anyone has questons.
  • 0 in reply to Penny C
    Then what is the process when you pay your credit card bank/ liability acct?
  • 0 in reply to An888_
    We process the payment to the credit card as a bank transfer from one account to the other, which works for us since we pay online instead of by check.
  • 0 in reply to Penny C
    Thank you for your answer Penny, much appreciated !