Sign Up
GUIDE

Understanding Your Transaction Data

Understanding Your Transaction Data
 

Introduction

This article will take you through all the elements of transaction data on Greenback. To view the details of a transaction on Greenback, simply choose a transaction from the transaction list. You can view the details of transactions by clicking the reference number or by clicking an "Items".

Transaction status

Transactions that do not exist in a final state will be listed with a transaction status. Transactions that exist in any open state will not be exportable within Greenback.

Payment Method

The payment method will include the card type (network), the last 4 digits of the credit card used, total amount charged and the date of payment.

For transactions with multiple payments, you will see each payment listed.

Customer Info

The customer/contact record on a Greenback transaction consists of Name, Address, City, State or Region, postal code and country (country code). Customer/contact records can be found for both "billing" and "shipping (ship to)".

Line Items

Each transaction on Greenback will contain one or many line items. Line items represent the products or services you purchased or sold. Line items consist of a product or service name, description, product SKU, uri (used to hyperlink back to the product or service for sale on the providers web site), quantity, unit price and total. Line items may also contain attributes specific to the upstream provider such as a model number.

SKUs

Product SKUs can play an important role in automating the categorization of your transactions. Greenback leverages machine learning models to automate the categorization of your transaction data when exporting to an accounting file and as such, SKUs play a pivotal role in the ongoing categorization.

In addition, Greenback explicitly categorizes transactions when a SKU from an upstream provider matches that of a SKU from your accounting file. Lastly, SKUs can be used to perform more complex workflows, referred to as Transforms, when exporting data to an accounting file.

Totals

Toward the bottom of each transaction detail you will find both the subtotal and grand total. The subtotal represents the sum of all items on the transaction. The grand total will represent the sum of all items on the transaction plus or minus any shipping revenue, shipping expenses, taxes, fees and discounts.

Sales Tax

If you transaction was subject to sales tax, you will see sales tax itemized out in the transaction view.

Other Taxes & Fees

Some integrations may support additional itemized taxes and fees such as transportation related taxes and fees as shown in this example from Delta Airlines.

Value Added Tax (VAT)

If a transaction is subject to a "value added tax" (VAT), "goods and services tax" (GST), "harmonized sales tax" (HST) or a "provincial sales tax" (PST) you will find them itemized in the "totals" section of the transaction.

Shipping

If a transaction is subject to shipping fees, you will find them itemized in the "totals" section of the transaction. There are several options for exporting shipping fees/sales. Learn more about updating your shipping export preferences here.

Discounts

If a transaction is subject to discounts, you will find them itemized in the "totals" section of the transaction. There are several options for exporting discounts. Learn more about updating your discount export preferences here.

Meta Data

Several integrations also include custom "name > value" pair attributes in the form of meta-data. These custom attributes can be included in the export to your accounting program as well as used to configure export routing preferences. If you have specific requirements regarding the use of custom attributes, please contact Greenback support for assistance.

Original Receipts

An original receipt is a PDF file from an upstream integration (e.g. Amazon) that is usually provided in your Order History. The original receipts provided by this authoritative source are shown in your Greenback transaction feed with a special callout. If an original receipt is available, a receipt icon will be visible on that specific transaction.

VAT Invoices

An original VAT invoice is a PDF file from an upstream integration (e.g. Amazon) that is usually provided in your Invoices tab. The VAT/GST/HST/PST invoices provided by this authoritative source are shown in your Greenback transaction feed with a special callout. If a VAT invoice (created by the seller) is available, an invoice icon will be visible on that specific transaction.

Ready to get automated?

  • Start your free trial
  • Easy set-up
  • Cancel any time