Ask HN: How to model daily state of accounts in RDBMS?

[dhruvkar]

I'm writing a module to handle accounting data for our company. We need to be able to see what the state of accounts (payables/receivables) were on any given day. How do I model this in an RDBMS?

I'm very new to database design.