Level 3 Line-Item Data and Sales Tax Reporting

Level 3 line-item data is the most detailed tier of card transaction information a merchant can pass to a card program, and in US Bank Access Online it is the foundation for accurate spend analysis, tax accounting, and audit-ready records. Where a basic charge tells you only the merchant name and total amount, a Level 3 transaction carries a full itemized breakdown: individual line items, quantities, unit prices, product codes, freight, duty, discounts, and sales tax collected. US Bank Access Online captures that enriched data when a supplier transmits it and makes it available for review, allocation, and reporting.

This page explains what Level 3 data is, how it differs from Level 1 and Level 2, which fields matter for sales tax reporting, and how program administrators and cardholders work with that data inside US Bank Access Online. The goal is practical: to help you understand why some transactions arrive richly detailed and others do not, how to find the tax figures you need, and how to build reports in US Bank Access Online that satisfy finance, procurement, and tax teams.

Level 1, Level 2, and Level 3 Data

Card networks define three tiers of transaction data, each adding more structure than the last. Understanding these tiers is the first step to using US Bank Access Online well, because the reporting depth you can achieve is capped by the level of data your suppliers actually transmit to US Bank Access Online.

Level 1 is the standard consumer-grade record. It contains the transaction total, the transaction date, and the merchant name. Nearly every card purchase carries Level 1 data, and US Bank Access Online will always show these basics for any posted charge. It is enough to reconcile a statement but not enough to see what was actually bought.

Level 2 adds a layer of commercial detail. On top of the Level 1 fields, a Level 2 transaction typically includes a customer reference or purchase order number, a tax amount, and a tax identification indicator. For organizations that need to track spend against purchase orders and confirm that tax was charged, Level 2 is a meaningful improvement, and US Bank Access Online surfaces these fields directly in transaction detail views.

Level 3 is the itemized tier. It carries everything in Level 2 plus a line-by-line description of the purchase: product or service codes, item descriptions, quantities, units of measure, unit prices, extended amounts, line-item discounts, freight, duty, and destination information. This is the level that turns a card charge into something close to an electronic invoice. When a supplier sends Level 3 detail, US Bank Access Online stores each line and makes it available for allocation and reporting.

The Line-Item Data Fields

When a Level 3 transaction posts, US Bank Access Online records both header-level fields that describe the whole purchase and detail-level fields that describe each individual line. Knowing which fields live where helps you build reports in US Bank Access Online and answer questions from your tax and procurement teams.

Header-Level Fields

At the header, US Bank Access Online captures the customer reference or purchase order number, the total transaction amount, the total tax amount, freight and shipping charges, duty amounts, an order or invoice number, and a ship-to postal code. These are the values most finance teams reconcile against, and they are the same values that feed the summary rows in reporting within US Bank Access Online.

Detail-Level Line Items

Each line item within a Level 3 transaction carries its own product code, item description, quantity, unit of measure, unit cost, extended line amount, discount amount, and a line-level tax figure where the supplier provides one. US Bank Access Online preserves these line rows so a cardholder can verify that what was charged matches what was ordered, and so an administrator can categorize spend at the item level rather than lumping an entire order into one code.

The example below shows how a single Level 3 purchase appears once its lines are expanded in US Bank Access Online. Amounts are illustrative.

Because each line is stored independently, US Bank Access Online lets you sort, filter, and total across lines rather than transactions alone. That is the difference between knowing you spent 799 dollars at a supplier and knowing exactly how much of it went to consumable supplies versus freight, a distinction US Bank Access Online makes visible at a glance.

Sales Tax Reporting

Sales tax is one of the most valuable pieces of enriched data, and it is a primary reason organizations pursue Level 3 enablement. When a supplier transmits the tax amount, US Bank Access Online records it as a distinct field rather than folding it into the transaction total. That separation is what makes card spend usable for tax accounting inside US Bank Access Online.

For many businesses the central concern is use tax accrual. When a purchase is made across state lines and the supplier did not collect the correct sales tax, the buyer may owe use tax to its own jurisdiction. To determine that, an accounting team needs to know exactly how much tax, if any, was charged on each transaction. US Bank Access Online provides that tax figure at the header level, and at the line level where the merchant supplies it, so teams can identify undertaxed and untaxed purchases and accrue accordingly.

Level 2 already delivers a header tax amount and a tax indicator, and this alone supports basic tax reconciliation in US Bank Access Online. Level 3 goes further by attaching tax to individual lines, which matters when a single order mixes taxable goods with tax-exempt items or services. Being able to see the tax broken down line by line inside US Bank Access Online removes guesswork from the exemption analysis.

Tax data in US Bank Access Online supports several downstream tasks. It feeds tax summary reports, lets accounts payable teams verify that tax was recovered on returns and credits, and provides documentation when a jurisdiction requests substantiation. Because the data is stored per transaction and per line, US Bank Access Online can aggregate tax by cardholder, by cost center, by supplier, or by jurisdiction depending on how you structure your report.

For organizations that hold tax-exempt status, the line-item view in US Bank Access Online is especially useful. It lets a reviewer confirm that exempt purchases were in fact processed without tax, and flag any transaction where a supplier charged tax in error so a credit can be pursued. Everything a reviewer needs for that check is present in the transaction detail that US Bank Access Online displays.

