5/24/2023 0 Comments Sql accounting software![]() Normally, AP will be on the Credit side, except when you settle down your payment. (in case that this is the Tax you have to pay as a consumer) ![]() I think the problem of transaction 326 you mentioned about is that it seems you have done on the wrong side of Debit/Credit things.ĭebiting 29 from Consulting & Accounting, andĭebiiting 2.39 from Sales Tax. However I am not sure if we could credit/debit negative values.Ĭan someone explain how databases and accounting principles go together? However if I look at it as Debiting -31.39 from AP, It does. While the sum of amount in this case = 0, the sum of credits isn't equal to sum of debits (Debiting 29 from Consulting & Accounting(E), Debiting 31.39 from AP(L), and crediting 2.39 to Sales Tax(L)). ![]() Here's the export from that accounting system: Wikipedia Helped a little, but when i tried to cross check with an accounting system, it doesn't looks how it's done. But then how do I convert debits, and credits to numerical values. ![]() This I assume simplifies the mathematics a lot. Using a separate debit and credit column in the database seems like one way, but most of the Open Source Accounting I have seen use a single amount column. I am working on a simple invoicing and accounting applications, but I am totally lost on how to represent accounting-transactions(journal-entries) in a database.
0 Comments
Leave a Reply. |