Reconciling using quickbooks. Type the ending balance and ending date on your statement.