Expense Account (Expense)
This account is utilized when posting Item type A/P Invoices that contain non-inventory items. The expense account will be debited (normally the purchase of an inventoried item debits the inventory account).
Revenue Account (Revenue)
This account is utilized when posting A/R Invoices or A/R Reserve Invoices. The revenue account will be credited.
Inventory Account (Asset)
The inventory account is utilized for all postings dealing with inventory (Delivery, Return, A/R Invoice, A/R Credit Memo, Goods Receipt PO, Goods Return, A/P Invoice, A/P Credit Memo, Goods Receipt, Goods Issue, Inventory Transfer, Inventory Revaluation, and Stock Posting). Debits and credits depend on the direction of stock movement.
Cost of Goods Sold Account (Cost of Goods Sold)
This account is utilized when posting item type deliveries (or A/R Invoices not based on Deliveries) for inventoried items. The COGS account will be debited.
Allocation Account (Liability)
This account is utilized when posting Goods Receipt PO’s for inventoried items. This is a clearing account which will be credited when you post a GRPO and debited when the linked A/P Invoice is created. This account can also be cleared by manually closing GRPO’s. In this case the Allocation account is debited and the Goods Clearing Account is credited.
Variance Account (Expense)
The variance account is used in conjunction with standard cost inventory items. Any time the stock level of a standard cost item increases, the potential exists for a difference between the cost input into the document, and the standard cost identified for the item. This variance will be posted to the variance account. For example Item A has a standard cost of $5. A GRPO is posted for 1 unit of Item A at a price of $7. The difference between $7-$5 = $2. $2 will be debited to the variance account and $5 will be debited to the inventory account.
Price Difference Account (Cost of Goods Sold)
The Price Difference Account is utilized with inventory items managed by either FIFO or Moving Average Cost. When the price on an A/P Invoice is different from that of the base GRPO then the difference must be accounted for as this directly affects inventory costing. There are three possible scenarios. The inventory received on the GRPO is still in stock. In this case the price difference will be applied to the inventory and the cost adjusted. The second scenario happens if there is no longer any inventory. The price difference can’t be applied to inventory so it will be posted to the price difference account. It is recommended that the price difference account be a cost of goods sold account. The third scenario is a combination of the first two. Some stock exists and is revalued and the remaining price difference is sent to the Price Difference Account.
Negative Inventory Adjustment Account (Expense)
This account is utilized if you allow inventory to enter into a negative state. Please contact ProjectLine for further information on negative inventory if necessary and how it can impact your financials.
Inventory Offset – Decrease Account (Expense)
This is the default offsetting account used when posting a Goods Issue. This decrease account will be debited. It is also used in the inventory count process - this is the default offsetting account used when performing a stock count and inventory is being written off/reduced
Inventory Offset – Increase Account (Expense)
This is the default offsetting account used when posting a Goods Receipt. This increase account will be credited. It is also used in the inventory count processes - this is the default offsetting account used when performing a stock count and inventory is being received/increased.
Sales Returns Account (Asset)
This account is utilized when posting a Return or an A/R Credit Memo. This is where the inventory value of the returned stock will be posted. It is highly recommended that this is set to the same account as your inventory account.
Exchange Rate Differences Account (Expense)
This account is utilized when a target document such as an A/P Invoice has a different exchange rate than the base document (GRPO) for items with foreign currency prices. A local currency variance is created due to the differing exchange rates which get posted to this account.
Goods Clearing Account (Expense)
This account is posted to when manually closing a Goods Receipt PO. See Allocation Account for further details.
G/L Decrease Account (Expense)
This account is the default offsetting account when performing a material revaluation and inventory value is being decreased.
G/L Increase Account (Expense)
This account is the default offsetting account when performing a material revaluation and inventory value is being increased.
WIP Inventory Account (Asset)
This account is utilized as the default offsetting account when posting Goods Issues for Production. Inventory will be credited and WIP will be debited. The WIP account is cleared when performing Receipts for Production.
WIP Inventory Variance Account (Expense)
On a production order there is the possibility that the sum of the component costs do not add up to the cost of the completed product. In this scenario the variance is posted to the WIP Variance Account upon closing the production order. This scenario happens frequently when finished products are managed by standard cost.
Expense Clearing Account (Liability)
This account is utilized in conjunction with the allocation account when additional expenses are involved. A GRPO posted with additional expenses will credit both the Allocation Account for the inventory as well as the Expense Clearing Account for additional expenses/freight.
Stock In Transit Account (Asset)
This account is debited when an A/P Reserve Invoice is used. Once the inventory has arrived and a GRPO has been posted this account will be credited.
Sales Credit Account (Revenue)
When performing an A/R Credit Memo the revenue will be returned to the sales credit account. It is recommended that this be set to the same account as your Revenue Account.
Purchase Credit Account (Expense)
When posting an A/P Credit Memo for a non-inventory item, this is the account where the expense will be returned to. It is recommended that this is set to the same account as your Expense Account.