TTC Work Log

The current month's finance summary, at a glance.

• Period Opening — opening balance + monthly allocation.
• Consumed — Coded + Non-coded man-days used this month.
• Closing / Carry — period opening − consumed (turns red if negative).
• Closing (IDR) — the closing balance in rupiah.

Below the cards, the Breakdown by project table lists each project's Used man-days for the selected month. Use the month pager (Prev / Next) to change month.

Submit a work record for a Non-coded project.

1. Pick the Project (Non-coded only). No project yet? Choose “Others” and type a project name — see the note below.
2. Set the Date.
3. Choose one or more Who (the person(s) who did the work — at least one is required).
4. Describe the Task.
5. Enter Valuable hours.
6. Click Submit — the record is created as pending until approved.

My history below the form shows your 10 most recent records; the full, month-filterable list lives in Work Records. You can delete your own records while they are still pending.

Bulk-create work records from a Nippo export file (ExportNippo.xlsx). Nippo is Logique's work-recording platform; its export can be imported here.

1. On Log Work, use the Import from Nippo card and choose the .xlsx file.
2. A preview (dry-run) appears — nothing is saved yet. Review the rows to import, what will be skipped, and any new projects/persons to be created.
3. Click Import to commit. Imported records are created as pending.

How matching works

• Only rows where CLIENT = Toyota Tsusho are considered.
• Projects & persons are matched by name. Unknown Toyota Tsusho projects are auto-created as Non-coded; unknown persons are auto-created.
• Duplicate rows (same date, project, hours, description) are skipped.

Review and decide on pending work records.

1. Open Approval to see all pending records.
2. Approve a record (it then counts toward consumption), or Reject it with a reason.
3. To act in bulk, tick records (or Select all) and use Approve selected / Reject selected (an optional reason applies to all).

The full list of work records, with filters.

• Members see only their own records (filter by status).
• Approvers/Admin see everyone's, and can also filter by project and by person (“who”).
• Use the month pager (Prev / Next, or the calendar picker, or “All months”) to scope the list.
• The header shows total approved hours and the equivalent MD.

Deleting: Members can delete their own pending records; Approvers/Admin can delete any record.

Record man-days for Coded projects (which are not logged daily).

1. Pick the month, then Add adjustment.
2. Choose the Coded project.
3. Enter the Delta and choose its unit — MD or MH. MH is converted to MD automatically (÷ 7.5).
4. Give a Reason and save. Positive adds man-days (debit); negative reduces them (credit, e.g. cancelled work).

The Recap shows total man-days per Coded project for the month (the sum of its adjustments). A project total above 31 MD in one month is flagged as a soft warning (possible overtime); the save is never blocked.

The project list with each project's total Used man-days.

• Used is the total across all months: Coded = Σ adjustments; Non-coded = Σ approved valuable hours ÷ 7.5.
• Admins can Add, Edit (name, type, code, active), and Delete projects.
• Coded work requires a manual project code; Non-coded does not.

Deleting is a soft delete and is blocked if the project is already used (has records, budgets, or adjustments) — deactivate it instead.

Manage the people (PICs) selectable as “Who” when logging work.

• Add / Edit a person, or toggle Active (only active people appear in the Log Work dropdown).
• Delete is a soft delete; existing records keep the name for history.

The full client report for a month — read-only; numbers come from the data you entered.

• Balance — opening + monthly allocation − consumed = closing, each with its IDR value.
• Section 1 — Work Records — approved Non-coded records, subtotaled to MD.
• Section 2 — Mandays per Project Code — one Mandays figure per Coded project (the PDF also lists each adjustment with its reason).

Exporting (Admin)

• Excel — generates and downloads an .xlsx, archived in History.
• PDF — opens the print dialog with the formatted Logique report; save as PDF. Also archived in History.

Manage accounts and assign roles.

• Add / Edit a user, set their role (Admin / Approver / Member), and toggle active.
• You cannot delete your own account.

Per-month allocation, opening balance, and IDR rate.

1. Pick the month.
2. Set the Monthly Allocation (MD).
3. Leave Auto carry-over on (opening = previous month's closing), or untick it to enter a manual opening.
4. Set the Rate (IDR / MD) if it differs.
5. Click Save. The Derived (preview) card shows the resulting opening, period opening, and IDR value.

An audit trail of changes plus archived exports.

• Records changes to budget, adjustments, monthly allocation and every report export — who and when, with a before → after summary.
• Filter by month (defaults to the current month), entity, and action.
• For exports, Download the archived Excel or Open report for that month.