Back

How to Assign an Account and Cost Center for Each Item in Invoices and Requisitions

This feature allows you to assign the accounting account and the cost center for each item separately within invoices and requisitions, which helps the accuracy of the accounting posting and improves tracking of costs and revenues at the item level.

Activating Account and Cost Center Settings

From the main menu, go to “Accounting” then choose “Accounting Settings”.

Click the tab “General Accounting Settings“.

From Accounts Assignment Rules enable Item-Level Account Assignment by Transaction Type for each transaction type you need: Sales Invoices, Purchase Invoices, and Requisitions. When enabled for purchase invoices, the Account field appears for each item in the purchase invoice directly, without the need to edit the accounts routing.

And from “Cost Center Distribution Rules“, enable

Then click the button “Save“.

Setting Account Routing at the Item Level

From “Accounting Settings” go to “Accounts Routing“.

From the section “Sales” go to “Product Sales Account”, select the routing type “Specify per Each”.

This step is specific to sales invoices only, and no similar setup is required for purchase invoices.

and click the button “Save“.

Creating a New Sales/Purchase Invoice

To create a new sales invoice, from the main menu click “Create Invoice” from the dropdown menu of “Sales“.

In the invoice table, new fields appear for each item in the invoice that allow you to select:

  • The account of the product
  • The cost center

And to create a purchase invoice, go from the main menu to “Purchases” and choose “Purchase Invoices”  then click “Add Purchase Invoice“.

You will find the two fields “Account” and “Cost Center” within the purchase invoice table.

Note: Without selecting an account for the item, the purchase invoice items that don’t enter the inventory are recorded on the Cost of Sales account, which are: services, items written manually without selecting a registered product, and products not tracked in the inventory. And when selecting an account for the item from the field Account, the item is recorded on the selected account instead of the cost of sales account.

Creating a New Requisition

Go to “Manage Requisitions” from the dropdown menu of “Inventory“.

Click the button “Add” then choose “Manual Inbound“.

The two fields “Account” and “Cost Center” will appear for you within the requisition table.

Frequently Asked Questions

Why was the purchase invoice recorded on the cost of sales account? And how do I change the account?

Recorded on the Cost of Sales account are the purchase invoice items that don’t enter the inventory: services, items written manually without selecting a registered product, and products not tracked in the inventory. As for the products tracked in the inventory, they are recorded on the warehouse account.

To change the account, enable item-level account assignment for Purchase Invoices from Accounts Assignment Rules in General Accounting Settings, then choose the required account for each item from the field Account in the purchase invoice table. There is no need to edit the accounts routing. This applies to the invoices saved after the change.

Is the purchases account the same one on which the purchase invoice items are recorded?

No. The non-inventory purchase invoice items are recorded on the Cost of Sales account, and the inventory products on the warehouse account. Therefore, editing the purchases account routing doesn’t change the account on which these items are recorded; use the Account field for each item instead.