Skip to main content

How to Export AP Bills in CSV or Excel Files

If you're not using an accounting integration, you can export AP Bills from tofu using pre-formatted CSV or Excel templates for easy upload into your accounting system. This also applies to read-only integrations.

Written by Jess B

Step 1: Select AP Bills

Only Ready AP Bills can be exported, so mark them Ready first. To find them quickly, go to your Extractions column and set the Extraction Status filter to Ready. You can select AP Bills in a few ways:

  • Manually select individual AP Bills

  • Use the Extraction filters to view only AP Bills, then click the checkbox beside Extraction to select all

  • Or use the keyboard shortcut Shift + E to select all visible AP Bills

💡 Tip: Selecting multiple AP Bills at once allows you to export in bulk and save time. You can also include AP Bills that are already Exported, for example to re-export a batch with a different template.


Step 2: Click Export

After selecting your AP Bills, click the Export button.


Step 3: Choose Export Format

You'll be prompted to choose an export format. Available options include:

  • Access UBS (CSV)

  • Accounting AI (CSV)

  • AutoCount Cloud (Excel)

  • AutoCount Desktop (Excel)

  • BrightBooks Supplier Invoices (CSV)

  • BrightBooks Supplier Invoices Summary (CSV)

  • Bukku (Excel)

  • enoFin (Excel)

  • EPSON財務会計 仕訳データ (CSV)

  • Express - Bank Fee (Excel)

  • Express (Excel)

  • FAST - Voucher (Excel)

  • FAST (Excel)

  • Foodics (Excel)

  • freee (CSV)

  • Jaz (Excel)

  • Manager.io (Excel)

  • Microsoft Dynamics 365 (Excel)

  • Million Business Software (CSV)

  • MISA AMIS Purchase Domestic (CSV)

  • MISA AMIS Purchase Imported (CSV)

  • MISA ASP (CSV)

  • MISA Offline Purchase Goods No Warehouse (CSV)

  • MISA Offline Purchase Goods Warehouse (CSV)

  • MISA Offline Purchase Services (CSV)

  • MJS Miroku 仕訳データ (CSV)

  • Money Forward - Invoice Compliant (CSV)

  • Money Forward Cloud Accounting (CSV)

  • Multibook (Excel)

  • MYOB - ABSS Premier V30.4 (CSV)

  • MYOB - ABSS Premier V30.4 (Excel)

  • NetSuite (CSV)

  • NetSuite Tax Override (CSV)

  • Odoo (Excel)

  • Peak - Bank Fee (Excel)

  • PEAK (Excel)

  • QNE - Past Bills (CSV)

  • QNE - Purchase Invoices (CSV)

  • QuickBooks Desktop (IIF)

  • QuickBooks Desktop (IIF) - 2016

  • QuickBooks Desktop (IIF) - 2021

  • QuickBooks Desktop (IIF) - Premier 2024

  • QuickBooks Journal Entry (CSV) (available when Journal Entry Format is enabled)

  • QuickBooks Online (CSV)

  • Sage 300 (Excel)

  • Sage 50 Cloud (Excel)

  • Sage 50 Desktop (Excel)

  • Sage 50cloud Pastel Partner (Excel)

  • Sage Accounting CA (Expense CSV)

  • Sage Accounting IE (Expense CSV)

  • Sage Accounting UK (Expense CSV)

  • Sage UBS Accounting (Excel)

  • SAP (Excel)

  • SQL Accounting (CSV)

  • Tally (XML)

  • ThaiTax (Excel)

  • tofu (Excel)

  • TR Cloud Head (CSV)

  • TR Cloud Item (CSV)

  • UAE FTA VAT311 (Excel)

  • VT Transaction+ (CSV)

  • Winton (Excel)

  • Winton AP List (Excel)

  • Xero (CSV)

  • Xero Manual Journal (CSV) (available when Journal Entry Format is enabled)

  • Zoho Books (CSV)

  • キーパー財務 仕訳データ (CSV)

  • ジョブカン会計 仕訳データ (CSV)

  • ジョブカン会計 仕訳データ (取引先あり、コードなし)

  • フリーウェイ経理 仕訳データ (CSV)

  • 会計王 仕訳データ (Excel)

  • 弥生会計 (CSV)

💡 Tip: If you always export to the same accounting software, for example freee, set CSV Export Target to that software in your Entity Settings → Features. Your exports will then use that template automatically, so you don't have to scroll through the full list each time.

If you switch between multiple export templates, keep CSV Export Target set to None so you can choose the template at export time.


Step 4: Mark Done

After you export, your AP Bills move to Exported. Once you've imported the file into your accounting system, click Mark Done to wrap them up. To skip this step, turn on Auto-Done under Entity Settings → Features → Extraction Types → AP Bills → Document Lifecycle. You can also turn on Auto-Ready there, so clean Drafts move straight to Ready.


Tips for Efficiency

  • Use filters (such as supplier or date range) to export only the records you need.

  • Export in smaller batches to make review and import easier.

  • Maintain a regular export routine (for example, weekly or monthly) to keep your accounting records up to date.

  • Familiarize yourself with the Extractions view to speed up selection and export workflows.

  • Use the Ready filter to see which AP Bills haven't been exported yet before starting an export session.

Did this answer your question?