Support for spirits used in wine production on the TTB report (US)

This feature was added in vintrace Version 5.2.4

This feature reports spirits used in Part III – Summary of Distilled Spirits of the TTB Report of Wine Premises Operations in vintrace.

New spirit tax class

A new tax class “Spirit” is automatically created for you in Winery Setup – Policy – Tax Class. If you already have an existing “Spirit” tax class, it gets updated to have the correct values in TTB Part and TTB Column ref fields.

New spirit tax class

You have to input the alcohol percentage in Alcohol (%) field for your spirit tax class. It is important to input the Alcohol (%) for spirits since this value will be used in calculating the proof gallons in the TTB report.

Input alcohol percentage in spirit tax class

Any TTB event for this tax class will get reported in Part III column (a) in the TTB report.

Spirit tax class TTB Class ref

If you more than one alcohol %/proof, you may create additional spirit tax classes; add one (named appropriately) for each additional alcohol % and specify columns “b” through “d”.

TTB - Spirits - add new spirits tax classes

Bulk intake of spirits

Using a standard Bulk Wine Intake bring the volume of spirits you have received and put it into the correct tank. You will be able to give the spirits product all the grape origin information you require as per any bulk wine. The most important option is to ensure you give the spirits product a tax state of “Bonded” and select the tax class “Spirits” you have setup in the previous step.

Bulk intake spirits

TTB reporting for spirits

Upon generating your TTB report, you have the option to view Part III in either proof gallons or gallons. The TTB requires reporting by proof gallons. Tick on Calculate Proof Gallons for Part III checkbox when you want to see the spirits reported in proof gallons.

Generate TTB report

The bulk intake of spirits we have done in the previous step is reported in Part III row 2 Received, under column (a). In the below example we have generated the report in proof gallons for spirits. For information on calculating proof gallons, click here for the TTB conversion table and formulas.

TTB report for bulk intake

Using spirits

So now you have a tank full of spirits and you want to use it with some of your wine. You can use spirits in any of the transfer operations in vintrace. Let’s take for example, you want to blend spirits into wine.

Blend spirits into wine

Important Note: the wine into which you are blending must already have been declared as vintrace doesn’t allow blending of declared and non-declared products. 

Once you complete the operation, the spirit used will be reported in Part III row 5 Used (shown in proof gallons).

TTP report for blending spirit into wine 1

And the  wine involved in the blend operation will be reported in Part I  in row 4 Produced by addition of wine spirits and in row 20 Used for addition of wine spirits.

TTP report for blending spirit into wine 2

 

 

Support for juice and concentrate on the TTB report (US)

This feature was added in vintrace Version 5.2.4

This feature reports juice and concentrate use in Part IV – Summary of Materials Received and Used of the TTB Report of Wine Premises Operations in vintrace. This is to track juice/concentrate that is not intended to be fermented (i.e. it may sit in a tank or drum to be used for sweetening in production), and in other cases, it may be produced and perhaps sold to other wineries as concentrate.

From this point on “juice” is grape juice that is not intended to be fermented
(i.e. added to wines directly, potentially sold later on).

Summary of sections in this article

New juice tax class
Bulk intake of juice
TTB reporting for juice
Using juice
Extraction operation for juice

New concentrate tax class
Bulk intake of concentrate
TTB reporting for concentrate
Using concentrate

Undeclare juice for wine production

New juice tax class

A new tax class “Juice” is automatically created for you in Winery Setup – Policy – Tax Class. If you already have an existing “Juice” tax class, it gets updated to have the correct values in TTB Part and TTB Column ref fields.

New juice tax class

Any TTB event for this tax class will get reported in Part IV column (c) in the TTB report.

Juice tax class 2

Bulk intake of juice

Using a standard Bulk Wine Intake bring the volume of juice you have received and put it into the correct tank. You will be able to give the juice product all the grape origin information you require as per any bulk wine. The most important option is to ensure you give the juice product a tax state of “Bonded” and select the tax class “Juice” you have setup in the previous step.

Juice bulk intake

TTB reporting for juice

The bulk intake of juice we have done in the previous step is reported in Part IV row 2 Received, under column (c).

TTB report after juice bulk intake

Using juice

So now you have a tank full of juice and you want to use it to sweeten some of your wine. You can use juice in any of the transfer operations in vintrace. Let’s take for example, you want to blend juice into wine.

Blend juice into wine

