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.
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
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.