ITrack/Enterprise/Accounting

ITrack Enterprise uses a very flexible accounting system. It is designed to allow for both complex and simple general ledger practices and to easily integrate with any sort of external general ledger based accounting package.

For details about an individual screen's accounting process, refer to that screen's page.

For information about configuring the accounting system (and for configuration examples), please refer to the accounting configuration section.

Accounts

The Accounting Screen in ITrack Enterprise allows a user (probably an administrator) to set up a chart of accounts. This is done in the Accounting screen on the Accounts tab. Accounts in ITrack have a number, a name, a description, and a type. For example:

Name: Accounts Receivable
Number: 1000
Description: An account that shows how much money the company is owed from customers.
Type: Asset

Departments

This is an optional accounting subsystem in which departments are created to categorize gl activity. Transactions inherit a department from the user that created them (though this department can often be overridden per document or per item). For this reason, departments can be assigned to users through the configure users dialog. Often, gl departments correspond to sub-accounts utilized in a company's accounting system.

For example, an accountant might have the account "Sales" with the sub-account "Sales-Gear Shop". Activity would be logged to the gear shop sales when a transaction hits the sales account and the gear shop department.

This system is optional and not required for proper operation of ITrack or its accounting modules.

Categories

Every item in inventory and every kind of labor used is assigned a "GL Category". A "GL Category" defines the kinds of accounts that that item needs to affect in different situations. These situations are called "GL Contexts" and are described below.

Some examples of GL Categories that a company might use:

• New Parts
• Used Parts
• Labor

Contexts

The software defines certain contexts, or situations where accounting applies. A complete list of the contexts is here:

Context	Description
Sale	Occurs when an item is sold on a sales order
Return	Occurs when an item is returned on a sales order
Core Sale	Occurs for every inherent core on a sales order that affects inventory when it is finalized
Core Return	Occurs for every dirty core returned on a sales order that affects inventory when it is finalized
Transfer	Occurs when an item is transferred on a transfer order
Core Transfer	Occurs for every core as it is transferred on a transfer order
Purchase	Occurs when an item is received from a purchase order
Core Purchase	Occurs for a vendor core charge on an item received on a purchase order
Purchase Return	Occurs when an item is returned on a purchase order
Core Purchase Return	Occurs when cores are returned to vendors
Work Order Consumption	Occurs for each line and labor item on an internal work order when it is finalized
Work Order Consumption Inherent Core	Occurs for inherent core charge item on an internal work order when it is finalized
Work Order Consumption Dirty Core	Occurs for dirty core credit on an internal work order when it is finalized
Work Order Production	Occurs for each master part on an internal work order when it is finalized
Work Order Production	Occurs for the master record on a work order when a work order is finalized
Work Order Sold	Occurs for each line and labor item on an external work order when it is finalized
Work Order Sold Inherent Core	Occurs for each inherent core charge on an external work order when it is finalized
Work Order Sold Dirty Core	Occurs for each dirty core credit on an external work order when it is finalized
Work In Progress (optional)	Occurs for each inventory line and labor item on a work order whenever it is saved. Accounting can be configured not to utilize WIP accounts.
Work In Progress Inherent Core (optional)	Occurs for each inherent core charge line on a work order whenever it is saved. Accounting can be configured not to utilize WIP accounts.
Work In Progress Dirty Core (optional)	Occurs for each dirty core credit line on a work order whenever it is saved. Accounting can be configured not to utilize WIP accounts.

Each combination of category and context allows the definition of four accounts. The user can set these up in the accounting screen on the Categories tab:

Account	When it is used
Transaction Debit	Debits this account (usually by price)
Transaction Credit	Credits this account (usually by price)
Inventory Debit	Debits this account (usually by cost)
Inventory Credit	Credits this account (usually by cost)

For certain categories in certain contexts, it might not make sense to fill in an account. For instance taxes are ordinarily applied on the transaction side rather than the inventory side.

For advice and examples for configuring accounting in ITrack, please refer to the accounting configuration help section.

Transactions

Whenever the General Ledger is affected, all of the entries are grouped into a transaction. The transaction verifies that all of the debits and all of the credits are equal, that balance being the fundamental rule of GL based accounting. The transaction also applies a timestamp recording the exact second that the accounting occurred and exactly how much money was involved. It also allows for user comments.

Entries

Each accounting entry is stored as a single record and therefore can be copied into whatever accounting system the user chooses (assuming their accounting package has some mechanism to either import or directly input data).

Accounting Packages

ITrack Enterprise was designed specifically with Sage's Mas90 accounting system in mind.