3 Replies Latest reply on Oct 10, 2011 9:26 AM by philmodjunk

# Checkbook Register

### Title

Checkbook Register

### Post

Great! Answer to previous post worked well. Now, How do I enter a starting value without entering it into the deposit or withdrawl fields? I know how to get a summary of all deposits and withdrawls but without reflecting the starting value.

Previous Post: Does anyone have a sample of a simple checkbook register for a FMP beginner? If not a sample, a little help getting started.

• ###### 1. Re: Checkbook Register

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.

• ###### 2. Re: Checkbook Register

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.

• ###### 3. Re: Checkbook Register

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