Once you complete the operation, the juice used will be reported in Part IV row 5 Used in wine production.

TTB report after blending juice into wine

And the  wine involved in the blend operation will be reported in Part I  in row 3 Produced by sweetening and in row 18 Used for sweetening.

TTB report after blending juice into wine 2

Extraction operation for juice

For an extraction operation where the juice produced is not intended to be fermented, you have the option to specify that this is for juice use only. You can do this by ticking on For Juice use only checkbox in the extraction operation screen.

Extraction for juice only

The juice produced will have a tax class of Juice.

Juice after extraction

The volume produced in the extraction operation will be reported in Part IV row 3 Juice or Concentrate Produced in the TTB report.

TTB report after extraction for juice only

The following section will be for reporting concentrate in Part IV column reference (d) Concentrate in the TTB report.

New concentrate tax class

A new tax class “Concentrate” is automatically created for you in Winery Setup – Setup Options – Policy – Tax Class. If you already have an existing “Concentrate” tax class, it gets updated to have the correct values in TTB Part and TTB Column ref fields.

New concentrate tax class

Any TTB event for this tax class will get reported in Part IV column (d) in the TTB report.

Concentrate tax class 2

Bulk intake of concentrate

Using a standard Bulk Wine Intake bring the volume of concentrate you have received and put it into the correct tank. You will be able to give the concentrate product all the grape origin information you require as per any bulk wine. The most important option is to ensure you give the concentrate product a tax state of “Bonded” and select the tax class “Concentrate” you have setup in the previous step.

Bulk wine intake concentrate

TTB reporting for concentrate

The bulk intake of concentrate we have done in the previous step is reported in Part IV row 2 Received, under column (d).

TTB report after concentrate bulk intake

Using concentrate

So now you have a tank full of concentrate and you want to use it with some of your wine. You can use concentrate in any of the transfer operations in vintrace. Let’s take for example, you want to blend concentrate into wine.

Blend concentrate into wine

Once you complete the operation, the concentrate used will be reported in Part IV row 5 Used in wine production, under column (d).

TTB report after blending concentrate into wine

And the  wine involved in the blend operation will be reported in Part I  in row 3 Produced by sweetening and in row 18 Used for sweetening.

TTB report after blending concentrate into wine 2

Undeclare juice/concentrate for wine production

If you have a juice product, concentrate product, or any product that has a tax class that belongs to d,e,f,g in Part IV of the TTB report that you decided you want to use for wine production, you can undeclare them by applying a product treatment operation.

Firstly, you need to setup a product treatment to undeclare the juice. Go to Winery Setup – Treatment – Treatment (Product) and click on New Product treatments… button.

Product treatment to undeclare juice 1

In Product Treatment Definition, provide a Treatment name, tick on Wine/Juice checkbox in Applies to field, and tick on Use for Wine Production checkbox.

Undeclare juice or concentrate

Applying this product treatment will change the bonded state of the juice/concentrate from bonded to non-declared.

You can use this product treatment on a juice product by clicking on Operations – Treatment (Product) from Product Overview.

Product treatment to undeclare juice 3

Select the product treatment you created to undeclare the juice in the Treatment (Product) screen and click on Now+Save button.

Product treatment to undeclare juice 4

The product’s tax class is now changed to non-declared.

Product treatment to undeclare juice 5

In the TTB report, the volume will be reported in Part IV row 5 Used in wine production and under Part VII row 1 In fermenters.

TTB report after undeclaring juice for wine production

Support for sugar (dry and liquid) on the TTB report (US)

This feature was added in vintrace Version 5.2.4

This feature reports sugar used (dry and liquid) in Part IV – Summary of Materials Received and Used of the TTB Report of Wine Premises Operations in vintrace.

Setup a dry sugar tax class

Firstly, you need to setup a tax class for dry sugar in Winery Setup – Setup Options – Policy – Tax Class. Click on New Tax class button.

Setup new tax class

Give the Name, TTB Class ref, and select Part IV – Materials in TTB Part where this tax class will get reported in the TTB report.

Sugar tax class 1

Input “h” in TTB Class ref. Any TTB event for this tax class will get reported under the corresponding column in Part IV of the TTB report. In the example below, we have entered “h” in TTB Class ref and this tax class will get reported in Part IV column (h) in the TTB report.

Sugar tax class 2

Setup dry sugar as an additive

