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 Invoices for Company
Similar to Customer Invoice Lines with Cost Center, this report provides a list of invoices along with their payment status, aging, collections status, and more. It also offers the ability to find customer invoices billed by a specific Ohio State employee.
Questions this report can answer
This report can help you answer questions such as:
- How many invoices did [name of worker] create? What customers are they associated with? When were they created? Are they paid or unpaid?
- How many invoices were created during a specific period – across all billing departments and units
Recommended Filters
The following are recommended. Other filters may be required, depending on your business need.
- Company = The Ohio State University
- Customers = Customer Group > your college or VP unit (see Notes)
- Invoice Status = Approved
- Invoice Type = Standard External (in most cases – if you use another invoice type, select it instead)
- Invoice Date Greater Than or Equal To = beginning of reconciliation date range
- Invoice Date Less Than or Equal To = end of reconciliation date range
- Invoice Payment Status = Partially Paid; Unpaid
- Created By Worker = first and last name of invoice creator
Notes
- This report does not offer filtering based on worktag combination.
- Use the Customers > 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 invoices specific to your worktag combination.