Exporting your USPS transactions via Pitney Bowes gives you a clear view of your shipping activity, including label charges and any adjustments. This can be helpful for:
- Reconciling postage costs
- Reviewing USPS Automated Package Verification (APV) adjustments
- Sharing data with your accounting team
- Analyzing shipping spend over time
Ordoro makes it easy to pull all of this into a single CSV file so you can review and work with the data in Excel or Google Sheets.
NOTE: If you use a personal USPS Pitney Bowes Merchant account, you can log in directly to their system for this information.
Exporting your transactions via USPS Pitney Bowes
- Click on your Company Name -> Account Settings.
- In the left menu, select Shippers/Carriers.
- Find your USPS (Pitney Bowes) account and click Transaction History → Export CSV.
- Choose your date range:
- Dates are based on the shipment date.
- If you don’t select a range, the report will default to the last 30 days.
- Once the export is ready, download it from Activity Menu → Exports.
- Click the CSV button. The file will automatically download to your computer.
- The column headings in the report are:
- Order Number
- Transaction Date
- Transaction Type
- Examples are: “Label Creation”, “net_zero_charge” – for postage purchases, etc.
- Tracking Number
- Transaction Amount
- Account Balance
- This is your Pitney Bowes postage account balance.
- Notes
- Examples are: “Adding Postage for USPS”, “Label for Order XYZ”, etc.
- Transaction ID