How to Import Invoices into Sage (50, Business Cloud & Intacct)

Sage 50 imports invoices through CSV files with columns for Type, Date, Net Amount, and Tax Code. Sage Business Cloud uses quick entry import through its online interface. Sage Intacct accepts CSV imports via Configuration Packages. All three products require properly formatted CSV files with product-specific column structures.

This guide walks you through the full process to import invoices into Sage regardless of which product you use. You will find:

How to identify which Sage product and version you are running
Step-by-step import methods for Sage 50, Sage Business Cloud, and Sage Intacct
The exact CSV format specifications each product expects, compared side by side
How to convert PDF invoices into Sage-ready CSV files before import
Fixes for common import errors that block or corrupt your data

Whether you need to import a batch of vendor purchase invoices or load sales invoices during a system migration, the guide covers all three Sage products in dedicated sections. Jump directly to the one that matches your setup.

Which Sage Product Are You Using?

The name "Sage" now covers three distinct accounting platforms, each with its own architecture and import method. Confirm which product you are on before following import instructions — the file formats are different.

Here is a quick breakdown of the three main Sage accounting products:

Sage 50 (also sold as Sage 50cloud) is a desktop-installed application with a long history in the UK small business and accountancy market. It supports CSV-based invoice import and is built around strong compliance with UK VAT rules and Making Tax Digital requirements. If you installed software on your local machine or a network server, you are almost certainly on Sage 50.
Sage Business Cloud (Sage Accounting) is a cloud-based online accounting platform aimed at smaller businesses. You access it through a web browser at sage.com, and the dashboard will display "Sage Accounting." Its import functionality relies on quick entry through the online interface, and it carries a lighter feature set compared to Sage 50 or Intacct.
Sage Intacct is a cloud-based ERP platform designed for mid-market financial controllers and AP teams at larger organizations. It supports Configuration Packages and CSV import, and it handles multi-entity and multi-currency environments natively. If your browser-based dashboard reads "Sage Intacct," that is your product.

The fastest way to identify your version: if you double-click an icon on your desktop to open it, you are on Sage 50. If you log in through a browser, check whether your dashboard says "Sage Accounting" or "Sage Intacct."

Sage holds a dominant position in the UK accounting software market, and a large share of its user base relies on efficient data import to meet compliance deadlines. HMRC's final evaluation of Making Tax Digital for VAT found that the shift to digital record-keeping software saved UK businesses an estimated 32 million to 49 million hours in the 2022-2023 tax year, with the financial value of that time estimated at between 603 million and 915 million pounds. For Sage users handling VAT-registered clients or their own filings, an efficient invoice import workflow directly supports that time saving.

If you are migrating invoices from another accounting platform such as QuickBooks, Xero, or a spreadsheet-based system, the import methods in this guide apply to your migration scenario as well. The CSV formatting requirements are the same whether your source data comes from an export, a manual spreadsheet, or an OCR-based invoice integration with SAP, QuickBooks, and Xero. Teams moving between Microsoft and Sage ecosystems may also need to import invoices into Dynamics 365 Business Central, which follows a comparable CSV-based workflow with its own field mapping requirements. If your migration involves MYOB rather than Sage, the process for importing invoices into MYOB uses its own Import/Export Assistant with different CSV formatting rules.

How to Import Invoices into Sage 50

Sage 50 uses CSV files as the primary method for importing invoice data. Both sales invoices and purchase invoices can be imported this way, though the column structure varies slightly depending on the transaction type.

Required CSV Column Format

Your CSV file needs to include specific columns that Sage 50 recognizes. The core columns are:

Type: Identifies the transaction. Use SI for Sales Invoice, SC for Sales Credit, PI for Purchase Invoice, or PC for Purchase Credit.
Account Reference: The customer or supplier account code already set up in your Sage 50 accounts.
Nominal Code: The general ledger code for the transaction. Common defaults include 4000 for Sales and 5000 for Purchases, though your chart of accounts may differ.
Date: The invoice date. For UK Sage 50 installations, this must follow the DD/MM/YYYY format.
Reference: The invoice number or your own reference identifier.
Net Amount: The pre-tax value of the transaction.
Tax Code: The VAT code that applies. Standard values include T1 for the standard 20% rate, T0 for zero-rated transactions, and T9 for transactions outside the scope of VAT.
Tax Amount: The calculated VAT amount. If you leave this column blank, Sage can auto-calculate it based on the Tax Code you provide.

One important detail: Sage 50 does not support importing invoices with individual line items through the standard CSV import. Each row in your CSV represents a single transaction line. If you need to import an invoice with multiple line items, each line item requires its own row, all sharing the same invoice reference in the Reference column.

Step-by-Step Import Process

Prepare your CSV file. Ensure all required columns are present and correctly formatted. Pay particular attention to the date format, which must match your Sage 50 regional settings. UK installations expect DD/MM/YYYY, while US installations use MM/DD/YYYY.
Open the import dialog. In Sage 50, go to File > Import. Select the appropriate data type for your import. For invoice transactions, choose "Audit Trail Transactions" as the import type. Some Sage 50 versions offer a dedicated invoice import option under the same menu.
Select and map your file. Browse to your CSV file and confirm the column mapping. Sage will attempt to match your column headers to its expected fields. Verify each mapping is correct before proceeding.
Preview and validate. Review the data preview screen carefully. Sage will flag validation errors such as unrecognized account references, invalid nominal codes, or formatting issues. Resolve any errors before confirming the import.

Practical Limits and Workarounds

Sage 50 enforces a file size limit of approximately 0.5 MB for CSV imports. If your dataset exceeds this threshold, split the file into smaller batches and import each one separately.

For users who need more flexibility than the built-in import provides, third-party add-ons such as Adept Tools can extend Sage 50's native CSV import capabilities. These tools offer additional field mapping options, validation rules, and support for more complex data structures.

How to Import Invoices into Sage Business Cloud

Sage Business Cloud (also known as Sage Accounting) takes a fundamentally different approach to data imports than its desktop counterpart, Sage 50. As a cloud-based platform, it handles invoice imports through its browser interface rather than through a dedicated import wizard on your local machine. The trade-off is a faster setup process, but with fewer configuration options.

Using the Quick Entry Import Method

The primary way to import invoices into Sage Business Cloud is through the Quick Entry batch import feature. Here is how the process works:

Log in to your Sage Business Cloud account and navigate to either Sales or Purchases, depending on whether you are importing sales invoices or supplier bills.
Look for the Import or Quick Entry option within the transaction area.
Prepare your CSV file according to the required format (detailed below), then upload it through the import dialog.
Review the field mapping preview that Sage displays, confirm the data looks correct, and complete the import.

Required CSV Format

Sage Business Cloud expects your CSV file to include these columns:

Contact Name - The customer or supplier name, which must match an existing contact in your Sage account
Date - The invoice date, formatted according to your account's locale settings (e.g., DD/MM/YYYY for UK accounts)
Reference - Your invoice number or reference identifier
Description - A text description of the goods or services
Net Amount - The pre-tax amount
Tax Rate - Must correspond to one of the tax rates already configured in your Sage account (e.g., "Standard 20%", "Zero Rated", "Exempt")
Total Amount - The gross amount including tax

Limitations to Be Aware Of

Sage Business Cloud's import functionality is noticeably more basic than what Sage 50 or Sage Intacct offer. Several constraints are worth noting before you begin:

No multi-line invoices per row. Each row in your CSV represents a single transaction line. If an invoice contains multiple line items, each line must be a separate row in the file, and the contact name and reference fields need to be repeated on every row.
Fewer custom fields. You cannot map to additional fields beyond the standard set listed above. Any supplementary data from your source system will need to be entered manually after the import.
Manual field mapping may be required. Depending on how your CSV headers are named, Sage may not automatically recognize every column. You might need to manually assign columns during the import preview step.
File size and row limits. For large backlogs of invoices, you may need to split your CSV into smaller batches. Sage Business Cloud can time out or reject files that exceed its upload thresholds, so breaking a 1,000-row file into batches of 200-300 rows is a practical workaround.

Working with Bulk Imports

If you are migrating historical data or processing a backlog of supplier invoices, expect to supplement the CSV import with some manual adjustments. After each batch upload, review the imported transactions in Sage to verify that tax calculations applied correctly and that contact names matched existing records. Any unmatched contacts will need to be created in Sage before re-importing those rows.

How to Import Invoices into Sage Intacct

Sage Intacct serves mid-market and enterprise finance teams that manage higher invoice volumes and multi-entity structures. Its import capabilities reflect that complexity, offering several methods to bring invoice data into the system: Configuration Packages for structured, repeatable imports; Smart CSV Import for simpler flat-file uploads; and API-based integration for fully automated AP workflows.

Using Configuration Packages for Invoice Import

Configuration Packages are the primary method for importing structured invoice data into Sage Intacct. They give you granular control over which fields to import, how validation is handled, and how parent-child relationships between invoice headers and line items are maintained.

To set up an import using Configuration Packages:

Navigate to the import tool. Go to Company > Configuration Packages within your Sage Intacct instance.
Create or select a package. You can build a new Configuration Package from scratch or use an existing template designed for AP invoice imports.
Define field mappings. Map each column in your CSV file to the corresponding Sage Intacct field. This is where you specify which data goes where and set validation rules for required fields, data types, and accepted values.
Upload your CSV file. Attach the prepared CSV that matches your defined mappings.
Run the import. Execute the package and review the results log for any rows that failed validation.

The key fields you will typically map for an AP invoice import include: Vendor ID, Transaction Date, Due Date, Invoice Number, Line Item Description, Amount, GL Account, and any relevant dimensions such as Department or Location for multi-dimensional reporting.

Understanding the Header-Detail CSV Structure

The CSV format for Sage Intacct differs significantly from the flat, one-row-per-invoice structure used by Sage 50. Sage Intacct imports commonly rely on a header-detail structure to represent the relationship between an invoice and its line items.

In this format, the first row for a given invoice contains header-level data: vendor, transaction date, due date, and invoice number. The rows that follow contain the line-item details: description, amount, GL account, and dimension assignments. A linking column, typically a Transaction ID or similar key field, ties each detail row back to its parent header. This structure allows a single CSV file to represent invoices with varying numbers of line items without duplicating header data on every row.

For organizations that do not need this level of granularity, Sage Intacct also supports Smart CSV Import, which accepts simpler flat-file formats for straightforward imports. And for teams building automated AP workflows, API-based import enables programmatic invoice creation, which is particularly valuable at scale — though imported bills still need to pass through Intacct's bill approval workflow before they can be posted. If you are weighing Intacct's native tools against OCR-led capture, this guide to Sage Intacct invoice OCR and extraction-first AP workflows covers where each approach fits. If your team is exploring this kind of automation, you may find the approach to automating invoice capture for ERP systems like NetSuite relevant to your planning.

7 CSV Formatting Rules for Sage Intacct

Before uploading your file, verify these formatting requirements to avoid rejected rows:

Date format alignment. Ensure all date fields match the date format configured in your Sage Intacct company settings. A mismatch between MM/DD/YYYY and DD/MM/YYYY is one of the most common causes of import failure.
Exact Vendor IDs. Every Vendor ID in your CSV must match a record in your vendor master exactly. Partial matches, extra spaces, or case differences will cause the row to fail.
Valid GL account numbers. Verify that every GL account number in your file exists and is active in your chart of accounts before running the import.
Entity ID for multi-entity imports. If your organization operates across multiple entities, each row must specify the correct entity ID. Omitting this field or using an incorrect value will route transactions to the wrong entity or reject them outright.
No special characters in reference fields. Strip special characters from invoice numbers, PO references, and other identifier fields. Characters like ampersands, angle brackets, or quotation marks can cause parsing errors.
Correct decimal formatting for amounts. Confirm that all numerical amounts use the decimal separator your Sage Intacct instance expects. Mixing period and comma decimal separators within a file will produce incorrect totals.
Duplicate invoice number check. Run a pre-import check against existing transactions to ensure your file does not contain invoice numbers already recorded in the system. Sage Intacct may reject or create duplicate entries depending on your configuration.

Import Capabilities Compared: Sage 50 vs. Business Cloud vs. Intacct

Before walking through conversion workflows, it helps to see exactly where each Sage product stands on invoice import functionality. The table below summarizes the key differences.

Feature	Sage 50	Sage Business Cloud	Sage Intacct
Import Method	CSV file import	Quick entry CSV import	Configuration Packages, Smart CSV, API
Date Format	DD/MM/YYYY (UK default)	Locale-dependent	Company setting-dependent
Line Item Handling	Separate row per line item	Separate row per line item	Header-detail structure
Multi-Entity Support	No (single company file)	Limited	Yes (multi-entity, multi-currency)
File Size Limit	~0.5 MB	Not documented	Varies by package configuration
Automation Options	Third-party add-ons	Limited	API, Smart CSV, Power Automate
Tax Code Handling	T-codes (T0, T1, T9)	Tax rate selection	Tax mapping in Configuration Package

The practical impact depends on your scale. If you import more than a few hundred invoices monthly, Sage 50's 0.5 MB file cap means splitting every batch, and the lack of header-detail structure means larger CSV files for multi-line invoices. At that volume, Intacct's Configuration Packages are worth the additional setup. Sage Business Cloud sits in between: the fastest import to configure, but the first to hit limits when you need line-item detail or custom field mapping. For teams comparing accounting platforms before a migration, FreshBooks invoice import options are a useful contrast because historical invoice loading there often depends on migration services or API-based creation instead of a built-in self-serve import wizard.

Automation tells a similar story. Sage 50 depends on third-party add-ons for anything beyond manual file import — its invoice scanning and OCR options all sit outside the core product — and Sage 100 faces a similar gap since it ships without built-in capture either — Sage 200 has the same limitation, relying entirely on third-party tools for invoice capture and OCR. Business Cloud offers minimal automation. Intacct opens the door to API-driven pipelines and Power Automate flows, but requires development effort. If you are already automating invoice data entry in Excel, the transition to Sage import follows a similar pattern: standardize your column formats and validate data before upload.

All three products share one prerequisite: your invoice data must be in a properly formatted CSV or structured file before Sage will accept it. For teams that receive invoices as PDFs or paper documents, preparing that file is often the most time-consuming step in the workflow.

Converting PDF Invoices to Sage-Ready CSV Files

Every import method covered above assumes one thing: you already have your invoice data in a structured CSV file. In practice, most businesses do not. Vendor invoices arrive as PDFs, whether emailed directly from suppliers, scanned from paper mail, or downloaded from procurement portals. The gap between a folder of PDF invoices and a Sage-ready CSV file is where hours of manual data entry typically live.

Manually bridging that gap means opening each PDF, reading the relevant fields, and typing values into a spreadsheet formatted to the exact column layout Sage expects. For a handful of invoices, this is manageable. For migration projects involving hundreds or thousands of historical documents, it becomes a serious bottleneck.

AI-based data extraction tools eliminate that manual re-keying step. Instead of reading each PDF yourself, you upload the files to an extraction platform, specify which fields you need and how they should be formatted, and receive a structured CSV or Excel file as output. The critical advantage for Sage users is the ability to control column names, date formats, and field selection so the output maps directly to what your Sage product requires. That review-first model is especially relevant in Sage Pastel invoice scanning workflows, where South African teams often want to validate CSV or Excel output before import.

Here is what that looks like for each Sage product:

Sage 50: You need a CSV with columns matching Sage 50's import template, including Type, Account Reference, Nominal Code, Date (formatted as DD/MM/YYYY), Reference, Net Amount, and Tax Code. Using an extraction tool, you would instruct the AI to output those exact columns in the right format. A practical prompt might read: "Extract invoice number, date as DD/MM/YYYY, vendor name, net amount, VAT code, and total. One row per invoice." The resulting file can be imported directly through Sage 50's Data Import wizard without further editing.
Sage Intacct: The import format is more structured, requiring a header-detail layout compatible with Intacct's Configuration Package. You would configure the extraction to produce fields like Vendor ID, Transaction Date, Invoice Number, and separate line-item rows with GL Account, Amount, and Description. Each header record links to its detail rows, matching the relational structure that Intacct expects.
Sage Business Cloud: For CSV imports via Sage Business Cloud's banking or purchase invoice screens, the extraction output needs to align with the product's field expectations, including supplier name, invoice number, date, and amounts in the layout that Business Cloud recognizes.

An AI-powered invoice data extraction platform like Invoice Data Extraction is built for exactly this workflow. You can upload batches of up to 6,000 mixed-format PDF and image files in a single job, then use natural language prompts to control exactly which fields are extracted, what the columns are named, and how dates and numbers are formatted. Processing runs at 1 to 8 seconds per page, and output is available as CSV or Excel. For teams handling recurring vendor invoice processing, saved prompts ensure every batch produces identically formatted files ready for Sage import. If you need more detail on the extraction step itself, our guide on converting PDF invoices to Excel walks through the process in depth.

This extraction-to-import workflow is especially valuable in two scenarios. First, during system migrations where you have years of historical invoices stored only as PDFs in a document management system or email archive, and need to bring that data into Sage in bulk. Second, for businesses with a high volume of recurring vendor invoices arriving as PDFs each month, where manual data entry creates a persistent bottleneck in the accounts payable cycle.

Troubleshooting Common Sage Invoice Import Errors

Most Sage invoice import failures trace back to a single root cause: a mismatch between the data in your CSV file and the master records configured in your Sage installation. Account codes, tax references, date formats, and nominal ledger entries all need to align precisely. The errors below cover the six most frequent problems across Sage 50, Business Cloud, and Intacct, along with specific fixes for each.

Date format mismatch

Sage reads dates based on regional settings — a UK Sage 50 installation expects DD/MM/YYYY, while a US installation expects MM/DD/YYYY, and Sage Intacct uses the format in your company settings. If your CSV contains "01/03/2026," Sage cannot determine whether you mean 1 March or 3 January.

The fix: Check your Sage date format setting before importing. In Sage 50, go to Settings > Company Preferences > Regional Settings. In Intacct, check Company > Setup > Company Information. Reformat every date value in your CSV to match exactly.

Invalid account reference or vendor ID

Sage rejects rows when the account reference field references a supplier or customer not set up in the system. This happens frequently during migrations where historical data references accounts never created in the new environment.

The fix: Export your current supplier/customer list from Sage and cross-reference it against the account codes in your CSV. Create any missing accounts first. In Sage 50, view supplier accounts under Suppliers > Supplier List. In Intacct, check Accounts Payable > Vendors.

Tax code or VAT code errors

Each Sage installation has a specific set of tax codes that vary by product and region. Using a code that does not exist, or the wrong format (e.g., "Standard" instead of "T1"), causes a rejection. Common UK VAT codes in Sage 50: T1 (20% standard), T0 (zero-rated), T2 (exempt), T9 (outside scope).

The fix: In Sage 50, navigate to Settings > Configuration > Tax Codes to verify active codes. Map every tax value in your CSV to the corresponding Sage code before importing.

Nominal code not found

Your CSV references a general ledger (nominal) code not set up in Sage. This is common when importing from a different accounting system with a different chart of accounts structure.

The fix: Export your chart of accounts from Sage and compare it against every nominal code in your CSV. In Sage 50, go to Nominal Codes > Chart of Accounts. In Intacct, check General Ledger > Chart of Accounts. Add any missing codes before re-running the import.

Duplicate invoice detection

Sage Intacct enforces unique invoice reference numbers to prevent double-posting. Sage 50 is less strict but may still produce unexpected results if duplicate references post to the same account.

The fix: Before importing, search your Sage transaction records for existing entries that share reference numbers with the incoming batch. In Intacct, use Accounts Payable > Bills to search by document number. If the duplicate is intentional (a corrected re-import), delete the original first or append a version suffix to create a unique identifier.

Character encoding issues

Special characters, accented letters, or currency symbols encoded in ANSI or Windows-1252 cause garbled text or import failures in Sage.

The fix: Save your CSV with UTF-8 encoding. In Excel, use Save As > CSV UTF-8 (Comma delimited). Google Sheets exports UTF-8 by default. If specific characters still cause problems, replace curly quotes, en dashes, non-breaking spaces, and trademark symbols with plain-text equivalents.

Your Sage Invoice Import Checklist

Prepare your source data. Extract PDF invoices into structured CSV using a dedicated extraction tool, or reformat existing data to match your Sage product's expected columns.
Validate before importing. Check date formats, account references, tax codes, and nominal codes against Sage's master data. This single pass catches the majority of failures.
Run a test batch. Import 5-10 invoices first to confirm column mapping and formatting before processing the full dataset.
Review imported transactions. Verify amounts, dates, references, and tax calculations in Sage. If you also import bank statements into Sage, reconcile against the imported invoices to confirm amounts match.