Table of Contents
101: Intro to Open Invoices
The Open Invoices module displays your open AR and AP invoices ingested directly from your ERP system. It provides a detailed, filterable table view of every outstanding invoice, including vendor or customer name, invoice number, invoice date, payment terms, due date, days outstanding, adjusted due date, and invoice amount.
You can toggle between two views:
Accounts Receivable — invoices owed to your company
Accounts Payable — invoices your company owes to vendors
Use the Search bar to filter by provider, customer, or vendor name (e.g., Netsuite, Sage), and apply date range filters to narrow results by invoice or due date. The Invoice Filters panel also lets you filter by Invoice Provider, Customer/Vendor, and Invoice Type.
Supported ERP Integrations
Citizens Treasury Intelligence currently supports ingesting open invoices via API from the following ERP systems:
NetSuite — NetSuite Inbound AR/AP Invoices Setup Guide
Sage Intacct — Sage Intacct Inbound AR/AP Invoices Setup Guide
Oracle Fusion — Oracle Fusion Inbound AR/AP Invoices Setup Guide
Before seeing Open Invoice data in your instance, you must first establish the API connection between your ERP and Citizens Treasury Intelligence. This is done through the Developer section of Citizens Treasury Intelligence (found at the bottom of the left-hand navigation). The connection requires generating API credentials from within your ERP and submitting them to Citizens Treasury Intelligence. The specific steps vary by ERP, so refer to the relevant setup guide linked above for your ERP system.
Imported Invoice Data
Citizens Treasury Intelligence ingests the following fields for each open invoice:
Field | Description |
Customer / Vendor | The name of the customer (AR) or vendor (AP) associated with the invoice |
Invoice Number | The unique invoice identifier from your ERP |
Invoice Date | The date the invoice was issued |
Payment Terms | The agreed payment terms (e.g., Net 30, Net 60, 1% 10 Net 30) |
Due Date | The original due date of the invoice |
Days Outstanding | The number of days the invoice has been open past its due date |
Adjusted Due Date | A manually adjusted due date used for forecasting purposes |
Amount | The invoice amount in its original currency |
Amount (USD Equivalent) | The invoice amount converted to USD |
Frequently Asked Questions
Q: Do I need to be a developer to set this up?
A: The initial ERP connection requires generating API credentials from within your ERP system and submitting them to Citizens Treasury Intelligence. Your IT or ERP admin team will typically handle the NetSuite, Sage, or Oracle Fusion configuration steps. Once credentials are submitted to Citizens Treasury Intelligence, our team completes the backend setup.
Q: How often is invoice data refreshed?
A: This data is refreshed every 24 hours on a prior day basis.
Q: Can I filter invoices by vendor or date range?
A: Yes. Use the Search bar to look up specific customers or vendors, apply From/To date filters, and use the Invoice Filters panel to narrow by provider, customer/vendor, and invoice type.
Q: Where do open invoices feed into forecasting?
A: Once ingested, AR and AP invoice data can be used to create Invoice Streams within the Data Streams module, and subsequently integrated into the Forecasts module, where it contributes to your projected cash inflows and outflows alongside your other data streams.