Vishakh: Changes to include some field definitions. Still need to define the charges and VAT calculation fields. We have an excel macro that does this. Should be used to educate users for these fields instead.

2017-11-22T10:27:03Z

Changes to include some field definitions. Still need to define the charges and VAT calculation fields. We have an excel macro that does this. Should be used to educate users for these fields instead.

Ash at 07:33, 25 July 2017

2017-07-25T07:33:30Z

Ash: Created page with "==Finance Report Details== Finance Report Download screen {{url|/administrator/reports}} The Finance Report download screen is fairly strai..."

2017-07-24T12:56:29Z

Created page with "==Finance Report Details== thumb|Finance Report Download screen {{url|/administrator/reports}} The Finance Report download screen is fairly strai..."

New page

==Finance Report Details==
[[File:Finance Report.PNG|thumb|Finance Report Download screen]]

{{url|/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.<br/>
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==
[[File:Finance Report Spreadsheet.PNG|thumb|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
*Order ID
*User Email
*Create User Email
*Union
*Group
*Event Date
*Category/Event
*Item ID
*Ticket Number
*Nominal Code
*Ticket Type / Membership Type / Product
*Item Price
*Transaction Fee
*Gross Price
*VAT Rate
*Quantity
*Status
*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
*Mode of Payment
*Itemable Transaction ID

@@ Line 13: / Line 13: @@
 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''' : Date on which the order was placed.
-*Order ID
+*'''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
+*'''User Email''': Email of the user who placed the order.
-*Create User Email
+*'''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
+*'''Union''': The name of the union on which the order was placed
-*Group
+*'''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
+*'''Event Date''': Date of the event for which the ticket was purchased.
-*Category/Event
+* '''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
+*'''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
+*'''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''': Nominal code of the item purchased. Nominal codes can be set up for memberships, shop products and event tickets.
-*Ticket Type / Membership Type / Product
+*'''Ticket Type / Membership Type / Product''': Name of the ticket type or membership type or product being purchased
-*Item Price
+*'''Item Price''': Base Price of the Item
-*Transaction Fee
+*'''Transaction Fee''': Transaction fee applicable to the item
-*Gross Price
+*'''Gross Price''': Total Price of the item. i.e Item Price + Transaction fee
-*VAT Rate
+*'''VAT Rate''': 20 as per current UK trade laws
-*Quantity
+*'''Quantity''': Quantity of item purchased
-*Status
+*'''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 Charges''':
-*Gross Total
+*'''Gross Total'''
-*Net of VAT on item Price
+*'''Net of VAT on item Price'''
-*Net of VAT on Transaction Fee
+*'''Net of VAT on Transaction Fee'''
-*Net of VAT on Charges
+*'''Net of VAT on Charges'''
-*Total net of VAT
+*'''Total net of VAT'''
-*VAT on Item Price
+*'''VAT on Item Price'''
-*VAT on Transaction Fee
+*'''VAT on Transaction Fee'''
-*VAT on Charges
+*'''VAT on Charges'''
-*Total VAT amount
+*'''Total VAT amount'''
-*Online / Offline
+*'''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
+*'''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
+*'''Itemable Transaction ID''': For UnionCloud internal use only.

← Older revision		Revision as of 07:33, 25 July 2017
Line 1:		Line 1:
		+	{{PAGENAME}} is a stub, and just part of a wider section on UnionCloud [[Main_Page#Reports\|Reporting]]
	==Finance Report Details==		==Finance Report Details==
	[[File:Finance Report.PNG\|thumb\|Finance Report Download screen]]		[[File:Finance Report.PNG\|thumb\|Finance Report Download screen]]

Finance Report - Revision history

Vishakh: Changes to include some field definitions. Still need to define the charges and VAT calculation fields. We have an excel macro that does this. Should be used to educate users for these fields instead.

Ash at 07:33, 25 July 2017

Ash: Created page with "==Finance Report Details== Finance Report Download screen {{url|/administrator/reports}} The Finance Report download screen is fairly strai..."