Hi Bem.
I use a sheet with columns setup like this...
(vertical separators use for columns)
DESCRIPTION| CK# |ACCT#| DATE| MEMO| ACCOUNT NAME| DEBIT| POSTED |CREDIT
|BALANCE |Outstanding Debits |Outstanding Credits| Statement Ending Balance

I put the formulas below on separate lines. Hopefully they will copy & paste
easier.
Paste these into row 1000 starting in column J. My data starts at row 5 so
"$5" may have to be changed to match yours.
You can copy them anywhere after. Your columns may be different. The will
correct as long as you get them in the right place first.

Formulas starting with the balance column (J) are..
=J999+I1000-G1000
=IF(OR(H1000="R",H1000="C"),"",IF(OR(B1000="",C100 0<2,C1000<20),G1000,""))
=IF(OR(H1000="R",H1000="C"),"",IF(I1000="","",I100 0))
=IF(OR(H1000="R",H1000="C"),"",J1000+(SUM(K$5:K100 0)-SUM(L$5:L1000)))
=IF(OR(H1000="R",H1000="C")," ",(M1000-(SUM(K$5:K1000))+SUM(L$5:L1000)))

What they do is look at column "Posted" which = blank, C (Cleared), or R
(for reconcile when the statement arrives).
I use C to mark transactions if I view my account online.
The "Statement Ending Balance" should match what your bank sees as your
current balance.

Working with them is pretty simple. Just look.
If there are outstanding debits or credits they appear. Otherwise the cells
appear blank.
When you reconcile change the posted column to R as you review each item on
the statement.

On my sheet the ACCT# is used to get the memo, description and account name
data from a table.


--
John
johnf202 at hot mail dot com


"bem" wrote in message
...
I have a check register set up in Excel list form, but it is getting pretty
large and cumbersome to navigate. Is there a function/formula that would
return a running list of uncleared transactions...I would like to have an
at-a-glance report that lists uncleared transactions. It would be nice to
see payee and amount but amount would suffice.

If this requires an array formula, please speak s..l...o...w...l...y....

Thanks,
bem