Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Import Macro Repair

...

  1. DuckDepot credit card statements are made available online through US Bank on the 26th of every month. Accounts Payable Specialist prints out report for the reconciliation process.
  2. AiM: Print out the AiM PCard Reconciliation report list corresponding to the DuckDepot card being reconciled.
    1. Log on to Aim
    2. From the home page – select Accounts Payable (left-hand menu)
      • Select Report listing
      • Select PCard Reconciliation Report to load the information report
    3. Print out the report
  3. Match each line item on the credit card statement to its corresponding line item on the AiM PCard Reconciliation report, this is done by matching the SQXXXXXXXX or PO numbers

    • Note: PO numbers in AiM are SQ numbers for DuckDepot transactions
    • If amounts do not match, this discrepancy refer to the Fixing PO Discrepancies in POI section
  4. At this point, a Purchase Order Invoice transaction must be created to track payments made in AiM
  5. AiM: Return to the PCard Reconciliation report
  6. Log on to Aim
  7. From the home page – select Accounts Payable (left-hand menu)
    • Select Report listing
    • Select PCard Reconciliation Report
  8. Select the desired Purchase Order (PO) number in the report to load the specific PO Page
    image2019-4-12_11-51-32.pngImage RemovedImage Added
  9. Select Purchase Order Invoice
    1. This will load a Purchase Order Invoice transaction (UPDATE SCREENSHOT)
  10. Enter the vendor the POI description box

  11. Enter the D00XXXXX number in the Invoice Number field
    1. Add alpha characters at end if D00XXXXX has already been used on a prior POI
  12. Enter the date of the DuckDepot transaction (this can be found on the USBank credit card statement)
    image2019-4-12_11-52-25.pngImage RemovedImage Added
  13. Confirm the DuckDepot card is correct in each Line Item in the POI
    1. Select the Line Item 
    2. The DuckDepot card number can be found in the External Reference Code field
  14. Select Done to update the Line Item and return to the POI
  15. Repeat the above step for each Line Item in the POI
  16. Return to the POI
  17. Select User Defined Fields 
    1. Fill in the Banner Doc Num UDF with D00XXXXX 
    2. Select Done
  18. Select the query icon on the Status bar
    1. Select Approved
  19. Save the PO Invoice
  20. Select the query icon on the Status bar
    1. Select Paid
  21. Save the PO Invoice
  22. Repeat procedure until the entire statement has been reconciled and all DuckDepot PO’s have been matched.

...

Page Properties
hiddentrue


Related issues