title: Accounting and Database design, storing debit and credit amount
body: <p>QUESTION:  In the case below should I have stored all my amount as positives decimal amounts then flag the amount as either being a "Debit" or "Credit" rather than storing debits as negative amount and credits as positive amount?</p>
  
  <hr>
  
  <p>In my database design, I store "debit" as negative amount, and credit as positive amount.</p>
  
  <p>Now in reporting sometimes the results come out wrong because if you do this</p>
  
  <p>TotalAmount = Amount-Fee, and if withdraw amount is $100, and fee is $1.</p>
  
  <p>You would end up with -$100-$1 = -$101, which is the <strong>incorrect result!.</strong></p>