Track everything a fan spends: ticket lottery rounds and refunds, concerts and fan meetings, trips abroad in other currencies, and merch, for several idols or groups at once.

What's inside

• Language switch: Chinese, English or Japanese labels, chosen from one dropdown.

• Ticket lottery log: each round's prepaid amount, non-refundable fee and result (pending, won, lost with refund due, refunded, or lost with nothing prepaid). It shows refunds you're still waiting for and money held by pending results.

• Multiple idols and groups: totals and share of spending for each.

• Events: totals for tickets, transport, lodging, merch and other, compared with each event's budget.

• Trip currencies: enter costs in JPY, KRW, USD or any currency you add. They're converted with rates you type in. Nothing is fetched online.

• Monthly budget vs actual for 12 months, from any start month.

• Dashboard: spending by category, grand total, win rate and year budget left.

• 21 built-in checks: each shows green OK or red CHECK, with an overall status on Start Here. A hidden audit recomputes calculated cells row by row and catches most typed-over formulas, but not every case. The README lists the exceptions.

• Any name works: names like >_<, <3 Tour or Star* are matched exactly. Case is ignored. Names starting with = need a leading apostrophe ('=LOVE).

• Sample data with fictional groups, plus a simple way to clear it.

Please note

• Tested in LibreOffice and Google Sheets (not Excel).

• The hidden Lists and Lang sheets are protected in Excel and LibreOffice only. In Google Sheets they stay hidden but are not protected; the README shows how to add protection (Data > Protect sheets and ranges).

• Korean labels are not included yet.

• Exchange rates are typed by you and are not live. This is a budgeting tool, not financial or tax advice.

• Room for 300 expenses, 100 lottery rounds, 50 events, 20 idols and 12 currencies. Typing just below a full table shows CHECK.

• No artist names, logos or photos are included. All sample names were made up for this template. As of 2026-10-16, web and YouTube searches found no match for them.

Digital file only. Nothing will be shipped.