Accounting for Manufacturing

Note
TradeGecko for Manufacturing is currently in Beta.

Accounting is an essential part of the Manufacturing industry. Having the ability to track the actual cost of a production run is fundamental in making decisions that will gear you toward success.

In this article:

  1. Learn how to map your Manufacturing Ledgers to Xero and QuickBooks Online.
  2. Understand how the Manufacturing Ledgers in TradeGecko affect your accounting integration.
  3. Understand how TradeGecko calculates and updates your accounting platform.

How to map Manufacturing Ledgers to Xero and QuickBooks Online

You can map your Manufacturing Ledgers to Xero during the integration process. In the ledger set up page, you’ll be required to assign the Manufacturing Ledgers to their corresponding ledger accounts in Xero.

9_Full_Screen_Install_Flow_-_Xero_Ledgers_Step_2x.png

You can also change the ledger mapping at any given time by going to My Apps, then click Xero. From here, go to Ledger Accounts and assign the ledgers. Once done, click Save Changes. If there are other expenses that you wish to track, you can create a new custom ledger.

Screen_Shot_2018-12-09_at_3.20.32_PM.png

Note
The same set up applies to QuickBooks Online.

How do Manufacturing Ledgers work?

Screen_Shot_2018-12-12_at_10.19.44_PM.png

Note that your Stock on Hand ledger will be adjusted every time there is movement on your Manufacturing Ledgers. Especially when your Production Order is updated to In Progress and Completed.

Screen_Shot_2018-12-12_at_10.20.14_PM.png

Understanding your Manufactured Product's Accounting Process

Screen_Shot_2018-12-11_at_3.36.54_PM.png

Before you can start creating your Bill of Materials and Production Orders, you will need to create your Manufactured Products (also known as Manufactured Variants) in TradeGecko. During the creation of the Manufactured Product, you will need to add an Initial Cost Price and Initial Stock Count. This is required in order to calculate a product’s Moving Average Cost.

If you do not have an Initial Cost Price and Initial Stock during the creation of the product, put 0 in the field. TradeGecko will generate the Initial Cost Price based on the cost of the first production run.

Ledger mapping of “Other Cost” for Bill of Materials

After the Manufactured Product has been created, you can create your Bill of Materials. Assigning an account ledger on the line items under “Other Costs” is optional at this point.

2_Create_Bill_of_Materials_-_Filled_Out_with_Acctg_Integration_-_Ledger_Dropdown_2x.png

Accounting for Production Order in Draft status

After creating the Bill of Materials, you will now be able to create the Production Order. When you select which Finished Product to build on the Production Order, TradeGecko will load its corresponding Bill of Materials. If you have assigned a ledger account on “Other Cost” during the creation of its Bill of Materials, the same ledger will automatically be assigned on the Production Order.

Note that Production Order in Draft status will not trigger any data movement for your ledger accounts.

6_Create_New_Production_Order_-_Select_Finished_Variant_with_Acctg_Integration_2x.png

Accounting for Production Order that is In Production

When a Production Order is updated to In Production, the following adjustment will occur.

For this Production Order, we will credit 100 x $8.99 (Watch Strap total cost) + 100 x $48.99 (Watch Face total cost) + 100 x $28.99 (Watch Box total cost) = ($8697) Total Cost of Components to the Stock on Hand ledger.

7_New_Order_UI_-_PRO_-_In_Production_2x.png

Screen_Shot_2018-12-12_at_10.23.51_PM.png

Accounting for Production Order in Completed status

When a Production Order’s status is updated to Completed, the following adjustment will occur.

8_New_Order_UI_-_PRO_-_Completed_2x.png

Screen_Shot_2019-01-02_at_3.35.24_PM.png

Note
Values are rounded off to two decimal places.

After shipping your Manufactured Product, we will credit your Stock on Hand account and debit your Cost of Goods Sold account using the recalculated Moving Average Cost.

In Production and Completed Production Orders will be synced to your accounting integration daily. The sync will take place on the time you have set on your accounting integration’s Sync Timing tab.

For more Manufacturing related articles, click here. Got a feedback about TradeGecko for Manufacturing? Let us know!

Note
Please feel free to contact our support team if you have any questions.
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF
Have more questions? Submit a request
Was this article helpful?
0 out of 0 found this helpful

Comments

NEW TO TRADEGECKO? START A 14 DAY FREE TRIAL, NO CREDIT CARD REQUIRED