Haruno can export a month's journal or trial balance from 弥生会計 Next for you, so you can close the month in the Portfolio. It only reads. Nothing is created, changed or paid in 弥生会計.
Mac appNot availableThe Mac app cannot export from 弥生会計 Next, and adding company files accepts only Excel, CSV and PDF, not the ZIP a trial balance arrives as.
Windows appAvailable
弥生会計 Next is Yayoi's cloud accounting service, and many small companies in Japan keep their books there. The connector named 弥生会計 Next lets Haruno fetch a month's reports from it. You then add the trial balance to a company in the Portfolio and close the month.
It only reads. Nothing is created, changed or paid in 弥生会計.
Connect it
Open Settings ▸ Connectors and find 弥生会計 Next under Finance. Enter your 弥生ID, which is the email address you sign in to Yayoi with, and your password, then press Connect.
The password is kept encrypted on this computer. Haruno types it only into Yayoi's own sign-in page, and it is never shown to the assistant. Disconnect deletes the stored sign-in.
Export a month
Ask Haruno in chat for a report and a month, for example the trial balance for August. There are two reports, one month at a time.
Report
What it is
What you get
Trial balance (残高試算表)
A list of every account and its balance at the end of the month
A ZIP with the balance sheet and the income statement
Journal (仕訳日記帳)
A list of every entry made in the month
An Excel workbook
Haruno signs in to Yayoi in its own browser. You can watch it in the Browser panel. The export takes a little while, and Haruno keeps checking until it is done. The file is saved in the project folder, under a folder called 弥生会計, where you and the chat can both open it.
If Yayoi asks for a second step to sign in, Haruno stops and asks you to finish signing in yourself in the Browser panel. Haruno also stops, and says why, if the page changed, if the portal did not answer, or if the month is outside the fiscal year.
Close the month with it
The Portfolio closes a 弥生会計 company from the trial balance ZIP. It does not read the journal.
Add the ZIP to the company
On the company's Files tab, or under Add data while it is being set up, press Upload files or drop the file. Pick the ZIP on its own. A ZIP found inside a folder is not added.
Analyze the data, the first time
Haruno drafts the company's mapping from what the export states, so it asks very little. The company must report in JPY, because the export is in yen and does not name a currency.
Close the month
Each later month is one more ZIP added the same way, then Close month…. See Closing a month.
A month corrected in 弥生会計 after it was reported is a restatement. The close stops and names the month. Reopen it with a reason, and the next close restates it. The corrected ZIP is saved beside the old one, and both stay.
A year of history in one file
Haruno exports one month at a time. For the months before the first close, export the trial balance by hand from Yayoi's portal in its monthly 推移 view, as CSV, and add that ZIP. Each month column is filed as its own month. Leave the 決 column out, and keep 部門 on すべて(合計).
What is left out, and what to know
The journal, the ledgers, and Yayoi's own entry or balance CSV files are not read by the close. They hold entries, not statements.
A trial balance made only of closing entries, one that covers more than one month, or one for a single department is left out with a reason. The company's other months still close.
A file must be as Yayoi made it. Every export says when it was made. A file that was edited or saved again, and lost that line, is left out. Export it again.
A month exported before it ended is reported but not locked. Export it again after the month ends.
Statement lines are captioned in English, such as Total Assets. Selling and administrative accounts keep their Japanese names.
A company keeps one source of statements. A company that already holds QuickBooks or Excel statement exports cannot also be drafted from a 弥生会計 trial balance. Add a new company for it instead.
What the close says about a refused file is written in English, even in the Japanese interface.