Finance Report

From UnionCloud Support
Jump to: navigation, search

Finance Report is a stub, and just part of a wider section on UnionCloud Reporting

Finance Report Details

Finance Report Download screen

You can find this page on your own site at url: <yoursite>/administrator/reports

The Finance Report download screen is fairly straight forward, and you can use it to generate reports about all of your finance activity, on your UnionCloud site within a date range.
These reports can be a maximum of 1 calendar month, if you would like a report for a longer period please raise this as a request in ZenDesk.

Download Report

An example of how the Finance Report Spreadsheet looks

Once downloaded this report will provide you with the following A list of all transactions that have been completed via your website within the date range you have specified, along with these fields;

  • Date : Date on which the order was placed.
  • Order ID: Order ID of the order placed. This same order ID is also be found on the payment provider's order listing for reference.
  • User Email: Email of the user who placed the order.
  • Create User Email: This will only be populated for remote sales(a.k.a Box Office) purchases. It will be the email of the user who was logged in to facilitate the purchase for the customer.
  • Union: The name of the union on which the order was placed
  • Group: The name of the group will be populated here in instances where a group membership or a group event ticket was purchased. In cases where union event tickets or shop products are purchased this will be populated with the name of the union.
  • Event Date: Date of the event for which the ticket was purchased.
  • Category/Event: This will contain the name of the event in cases of event ticket purchases. In cases of shop order purchases this will have a value as 'eShop'. For group membership purchases this will have a value as 'Memberships'.
  • Item ID: This will contain the booking/transaction references for membership and event purchases in UnionCloud. Not of any value to NUS finance. However for shop products this populates with the product(product variant) code.
  • Ticket Number: Will capture the ticket number of the particular event booking. In case of membership or shop purchases this will be blank.
  • Nominal Code: Nominal code of the item purchased. Nominal codes can be set up for memberships, shop products and event tickets.
  • Ticket Type / Membership Type / Product: Name of the ticket type or membership type or product being purchased
  • Item Price: Base Price of the Item
  • Transaction Fee: Transaction fee applicable to the item
  • Gross Price: Total Price of the item. i.e Item Price + Transaction fee
  • VAT Rate: 20 as per current UK trade laws
  • Quantity: Quantity of item purchased
  • Status: Payment status of the Order. Can be Payment Processed for a paid order, Free for free items, Refund for a refund transaction row appearing corresponding to the original order and Refund and Resell for a refund and resell transaction row appearing corresponding to the original order
  • Gross Charges:
  • Gross Total
  • Net of VAT on item Price
  • Net of VAT on Transaction Fee
  • Net of VAT on Charges
  • Total net of VAT
  • VAT on Item Price
  • VAT on Transaction Fee
  • VAT on Charges
  • Total VAT amount
  • Online / Offline: Populated as Online for any orders from the website through the payment gateway. For any other transactions, i.e remote sales, club membership uploads via csv or web-services.
  • Mode of Payment: Populated with Cash or Card if the order is purchased via Remote Sales. If it is a paid order from the website through the payment gateway it will show as credit_card.
  • Itemable Transaction ID: For UnionCloud internal use only.