Unlike the other materials (grapes, juice, and concentrate) in Part IV of the TTB report, sugar will be handled as an additive in vintrace. You need to setup a new additive by going to Winery Setup – Production – Additive. Click on New Additive… button.

For more information on how to setup new additives, refer to this article.

Setup dry sugar additive 1

Provide the Name, Unit of addition, and Owner for the dry sugar additive you want to setup. Click on Save button.

Setup dry sugar additive 2

Setup an additive stock item to link to your dry sugar additive by going to Winery Setup – General stock items – Additive. Click on New Additive stock item… button.

Setup dry sugar stock additive 1

Enter the Stock Code, Unit, and Owner, select the Tax class “Dry sugar” that was created in the previous steps, and select “Dry Sugar” in the Additive field to link this to the additive created previously. It is very important that you select the correct tax class so that the sugar used will be reported correctly in the TTB report.

Setup dry sugar stock additive 2

Stock receival of dry sugar

To receive sugar into your inventory, go to Inventory – Receive. Enter the receival details such as the vendor, carrier, stock item, received units, and routing information.

Dry sugar receival

TTB reporting for dry sugar

The stock receival done in the previous step is reported in Part IV row 2 Received column (h) in the TTB report.

TTB report after stock receival dry sugar

Using dry sugar

You can add dry sugar to your wine like any other additive by performing additive/multi addition operation, or as an inline addition in any of your transfer/blend operations. In the example below, we have added dry sugar to wine by performing an additive operation.

Additive operation dry sugar

After the additive operation, the dry sugar used will be reported in Part IV row 5 Used in Wine Production.

TTB report after additive operation dry sugar 1

 

Setup a liquid sugar tax class

Firstly, you need to setup a tax class for dry sugar in Winery Setup – Setup Options – Policy – Tax Class. Click on New Tax class button.

Setup new tax class

Give the Name, TTB Class ref, and select Part IV – Materials in TTB Part where this tax class will get reported in the TTB report.

Setup liquid sugar 1

Input “i” in TTB Class ref. Any TTB event for this tax class will get reported under the corresponding column in Part IV of the TTB report. In the example below, we have entered “i” in TTB Class ref and this tax class will get reported in Part IV column (i) in the TTB report.

Setup liquid sugar 2

Setting up additives for liquid sugar is the same as dry sugar, just make sure you specify the Liquid sugar in the tax class of the liquid sugar stock item. Using liquid sugar is the same as dry sugar by using it in any addition operation.

 

Notification of TTB impact for loss/gain reasons (US)

This feature was added in vintrace version 5.2.3

This feature allows you see the information on how the loss reason you selected for a particular operation will impact your 702 report. This feature is only available to US customers.

As an example let’s record a measurement operation for a wine product in vintrace, and you have a loss of 1 gal.

Measurement loss

You then select a loss reason; in the case of the example below, the loss reason selected is Evaporation. Click on the ttbOn icon beside the Loss Reason field to view the 702 reason used for that particular loss reason.

702 reason

TTB Event Console (US)

This feature was added in vintrace Version 5.2.3

The TTB Event Console is a new feature in vintrace that shows all the TTB events for a selected bond and tax class within a date range. You can click on each event to go to the operation/action that caused the event.

Accessing the TTB Event Console

You can access the TTB Event Console by navigating to Console – TTB event history…

Console access 1

You can also access it from Product Overview or Stock Item Overview – Actions – View related TTB tax events…

Console access 2

Another way to access the TTB Event Console is from Winery Reports – Government Reports – TTB Report of Wine Premises Operations, then click on Launch TTB history to compare.

Console access 3

The TTB Event Console

To run the console, you have to select the From and To dates, Bond, and Tax Class of the TTB events you want to view and then click on Search button.

You also have the option to filter the search either by Batch or Item.

TTB Event Console

The From and To dates are set to the start date and end date of the previous month by default.

You can change the default date range to yearly, quarterly, or monthly by going to Winery Setup – Work-flow – Defaults and under Policy Defaults set the Preferred TTB Period. Please note that this setting also changes the default period when you run the TTB reports under Winery Reports – Government reports.

Preferred TTB Period

The event data in the TTB Event Console is separated into Section A and Section B, and they correspond to the same sections in the TTB report. Each section shows the Opening and Closing balance for each section if you ticked the Show Opening/Closing balances checkbox.

TTB Event Console 2

The TTB Event Console also shows the detail of each event such as Date occurred, Operation, Target (batch or stock item code), Tax change reason, and Volume change.