How Level 3 Data Flows Through the System

The journey of Level 3 data begins at the supplier. When a cardholder makes a purchase, a Level 3 capable merchant assembles the itemized detail and transmits it through the card network alongside the authorization and settlement messages. The card network passes that enriched data on, and US Bank Access Online ingests it as the transaction posts.

Once posted, the data is attached to the transaction record in US Bank Access Online. Cardholders and reviewers can open a transaction and expand it to see the line detail, the tax breakdown, and the shipping and reference fields. From there the transaction moves through your normal workflow in US Bank Access Online: reviewing, allocating to accounting codes, and approving.

Allocation is where line-item detail earns its value. Instead of assigning an entire order to one cost center or general ledger code, US Bank Access Online can allow splitting spend by line, so consumables, capital items, and freight land in the right accounts. This granularity flows directly into the extracts that US Bank Access Online produces to feed your general ledger, meaning the accounting entries reflect what was actually bought.

The available fields and workflows depend on how your organization has configured its program within US Bank Access Online. Program administrators control which reports are available, how allocation works, and which accounting fields cardholders can edit, so the exact experience in US Bank Access Online varies from one program to the next.

Reports and Data Extracts

US Bank Access Online includes a reporting function that turns stored transaction data into the summaries and extracts finance teams rely on. For Level 3 and tax work, the reports that matter most are those that expose line-item detail and isolate tax figures rather than reporting only transaction totals. US Bank Access Online offers both on demand.

Line-item detail reports list each individual line from Level 3 transactions, including product codes, descriptions, quantities, and amounts. These reports let a category manager analyze exactly what is being bought across the program, and they give tax teams the line-level view needed to separate taxable from exempt spend. Because US Bank Access Online stores the underlying lines, these reports can be generated repeatedly for any period you have data.

Tax-focused reports summarize the sales tax field across the scope you choose. A common use is a report that totals tax by supplier and by cardholder so an accounting team can quickly see where tax was and was not collected. US Bank Access Online lets administrators schedule some reports to run automatically, so a recurring tax summary can arrive on a fixed cadence without manual effort.

Beyond on-screen reports, US Bank Access Online can produce data extracts in structured formats for import into an accounting or expense system. When Level 3 data is present, those extracts can carry the enriched fields through to your general ledger, so the detail captured in US Bank Access Online does not stop at the portal. This is the mechanism most large programs use to feed automated accounting from US Bank Access Online.

Report availability and the specific formats offered are governed by your program setup. If a report you need is not visible, a program administrator can typically enable it or adjust your role within US Bank Access Online. The reporting library in US Bank Access Online is broad, so most tax and line-item questions can be answered without exporting raw data and building spreadsheets by hand.

Data Level Comparison

The table below summarizes what each data level typically carries and how it is used within US Bank Access Online. Actual fields depend on the card network and the merchant, and US Bank Access Online reflects whatever is transmitted.

Why Level 3 Reporting Matters

The practical value of Level 3 data comes down to visibility and control. When suppliers transmit itemized detail, US Bank Access Online can answer questions that a total-only record simply cannot: what was purchased, at what unit price, with how much tax, and to which account it should be charged. US Bank Access Online keeps all of that in one place.

For tax teams, the benefit is cleaner use tax accrual and faster exemption checks, because the tax figure in US Bank Access Online is isolated and, at Level 3, tied to individual lines. For procurement, the benefit is category insight, since line-item data in US Bank Access Online reveals buying patterns that support negotiation with suppliers. For accounts payable, the benefit is straight-through processing, because enriched data flowing out of US Bank Access Online reduces the manual keying that slows reconciliation.

There is an audit dimension as well. Detailed, per-line records stored in US Bank Access Online give internal auditors and external reviewers the substantiation they expect, reducing the effort needed to respond to a tax authority inquiry or an internal spend review. The detail is already there in US Bank Access Online, timestamped and attributed, rather than reconstructed after the fact.

How to Get Started with Level 3 Reporting

Working with Level 3 data in US Bank Access Online is less about a single switch and more about a short sequence of setup and habit. The steps below outline how most programs move from receiving basic transactions to using rich line-item and tax detail within US Bank Access Online.

1. 01

   Confirm your role and access

   Sign in to US Bank Access Online and confirm your role allows you to view transaction detail and run reports. If line detail or reporting is not visible in US Bank Access Online, ask your program administrator to adjust your permissions.

2. 02

   Identify Level 3 capable suppliers

   Review recent transactions in US Bank Access Online and note which suppliers deliver line-item detail. These are the vendors whose data will populate your enriched reports in US Bank Access Online, and they are the ones worth steering more spend toward.

3. 03

   Set up allocation and accounting codes

   Have your administrator configure the accounting fields and, where supported, line-level splitting so that Level 3 detail can be allocated accurately as transactions post through US Bank Access Online.

4. 04

   Build or schedule the reports you need

   Use the reporting library in US Bank Access Online to generate a line-item detail report and a tax summary, then schedule the recurring ones in US Bank Access Online so tax figures arrive on a predictable cadence.

5. 05

   Review, reconcile, and refine

   Reconcile the tax figures from US Bank Access Online against expected rates, follow up on undertaxed or overtaxed lines, and refine your reports in US Bank Access Online as your program grows.

Frequently Asked Questions