Administration Settings
(A Step-by-Step Administration Setup)
Purpose: This module guides bookkeepers through the proper setup and management of Expense Accounts in TRAKIT. Expense Accounts form the foundation for categorizing spending and ensuring compliance with internal budgets and tax regulations.
1. Navigate to Administration Settings
2. Open Expense Accounts Menu
3. Add a New Expense Account
4. Managing Existing Accounts
Each account line item has an Action Combo Menu (usually represented as 3 dots or a dropdown), you can:
5. Assigning Tax Codes
Key Bookkeeper Responsibilities
📌 Ensure all expense categories used by the business are set up correctly
📌 Coordinate with the Admin or Accountant to verify tax assignments
📌 Only use active accounts for categorizing expenses
📌 Regularly review inactive accounts for potential reactivation or cleanup
Tips for Best Practice
💡 Keep account names descriptive but concise(e.g., “Office Supplies”, “Staff Meals”)
💡 Group similar accounts under logical headings when possible for better reporting
💡 Avoid duplicating accounts unless there’s a functional reason (e.g., regional breakdowns)
Purpose: Cost Accounts are used to classify direct costs related to goods acquired for business operations. These accounts are crucial for accurate COGS tracking and must be clearly separated from regular Expense Accounts.
* Cost Accounts (Goods): for items purchased and resold or used in production.
1. Navigate to Cost Accounts
2. Add a New Cost Account
3. Manage Existing Accounts
For each account line, click the Action Combo Menu:
4. Assigning Tax Codes
Key Bookkeeper Responsibilities
📌 Confirm cost accounts are used only for direct costs, not operational expenses
📌 Check with team leads on whether purchases fall under Goods or Services
📌 Ensure tax mapping aligns with the type of supplier (VAT-registered, exempt, etc.)
📌 Use consistent naming across accounts to simplify reconciliation and reports
Tips for Best Practice
💡 Use prefix conventions to differentiate, for example: COG/Goods – Materials & COG/Service – Subcontractor
💡 Coordinate with the Admin team or Accountant before creating new accounts if unsure
💡 Review inactive accounts periodically to avoid bloating the system
Purpose: Cost Accounts are used to classify direct costs related to services acquired for business operations. These accounts are crucial for accurate COGS tracking and must be clearly separated from regular Expense Accounts.
* Cost Accounts (Services): for services subcontracted or billed as part of client engagements
1. Navigate to Cost Accounts
From Administration Settings, open Cost Accounts (Services)
2. Add a New Cost Account
3. Manage Existing Accounts
For each account line, click the Action Combo Menu:
4. Assigning Tax Codes
Key Bookkeeper Responsibilities
📌 Confirm cost accounts are used only for direct costs, not operational expenses
📌 Check with team leads on whether purchases fall under Goods or Services
📌 Ensure tax mapping aligns with the type of supplier (VAT-registered, exempt, etc.)
📌 Use consistent naming across accounts to simplify reconciliation and reports
Tips for Best Practice
💡 Use prefix conventions to differentiate, for example: COG/Goods – Materials & COG/Service – Subcontractor
💡 Coordinate with the Admin team or Accountant before creating new accounts if unsure
💡 Review inactive accounts periodically to avoid bloating the system
Purpose: Expense & Cost Categories serve as tags or labels that link specific transactions to accounts in the Chart of Accounts (COA). They help standardize reporting and improve the consistency of entries across the organization.
Role in TRAKIT
Each Category is:
1. Navigate to Expense & Cost Categories
2. Add a New Category
Click the “Add Category” button
3. Manage Existing Categories
Click on a category to:
Key Bookkeeper Responsibilities
📌 Ensure each Category is linked to the correct COA item
📌 Verify that new categories are not duplicates of existing ones
📌 Assist in maintaining a clean and relevant list of active categories
📌 Educate requestors on choosing the correct Category for transactions
Tips for Best Practice
💡 Use categories that reflect functional business use (e.g., “Marketing Expenses”, “Transport – Service”)
💡 Avoid too much granularity unless needed for compliance or reporting
💡 Regularly review category usage with the Accountant or Admin to realign with company operations
Purpose: Tax Mapping ensures every Expense or Cost Account is linked to the correct tax classification, such as VAT or tax-exempt. This setup is essential for accurate compliance reporting, tax filing and withholding validations.
Where Tax Mapping Happens
Tax Mapping is applied through:
Each account must be mapped to a specific tax category based on its expected usage and vendor tax status.
1. Locate the Account
Go to:
2. Open the Action Combo
3. Assign the Appropriate Tax Code
A dropdown will appear with available tax options, such as::
Select the correct classification and save.
Why It Matters
Proper tax mapping ensures:
✅ Expense records are prepared with the correct BIR tax code
✅ OCR tools correctly extract and tag tax components during liquidation
✅ TRAKIT generates valid tax summary reports and .datfiles for tax filing (e.g., BIR submissions)
Key Bookkeeper Responsibilities
📌 Confirm each account has a mapped tax code (none should be left blank)
📌 Coordinate with the accountant on tax treatment of new expense types
📌 Watch for incorrect mappings(e.g., assigning VAT to a non-VAT vendor)
Mistake
Assigning "VAT 12%" to tax-exempt suppliers
Leaving tax mapping blank
Mapping unrelated accounts to withholding categories
Correction
Use "VAT Exempt" instead
Always assign the correct tax classification
Only map if subject to EWT or Final Tax
Purpose: Central Cash Funds represent the main funding sources managed by an organization within TRAKIT. These include the official bank accounts (typically held by the organization itself) and are not assigned to individual users, but instead serve as the core disbursement accounts for the entire system.
Key Central Cash Fund: Cash in Banks
This is the first fund type under Central Cash Funds and is essential for:
1. Navigate to Cash in Banks
From Administration Settings, under Central Cash Funds, select Cash
in Banks
2. Add a New Bank Account
Click the “Add Account” button and complete the form:
Click “Create Account” to save
3. Manage Bank Accounts
Each line item has an Action Combo Menu, allowing you to:
Bookkeeper Access & Responsibilities
While adding or editing bank accounts is typically an Admin-level function, bookkeepers must:
📌 Be aware of all active bank accounts to correctly track and reconcile fund requests
📌 Confirm that transfers and replenishments are tagged to the correct bank source
📌 Flag any inconsistencies between source of funds and disbursements
📌 Educate requestors on choosing the correct Category for transactions
Practical Use Cases
Each line item has an Action Combo Menu, allowing you to:
Purpose: User Cash Accounts in TRAKIT represent individual funds assigned to specific users. These include operational cash allocations such as debit-card-linked sub-accounts, cash advances, petty cash, and revolving funds. They are critical for enabling decentralized spending while maintaining centralized control and traceability.
Types of User Cash Accounts
1. Navigate to User Cash Accounts
From Administration Settings, go to User Cash Accounts, you will see
sub-menus for:
2. Select a User
Choose between All Users or an Individual User to view and manage account assignments
3. Add a New Account
For each fund type:
4. Manage Existing Accounts
From the Action Combo Menu, you can:
Key Custodianship Rules
📌 Each Business Unit, Client Engagement, or Project can assign only
one fund per custodian per fund type
📌 A user may hold multiple fund types but cannot share custodianship
on a single fund
📌 Fund visibility is limited to authorized users and their assigned responsibilities
Practical Use Cases
Each line item has an Action Combo Menu, allowing you to:
Key Bookkeeper Responsibilities
📌 Track and reconcile each custodian’s fund balances.
📌 Ensure the correct linkage between fund, user, and the appropriate BU/Project/Engagement
📌 Support users in fund liquidation and monitor for unliquidated
balances
📌 Coordinate fund activations and deactivations with Admin or Management
Tips for Best Practice
💡 Use consistent fund naming conventions (e.g., PCF – John – Marketing, RF – Jane – Cebu Project)
💡 Always verify the fund assignment context (which BU or Project it belongs to)
💡 Review all active and inactive user funds monthly for audit and budgeting purposes
Purpose: This module provides a comprehensive overview of all Fund Types used in TRAKIT. Each fund type supports a specific operational or financial use case, and understanding their distinctions is critical for effective cash tracking, compliance, and reconciliation.
Key Bookkeeper Responsibilities
📌 Set up and validate correct fund structuresbased on operational
needs
📌 Monitor fund utilization and reconcile unliquidated or dormant
funds
📌 Coordinate with management when a custodian changes or a fund needs to be restructured
📌 Ensure compliance by checking that only one active fund per
custodian per unit/project/type exists
Key Fund Logic
1. One Custodian per Fund per Type per Assignment
A Business Unit, Client Engagement, or Project can only assign one Petty Cash Fund and one Revolving Fund per custodian
2. Custodians Cannot Share Funds
Each fund must be linked to a single responsible user (custodian)
3. Bank Sub-Accounts Are User-Specific
These are not tied to Business Units or Projects but are used for organizational purchases via digital means
4. Cash Advances Are Floating
They are temporary and do not belong to a BU/Project structure. Custodians are required to liquidate them after use
Use Case Examples
Scenario
1. Field employee needs petty cash for transport in Marketing Unit.
2. Team leader requires ongoing funds for provincial training project.
3. Finance officer receives digital card for online supplier payments.
4. Messenger picks up permit and needs cash.
Fund Type Used
1. Petty Cash Fund – Assigned to “Marketing” BU
2. Revolving Fund – Assigned to Project “Provincial Rollout”
3. Bank Sub-Account
4. Cash Advance – Others
Common Errors to Avoid
❌ Assigning multiple PCFs to the same custodian for one BU/project
❌ Using a Cash Advance where a Revolving Fund would be more
appropriate
❌ Forgetting to deactivate unused funds after reassignment or staff
turnover
Purpose: Cash Budget Lines in TRAKIT define the financial structure for how funds are allocated, requested, and monitored across the organization. Each fund (Petty Cash, Revolving Fund, etc.) must be tagged to a Business Unit (BU), Project, or Client Engagement, creating a system of accountability and internal budgeting control.
1. Navigate to Cash Budget Lines
Go to Administration Settings → Cash Budget Lines, and choose:
2. Add a New Budget Line
Click “Add Account” and complete the form:
Click “Create Account”
3. Manage Existing Budget Lines
From the Action Combo Menu, you can:
Key Bookkeeper Responsibilities
📌 Ensure each fund (PCF or RF) is correctly tagged to its relevant BU, Project, or (eventually) Client Engagement
📌 Support Admin and Managers in maintaining active and up-to-date budget lines
📌 Identify if a fund is misaligned(e.g., a Marketing PCF tagged to a Finance project)
📌 Verify that no duplicate or unused budget lines exist in the system
Tips for Best Practice
💡 Name each BU/Project consistently (e.g., HR – Internal, Project – Cebu Roadshow)
💡 Maintain separate entries for distinct client projects or multi-phase initiatives
💡 Review monthly to ensure only relevant and active lines are enabled
Integration with Other Modules
Feature: Fund Requests
Linked To: Require valid Budget Linetagging
Feature: Liquidation Tracking
Linked To: Summarized by BU/Project
Feature: Internal Chargebacks
Linked To: Based on assigned Budget Line
Feature: Profit & Loss Reports
Linked To: Generated per BU, Project, and (soon) Engagement
Purpose: This module explains the expense lifecycle in TRAKIT—from document submission to final liquidation. It ensures all disbursements made through Petty Cash, Revolving Funds, and Cash Advances are fully accounted for using proper documentation and approval workflows.
Expense Workflow Overview
❗ Steps 1–3 are the responsibility of the Custodian ❗
1. Source Document Identification
Custodian collects receipts, invoices, bills, or supporting files for any cash spent.
2. For Liquidation (OCR Process Begins)
Documents are uploaded and processed by TRAKIT’s OCR tool to extract
data.
3. Liquidated
Expenses are tagged to a Fund, Budget Line and COA. All documents are matched, and totals reconciled.
❗ Steps 4–5 are handled by the Bookkeeper or Admin Reviewer ❗
4. Approved
Verified by the bookkeeper and/or manager. Included in reporting and P&L summaries.
5. Rejected
Returned to custodian with comments for correction or resubmission.
Types of Source Documents
🧾 Official Receipts: Common in local BIR-compliant purchases
🧾 Invoices: Used in supplier billings or deferred payments
🧾 Sales Orders/Delivery Receipts: Used for logistics or fulfillment tracking
🧾 Proof of Payment (POP): Digital or physical record (bank screenshot, etc.)
*All uploaded documents are linked to the Fund, User, and Budget Line involved.
Key Features in the Expense Window
Key Bookkeeper Responsibilities
📌 Monitor the status of all liquidations and escalate delays in submission
📌 Review OCR data for accuracy and ensure correct tax coding
📌 Approve or reject liquidations with proper annotation
📌 Regularly export reports for management, audit, and compliance
Tips for Best Practice
💡 Ensure each liquidation is backed by valid and readable documents
💡 Cross-check fund amount vs. liquidated total to detect discrepancies
💡 Reject incomplete or unclear submissions early to avoid month-end bottlenecks
Purpose: This module outlines how bookkeepers use TRAKIT's reporting and reconciliation tools to monitor fund performance, validate liquidations, and generate real-time financial insights across Users, Funds, Business Units, Projects, and (soon) Client Engagements.
P&L Integration and Chargebacks
TRAKIT can generate internal P&L statements by aggregating:
This ensures each BU, Project, or Engagement can be assessed as its own profit center, supporting accountability and internal benchmarking.
Bookkeeper Reporting Tasks
1. Daily / Weekly Tasks
📌 Monitor open liquidations
📌 Check for delayed submissions
📌 Follow up on rejected items
2. Monthly Tasks
📌 Export and review P&L per Business Unit or Project
📌 Identify variances between Budgeted vs Actual
📌 Prepare audit trail summaries and fund utilization reports
3. Quarterly Tasks
📌 Support auditors with full liquidation trails
📌 Validate overhead allocations and internal charges
📌 Confirm unused or stale funds for deactivation
Tips for Best Practice
💡 Always reconcile custodian fund balances before month-end close
💡 Use variance analysis to inform fund reallocations or corrections
💡 Keep reports centralized and version-controlled for audit efficiency
💡 Ensure proper mapping of all expenses to allow automatic report generation
Common Errors to Avoid
❌ Incomplete fund tagging.
Which can lead to report gaps or miscoded expenses, so review budget line and fund links before approval
❌ Unclosed cash advances.
Which can skew fund balances, so monitor unliquidated statuses weekly
❌ Manual Excel-only reports.
Which can lead to risk of version error, so use TRAKIT filters and exports directly
TOTALFLOW Enterprises Pte. Ltd.
160 Robinson Road, 14-04 Singapore Business Federation Center, Singapore