Double Entry Posting

[Moe]

I would appreciate if any can answer me on the following:
I am working on creating a simple accounting program by excel and need to
find out how I can do an auto command for excel to post the (Debit) and
(Credit) sides to their relevant accounts on a separate sheet or book. Taking
into consideration that the double entry sheet consists of too many entries
and various account numbers and amounts. The following is an example:

On one sheet (Double Entry Sheet)

DR. Acc. Num. CR. Acc. Num.
1000 100101 1000 234100

On account sheet:

Acc.Num 100101 credited for $1000

On another account sheet:

Acc. Num. 234100 debited for $1000

Hope this is clear.
Thanks

 

[Bernie Deitrick]

Moe,

I would not add any more sheets.

You could simply filter your database on either Acc. Num. columns to show Credits (filter on the
first Acc #) or Debits (filter on the second) for the account of interest. If you want to see both
credits and debits, then add a column of formulas - enter this, perhaps, in cell E2

=OR(B2=$E$1,D2=$E$1)

and copy down to match. Enter the account number of interest in cell E1, then filter based on
column E being TRUE to show both credits and debits.

HTH,
Bernie
MS Excel MVP