TTB Event Console 3

Clicking on the operation link for each event will bring up the operation screen that caused the event. In the example below, we clicked on the Bulk wine intake operation under Section A.

Operation link

Compare against TTB Reports

You can also compare the TTB events against the TTB reports for the date range, bond, and tax class you have selected in the console by clicking on Compare against TTB Reports… button.

You have the option to either Run TTB Report or TTB Breakdown Report.

Generate related reports

Clicking on Run TTB Report would bring up the TTB Report of Wine Premises Operations screen with the date and bond selected based on the one you have in the TTB Event Console.

generate related reports 2

Edit Tax Volume Event details

You can edit the Tax Volume Event details of a TTB event by clicking on the pencil icon beside the event and this will show you the Tax Volume Event [UPDATE] screen.

Note: You need to have the Can edit TTB Tax Volume Events user permission in order to edit the Tax Volume Event details.

Edit TTB Tax Event

In the Tax Volume Event [UPDATE] screen, you can change the details such as Volume Change, Tax class, Tax state, Tax change reason, and Bond.

Any changes you make in this screen will only impact the TTB Reports and will not change the operation or batch/stock item that created the TTB tax event.

Tax Volume Event Update

We urge you to please be cautious if you do choose to edit the Tax Volume Event details because this will impact your TTB report.

How has TTB bond tracking changed between Version 3.x.x and Version 4.x.x of VINx2?

What used to happen

In version 3.x.x (and below) of VINx2, TTB bonds were tied to the Owner of a batch of wine.  This forced a number of customers with multiple facilities to have to create two sets of Owners if wine was moved from one facility to another.  Even though the wine may not have been changing ownership, the system would force you to change it to get the bonds correct.  In some cases, if you had the same wine stored at two facilities it would need to be configured as two separate owners (and batches) just so you could report it on your 702 report.

What happens now

In version 4.x.x (and above), TTB bonds are tracked based on the physical location of the wine.  Typically, this means that the bond that gets used for a particular lot of wine will be based on which winery the vessel it is in is located at. So rather than changing owners when transferring wine between bonds, you just have to transfer the wine from a vessel located at one winery to a vessel located at another.  Details on moving a wine between facilities can be found here.  This makes bond tracking much closer to the real world movements of your wines that are taking place. The only real restriction that would be enforced now is if you have one lot of wine in barrel with some barrels at multiple bonded wineries, you would need to have a separate barrel group for the barrels at each physical location.  It is good practice to do this anyway, as you would typically be completing separate topping and other work orders for the barrels at the different locations.

So what do these changes mean?

Generally, you won’t have to change anything to start getting the benefit of the improved way VINx2 tracks your bonds.  The conversion from versions 3 to 4 will take care of most of the work for you.  But, if you have been using multiple copies of the same owner with different bonds, you can take steps to consolidate the owners in the system to represent the real ownership, rather than the ownership+bond combination that Version 3.x.x required.

One thing to note is if you have been using the different bond per owner to track multiple bonds at the same physical location (ignoring AP bonds for now, we’ll get to them in a bit) you could potentially end up needing to adjust the bond details after your version 3 to 4 conversion.  Depending on the reason you were tracking things this way, there will be a different solution, so rather than try and explain them all here, it would be best to contact VINx2 Support do we can help you work out the best option and help you update the system accordingly.

A special note on Alternating Proprietorship bonds

AP bonds are largely unaffected by this change, since they are designed to allow you to track a special sub-bond at the winery based on a special class of Owner owning that wine.  As such, you should not need to change anything with the way that AP bonds are tracked within VINx2.

How to dump bottles to bulk

The following support article will help you take bottles in inventory and dump them to bulk, and also trigger off the correct TTB events for your TTB report to show that the wine has been dumped to bulk.

Please note: if you are using our Sparkling module and the bottled wine is still on tirage, then you should use the Tirage Admin operation to transfer your tiraged stock back into tank in a single operation.  This will also take care of your TTB reporting.  The specific options for moving tirage stock back to tank are under the Split / Transfer tab.

There are a few requirements before we get started, the first is that you have a wine batch linked to your bottles so that it is classed as a wine stock item and tracked on your TTB report.
If the wine has previously been packaged within VINx2 it is pretty likely it is already linked up, if the bottles were not however there is a good chance they are not linked to a wine batch in the system.

