Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
Identifying Discrepancy in Accounts Receivable Reconciliation
Identifying Discrepancy in Accounts Receivable Reconciliation
Identifying Discrepancy in Accounts Receivable Reconciliation
When reconciliation is conducted, there may be differences between the customer balance and the general ledger balance. Any of the following reasons can account for these differences:
- There are journal entries posted to the accounts receivable account. In
DAT
, there is a report called [Finance] AR Reconciliation - Summary, that breaks down transactions by description. This will help you identify if there are any journal entries associated with your accounts receivable account.
- There are miscellaneous receipts posted to the accounts receivable account. In
DAT
, there is a report called
[Finance] AR Reconciliation - Summary
, that breaks down transactions by description. This will help you identify if there are any miscellaneous receipts associated with your accounts receivable account.
- There are invoices that credit the accounts receivable account instead of debiting it. In
DAT
, there is a report called
[Finance] AR Reconciliation - Invoices
Debiting AR Account that will help you identify such invoices.
- There are receipts/credits that debit the accounts receivable account instead of crediting it. In
DAT
, there is a report called
[Finance] AR Reconciliation - Receipts/Credits Debiting AR Account
that will help you identify such receipts/credits.
- The parameters specified in the
Customer Balance Configuration
screen do not match those that are specified in the General Ledger screen.
Example:
Unposted transactions may be set to show on Customer Balance - - Configuration screen whereas the General Ledger screen only takes into account posted transactions.
Similarly, there may be differences between the customer balance and the customer aging report. Any of the following reasons can account for these differences:
- There are invoices that credit the accounts receivable account instead of debiting it. In
DAT
, there is a report called
[Finance] AR Reconciliation - Invoices
Debiting AR Account that will help you identify such invoices.
- There are receipts/credits that debit the accounts receivable account instead of crediting it. In
DAT
, there is a report called
[Finance] AR Reconciliation - Receipts/Credits Debiting AR Account
that will help you identify such receipts/credits.
- The parameters specified in the
Customer Balance Configuration
screen do not match those that are specified in the Aging Report.
Example:
Unposted transactions may be set to show on
Customer Balance Configuration
screen whereas the A/R Aging Report may be configured to show posted transactions only.
See also
Customer Balance Configuration
Action
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.