Reconciliation Worksheets - Example

Homeowner Payment Clearing Account Reconciliation

QuickBooks Balance Sheet

   

Homeowners Payment Clearing Account

 

$1,050

     

Keystone

   

Closing Fee Payments Detail

$120

 

Mortgage Payments Detail (principal)

630

 

Mortgage Payment Detail (escrow)

290

 

Mortgage Payments Detail (late fee)

10

$1,050

Variance

 

$0



Mortgage and Escrow Balances Reconciliation

QuickBooks Balance Sheet

   

Mortgage Receivable Balance

$352,654

 

Escrow Liability Balance

 

$5,346

     

Keystone Mortgage, Escrow and Other Debt Balances

   

Mortgage Principal

$352,654

 

Homeowner Escrow

 

$5,346

Mortgage Receivable Variance

$0

 

Escrow Liability Variance

 

$0

Contributions Reconciliation

QuickBooks Donation Clearing Account

 

 $35,425

 
 
 
     

Keystone Donations by Donor report

   

Individuals

$225

 

Businesses/Organizations

$200

 

Churches

$10,000

 

Foundations/Trusts

$25,000

$35,425

Variance

 

$0

Date:  2 Feb 2007

Signed: