Automate Monthly Consumption Tax Return Prep with Closing Workflows

For many Japanese companies, the consumption tax return is a twice-a-year shock. Interim returns land in the middle of the fiscal year, and the final annual return lands at the end. In both cases, the finance team digs through spreadsheets, reconstructs output tax and input tax from memory, and hands a pile of reconciliations to the tax accountant at the last minute. The annual return itself is always the tax accountant's job. What changes everything is what happens in between: a monthly closing workflow that ties figures down every single period, so the interim and annual returns are ready, not a scramble.

This article is a practical, plain-language walkthrough of how a double-entry core business system structures consumption tax figures month by month. It is written for owners, CFOs, and operations heads, not developers. We will not promise automatic filing to a government portal, because the system does not do that. What it does is give your tax accountant a clean, locked set of figures per period, with the qualified-invoice details already captured.

The Problem

The core pain is reconstruction. When monthly figures are never tied down, each tax return becomes a forensic exercise. Someone opens last quarter's sales ledgers, pulls out the consumption tax line, tries to separate the 10 percent standard rate from the 8 percent reduced rate, then hunts down the input tax credit calculations across purchase bills. Multiply that across a year of invoices and bills, and the tax accountant spends days rebuilding what should have been a simple report.

Three structural problems make this worse.

First, output tax and input tax live in the same general bucket. Without separate sales-tax and purchase-tax accounts, you cannot see what you collected versus what you paid at a glance. Second, multi-rate handling is manual. A single invoice might mix standard-rate goods with reduced-rate items, and if the tax rate is not stored on each line, the calculation breaks. Third, there is no clean period boundary. Invoices and bills float across months with no closing lock, so the "as of this period" number keeps drifting.

The qualified-invoice system, which started in October 2023, sharpened all of this. Your company registration number must appear on invoices, and the input tax credit now depends on the seller's registration. Transitional measures were revised by the 2026 tax reform. Deduction rates run at 80 percent until September 2026, then 70 percent from October 2026 through September 2028, then step down to 50 percent, 30 percent, and 0 percent from October 2031. Any framing of a straight drop to zero by 2029 is outdated. Storing the right registration numbers and tying each invoice to a tax period is no longer optional.

A Real-World Scenario

Consider a freight forwarder in Kobe with about 90 staff. The company handles domestic freight, customs brokerage, and warehousing, so its invoices mix services at the 10 percent standard rate with storage and handling charges that may sit at different rates depending on classification. For years, the finance team rebuilt the consumption tax figure from scratch each quarter.

Before the change, quarterly interim return prep took about two weeks of staff time. Sales invoices sat in one folder, purchase bills in another, and a senior accountant manually separated output tax from input tax using spreadsheet macros nobody else understood. Errors surfaced late, sometimes after the interim return was already filed. When the tax accountant arrived for the annual final return, the team would spend a full week reconstructing the year.

The company then adopted a double-entry core business system with configurable tax settings and a closing schedule. Within two cycles, the quarterly prep dropped from two weeks to a few days, and the annual return prep fell from a week of reconstruction to a packaged handover. The tax accountant received clean, period-locked figures with the qualified-invoice registration numbers already attached to each business partner. No forensic digging, no spreadsheet macros.

What Changes

The shift is structural, not cosmetic. A core business system changes the consumption tax workflow in five concrete ways.

Output tax and input tax now live in separate, correctly typed accounts. When the system writes a sales-tax account, it enforces that the account is a liability subtype, because that is tax you owe. When it writes a purchase-tax account, it enforces an asset subtype, because that is tax you paid. This is not a label you hope people get right. The system refuses to save the wrong combination. The result is a clean separation that makes the interim and annual returns a matter of reading two accounts.

Each tax rate is its own configuration record. A single company can hold the 10 percent standard rate and the 8 percent reduced rate side by side, each pointing to its own sales-tax and purchase-tax accounts. An invoice line carries its tax setting, so a mixed invoice calculates correctly line by line. No manual rate lookup, no end-of-quarter rework.

Every sales invoice and every purchase bill generates its own journal entries automatically. The days of a bookkeeper typing the consumption tax line by hand are gone. The double-entry engine posts the entry, validates the type, and moves on. Credit notes are handled as a distinct invoice type, so refunds and adjustments flow through the same structure.

Your qualified-invoice registration number is stored in company settings and printed on every invoice. Each business partner carries its own registration number and corporate number, captured once at onboarding. When the tax accountant needs the input tax credit detail, the partner registration numbers are already there, tied to the bills they came from.

The closing run locks each period. A closing schedule defines the period start and end dates, which remain editable until temporary close. When the run executes, it closes the period and ties every invoice and bill to that run. The result is a locked, clean set of figures for that period. The next quarter does not disturb the last quarter, and the annual return is a roll-up of locked periods, not a fresh reconstruction.

The Steps

Here is a practical checklist for running consumption tax prep through a monthly closing workflow. Treat each step as something the system either handles automatically or makes a one-time configuration.

Configure each tax rate as its own record. Set the 10 percent standard rate and the 8 percent reduced rate, each with its own sales-tax liability account and purchase-tax asset account. Do this once per company.
Store your qualified-invoice registration number in company settings, and confirm it prints on invoices. Enter each business partner's registration number and corporate number when you onboard them. The system stores these numbers but does not verify them against the tax-office public registry, so confirm accuracy at entry.
Tag every product and invoice line with the correct tax setting. Because the tax setting lives on the line, mixed invoices calculate line by line. This removes the end-of-quarter scramble of separating rates by hand.
Let the system generate journal entries automatically. Every sales invoice and every purchase bill posts its own entries, with entry-type validation. Credit notes flow through as their own invoice type. No manual posting, no transcription errors.
Run the monthly close. Confirm the period start and end dates, then execute the closing run. This locks the period and ties every invoice and bill to it. Until temporary close, the dates stay editable if you need to adjust.
Review output tax and input tax for the period. Read the sales-tax liability account for output tax and the purchase-tax asset account for input tax. The separation is enforced by account subtype, so the figures are trustworthy.
Hand the period package to your tax accountant. The locked figures, the qualified-invoice registration numbers, and the per-period breakdown travel together. Your tax accountant prepares the interim and annual returns from clean data, not from a reconstruction.
Repeat every month. The compounding effect is the point. By the twelfth close, the annual return is a roll-up of 12 locked periods, each already reconciled.

Frequently Asked Questions

Does the system file the consumption tax return automatically?

No. The final annual return and the quarterly interim return remain the tax accountant's job. The system structures the data, captures the qualified-invoice details, and locks clean figures per period. Your tax accountant works from a packaged handover instead of a reconstruction.

How does the system handle the 8 percent reduced rate and the 10 percent standard rate together?

Each rate is a separate configuration record with its own sales-tax and purchase-tax accounts. A product or invoice line carries its tax setting, so a single invoice that mixes reduced-rate food and beverages with standard-rate services calculates correctly line by line. Multi-rate is native, not bolted on.

What about the qualified-invoice system transitional measures?

The system stores your registration number and each partner's registration number, printed on invoices and tied to the relevant bills. The transitional deduction schedule, revised by the 2026 tax reform, runs 80 percent to September 2026, then 70 percent to September 2028, then 50 percent, 30 percent, and 0 percent from October 2031. The system gives your tax accountant the underlying figures to apply the correct transitional percentage.

Do we need developers to change tax rates later?

No. Tax settings, company settings, and business partner master data are all configurable without code changes. Adding a rate or adjusting an account is an administrator task, not an engineering project. You can try the full workflow on Kikan System free with up to 2 users and no credit card, and reconfigure tax settings whenever the schedule changes.

Key Takeaway

The consumption tax return stops being a shock the moment figures are tied down every month. A double-entry core business system with configurable tax settings, automatic journal entries, separate output-tax and input-tax accounts, and a locked closing run turns twice-a-year reconstruction into a packaged, period-by-period handover. The tax accountant still owns the interim and annual returns. Your team owns the months in between, and now those months are clean.

Ready to Clean Up Your Monthly Close?

Kikan System is a modular ERP authored natively in Japanese and English, built for the Japan market and the qualified-invoice system. Configure your tax rates, separate your output-tax and input-tax accounts, and run a locked monthly close that hands clean figures to your tax accountant. Start free with up to 2 users and no credit card.

(-> Start free)(/#get-started)