Printavo's data export allows you to analyze your data on your terms

Printavo does have some built-in analytics, but, occasionally, shops prefer to use an external system like Microsoft Excel, Google Sheets, or Numbers (by Apple) to run their numbers. With a single click, you can generate a .CSV spreadsheet from a date range of your choice that gets sent directly to your inbox.

Where to do this: My Account > Import/Export Data

Export_Range_and_Buttons.png

Click the below links to see what column headers are included in each export. We've also attached sample exports to the bottom of this page.

What's included on the "Customers" export?

  • Customer ID
  • First Name
  • Last Name
  • Company
  • Email
  • Phone
  • Fax
  • Full Billing Address
  • Billing Address - Address 1
  • Billing Address - Address 2
  • Billing Address - City
  • Billing Address - State
  • Billing Address - Zip
  • Billing Address - Country
  • Full Shipping Address
  • Shipping Address - Address 1
  • Shipping Address - Address 2
  • Shipping Address - City
  • Shipping Address - State
  • Shipping Address - Zip
  • Shipping Address - Country
  • Tax Exempt?
  • Tax Resale No.
  • Created
  • Owner Email
  • Owner Name
  • Default Payment Term
  • Default Payment Term Days

Return to top of article

What's included on the "Quotes/Invoices" export?

  • Invoice #
  • Nickname
  • Created Date
  • Custom Created At
  • Production Due Date
  • Customer Due Date
  • Invoice Date
  • Payment Term
  • Payment Term Days
  • Payment Due Date
  • Customer Full Name
  • Customer Email
  • Customer Company
  • Customer Id
  • Customer Notes
  • Production Notes
  • Total Quantity
  • Sales Tax
  • Total Untaxed
  • Amount Paid
  • Amount Outstanding
  • Total
  • Paid?
  • Invoice Status
  • Delivery Method
  • PO #
  • Tags
  • Owner
  • Public Invoice View URL
  • Invoice URL
  • Billing Address 1
  • Billing Address 2
  • Billing City
  • Billing State
  • Billing Zip
  • Billing Country
  • Shipping Address 1
  • Shipping Address 2
  • Shipping City
  • Shipping State
  • Shipping Zip
  • Shipping Country

Return to top of article

What's included on the "Payments/Expenses" export?

  • ID
  • Created Date
  • Transaction Date
  • Payment Processor
  • Payment Transaction ID
  • Name
  • Category
  • Amount
  • Invoice #
  • Invoice URL
  • Sales Tax Percentage
  • Sales Tax

Return to top of article

What's included on the "Products" export?

  • Style Number
  • Brand
  • Style Description
  • Color
  • Size
  • Price Per
  • Dozens Price
  • Case Price
  • Created

Return to top of article

NEXT: 6.8 Cash-Basis & Accrual Accounting Tax Data

PREVIOUS: 6.6 Expense Tracking

Click the files below to download and view sample exports

Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.