Monday, November 10, 2014

Initiate accounts with some balance - Adding an Equity account

Before we can do anything, there must be some cash in these accounts. To start, let's give ourselves some equity.

1. First create an "Equity" type account named "Equity"

Here's how things should look after completion:












2. Then add 10,000 to the Cash account, matched with entry in Equity on 01-Jan-2014.












And the following are our balances:












And here's the changes to the database:

** slots **
6|04a6f5e65289295457ba0b24d2de69fd|date-posted|10|0||0.0|||0|1|20140101


** splits **
1eb24bc760ee0c99a54c2a3cd36798f7|04a6f5e65289295457ba0b24d2de69fd|6a86047e3b12a6c4748fbf8fde76c0c0|||n||1000000|100|1000000|100|
6e87026b4db7f5ce5658e8ea402cae8d|04a6f5e65289295457ba0b24d2de69fd|dedeaf05873d7e92aa2a31dba73704d5|||n||-1000000|100|-1000000|100|

** transactions **
04a6f5e65289295457ba0b24d2de69fd|be2788c5c017bb63c859430612e64093||20131231170000|20141111064545|Initial Balance
Notes
1. Slots table gets inserted with a "date-posted" entry -- huh? See here, and here.
2. A row gets added to the transactions table
3. Two rows gets added to the splits table

No comments:

Post a Comment