A couple of ideas to implement:
- Add column to entries table for balanced, processed, or posted entries (entry_state_id?)
- Only show accounts that have activity - or ability to hide accounts.
- Accounting periods - monthly, quarterly, or yearly - tasks including bank reconciliation, and closing accounts.
Sub-accounts and / or grouping of accounts- Reverse a journal entry!
Accounting periods are a very important part of bookkeeping and accounting, and very much something I want to setup in PBooks. While I've been reading about XBRL, I've noticed that they have some information on accounting periods, and I'll also check out some of the notes I saw on the Gnucash wiki. I've also happened upon a bunch more open source accounting programs at sourceforge so I'm going to dig through those ones before I craft my own. So I found a decent reference to "accounting periods". Its simple enough for me to understand at this point, and I'd like to build on the basic concept. Rick Bradley's Accountomatic is the program I found this simple but effective accounting period concept. It basically is a start and end date that you can use as a bookmark to certain snapshots of financial records. While the rest of Accountomatic is nice and simple, its written in ruby, and while I hear good things about that language, I prefer PHP for now.
CREATE TABLE periods ( id serial NOT NULL, fromdate timestamp with time zone DEFAULT now() NOT NULL, todate timestamp with time zone DEFAULT now() NOT NULL);I did some more research and found this helpful page:
Computerized Accounting Training > Year End & Month End Bookkeeping Tasks-----
Oh but I did create a test data generator. It simply creates a recently dated set of transactions in CSV format. Should be very helpful for testing! I got the idea from the ESU Team - thanks!
