How do I get a trial balance, balance sheet and P&L from daily records?
Register your industry and opening balances, record receipts and payments, confirm them, and download the trial balance, balance sheet and profit and loss statement.These are the 6 steps in NAGASHIRO Report Desk (operated by Nagashiro LLC / Nagashiro International Accounting & Legal Office).
Overview
| Step | What to do | Note |
|---|---|---|
| 1 | Sign up with an email address, then set the company name and password | You must accept the terms. New sign-ups are closed during the test version |
| 2 | Register the industry, fiscal year-end month and whether you have employees | After the first save, only the office can change them |
| 3 | Enter cash and bank balances on the first day of records (opening balances) | The office assists with entering and checking them before they apply. The user or a licensed tax accountant decides whether the amounts are correct |
| 4 | Record receipts and payments | On screen, with the Excel template, from bank statements (optional), or from receipt images (read only with your consent) |
| 5 | Check and confirm the unconfirmed rows | Leave category or tax rate blank if you do not know. Blank rows stay unconfirmed. The office only assists with entering and checking book data. The user or a licensed tax accountant decides whether accounts, tax categories and amounts are correct. |
| 6 | Download the trial balance, balance sheet and P&L as Excel / PDF | No output if debits and credits differ or an account has no section |
When can I not get the reports?
If debits and credits differ, or an account has no section, the reports are not produced (BLOCKED).
If opening balances are missing, or two records have the same date and amount, the reports are produced with a warning (NEEDS_REVIEW).
How are sales records handled?
If there are no sales records such as POS daily reports or register Z reports, only bank deposits count as sales, and a warning shows.
The user or a licensed tax accountant decides whether cash sales are missing. The office assists with checking.
FAQ
- Do I enter amounts with or without consumption tax?
- The Excel template has a tax-rate column, and books are kept excluding tax. The user or the user's adviser decides how to treat consumption tax.
- What if I upload the same file twice?
- The same rows are not added again.
- What format do bank statements need?
- The header row needs date, description, withdrawal and deposit columns. The rows become unconfirmed rows.
- Can I file a tax return with these reports?
- This tool does not prepare tax returns. Check the output yourself, and ask a licensed tax accountant to file.
Official sources
- Ordinance on Company Accounting (e-Gov, Japanese)
- Enforcement Regulation of the Corporation Tax Act: books (e-Gov, Japanese)
This tool does not prepare tax returns and does not calculate tax or give tax advice on individual cases. Tax agency, preparation of tax documents and tax consultation are the work of licensed tax accountants (zeirishi), including tax accountant corporations. This service and its operator (Nagashiro LLC) do not do this work. For individual tax questions, ask a licensed tax accountant (zeirishi) or tax accountant corporation.
This is a test version. The terms of use are a draft, and new sign-ups are closed.
Nagashiro LLC (合同会社ながしろ), Nagashiro International Accounting & Legal Office / 〒111-0053 東京都台東区浅草橋1-4-4 斉藤サンエスビル2階 TEL 03-5809-2334