View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Create a credit (negative) column in Excel?

Shows how little I know about bookkeeping<g

My rudimentary style is a column of "ins" and a column of "outs" with the
difference being what I still have in my pocket or owe to my creditors.


Gord

On Thu, 5 Jul 2007 19:23:12 -0400, Stan Brown
wrote:

Thu, 05 Jul 2007 14:17:39 -0700 from <Gord Dibben
<gorddibbATshawDOTca:

Credits are generally positive values.

Don't enter numbers with a negative value in the credit column.

Enter those in your debit column.

Or am I missing some detail?


Credits *and* debits are generally positive. In proper accounting
books (using the double-entry method, which it sounds like the OP
does), total credits must equal total debits.

The OP should have positive credits and positive debits, and strike a
balance by sum(debits) - sum(credits) for an asset or expense
account, sum(credits) - sum(debits) for a liability or equity or
revenue account.