Sage Intacct - How to Export Bills Register Report

TABLE OF CONTENTS

• 1. Navigate to the Bills Register Report
• 2. Set the Date Range
• 3. Apply Filters (Optional)
• 4. Add Location Information (Recommended)
• 5. Review the Report Columns
• 6. Export the Report
• 7. Your CSV File Now Contains:

This guide explains how to export invoice-level data from Sage Intacct with the fields required for Ottimate’s disbursement workflow, including:

• Invoice Number
• Invoice Date
• Invoice Total

Location name and location ID are needed if the invoices don't exist in Ottimate and will have to be created

• Location Name (optional)
• Location ID (optional)

Sage Intacct provides these values through the Bills Register report, which includes invoice details, payment details, and location-level groupings.

1. Navigate to the Bills Register Report

1. Log in to Sage Intacct.

2. Go to:

   Accounts Payable → All → Reports → Registers → Bills

This opens the Bills Register report screen, which displays all bills and adjustments for a selected period.

2. Set the Date Range

You can choose:

• A predefined reporting period (e.g., This Month, Last Month), or
• A custom Start Date and End Date

If no period is selected, Intacct defaults to “Month to Date.”

3. Apply Filters (Optional)

Use filters to narrow the data:

• Vendor
• Vendor Type
• Location

More filters = fewer, more precise results.

For Ottimate’s import, you may want to include:

• All Locations
• All Vendors

4. Add Location Information (Recommended)

To include Location data:

1. In Format, set Group By → Location

   This groups bills by Location and displays subtotals by Location.

   Bills Register report

2. If Location ID is needed, ensure your Intacct admin has enabled:

   Platform Services → Company → Enable “Show Internal IDs”

5. Review the Report Columns

The Bills Register includes all invoice fields required for Ottimate:

6. Export the Report

Choose any of the export options:

To download CSV immediately

1. Select Export
2. Choose CSV

7. Your CSV File Now Contains:

• Invoice dates
• Invoice numbers
• Invoice totals
• Location name
• Location ID (if internal IDs are enabled)
• Payment information (Amount Paid, Payment Method, etc.)
• Credit adjustments and applied credits (if included)

This file can now be uploaded to Ottimate using the disbursement workflow for disbursements.