Reconcile checkbook in numbers

I have a checkbook in Numbers that has date, transaction type, payee/payer, category, notes, debit, credit, reconcile, balance. I need a new table to reconcile the checkbook monthly with the bank statement. The reconcile column has check boxes. I want to reconcile by checking off the boxes in the main table to change what is going on one the reconcile table until it evens out. Having "Your beginning balance this period" and "Your ending balance" with the difference going to zero when all the boxes are checked off. I know some banks have dates for beginning and ending in the middle of the month and some go by the actual month. Some non-checked boxes will be in the last month. I just need a formula that checks for unchecked checkboxes, then calculate when a checkbox is checked.

Statement Beginning Balance 0,000.00

Statement Ending Balance 0,000.00

Reconciled Balance 0,000.00 Formula that checks for the checkbox for checks and uses the numbers in the debit and credit columns.

Unreconciled Balance 0,000.00

I probably not explaining correctly of what I want, but any help will do. Thanks.