Browse articles

Checking your import

Compare people, projects, hours and billing totals in Monument with the same totals from your old system, and fix what doesn't match.

What you'll achieve

Be sure your imported history matches your old system before anyone relies on it.

You'll end up with: Imported projects, people and hours match your old system's totals, or you know why they don't.

An import that's nearly right is worse than none: people stop trusting the reports and go back to spreadsheets. Check four totals against your old system before you announce Monument to the practice.

Check four totals

  1. 1

    People: open Team. Team members lists the active people. Compare them with your old system's active staff.

  2. 2

    Projects: open Projects and compare the list. Spot-check a few projects you know well: code, client, stages and dates.

  3. 3

    Hours: in Reports, choose Timesheets by person. Click Period and choose the period you imported, such as Last Fortnight, or a Custom range, then click Apply. Compare each person's total, and the Totals row, with your old system.

  4. 4

    Billing: in Reports, choose Invoiced and paid by month and compare the total invoiced for the same period.

You don't need to save the report with the new period. Changing the period only changes what you see now.

When totals don't match

  • Rows were skipped. The spreadsheet import lists skipped rows and their reasons before it starts. Fix those rows in the file and import them again.
  • Hours land on the wrong person or project. A name or code in the file didn't match. Correct the match and re-import, or fix the entries in bulk on the Time page.
  • Billing differs. Invoices from before Monument may not be imported. Record them with revenue entries so reports include them.
  • A figure differs but the rows match. Monument may count the figure differently. See what each figure counts.

Where this fits next

Your history is in. Next, bring your team in with the right access.

Search Monument help

Search help articles and open a result.