to set up a check register which automatically updates your balance

Hi Jim,

This is an image of a file created using the Checking Register template supplied with Numbers '09 (but not included in the current version of Numbers).

Formulas immediately below are those supplied with the version above.

Transactions Table:

F1: entered amount (4650.00)

F3: =$F$1+SUM(OFFSET(F3,3-ROW(),-1,ROW()-2))

Fill the formula down to the last row of the table (currently row 14)

Account Categories:

B2: =SUMIF(Transactions :: $D,A2,Transactions :: E)

Fill down to B6.

Row 7 is a Footer row.

B7: =SUM(B)

The pie chart is a chart of the values in B2 - B6 of the Account Categories table.

There are two things I've not liked about this template:

• Expenditures and deposits are entered in a single "Amounts" column. Since most items will be expenditures, this requires including a - sign in most entries. I'd split this into two columns—In and Out, allowing all entries to be positive numbers.
• "Credit Card" is a payment method, not an expenditure category. It's listed as a 'category' to simplify the table, which is a pretty good reason, but you do need to be aware that doing so lumps many expense categories by 'how you paid' rather than 'what you spent it for' making the Account Categories table and it's graph a less accurate presentation of your spending patterns.

Here's the same Transaction Table with Amounts recorded in separate columns, and a different formula for the running balance in the Balance column (now Column G):

Transactions:

G3: =$G$1+SUM($E$2:E3)-SUM($F$2:F3)

Fill down to the end of the column.

Accounts Summary:

No changes.

Made in Numbers '09 using the Checking Register template.

The same formulas will work in Numbers v3

Regards,

Barry

you can do something like this:

make the first row a header row and enter the column titles as shown

enter information as needed in each row.

cell C2 contains the formula (select cell E2 then type or copy and paste from here):

=IF(COUNTA(A2:D2)>2,SUM($D$2:D2)−SUM($C$2:C2), "")

shorthand for this is:

E2=IF(COUNTA(A2:D2)>2,SUM($D$2:D2)−SUM($C$2:C2), "")

select cell E2, copy

select cells E2 thru the end of column E, paste