lesson 4 reconciling transactions
Skip this Video
Download Presentation
Lesson 4: Reconciling Transactions

Loading in 2 Seconds...

play fullscreen
1 / 63

Lesson 4: Reconciling Transactions - PowerPoint PPT Presentation

  • Uploaded on

Lesson 4: Reconciling Transactions. Training Objectives. At the conclusion of this lesson, PCMS Cardholders will be able to: Query a cardholder account. View, dispute and reconcile transactions. . -. Overview - Main Window. Main Window – ID Information . Main Window – Transaction Tab.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Lesson 4: Reconciling Transactions' - jenibelle

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
training objectives
Training Objectives
  • At the conclusion of this lesson, PCMS Cardholders will be able to:
    • Query a cardholder account.
    • View, dispute and reconcile transactions.


querying transactions
Querying Transactions
  • Two Types of Queries
    • All Transactions for a Cardholder account.
    • Specific transactions.
querying all transactions
Querying All Transactions
  • Click on the Command Bar.
  • Current Cardholder Account Details Will Appear.
  • If previous accounts exist the scroll bar will become active
querying specific transactions
Querying Specific Transactions
  • Click on the Command Bar
  • Select the desired account.
  • Place cursor in any field in the Card Transactions tab and click
  • Account information will remain, field values in the Card Transaction area will clear
  • Enter value to search on and click
  • Query results will appear
  • Range operators and wildcards can be used
practical exercise
Practical Exercise
  • Query all transactions and view the first transaction in the list returned.
  • Execute a specific query to find all transactions where the Merchant is located in California (CA).
  • Query transactions greater than $50.00.
  • Search for all Merchants containing the word “ACE” in their name.
  • Note the transaction detail information. Can you determine if a Purchase Card or Convenience Check was used to make the purchase?
reconciliation process
Reconciliation Process
  • View the transaction in PCMS.
  • Verify the transaction details are correct against paperwork and ensure all details are correct.
  • Select an Action Code.
  • Enter Comments and Dates.
  • Modify lines of accounting if necessary.
  • Save transaction.
reconciling check transactions
Reconciling Check Transactions
  • Cardholder must obtain the Merchant’s TIN at the time of purchase .
  • The Merchant Address, Merchant City, Merchant State, and TINfields will appear white. Enter this information when the transaction Is approved. For checks to foreign merchants, enter the city, country, and postal code in Merchant City, two zeroes in State, and leave Zip blank.
  • The check number will be entered by the bank and appear in Check Number field on the transaction screen.
action codes
Action Codes

Days to reconcile

from date of purchase:

U – 30 days

Q – 30 days

D – 60 days

modifying lines of accounting
Modifying Lines of Accounting
  • To modify a line of accounting currently attached to the transaction, click modify. Line is copied to the bottom part of the window, except for the Account Description value. Change the data as needed. Repeat these instructions for each line to be modified.
  • To modify all current lines of accounting, click Modify All Acctg. All current lines of accounting are copied to bottom part of the window. Change data as needed.
  • Click Saveon the Command Bar to update the database
reconciling credits
Reconciling Credits
  • Transaction Credits have a minus sign ( - ) in front of the transaction amount:
    • View the Transaction.
    • From the Transaction Maintenance window, change Action Code to Approved.
    • Click Saveon the Command Bar.
locked transactions
Locked Transactions
  • Locked is the only status that will prevent a cardholder from being able to reconcile.
  • Accounting statuses are
    • O = Obligated
    • P = Paid By FFIS
    • N = New (not obligated and not paid)
    • L = Locked
practical exercise33
Practical Exercise
  • Reconcile the transaction to “Sita Business System” in the amount of $172.00 using the following information:
      • Approve the transaction.
      • A computer cart costing $172.00 was due for delivery on July 23rd 2002.
      • The goods were received a day later than expected, due to inclement weather.
practical exercise34
Practical Exercise
  • 2. Reconcile the transaction to “Standard Copy Products” in the amount of $2,195.00 using the following information:
      • Approve the transaction.
      • Copier materials were shipped same day delivery on July 22nd 2002.
      • Goods\services were received on the date expected.
      • The correct BOCC formation for this transaction is: 2672.
practical exercise35
Practical Exercise
  • 3. Reconcile the transaction to “Transcender Corporation” in the amount of $2,644.00 using the following information :
      • Approve the transaction.
      • The PC and monitor were received on July 21st 2002.
      • There is currently not a description available for the SF-281 code.
      • The accounting information needs to be distributed across the following accounting codes and BOCCs:
        • Accounting Code _____, BOCC _____, Distribution Percent 50%
        • Accounting Code _____, BOCC _____, Distribution percent 50%.
practical exercise36
Practical Exercise
  • 4. Reconcile the check transaction to “Wilson Carpet Service” in the amount of $1,000.00 using the following information :
      • Approve the transaction.
      • Check no: 001009.
      • Merchant location: Alexandria, VA.
      • Tax ID no: 52-7600000.
      • Purchase date was July 22nd 2002 and goods\services were received one week after purchase date.
      • Bank fee should be calculated at 1.5% of the check amount.
      • Approve the bank fee associated with this check transaction.
practical exercise37
Practical Exercise
  • Reconcile the transaction to “Nyma Inc.” In the amount of $59.00 using the following information:
      • Only 5 of the 10 glass beakers were received on 07/30/02, due to low stock supplies. The remaining 5 beakers will be shipped on 08/07/02 (next day delivery).
      • Unit price is $5.50, shipping and handling is $4.00.
      • Invoice number: 56084.
      • Order number: w58625-hav.
