How Can I Create, Use, and Import an External Time Sheet?

How Can I Create, Use, and Import an External Time Sheet?

Create an External Time Sheet

Open the time sheet.

In the "Tools" menu, choose "Create External Time Sheet" to create an Excel file on your desktop to record your services. This is only possible if Microsoft Excel is installed on your computer.

The Excel file has two sheets: Enter your services in the first sheet; the second sheet contains services, cases and prices from timeSensor. This second sheet is only used as an internal reference and should not be altered. If you press and hold the option/alt key while creating the Excel file, all cases will be added to the file. Otherwise, only the last accessed cases will be added to the external time sheet.

Import an External Time Sheet

You can always copy and paste your services from the Excel file into the time sheet. You can also import the external time sheet using the command "Import External Time Sheet".




[A13]

    • Related Articles

    • How can I create an external timesheet, fill it out and import it again?

      Create external timesheet First open your timesheet. With the Create external timesheet command in the Tools menu, you can create an Excel document on your desk for external activity recording. This requires Microsoft Excel® software to be installed ...

    • How Can I Import Contacts from Excel into timeSensor® LEGAL?

      Follow these five steps to import contacts from Excel into  timeSensor® LEGAL. Prepare your contacts in Excel and save them as a tab delimited text file (.txt). In timeSensor® LEGAL, go to "Contacts". In the "Tools" menu, select "Import", then ...

    • How do I import a chart of accounts?

      This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com. Importing a chart of accounts saves you from having to create accounts manually. This is how you proceed: ...

    • How can I import bookings into timeSensor LEGAL?

      General Information From build 3414, you can import bookings into timeSensor LEGAL. Thanks to our flexible import editor, virtually any file format can be imported. Since we do not want a failed import to ruin our accounting data, timeSensor LEGAL ...

    • How Can I Create a Collective Invoice?

      When a client has several cases, you may want to enter services in each case individually, but create a collective invoice. To do this, you will need an invoice file (billing file), which is a case used exclusively to invoice other cases (but which ...