> its better to have one row in a table with a debit and credit.
No. Some transactions have 3 lines, eg: two debits and one credit. Some examples:
- Split payment at a shop, $100 item bought with $70 cheque and $30 cash would be
credit sales $100
debit cash $30
debit bank $70
Now if you introduce sales tax or VAT/GST, its more complicated. Say the $100 item is actually $90 + $10 VAT, then entries goes:
credit sales $90
credit vat-payable $10
debit cash $30
debit bank $70
No. Some transactions have 3 lines, eg: two debits and one credit. Some examples: - Split payment at a shop, $100 item bought with $70 cheque and $30 cash would be credit sales $100 debit cash $30 debit bank $70
Now if you introduce sales tax or VAT/GST, its more complicated. Say the $100 item is actually $90 + $10 VAT, then entries goes: credit sales $90 credit vat-payable $10 debit cash $30 debit bank $70