A simple check book register starts with the following fields:
TransDate; Desc; Deposit; Withdrawal; cBal; sBalance
Transdate is a date field. Description is text. Deposit and Withdrawal are number field.
cBal is a calculation field you do not actually place on your layout, but it's used behind the scenes to pull together deposit and withdrawal values into one field with different signs so that sBalance can compute the needed running total. Use this expression for it:
Deposit - Withdrawal.
Then set up sBalance as a summary field that computes the total of cBal and specify that it compute a running total.
Now you can set up a list or table view layout with all these fields but cBal on it and you'll get what looks like the traditional check register, but one that does the math for you.
Great! That works well but here is the next part. How do I enter a starting value without entering into the deposit or withdrawl fields? I know how to get a summary of all deposits and withdrawls but without reflecting the starting value.
Why wouldn't your starting value be entered as a deposit with "starting balance" or some such text be entered in the Desc field? That's how I usually set this up and also is how I've seen most bookkeepers start a new ledger...
You can add a third field for starting bala nce an incorporate it into cBal to produce:
StartingBalance + Deposit - Withdrawal