Using Find Customer Payments - OSU for Accounts Receivable Reporting and Reconciliation

About Accounts Receivable Reporting and Reconciliation

Reconciliation confirms that your account balances in the General Ledger are accurate and can help you identify and correct any discrepancies. Two tasks are required to complete an accounts receivable reconciliation: reviewing customer invoices outstanding and ensuring your total accounts receivable balances agree with the outstanding amount.  

How often you reconcile your accounts receivable and when is determined at the unit level; follow established departmental procedures and guidelines. You may also review the University Controller's Reconciliation Guidelines  for additional guidance. 

Contact your Senior Fiscal Officer, Cost Center Manager, or other departmental finance leader with questions about reconciliation. 

Find Customer Payments - OSU

Use this report to find payments applied toward open customer invoices. 

Questions this report can answer

This report can help you answer questions such as: 

  • How can I find payments toward my invoices?
  • When did my customer's payment arrive and get posted?
  • Which payment method did my customer use? 
Recommended Filters

The following are recommended. Other filters may be required, depending on your business need. 

  • Customers = customer(s) for whom you would like to search
  • Customer Group = your college or VP unit (see Notes)
  • Payment Date On or After = beginning of reconciliation date range
  • Payment Date On or Before = end of reconciliation date range
  • Transaction Reference = OUB
  • Include Deposited Payments = Flagged

Notes

  • Use the Customer Group filter to limit your results to accounts receivable operations within your college or VP unit. Additional data manipulation may be required to identify customer payments specific to your worktag combination.
  • Entering “OUB” in the Transaction Reference filter will narrow your search results to only payments processed and deposited by the Bursar
  • Payment application (which payment paid which invoice) cannot be determined using this report.
  • Payment Types:
    • Check Deposit – customer mailed a paper check payment to the Accounts Receivable PO Box
    • EFT – customer paid by wire transfer
    • OAG Payment – customer in Collections with the Ohio Attorney General made a payment 
    • Online Check Payment – customer paid online using their bank account and routing number
    • Online Credit Card Payment – customer paid online using their credit card