Skip to main content

tofu (Excel): A Universal Export Template

Learn about tofu (Excel), a universal export template that pulls every available field from your extraction so nothing is missed, and how to use it if you're on a bespoke or in-house accounting system.

J
Written by Jess B

Why the tofu (Excel) exists

Most export templates match one accounting software's column layout, so they can change whenever that vendor updates its import requirements.

tofu (Excel) is different: one stable, comprehensive format per extraction type, not tied to any vendor. If you're on a bespoke or in-house system, it's the fixed contract on tofu's side, your team or vendor maps it to your system, and that mapping stays reliable since the format itself never changes.


What's included

Extraction Type

Header fields

Line item fields

AP Bills / AR Invoices

Invoice Number, Invoice Reference, Type, Contact Name, Contact Code, Invoice Date, Due Date, Currency, Line Amount Type, Total Amount, Total Tax, Discount Rate, Discount Amount, Discount Type

Line Description, Line Quantity, Line Unit Price, Line Discount Rate, Line Discount Amount, Line Discount Type, Line Tax Rate, Line Tax Amount, Line Account Code, Line Account Name, Line Tax Rate Name, Line Debit Account Code, Line Credit Account Code, Line Debit Tax Rate Name, Line Credit Tax Rate Name, Line Tags, Line Debit Tags, Line Credit Tags

Direct Expenses

Reference, Transaction Date, Currency, Type, Spend Type, Payment Type, Contact Name, Contact Code, Total Amount, Discount Rate, Discount Amount, Discount Type, Line Amount Type

Line Description, Line Quantity, Line Unit Price, Line Amount, Line Tax Rate, Line Tax Amount, Line Account Code, Line Account Name, Line Tax Rate Name, Line Debit Account Code, Line Credit Account Code, Line Debit Tax Rate Name, Line Credit Tax Rate Name, Line Tags, Line Debit Tags, Line Credit Tags

Bank Statements

Bank Name, Account Number, Currency, Opening Balance, Closing Balance, Credit Total, Debit Total, Subtotal

Transaction Date, Transaction Currency, Description, Contact Name, Amount, Balance, Reference, Check Number, Tax Rate, Tax Amount, Debit Tax Rate, Debit Tax Amount, Credit Tax Rate, Credit Tax Amount, Account Code, Account Name, Tax Rate Name, Debit Account Code, Debit Tax Rate Name, Credit Account Code, Credit Tax Rate Name, Debit Tags, Credit Tags

Sample files: download an example export for AP Bill, AR Invoices, Bank Statements, Direct Expenses to see the exact format.

Note: Since the tofu (Excel) exports every available field, some columns may be blank if that data wasn't captured for a particular document.


How to export using tofu (Excel) format

  1. Select your Ready extractions. Only Ready extractions can be exported, so mark them Ready first. To find them quickly, set the Extraction Status filter to Ready in the Extractions panel.

    • Individual: open the Ready extraction from the review page and click Export, or select it from the Extractions panel.

    • Bulk: from the Extractions panel, select the extractions you need. To select all, click the checkbox beside Extraction or use the keyboard shortcut Shift + E.

  2. Click Export.

  3. Choose tofu (Excel) from the export format list. Available for AP Bills, AR Invoices, Bank Statements, and Direct Expenses.

After you export, your extractions move to Exported. Once you’ve used the file, click Mark Done to wrap them up. To skip this step, turn on Auto-Done under Entity Settings → Features → Extraction Types, in Document Lifecycle for the extraction type.

Tips

  • Use filters (supplier, customer, or extraction type) to export only what you need.

  • Export in batches to make mapping easier.

  • Use the Ready filter to see which extractions haven’t been exported yet before starting an export session.

Did this answer your question?