Table of Contents

1. Setup a G/L Clearing Account.  This Account will be used to clear the Buy-From Vendor transactions. G/L

    Accounts can be accessed from Departments à Financial Management à General Ledger à Lists à Chart

    of Accounts.

1. Define a unique Payment Method for each credit card the food bank is billed for.  Payment Methods can be

    accessed from Departments à Financial Management à Payables à Administration à Setup à Payment

    Methods.

2. Click New on the Home Tab to create a new Payment Method. 

3. Enter a Code and Description. Link the G/L Clearing Account to each credit card Payment Method as follows.  

1. Create a vendor for each credit card the food bank is billed for.  Vendors can be accessed from

    Departments à Financial Management à Payables à Lists à Vendors.

2. Link each credit card vendor to a unique credit card Payment Method.

3. Leave the IRS 1099 Code field blank.  The credit card Payment Method will not allow an invoice to be subject

    to 1099 to comply with the 1099-K requirements which requires the credit card processor to report 1099

    amounts for credit card payments.

1. Setup a Vendor CC Invoice Number Series with a Starting Number.  The No Series Setup can be accessed

    from Departments à Financial Management à Administration à Setup à No. Series. This is the No. Series

    that will be assigned to create purchase invoices when the credit card transactions are imported.  Manually

    entered credit card transactions will be assigned whatever Number Series is selected when the purchase

    invoice is created. 

2. Link a No Series to the Vendor CC Invoice Nos. field in the Purchases & Payables Setup.

1. Create a purchase invoice or purchase order.  In the Buy-From Vendor No, select the vendor who the

    transaction was purchased from.  This requires a vendor be setup for each entity you purchase from even

    though the transaction will be paid via the credit card vendor.

2. On the Invoice Details FastTab, select a credit card Payment Method.  The Payment Method that is selected

    should align with the credit card that was used for this purchase.

3. Enter the purchase invoice lines like you normally would.  A single invoice can be entered for

    each transaction or transactions can be combined on a document.  The key is that transactions need to be

    entered based on the vendor they were purchased from.

4. Post the purchase invoice.  When the invoice is posted, entries will be created for both the Buy-From

    Vendor (vendor entered on the purchase invoice ) and the Pay-To Vendor (credit card vendor). 

5. Two entries will be recorded (Invoice and Payment) for the Buy-From vendor.  Whereas a single entry

    (Invoice) will automatically be records for the Pay-To Vendor.   This allows the original transaction to be

    tracked against the Buy-From Vendor, and the payment to be tracked and made against the Pay-To Vendor.

6. The G/L clearing account (account 281000 in this instance) associated with the credit card Payment Method,

    was used to offset the Payment to the Buy-From Vendor and to record the Invoice to the Pay-To Vendor.  

    The net effect is $0 in the G/L Clearing Account.   The G/L accounts that were entered on the purchase

    invoice lines, posted as is and are associated with the Invoice to the Buy-from Vendor.  Please note the

    Source Name (Vendor Name) associated with the transaction displays in the General Ledger Entries. 

7. Credit card purchases can be reversed via a purchase credit memo. On the purchase credit memo select the

    same Buy-From Vendor and the credit card Payment Method that was used for the original transaction.   If

    the Copy Document functionality is used, the Payment Method Code is copied along with the amount and

    other parameters. 

1. Credit card purchases can be imported from an Excel file by running the Import CC Transactions Excel

    function. 

2. The import is accessed from Departments à Financial Management à Periodic Activities à Payables à

    Import CC Transactions Excel.   Purchase invoices are created for each combination of Vendor No., External

    Doc No., Payment Method Code, Fund No, and Global Dimensions when the Excel file is imported.

3. From the Import CC Transactions Excel Page, select the Workbook File Name and the Worksheet Name

    Toggle the Auto Post field to automatically post the purchase invoices that are created.  If Auto Post is not

    selected, when the import runs, the purchase invoices that were created will need to be posted manually.

4. Click the OK button to launch the import.  An import dialog will pop indicating % complete.   Once the

    import has completed, a message will pop up indicating the entries have been successfully imported. 

5. As noted above, a separate purchase invoice will be created for each combination of Vendor No., External

    Doc No., Payment Method Code, Fund No, and Global Dimensions when the Excel file is imported.  

6. The purchase Invoice number that is assigned is based on No Series assigned to the Vendor Invoice Nos.

    field in the Purchases & Payables Setup.

7. If invalid data exists in the data file (such as an invalid Vendor No, Fund No, G/L Account No, Dimension

    Code),  or if the data file is blank, the below message will pop up.  Because the file could contain multiple

    errors, the message will not display the errors that was encountered.  

8. The import will continue even if invalid data is encountered.  For each transaction combination, a separate

    purchase invoice  will be created regardless if purchase lines could not be created because of invalid data 

    invalid purchase documents will not be posted).  The data can be updated in the file and then re-imported.  

    Before re-importing verify which transactions have been created and what data was imported.  Depending

    on the volume of transactions, it may be easier create a data file just for the transactions that did not import

    and/or had errors.   You may also manually update the purchase invoices with the correct data or delete all

    of the purchase invoices that were created and the re-import the entire file.  

9. If Auto Post was not selected when the import was run, the purchase invoices that were created will need to

    be posted. In the below example, the purchase invoices that were created from the import are easily

    identified by the CCI-XXX No. that was assigned.  Review and update the purchase Invoices as needed and

    then post.

10. To import the transactions, the Excel file (xlsx format) must be defined as follows.