Skip to content
BrewKeeper Docs

Excise Tax Report

Purpose: Generate a Tax Excise Report compliant to Japan standards

Prerequisites

  1. You have created a Bonded Area in Warehouse > Settings
  2. You have created in Accounting > Settings

Accounting > Reports > Excise Tax Report

The first and last days of the previous month are automatically input into the From and To date fields for convenience when you first visit this page.

The table you are presented includes all physical inventory that has:

  1. Left any bonded areas
    This may include multiple bonded areas with multiple locations
    This does not include inventory transferred between bonded areas
  2. AND THEN entered into any other pile
    This does not include destroyed inventory
  3. Within the timeframe selected
  4. Grouped by Product, SKU and variant size

What about returns? If the inventory enters a bonded area, it will not be seen by this report.

What about reverts? A revert is an accidental scan that has been undone, so you need to think about it as never having happened in the first place.

Reverts are calculated and automatically subtracted from the table you see.

Another table is shown below which shows you any returned inventory
Returned table includes all physical inventory that has:

  1. An ‘undo’ scan associated
  2. Entered any bonded area
  3. FROM another pile
    This does not include destroyed inventory
  4. Within the timeframe selected
  5. Grouped by Product, SKU and variant size

Reverts

A revert must take place during the report time to take affect.
Eg. If a keg is fulfilled on the last day of the month

Low fills

Make a new row in the spreadsheet, because there is a different volume.

V2

Since 2023, the Tax forms have changed, and Breweries have been manually updating their spreadsheets.

Changes include:

  1. A new page (tab 2) which gives additional information
  • A cell with a cumulative total for this tax year
  • Data that was previously on a

Storing Excise Tax monthly totals in BrewKeeper

Year

  • Tax Month number (01 = April)
    • JP Category code => Month Total Tax for code
    • Total => Sum(codes)
2025:
  1:
    "350": 100
    "581": 150
    "582": 125
    "Total": 375
  2:
    "350": 100
    "581": 150
    "582": 125
    "Total": 375
2024:
  1:

Tabs

使い方 How to Use

酒税納税申告書

税額算出表

戻入れ種類の控除(還付)税額計算表

returned alcoholic beverages - only adds if there are returns

課税税額計算(明細)書

戻入酒類明細書

detailed excise tax returns. only adds if there are returns

元データ (戻入れ)

raw data incoming

元データ (出荷)

raw data outgoing

Columns

The following columns are for transfers between bonded areas (?)

F ① 総移出数量 ML

Total volume left bonded area

G ② 未納税移出数 ML

The volume left bonded area WITHOUT paying tax (eg. transfer between bonded areas)

G ③ 輸出免税数 ML

The volume exported (therefore not subject to tax)
NOT CURRENTLY SUPPORTED

H ④ 税標準数 (① - ② - ③ ) ML

Taxable volume = ① - ② - ③