Sign Up
GUIDE

Downloading Your Transaction Data

Downloading Your Transaction Data
 

Introduction

In addition to the ability to export your transactions to an accounting program, Greenback also gives you the ability to download a CSV file of your data. CSV files can easily be reviewed using many of today's popular spreadsheet applications including Microsoft Excel and Google Sheets.

How to download your transaction data

To download your transaction data, simply look for the download link under the transaction filter header (you will also find the search bar here). The download tool will only generate a file based on the current filters. For example, if you have filtered your transaction list to only include those transactions from the past month, the download tool will generate a file that contains only transactions from last month.

Download Types

There are two download file options available, "Transaction" files and "Line Item" files. Line Item files are available for paid plans only.

Transaction File

The Transaction File will download all transactions per your current view filters to a single CSV file. Each row in the file will represent a single order.

ColumnDescription
IDUnique ID on the Greenback platform
TypeThe type of transaction (Sale, Purchase, Refund, Reimbursement)
Reference NoReference number of the transaction
DateDate of the transaction
ContactOriginating source of the transaction
Buyer/SellerName of the buyer or seller associated with the transaction
PO/JobAny Purchase Order or Job Order number associated with transaction
CurrencyThe currency code of the transaction
SubtotalThe subtotal of the transaction
Shipping TotalThe sum of all shipping charges
Fee TotalThe sum of all fees associated with the transaction
Discount TotalThe sum of all discounts associated with the transaction
Tip TotalThe sum of all tips associated with the transaction
Other TotalThe sum of other ancillary elements of the transaction
Tax TotalThe sum of all taxes associated with the transaction
Grand TotalThe grand total of the transaction
Number of ItemsThe number of line items associated with the transaction
ShipmentsThe number of shipments associated with the transaction
Payment/DepositThe payment type or settlement source of the transaction
Payment TypeThe payment type

Line Items File

The Line Items File will download all transactions per your current view filters to a single CSV file. Each line item within a transaction will be represented with it's own row in the CSV file. The reference number column can be used to group line items to their respective transaction.

ColumnDescription
IDUnique ID on the Greenback platform
TypeThe type of transaction (Sale, Purchase, Refund, Reimbursement)
Reference NoReference number that can be correlated line item to transaction
DateDate of the transaction
ContactOriginating source of the transaction
Item CodeThe item code of the transaction
Item NameThe item name
Item QuantityThe quantity of the item ordered
Item Price per UnitThe price for a single unit
Item Total PriceThe total price of the item across all quantities ordered

Join the world's most advanced pre-accounting system.