Invoice data can be exported from the Invoices page by clicking the Export button in the top right corner, next to the Create Invoice button. BulkSource offers two types of exports, each suited to a different purpose:
- Standard (Header) Export — a snapshot of your invoices at the moment you run the export. Each row represents one invoice. Because invoices can change over time (for example, late fees and adjustments can be applied after the invoice is created), the data will vary depending on when you run it.
- GL Details Export — a line-item breakdown organized by your Chart of Accounts. Every line item carries a date stamp, so this export captures how and when an invoice changed over time. This is the recommended format for ERP integrations and any workflow where tracking invoice changes matters.
Quick Reference
| Export | Granularity | Timing | Best For |
|---|---|---|---|
| Standard (Header) | One row per invoice | Current values at time of export | General invoice review, reporting, and high-level summaries |
| Ticket GL Detail | One or more rows per ticket — separate rows for product, freight, and tax | Invoice date | Tracking original invoice data during invoice creation; revenue recognition for ticket-level charges. Includes price index adjustments and surcharges tied to tickets |
| Adjustment GL Detail | One row per adjustment, by GL account | Date the adjustment was added | Tracking changes made after invoice creation (credits, discounts, manual corrections) |
| Late Fee GL Detail | One row per late fee, by GL account | Date the late fee was applied | Tracking late fees applied after invoice creation per payment term rules |
Tip: The Standard Export is accessed by clicking Export directly. The three GL Details exports are available as dropdown options from the Export button.
Standard Export (Invoice Header Data)
The Standard Export provides a summary-level view of your invoices. Each row represents one invoice and reflects its current state at the time of export.
| Field | Description |
|---|---|
| Invoice Number | Unique identifier for the invoice |
| Customer ID | The customer's ID in BulkSource |
| Invoice Date | The date the invoice was issued |
| Due Date | The payment due date |
| Project & Order | Associated project or order |
| Purchase Order Number | Customer's purchase order number |
| Fulfilled From Site | The site/location that fulfilled the order |
| Delivery Method | Whether the order was a delivery or a pickup |
| Products (Total) | The total dollar amount charged for products |
| Freight | Freight charges |
| Surcharges | Any applied surcharges |
| Adjustments | Any adjustments made to the invoice |
| Tax | Tax charges |
| Late Fees | Any late fees applied to the invoice |
| Total | Total invoice amount |
| Unreconciled Payment Amount | Amount applied from Unreconciled Payments |
| Amount Paid | Total amount paid toward the invoice |
| Invoice Status | Current status: Fully Paid, Partially Paid, Open, or Past Due |
| Age (Days) | Number of days since the invoice was issued |
| Aging Bucket | Aging category: 0–30, 31–60, 61–90, or 90+ days |
Note: The Standard Export shows totals only — it does not show the breakdown of when individual adjustments or late fees were created. For a full line-item breakdown with dates, use the GL Details Export.
GL Details Export
The GL Details Export organizes invoice data at the line-item level according to your Chart of Accounts, making it the right choice for accounting, revenue recognition, and ERP integrations.
Because each line item includes a date stamp, the GL Details Export captures how and when an invoice changed over time — something the Standard Export cannot show.
The GL Details Export is split into three separate sections, each covering a different type of charge.
1. Ticket GL Details
Charges that originated at the ticket level — created when the ticket was processed. Each ticket may have one or more rows, broken out by Revenue GL Account Number (for example, separate rows for product, freight, and tax).
Fields included:
- Invoice Number
- Invoice Date
- Customer ID
- Customer Name
- Customer Type
- Project ID
- Site
- Plant ID (Entity Name and Entity ID — the fulfilling location)
- Revenue GL Account Number
- Amount
This section includes all ticket-level charges, including:
- Product charges
- Freight
- Taxes
- Price index adjustments tied to tickets
- Surcharges tied to tickets (e.g., fuel, environmental)
Because charges are tied to GL account numbers, this export shows exactly what each amount was charged for.
Line items in the Ticket GL Details can be negative in the case of credit tickets or reversals.
Ticket-level vs. invoice-level charges: Surcharges and price index adjustments applied at the ticket level (when the ticket is processed) appear in Ticket GL Detail. Credits, discounts, and manual corrections added at the invoice level (after the ticket is created) appear in Adjustment GL Detail.
2. Adjustment GL Details
Adjustments made at the invoice level — added after the ticket was created, directly on the invoice itself. Common examples include credits, discounts, and manual corrections.
The fields are the same as the Ticket GL Details export, including the Revenue GL Account Number.
3. Late Fee GL Details
Late fees that were automatically applied to an invoice when a customer has not paid within their payment terms.
Late fees are tracked separately because:
- They are not created at ticket creation
- They are not considered adjustments
- They are applied automatically by the system based on payment term rules
The fields follow the same structure as the other GL exports.
Before Using the GL Details Export
The GL Details Export is most useful when all invoice components are mapped to GL account numbers. This includes:
- Products
- Taxes
- Adjustments
- Late Fees
If a component is not mapped, its line items will still appear in the export, but the Revenue GL Account Number field will be blank (null). This may cause issues downstream in ERP integrations or GL reconciliation workflows that rely on a complete account number on every row.
See Chart of Accounts Setup – BulkSource for more information on mapping GL accounts.
Which Export Should I Use?
| Use Case | Recommended Export |
|---|---|
| General invoice review or reporting | Standard Export |
| Sharing a high-level invoice summary | Standard Export |
| Accounting, revenue recognition, or GL reconciliation | GL Details Export |
| Reviewing when specific adjustments or late fees were applied | GL Details Export |
| ERP integration or tracking invoice changes over time | GL Details Export |
Comments
0 comments
Article is closed for comments.