I'm ready to start shadowing my company accounts using ledger. We will do that for 30 days or so before putting the current system in the bin. Many thanks to John and all who comment here for such a wonderful tool.
Our business is project oriented. The three biggest issues I see are: 1-Efficiently "tagging" transactions on a per job basis 2-Transactions that might span multiple jobs 3-Reporting project Income for projects that span fiscal year ends (our year end is Sep 30) I will have two other people entering transactions and I need some ways to easily search for errors/omissions I have decided to use the text "Job***" as payee info" 2010/02/04 Corporation X, Job842 I would do something like "ledger reg -- -Job" to see all transactions without a "Job" tag At the moment I'm using "NoJob" on liability payments, A/R receipts, transfers, etc to filter out all of the items that would be spit out. We only NEED inc stmt info on a per job basis. I guess we will do something similar for 1099 recipients (USA) Transactions that span multiple jobs will have to be split The last issue (projects spaning year ends) is the worst. I've settled on an opening entry, dated at the previous year end. Per job reports have open beginnings, all other income statement type reports get a finite begin date. I've tried to use the (code) space but I found it easier to play with the data on the back-end when it was defined as the payee. I looked at sub accounts for each project but the chart of accounts becomes so unwieldy. I have company-mode setup with a back-end I created so the chart of accounts will pop-up for my assistants to select from. Any others using ledger for job costing? I'm sure there's better ways to do some of this.
