Transaction Report Overview

The Transaction Report is a CSV file of a customizable report on transactional data across all your stores.

Jump to:

Transaction Report Overview

Common Uses for the Transaction Report

To get to the transaction report, you will go to the "Accounting Tab" and then click on "Transaction Report". 

Transaction Report Overview

You can either filter transactions by date range OR deposits.

Dates

Step 1: Select the date range that you want to include when pulling the transactions list.  

Step 2: To select the range, you'll click the date you want to begin at and then go to the date you want to end the range at and click that date. It will then show in green the selected dates.

Note: You can only pull up to 12 months at a time for the date range.

Step 3: If you are pulling a specific store, make sure to include the correct dates for when that store was open.

Deposits

You can select one or multiple specific deposits to pull the transactions from. Once you have filtered the report by either the dates or deposits, you can customize what information needs to be included in the report. 

Stores

If you're needing information only for specific stores, you can select the stores you are wanting to include under stores. The report automatically includes all stores within the date range/deposit. If zero stores are selected, it will pull all transactions for the dates/deposits selected. You only need to make this selection if you have specific stores you're needing to pull from.

Sales Representative

If you're wanting to pull transactions based on the sales representative, you can select the sales rep you want to include. The report automatically includes all sales rep's stores within the date range/deposits unless you select specific representatives that you want to include. 

Payment Methods

You can select which payment methods you want to include in the report. The report defaults to include all payment methods but you can deselect any options. If the option is outlined in Green, it will be included. If you deselect, it will turn grey. The report defaults to include all transactions(charges or refunds) made on orders. You can also select to only include the original transaction for orders. 

Filters

On the right-hand side, you can click the checkboxes next to each option to include or remove data from the CSV file.

Transaction Information:

• Amount - total charged to the customer
• Card info - last 4 digits of the CC and the card issuer(Visa, Mastercard, etc.)
• Check number - if the customer paid or was refunded by check, it will include the check number
• Date - date of the transaction
• Description - for any additional charges or refunds, it will show the description if one was included
• Fees - any fees that you charge your customers at checkout
  • Note: these are not the OMG/Processing fees deducted from deposits
•  Payment method - shows the method of payment either by credit card, gift card, cash/check, or PO option
• Taxes - the sales tax that you set up to charge customers- either calculated or manual taxes
• Transaction type - shows if the transaction was a charge (SALE) or a Refund to the customer

Order Information

• Order ID - customer's order ID number that can be used to pull up the order
• OMG Sale Code - OMG's automatic sale code that is assigned to stores and cannot be changed
• Sale Code - the customizable sale code on stores
• Sales Representative - the sales rep that is assigned to the store
• Store Title - name of the store the order was placed on 
• Work Order - the optional Work Order number assigned to the store from the General tab of edit store 

Customer Information

• Billing Information - customer's billing name & billing address included on the order
  • Pro Tip: if you're trying to pull customer email addresses across multiple stores, you'll want to make sure you have the Billing Information checked as that will include the email from each order.
• Custom Fields - any additional information that was collected at checkout (ex: grade, homeroom teacher, is this a gift?, etc.)
• Player Information - Player first and last name
• Shipping Information - customer's shipping name & shipping address included on the order

Deposit/Invoice Information

• Deposit Number- deposit ID that the order is included on
• Invoice Number- invoice ID that the order is included on, if applicable
• OMG Fee- amount taken out for the OMG fee
• Processing Fee - amount taken out for the Credit Card Processing fee
  • To see the percentage for OMG fee/Processing fees for your account, you can go to Dealer Settings, then to the OMG Payments tab

Once you've made your selections, you can either click "Download Report" which downloads the CSV file to your computer or you can click "Email Report" which will send to you in an email that you can easily forward to others if needed. 

Common Uses for the Transaction Report: 

Gather emails across multiple stores

• If you're needing to pull the email addresses for customers for a specific time frame or specific stores, you can do so by selecting the dates & stores that you want to include. 
• Make sure that you select to include the Billing information on the report
• When you download the report, it will include the customer's email address they entered on the order which you can use to copy and paste into your email server. 

Using the Transaction Report for Deposits

• The Transaction Report allows you to view which orders were on a particular deposit, fees deducted, etc.
• Select one or more deposits you'd like to see more details on from the dropdown menu.
• Check or uncheck all information you'd like to include in your Transaction Report.

Reporting on Gift Card Totals 

• The Transaction Report has an added gift card filter under Payment Methods.
• This can assist will creating gift card invoices for the client.
• This will pull the total amount used in gift cards on specific orders as well as for the stores/deposits/dates that you selected to pull.

• Deleted gift cards that were redeemed in the store will also appear on this report. 
• For a walkthrough on adding Gift Cards to stores, take a look here. 

Collected Taxes on Stores

• If you need to know the taxes collected during a certain date range across multiple or all stores, you can download the transaction report and select to include Taxes. This will show you the taxes that you collected from customers on your stores. It will show you whether the taxes were calculated or manual taxes and what was collected per each order. It will show you the total collected at the bottom of the report. 

• For a walkthrough on adding taxes on your stores, take a look here. 

Shipping Information

• If you need to pull shipping information into an Excel sheet, you can use the transaction report to easily pull that information for one or multiple stores. Under the Customer Information section, you'll want to make sure that you selected to include the Shipping Information. This will pull the shipping names/addresses into a CSV that you can use to easily see the addresses or import into applications that you may use for shipping. 

• For a walkthrough on adding shipping to your stores, take a look here. 

For an overview of other reports available on each store, you can take a look here.