Using Find Find Journal Lines - 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 Journal Lines - OSU

Use this report to find the journal transactions written to the General Ledger when a customer invoice is created. Output includes both the credit and debit side of the transaction. 

Questions this report can answer

This report can help you answer questions such as: 

  • What is the accounting associated with my customer invoice?
  • Where on the General Ledger is my customer invoice written?
Recommended Filters

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

  • Company = The Ohio State University
  • Year = FY[20XX]
  • Period = fiscal period you wish to search
  • Journal Sources = Customer Invoice
  • Accounting Date On or After = beginning of reconciliation date range
  • Accounting Date On or Before = end of reconciliation date range
  • Worktags = worktags associated with customer invoices (see Notes)

Notes

  • Most customer invoice accounting transactions write the debit to Ledger Account 12000: Accounts Receivable and the credit transaction to Ledger Account 42000: Sales and Services.
  • Memos recorded at the line level on a customer invoice will appear in the Line Memo field on the journal transaction. Line level memos do not appear on the PDF copy of the invoice sent to customers
  • If you track Cost Center, Balancing Unit, Fund, and Function at the header level of your invoices, you may include these values in the Worktags filter. If you invoice at the line level (the default), you may only include Balancing Unit and Fund in the Worktags filter. 
  • If you track worktags at the invoice line level, using Cost Center in the Worktags filter will return limited or no results because it is not a worktag required to generate a balance sheet. Cost Center does not automatically populate on the AR side of a journal entry produced when an invoice is created in Workday.