Pay AP Invoices with Bank Purchase Card through an upload to the bank

 have a client that wants to do the following...

"Process AP invoices just like we currently do, but the vendor set-up will reflect it being a credit card payment (i.e. rather than live check or ACH).  When we process the weekly AP batches, we will end up with 3 registers:  checks, ACHs and purchase cards.  The purchase card register will be uploaded to Key Bank’s website for processing." 

Any suggestions for how to handle this? 

Options I can think of...

1 –

  • run a check selection based on the UDF credit card vendor
  • print fake checks
  • print the check register then a custom report to upload to key bank

 

2 –

  • run a custom report on open invoice to identify invoices based on the UDF credit card vendor
  • print a custom report to upload to key bank
  • write a VI import into manual check entry to mark the invoices as paid

Any other ideas?  Any advantages or disadvantages to 1 or 2 above? 

  • 0

    The upload to Key Bank isn't an ACH format?  I'm unsure how this wouldn't be similar to a credit card vendor with an ACH payment which Sage supports natively.

  • 0 in reply to Wayne Schulz

    No, it's not an ACH format for payments made with a credit card - there's no banking information.  Here's the specifications from Key Bank. 

    MerchantCode                                              REQUIRED

    InvoiceNumber                                            REQUIRED max (50)

    InvoiceDate (mm/dd/yyyy)                    REQUIRED

    InvoiceAmount                                            REQUIRED

    UDF1Label                                                     max (50)

    UDF1Value                                                    max (50)

    UDF2Label                                                     max (50)

    UDF2Value                                                    max (50)

    UDF3Label                                                     max (50)

    UDF3Value                                                    max (50)

    UDF4Label                                                     max (50)

    UDF4Value                                                    max (50)