Overview

---

 This article will cover:

• How to fill out the attached Merchant Receipt Template in Excel to clear the Oracle Credit Card Clearing Account Balance
• How departments, Financial Units, use the Merchant Receipt Template that:
  
  • Accept credit card payments via credit card terminal or website
  • Aren't invoicing in Oracle and need to book revenue to a Chart of Account (CoA) 

Critical Concepts

---

• If you need the Merchant Receipt Template, email merchantservices@ucsd.edu 
• Any inquiries, please contact Merchant Services
• Best practice is to:
  
  • Complete and submit the Merchant Receipt Template at the beginning of the month when the previous month has closed
  • Run the General Ledger Transaction Details Report within the General Ledger Panorama and reconcile against your business records
• Run the General Ledger Transaction Details Report in the Panorama, in Procedure A, before completing the Merchant Receipt Template in Procedure B
• If you have variances, use ClientLine reporting to research bank deposits
  

Steps to Take

---

Procedure A

1. KB0032936 provides instructions on How to Run General Ledger Detail Report

2. Alternatively, you can access this report from the Oracle home page:

• • Select Tools module
  • Select Reports and Analytics
  • Click Browse Catalog and find the report from Shared Folders > Custom > Financials > General Ledger > General Ledger Transaction Detail > General Ledger Detail Report
    
  • If this report is accessed from Financial Reporting Center and then Open Workspace for Financial Report path, you cannot fully utilize the report functions, especially drill-down function by using Action Link

3. Include this information on the Merchant Receipt Template, Oracle-GL Detail Trans tab

For additional guidance on OFC GL Reports please reference KBA0032374 How to Check a Fund Balance or Balance on Chart String Segments

Procedure B

1. Open the Merchant Receipt Template

2. There are two tabs on the Merchant Receipt Template

a. Form: complete form as directed beginning in Step #4, form includes sample data

b. Instructions: additional instructions for completing form

3. Complete the following fields in the Merchant Receipt Template on the 1st tab

4. In Merchant Name, select your business from the drop down, which populates the Activity Code field 

5. In GL Values, enter

a. Entity

b. Fund

c. Financial Unit

d. Account 

6. In Business Unit, select Business Unit

7. In Comments, if needed, add applicable comments

8. In Deposit Date, enter date of transactions

9. In Amount, enter daily credit card batch total, which must tie to daily batch amount

10. In Customer Account, enter Customer Account if applying payment to an invoice (see* below)

11. In  Transaction (Inv)#, enter Transaction/Invoice # if applying payment to an invoice (see* below)

12. In Project, enter Project# only if booking revenue to a Project

13. When you are complete entering the information in the file, save as, using this file naming convention, e.g.: UCSD SURPLUS SALES APR2022_CC0128

Below is an example of a completed Merchant Receipt Template

Procedure C

Submit completed form to Merchant Services via Services & Support Finance Portal

1. I want to: Ask a Question or Make a Request

2. About: Banking, Cash & Card Products

3. Related To: Merchant Services

4. More Specifically: Merchant Receipt Form

5. At bottom of ticket request, select Add Attachments, attach Merchant Receipt Template

6. Submit