Barrel storage costs (barrel depreciation) can be added to bulk wines in barrel by linking your barrels to Cost Items and running the utility under Tools – Costing – Storage costs.
If you have accounting integration configured then you can link the Cost items to specific Accounts in your general ledger. These accounts should represent the asset accounts for the value of your barrels. When the storage costs are applied, and as part of the Accounts Sync process, a journal will be created to capitlise some of the barrel cost to the Bulk Wine Work in Progress asset account.
With the accounting integration configured it’s important to run the Storage cost utility before running your accounts sync as detailed in the recommended end of month procedure.
Configuring barrel storage cost item
First, you will need to have the appropriate Cost items configured under Winery Setup – Costing – Cost items. You should have one of these configured for each different type of barrel or one for at least each different rate of depreciation; i.e., if you depreciate your 2011 French Oak at $1.50 per day and your 2012 American at $1.20 per day, then you would configure two separate cost items.
Note: barrel storage costs can only be depreciated/applied at a per day rate within vintrace.
If you don’t have accounting integration turned on, skip the next step and go to setting storage cost on the barrel
Configuring barrel storage cost item with accounting integration turned on
When you have accounting integration turned on, you need to link your cost item to an asset account that represents the barrels in your accounting general ledger. This will be the account used to create a journal of the cost value by crediting this account and debiting your Bulk Wine Work in Progress account.
Please refer to this article on how to setup accounts for accounting integration.
Setting storage cost item on the barrel
Each barrel will then need to be linked to the Cost item under Winery Setup – Vessels – Barrels, then go to the Advanced tab.
To make this easier for a large number of barrels we recommend using the Import/Export utility to update barrel details in bulk.
Setting storage cost item on barrels by bulk
You can set the storage cost item against multiple barrels by using the barrel importer utility in Winery Setup – Vessels – Barrels – Import barrel registry. Please refer to this article for more information on importing data.
Set the Storage Cost Item and Depreciation Start Date in the import file for the barrels you want to set the storage costs against.
Important: You need to set the Depreciation Start Date as the date you want to start the storage costs so you don’t add extra costs to wines with storage costs already factored in.
Contact support if you require assistance with this step.
Generating storage costs
Once you have configured the barrels to have storage costs, you can use the utility under Tools – Costing – Storage costs.
First, set the Effective date to the last date you want storage costs loaded. We suggest running this monthly and backdating this to the end of the previous month.
There is a confirmation message here that you must agree that you have checked and ensured all outstanding work orders for barrel work has been closed off in the system up until the effective date. Please use the Check Job management console link to check the scheduled task work-list across all facilities.
You also have the option to Preview storage costs; we encourage you to use this link before saving the costs to ensure you see what you would expect.
When you are satisfied with the costs, add a reason or note in the text box provided, tick on the I confirm I have checked and understand checkbox, and then click on Save.
This will add the costs to all the wines up to and including effective date.
vintrace has built-in smarts to know that if a wine was only in barrel for 10 days of the month, only 10 days worth of cost should be added to that wine, even if that wine has now been racked to tank or bottled. Unlike other systems you should not need to run this utility daily, although you may take a while becoming comfortable with the process.
Synchronising barrel storage cost items to accounting integration
If you have accounting integration turned on, the storage cost you have generated will create manual journals. We recommend that as your end of month process, you generate the storage costs first, then apportion overhead costs (e.g. electricity, other utilities, etc.) to your wine via the Cost Allocation Console, and then run the Accounts sync to capitalise cost from the account linked to the stock item through to the Bulk wine in production account.
Clicking on the the entry in the Accounts Link Console – Production Movements and Journals table will bring up the details of the cost movement which shows the barrel storage cost items we have previously generated.
When you save and sync, the manual journals will be posted in Xero.