Ori Accounting CSV: freee, Money Forward, Yayoi

How do I export an accounting CSV from Ori?

To export an accounting CSV from Ori, open Archive, choose a Period in the Export card, select Accounting CSV, pick your Accounting software and the Document type posted as sales, then click Start export. Ori writes that type’s documents in your software’s own import format, one line per tax rate, and you import the file yourself.

  1. In Ori, open Archive and find the Export card.
  2. Choose a Period: This month, Last month, Last 3 months, This fiscal year or All time.
  3. Under Format, choose Accounting CSV.
  4. Under Accounting software, choose freee, Money Forward Cloud, Yayoi Kaikei (tax-inclusive bookkeeping) or Yayoi Kaikei (tax-exclusive bookkeeping). For Yayoi, pick the bookkeeping method your Yayoi company is set to.
  5. Under Document type posted as sales, choose Invoice or Receipt: “Only documents of this type are exported, so the same sale is never posted twice.”
  6. Click Start export. Start this export? shows the period, the format, the type and Documents included. Click Start export again.
  7. Ori shows “Preparing export…” with a count; “Processing continues if you leave this page.” When it says “Export complete”, click Download.

Which documents does the CSV include?

Ori’s accounting CSV includes only the issued documents of the type you choose under Document type posted as sales, Invoice or Receipt, dated in the period, so each sale is posted once. Quotations, delivery notes and purchase orders are never included, and neither are voided documents or unissued drafts.

  • A sale has one document behind it in the books: an invoice for a sale billed now and paid later, or a receipt for one paid at the time. If you’re not sure which your books use, ask your tax accountant.
  • Documents included in the confirmation counts only the type you chose.
  • The card opens on the type you exported last time, and on Invoice before your first accounting CSV.

Important: If you export both types for the same period, any order that has both an invoice and a receipt is posted twice. Export one type, or make sure no order has both.

What does each row contain?

Each line of Ori’s accounting CSV is one tax rate of one document, written in the chosen software’s own import format, so an invoice with 10% and 8% items becomes two lines. The amount is the tax-inclusive total for that rate. What each software’s file holds:

freee Money Forward Cloud Yayoi Kaikei
Format freee’s deal import (取引のインポート), with freee’s own header row Money Forward’s journal import (仕訳帳), with its 27-column header row The Yayoi import format (弥生インポート形式): 25 items a line, no header row
Each document One income deal (収入), one line per rate One journal entry, one line per rate One journal per rate
Accounts 売上高 (sales), left unsettled, so freee books 売掛金 (accounts receivable) 売掛金 debit, 売上高 credit 売掛金 debit, 売上高 credit
Tax category 課税売上10%, 課税売上8%(軽) or 対象外 課税売上 10%, 課税売上 (軽)8% or 対象外 課税売上込10% and 課税売上込軽減8% (tax-inclusive bookkeeping), 課税売上内10% and 課税売上内軽減8% (tax-exclusive), or 対象外
Tax amount The document’s own Left blank: Money Forward calculates it The document’s own
Customer The recipient, on invoices only Not filled in Not filled in
Encoding UTF-8 with a BOM UTF-8 with a BOM Shift-JIS
  • Each line’s description (摘要, or freee’s 備考) holds the document’s title, number and recipient, and freee’s 管理番号 (reference number) holds the document number.
  • A document with negative amounts, such as a refund, is posted as a return with positive amounts: an expense deal (支出) on 売上高 in freee, and a debit to 売上高 at the return tax category (課税売上-返還等 in Money Forward, 課税売返 in Yayoi). A line with a zero amount is left out.
  • The document’s date is the order’s date for a document issued from an order, and the day you issued it for one made in New document: document numbers in Ori.
  • The file is named ori-accounting-invoice-….csv or ori-accounting-receipt-….csv, so files for the two types never share a name.

Note: Yayoi Kaikei Online imports up to 1,000 lines a file, so export a shorter period if it refuses a file. If your Money Forward books enter tax separately (税抜(別記)), edit each entry after the import, as Money Forward asks for its own sales exports.

Does Ori connect to freee, Money Forward or Yayoi?

No. Ori does not connect to freee, Money Forward Cloud or Yayoi Kaikei: it writes a file in the import format of the software you chose, and you import that file yourself. Check what your software’s import screen shows before you confirm.

  • In freee: 取引入力 → 収入・支出形式(取引の一覧・登録) → ・・・ → 取引データのインポート.
  • In Money Forward Cloud: 会計帳簿 → 仕訳帳 → インポート → 仕訳帳.
  • In Yayoi Kaikei: its journal data import (仕訳データのインポート), which reads the Yayoi import format.

Ori also doesn’t send the file anywhere. Each export is recorded in the archive’s audit log: “Export history is also recorded in the audit log.”

How is it different from the audit ZIP?

The accounting CSV and the audit ZIP sit in the same Export card and do different jobs. The accounting CSV holds one document type’s amounts, per tax rate, for your bookkeeping. The audit ZIP holds the PDF of every document and every earlier version, with an index CSV, for a tax audit or your tax accountant.

Accounting CSV Audit ZIP (PDFs + index CSV)
For Your accounting software A tax audit, your tax accountant
Documents Invoices or receipts, one type per file Every document type, every version
Contents One line per tax rate of each document, in your software’s import format PDFs, and an index with one row per stored version
Voided documents Left out Included, marked voided

How the audit ZIP works: how do I export documents for my accountant?

Ori Order Printer: PDF Invoice

Ori is a Shopify app that turns orders into numbered PDF invoices, receipts, delivery notes, quotations and purchase orders. For shops in Japan, its designs print the qualified-invoice items: your registration number, the totals and tax at 8% and 10%, and, on Japanese designs, the reduced-rate marks. Every issued PDF is kept with its hash and every earlier version. Every feature is free, including email and receipts customers issue themselves.

Need help with Ori? Email support@b2bgold.app.