When viewing the bottled stock you can check if it is a wine stock item in the bill of materials.
There will be a line item on the bill of materials containing a [wine batch]/BLK item, with a associated volume.
Additionally it will also need a tax class set.

The following support article also covers receiving and setting up wine stock items within VINx2.
Have a read over this before continuing if you are unsure whether or not the wine you are dumping to bulk is a wine stock item, or if you would like to first receive the goods before dumping to bulk.
[How to receive bottled wine stock into inventory]

After you have confirmed that the stock item is a wine stock item, or created the appropriate wine stock item you can then move onto dumping the bottles to bulk.
Start by performing a Stock Adjustment against the bottles, make sure to select the Reason ‘TTB – Dumped to Bulk’, this will show the bottled stock as dumped to bulk on your TTB report.

This finishes up the inventory side of things, now we need to bring the wine into the system.

Under the operations menu on the main screen select the bulk wine intake operation.
On the wine details tab you’ll want to select the batch/lot of the wine you are dumping to bulk, or create it.
After this is done enter in 0.01 gallons as the volume you are bringing in, this is important for the next step.
After this fill in the other wine details such as fraction type, fermentation state and colour.

Now head into the vessels tab, select the vessel you want to put the wine into and enter the amount you are dumping to bulk into the Transfer in amount.
Press the calculator button on the bottom right, this will calculate the gain required on the left hand side.
Finally Select the loss reason, ‘TTB – Bottled dumped to bulk’.

After filling out the composition information for the wine along with any other details you would like to record (such as analysis or additions) save the operation.
This will have 0.01 gallons of the wine arrive in the winery followed by a gain up to the amount as ‘bottled dumped to bulk’, depending on your TTB precision this will be rounded to the nearest whole gallon.

If you have any questions regarding the process feel free to contact the support desk and we can answer any questions or give you a run through.

Creating your first TTB Report (‘702’)

Generating a TTB Report (‘702’) in vintrace is usually a simple task that you can perform at the end of your reporting period (monthly, quarterly or yearly).  However, the first one you generate is likely to need some adjustments due to the fact that you would have been tracking gallons/movements in your old system/spreadsheets/paperwork part-way through the reporting period as well as in vintrace after going live.

If you are in this situation you will need to combine the details of two TTB Reports (‘702’) for your first report after go-live.

1) The first step is to work out the correct go-live date to use. This is typically the date of your vintrace training. If this date coincides with the first day of the reporting period, then you might not need to do anything other than run your first TTB report in vintrace. If you make any corrections to your opening vintrace balances that they are back-dated prior to this date.

2) Okay, so now you have the date, generate the TTB Report using your old system/spreadsheets/paperwork up until this date.  From the old system, we’re focusing on the opening balance and items describing “movements” in Sections A and B.  From this point, we’ll refer to this report as the “old 702”.

3) In VINx2, run the TTB Report (Reports -> Statutory reports -> TTB Report of Wine Premises Operations) with a start date of our date above, and a closing date of the end of the period.  In here, we’re we’re interested in the movement items and closing balances in Section A and Section B.  The 702 that vintrace generates will allow you to override the values before you print/submit to the TTB.  From this point on, this document will be referred to as the “vintrace 702”.

Please note that if the closing balances on your “old 702” do not match the opening balance on your “vintrace 702” it may be that the load-up data you sent us to be imported did not match up with your old system/spreadsheet/paperwork balance.  If this is the case, contact the Helpdesk so we can help you correct any inconsistencies before continuing.

4) On your “vintrace 702”, remove the opening balance volumes from Sections A and B and replace them with the values in the “old 702”.  For each of the movement items in Section A (items 2-11 and 13-30) and Section B (items 2-6 and 8-19), add the value from your “old 702” into the corresponding item on your “vintrace 702” (if the item is empty on your “vintrace 702” just copy the value from the “old 702” into the corresponding item).

5) The next step is to calculate the TOTAL for Section A (items 12 and 32) and Section B (items 7 and 21).  For Section A, add up items 1 through 11 in your “vintrace 702” and enter the value into item 12.  Then add up items 13 through 30, and subtract this number from item 31.  Enter the result into item 32.  At this point, 12 and 32 should be identical.  If not, double-check that you have not missed any items in step 4.  Do the same for Section B.  Total up 1-6 and enter into 7.  Then total up 8-19, and subtract this from value in 20.  Enter result into 21.  Again, these should match up.  If they do not, double-check step 4.

