History Loading

When you begin processing information in DPS, you enter transaction data through data entry and then post it to the database. For historical data, however, you bypass this process and enter data that directly updates the appropriate parts of the database.

You can begin using DPS before you have entered all history. However, the sooner you enter historical data, the sooner you can generate up-to-date reports.

Some types of historical data are required to ensure that your reports run properly, while other types of historical data are optional. The amount of optional historical data that you enter will impact the relevance of your project and accounting reports.

Determining the Level of Detail

The amount of history that you enter depends on the level of detail that you want to include on your reports. Reports are only as thorough as the history that you provide. Depending on your reporting needs, you may decide to enter more history detail for certain projects than for others.

You may want to enter history at a level of detail that your existing records do not support. For example, assume that you have always tracked reimbursable project expenses in a single general ledger account. Now, you want to start tracking expenses separately in Consultant, Reproduction, Travel, and Miscellaneous categories so that more detailed information appears on project reports and bills. You can approach this problem in one of three ways:

• Enter all historical expenses in the Miscellaneous account. If you choose this approach, the individual expense account balances on your Income Statement will be incorrect for the first year but total expenses will be correct. Expenses will not be broken out, for example, as Consultants or Reproductions on your project reports or invoices until you begin processing transactions through DPS.
• Assign a percentage of the total historical expense to each category. You might, for example, estimate that travel usually amounts to 10% of all project expense and assign 10% of each project's total expense to the Travel account. This method affects the meaningfulness of your balances.
• Research your project expenses to determine accurate balances for each expense account. This may be a time-consuming task, and the information that you obtain may be incomplete.