Add a company by hand or from QuickBooks, drop its accounting exports onto it, and let Haruno read them into a draft that you approve before the first close.
Mac appAvailable
Windows appAvailable
A company gets into the Portfolio in one of two ways. You can fill it in by hand and add its files, or you can add it from QuickBooks and let Haruno bring its months. This page is about the first way. For the second, see QuickBooks.
Add the company
Press Add company
It is the plus at the right of the Portfolio toolbar. A sheet called Company details opens with two tabs, Fill in by hand and From QuickBooks.
Add company, filled in by hand.
Type the name
The name is the only required field. Under Company details (optional) you can add the tax jurisdiction, the legal entity type and the EIN. The EIN is the nine-digit business tax number the US tax office issues. You can add any of these later with Company details on the company's page.
Press Save
The company opens on its own page, ready for files. A name that is already in use is refused, and so is a name an archived company holds. Restore that one instead.
Add the files
Haruno builds the books from the company's accounting exports. Bring a Balance Sheet and a Profit and Loss by month, ideally the last 24 months, as Excel exports. A balance sheet lists what the company owns and owes on a date. A profit and loss lists what it earned and spent over a month. A reconciliation workbook and a billing export are optional.
Drop files or a whole folder onto the page, or press Upload files or Open a folder. Haruno accepts:
Excel (.xlsx) and CSV files, and PDF files, including those in subfolders.
A ZIP (.zip) that you choose on its own. A 弥生会計 trial balance arrives as one.
Haruno copies the files into the company. Your originals stay where they are.
The Files tab. Drop files here or press Upload files.
Only some PDFs are read
The one PDF Haruno reads is a QuickBooks reconciliation report. For any other PDF the page says to export the report to Excel and add that file. Annual reports belong in a project, not here. A ZIP found inside a folder is not added, and neither is a ZIP over 64 MB.
After you add files, an Import results list says what happened to each one. A file can be read, not recognized, skipped, or not in the mapping. A file with the same name as an earlier one is saved beside it, and the older file is never replaced. A file that is an export of a different company is flagged, so you can move it to the right one.
The Read as menu on a file lets you tell Haruno what the file is, such as Trial balance, Budget or Billing invoices. Leave it on Automatic unless Haruno guessed wrong.
From files to a first close
A new company moves along a short path, shown at the top of its page.
Setting up a company: add data, analyze it, review the draft.
Add data. Drop the files.
Analyze data. Haruno reads the files once and writes a draft of the company's mapping. The mapping says which account goes on which line of the statements. Nothing is closed and nothing is changed by reading.
Review the draft. You check Haruno's suggestions and approve them. A bar at the bottom of the review says what is left, and Show next takes you to the next item that needs you. Approve mapping in that bar finishes the step. See Mappings.
Ready to close. The first close creates the company's first report. See Closing a month.
Before you can approve the mapping, the company needs a reporting currency and a fiscal year-end month. Set them in Company details. Haruno asks for them when they are missing.
Files after the first close
Add each new month's files the same way. The page then shows how many new files arrived since the last close. A file a close has read stays in the company, because its figures are already in the books.