Historical Data

​What are historical data
Historical Data are any time records that happened in the past. 

This diagram was created with bookkeeping in mind, but you might consider it for time records as well. The image is downloadable as a PDF.

Historical Records

​For our purposes when speaking of historical data, the project may still be under way, but you may want to consider time records for closed projects for reference. Each record must contain a Date, Project-Phase, Number of Hours, and a User. Optionally you can enter a Description.

For MyCorbu BASIC there is just one way to add historical data from past work. Manually.

There are three strategies you can follow. 

1. Start using MyCorbu at the start of a month and maintain old records in your old system. 
2. Re-enter each time record accurately into MyCorbu for all ongoing work. Depending on what kind of records you have, each person does their own or one person or a team tackles the job. This method takes the most time. You get the best results from this method, but a year from now it may not matter. 
3. Enter summarized records of your past work. Enter the number of hours as large numbers. It is not necessary to keep below 24 hours per day. Enter the hours in the correct month or not, the total is what matters. However, keeping the hours in the correct year prevents your data from being outrageously wrong. 

You can also use a hybrid approach. Enter some projects accurately and some projects by summarizing. Perhaps the newest projects are entered accurately and older projects are summarized. Or perhaps other criteria determines which approach is used on which projects. 

The benefit of transcribing your historical data is being able to look up these records easily when estimating new work. 

Who can enter historical time records
A Level 1 User can add their own historical records. A Level 2 User or above can add records for anyone.

How you enter historical time records
Add historical time records on the Projects Time page using the ADD TIME ENTRY button. When you 'Submit' a record, a link to 'Reload the Form' can be used to easily access the form for entering another record.

When to add historical data 
Adding historical time records can be done anytime. The addition of some records will be more urgent than others. The frequency with which you access this historical information should inform your decisions about how much to recreate and when.

BOOKKEEPING DATA
The BOOKS version of MyCorbu adds a new dimension to the need for historical data. The strategy is very similar, but refer to the graphic above for some additional considerations.

Keep in mind:

• This is bookkeeping, not brain surgery.
• The relevance of 7 year old financial data is very low.
• The relevance of 5 year old financial data is questionable.
• The relevance of 3 year old financial data is useful.

Bookkeeping creates a need for historical data, at least in the short term. Most of that need can be satisfied with a fairly minimal number of entries per project.
Suggested minimal historical records entries:

• Add the Project
• Add the Project-Phases
• Add the Contact Org for client, consultants, etc.
• Set charge rates to ‘era-appropriate’ (perhaps 90% of billing rates in effect)
• Make one time entry per person per Project-Phase on a relevant date per year (or month)
• ​Ignore reimbursable expenses and mileage
• Make one expense entry for each project-related expense category (e.g. consultants) per year
• Make one income entry for the project per year

​Revised April 15, 2018