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 in 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 the top of the article

What's included in 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
  • Item total (Order total without fees)
  • Fees (Displaying as each individual fee name)
  • Total
  • Total Expenses
  • 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
  • Exported to QuickBooks (shown as True/False)
  • Last time exported to QuickBooks

Return to the top of the article

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

  • ID
  • Created Date
  • Transaction Date
  • Payment Processor
  • Payment Transaction ID
  • Name
  • Category
  • Amount
  • Invoice #
  • Invoice URL
  • Invoice Owner
  • Invoice Created Date
  • Invoice Payment Due Date
  • Invoice Customer Due Date
  • Invoice Production Due Date
  • Customer First Name
  • Customer Last Name
  • Customer Company Name
  • Customer ID
  • Sales Tax Percentage
  • Sales Tax

Return to the top of the article

What's included in the "Products" export?

Note: The Products export will provide a list of your custom products.

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

Return to the top of the article

What's included in the "Deposits" export?

Note: The Deposits export will provide a list of your deposits and their associated transactions.

  • Order ID
  • Type
  • Deposit ID
  • Customer / Store
  • Transaction ID
  • Cardholder Name
  • Cardholder Address 1
  • Cardholder City
  • Cardholder State
  • Cardholder Zip
  • Net Amount
  • Currency Code
  • Created Date
  • Gross Amount
  • Total Fees

Return to the top of the 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?
6 out of 8 found this helpful

Comments

0 comments

Please sign in to leave a comment.