6) The last step is to check the back of the form.  You should be able to use the same principles as Steps 4 and 5 to record opening (from “old 702”) and closing (from “vintrace 702”) and items (combination of both 702s) for these parts.  For Part VII, the value from vintrace should be all you need in the “IN FERMENTERS END OF PERIOD” section.

Once you’re happy that the TTB Report balances, create a hard-copy by printing this, and file it away for future reference.

Now that you’re just using vintrace for recording your wine movements, each subsequent TTB Report (‘702) is as easy as running the one report in vintrace.  Simply go to Reports -> Statutory reports -> TTB Report of Wine Premises Operations then check the date range is the period you’re reporting for, and click the “Generate” button.

 

3.1.1 Artifically carbonated 702 TTB events

US Customers can now setup a treatment to apply to a wine that has been artificially carbonated.

Configure the treatment under Winery Setup | Treatments | Treatment (Product)

Name the treatment Carbonate Wine, tick Wine/Juice and the Change tax class check boxes. Select the Tax Class Carbonated wine and the change reason Produced by fermentation.

When the treatment is recorded against a wine VINx2 will record the 702 events for the “used for effervescent wine” reason

 

How to handle spirits in vintrace

vintrace now supports the handling of spirits on your TTB reports. For more details please read here: http://jx2.com.au/support/question/support-for-spirits-in-the-ttb-report-us/

Currently VINx2 does not report spirit use in our 702 Report and requires you to do some calculations outside of the report to get the correct value.  This is something we plan to rectify in the near future in the meantime the following is a guide to help make tracking your spirits easy in VINx2.

Remember you can click on the images to see larger copies of them

Setup Step 1. Setup A New Tax Class
This first step allows you to bring the spirit into the system and not have it effect any of the values in your current Tax Classes. This is done via the Winery Setup -> Policy -> Tax Class

Give the class the name and description ‘Spirits’ and use a TTB Class ref of ‘y’.
The Class ref of ‘y’ is really important!

Setup Step 2: Create an ‘Add Spirit’ treatment
This time in Winery Setup -> Treatment -> Treatment(Product) you can create a treatment to show that you added spirits. Make sure the Product type is set to Wine/Juice

Setup Step 3. Make Sure your multi top operation allows for treatments.
Open up a multi top operation and make sure there is a treatment directly under transfer options.

This can only be turned on by a support tech so please email us at support@jx2.com.au to request that treatments be turned on for Multi Topping Operations.

Ok so now the setup is done we can put it to use the following steps outline the use of these items.

Step 1. Bulk Intake Some Spirits
Using a standard Bulk Wine Intake bring the volume of spirits you have received and put it into the correct tank. You will be able to give the spirit all the grape origin information you require as per any bulk wine. The most import option is to ensure you give the spirit a tax state of ‘Bonded’ and a tax class of ‘Spirit’

Step 2. Use the Spirit
So now you have a tank full of spirit and you want to use it with some of your wine. Use the multi topping operation. This operation deliberately allows you to blend wines across different classes so you can use your spirit with a wine in any class. However be aware that the resulting blend will take on the tax class of the largest component. So if you are putting more spirits in than you have wine the whole lot will end up in our new spirit class and drop off the 702 Report.

When filling in the multi top make sure the Topping Mode is set to increase volume and select the ‘Add Spirit’ treatment we setup earlier.

Once you enter this operation your wine will show the ‘Add spirit’ in the history and it’s composition will include the spirit origins as well.

702 Reporting
Now that some of the spirit is in a wine with a reportable tax class VINx2 will show this gain in Section A Row 9. Inventory Gains. If this is were you currently report gains from spirit use then you need do nothing with this value. If you wish to report this gain on a different Row of the 702 you will need to calculate how much of Row 9 is from spirit.

To do this run the 702 Break down report selecting only spirit as an option

This will open the CSV in Excel where you can see how much spirits has been consumed in the ‘Inventory and non-tax losses’ column which by default is Column AK at the time of writing this documentation.

Once you have this value you then simply subtract this amount from Section A Row 9 and Add it to the Section/Row you wish to report this value in.

You will also have to report how much spirit you had on hand at the beginning of the period, how much you received, how much you used and the balance at end of period. Each of these are all in the CSV in the columns titled “Opening balance”, “Bulk received in bond”, “Inventory and non-tax losses” and “Closing balance”