Check register

[Wes]

How can I create a check register that lists check amounts in one column deposits in another and the running total in a third column

 

[JE McGimpsey]

How can I create a check register that lists check amounts in one column
deposits in another and the running total in a third column

If you're using XL08, simply create a Personal Checkbook ledger sheet,
from the Sheets gallery (Accounts tab).

If you're using XL04 or earlier, one way:

Enter Checks in column C, Deposits in Column D. Assuming the total
starts in E2:

E2: =D2 - C2
E3: =E2 + D3 - C3

copy E3 down as far as necessary.

 

[Phillip Jones]

I don't know if this will work or not This is sample may have to tweak
to work the way you want.

first create 12 sheets that have 32 rows

In first row use for column headers

have Titles:

A1 - beginning Balance or Current Balance this would be one number that
stays where it its.

B1 - Income

C1 - Income description

D1 - Debit or pay out

D1 - Debit pay out description

F1 Ending Balance

Row 33

use the following formulas:

=Sum(A2+(B2:C32)) Running total of current Balance and income from
received money or checks.

D33=Sum(D2:32) Running Total of Debits.

G33-Ending Balance =Sum(B33+D33)

If you have the column items summed together using example B2:32) then
everything should automatically update each tome you enter a Number.

For my example above I am assuming one Income and one Debit entry per
day. You have to add number of rows according to the most transaction
you would do on any one day in a Month. To take into consideration most
number of days in a Month it would be 31 times that amount plus one row
for Description headers and one row for you calculation fields.

If say you had Income 10 Transactions on any one given day you would
have to have 3222 rows.

How can I create a check register that lists check amounts in one column deposits in another and the running total in a third column

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Phillip Jones]

the 12 sheets are 1 sheet per month.

you would have to repeat set ups for 12 months.

after trying out formula to see that they work then copy to the other
sheets and put header for Jan, Feb, March, etc. until Dec. I've tried
out Excel2008 and though can be done its far less complicated in Excel2004.

I don't know if this will work or not This is sample may have to tweak
to work the way you want.

first create 12 sheets that have 32 rows

In first row use for column headers

have Titles:

A1 - beginning Balance or Current Balance this would be one number that
stays where it its.

B1 - Income

C1 - Income description

D1 - Debit or pay out

D1 - Debit pay out description

F1 Ending Balance

Row 33

use the following formulas:

=Sum(A2+(B2:C32)) Running total of current Balance and income from
received money or checks.

D33=Sum(D2:32) Running Total of Debits.

G33-Ending Balance =Sum(B33+D33)

If you have the column items summed together using example B2:32) then
everything should automatically update each tome you enter a Number.

For my example above I am assuming one Income and one Debit entry per
day. You have to add number of rows according to the most transaction
you would do on any one day in a Month. To take into consideration most
number of days in a Month it would be 31 times that amount plus one row
for Description headers and one row for you calculation fields.

If say you had Income 10 Transactions on any one given day you would
have to have 3222 rows.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>