practical exercise38
Practical Exercise
  • Reconcile the transaction to “Corvision Media, Inc.” In the amount of $705.00 using the following information:
      • The goods\services were received on the date expected, July 21st 2002.
      • Order was for cable cutter (hydraulic) $678.60; twist drills ¼” diameter, 6-1/8” overall length $26.40.
      • The twist drills you received were 1\2” diameter.
when to file transaction disputes
When to File Transaction Disputes
  • Filing Transaction Disputes
    • Before lodging a dispute in PCMS the Cardholder should investigate the problem and try to resolve it
    • File a dispute when the invoice amount or goods\services received are not in keeping with what the Cardholder purchased
    • Cardholders have 60 days from the date of purchase to dispute and resolve a transaction
    • A dispute cannot be filed for a transaction made using a Convenience Check or for Convenience Check fees
how to dispute a transaction
How to Dispute a Transaction
  • On the Card Transactions tab, select the transaction by placing the cursor in one of the fields on that line.
  • If the dispute is over merchandise not received, leave Date Received blank until the merchandise is actually received.
  • Go to the Transaction Maintenance tab and provide the appropriate reconciliation information.
  • Go to details of the dispute on the Disputes Maintenance tab.
    • PCMS will populate Purchase Date, Merchant Name, and Reference Number based on the existing transaction information.
  • Enter details of the dispute
  • Click the Save button on the command bar.
resolving disputes
Resolving Disputes
  • To resolve the dispute, query the transaction and go to the Disputes tab.
resolving disputes43
Resolving Disputes
  • Enter Date Resolved
  • Go to the Transaction Maintenance tab and update accounting information, if necessary.
  • Go to the Transactions tab and change the Action Code to Resolved.
  • Click Save on the Command Bar
transaction credits debits
Transaction Credits & Debits
  • A transaction must be paid before it can be disputed.
  • After payment has been made, the description field of the transaction will display the message Accepted by FFIS.
  • If cardholder disputes a transaction, bank issues temporary credit to cardholder account while it investigating the dispute.
transaction credits debits45
Transaction Credits & Debits
  • The temporary bank credit is called a Retail Credit.
  • Retail Credit Adjustment will appear in Merchant Name with a minus ( - ) sign preceding the transaction amount.
  • The Cardholder must reconcile this transaction by approving it.
  • The bank tries to resolve the dispute with the merchant.
transaction credits debits46
Transaction Credits & Debits
  • If the Dispute Is Found in the Cardholder’s Favor:
    • A transaction credit will be issued by the merchant.
    • Retail credit adjustment will appear in Merchant Name with a minus ( - ) sign preceding the transaction amount.
    • The Cardholder must reconcile this transaction by approving it.
    • The Cardholder disputed then places the transaction in a resolved state.
transaction credits debits47
Transaction Credits & Debits
  • If the Dispute Is Found in the Merchant’s Favor:
    • The bank will issue a Retail Debit, which offsets the temporary credit.
    • A credit from the merchant will not be generated. The original charge to the cardholder account will stand.
    • Cardholder is NOT informed by the bank that dispute found in the merchant’s favor.
    • When Retail Debitis received, Cardholder should approve debit and place disputed transaction in a resolved state.
practical exercise48
Practical Exercise
  • Reconcile the Transaction to “Sita Business System” in the Amount of $432.50 Using the Following Information:
      • Goods\services were received on the date expected, July 18th 2002.
      • Invoice states order placed was:
        • 2x black briefcases (unit price $43.55)
        • 1x audio visual cart 27” (unit price $320.45)
        • shipping and handling was $24.95.
      • The amount charged on the invoice for the AV cart was not the amount quoted at the time of purchase, which was $220.45.
summary and review
Summary and Review
  • What are the differences between reconciling transactions made with Purchase Cards and transaction made with checks?
  • How do you query transactions valued greater than $200?
  • How do you navigate between transactions without returning to the query screen?
  • What is the process you follow if you find a discrepancy between the cost of the item on the invoice and the transaction value in PCMS?
  • If you order a set of 10 items and only 5 are in stock and shipped to you, what is the reconciliation process you would follow in PCMS?
  • What is the process for disputing a transaction?
  • What is the process for resolving a disputed transaction?
training objectives51
Training Objectives
  • At the conclusion of this lesson, PCMS Cardholders will be able to:
    • - Generate a Cardholder Report based on date ranges.
cardholder reports
Cardholder Reports
  • Reports Menu is Located on Main PCMS Window
  • Generates the Cardholder Report
  • Report Generates All Transactions for a specific Cardholder Account
date range
Date Range
  • Specifies the date range for the report.
    • Enter the date in the following format: DD-MMM-YYYY
    • For example November 1st 2002 would be entered as: 01-Nov-2002
    • Date format is not case sensitive.
saving a report
Saving a Report
  • The best format for saving a report is HTML or TXT.
    • Go to File > Save As
    • In Save in box, navigate to the location where you want to save the report.
    • In File name box, enter a name for the report.
    • In Save as type box, click down arrow to see choices. Select one of the following:
      • Web Page, HTML only (*.htm, *.html)
      • Text File (*.txt)
    • Accept default listed in Encoding box.
    • Click Save.
printing a report
Printing a Report
  • Reports print best when page orientation is set to Landscape.
    • Go to File > Page Setup
    • Find the Orientation in the lower left portion of the dialog box and select Landscape.
    • Click OK.
practical exercise62
Practical Exercise
  • Generate a Cardholder Report
  • The report range should be for the entire last month
  • Save the report to an html file on your c:\ drive called “myreport.html”
summary and review63
Summary and Review
  • What is the date format the report feature uses?
  • How do you generate a report that will display on the screen?
  • Why would you generate a report?