Import Data in Bulk
Import Transactions in Bulk
Sometimes you just need to import your transaction data from a report or a spreadsheet. Rev Rec allows you to do this leveraging our "Import" feature.
Importing Transactions
In order to access this you click on Sync -> Import as shown here.
We support importing your transactions in as Microsoft Excel workbooks. Each sheet is a particular type of data (the sheet and column names have to match exactly).
OrderDetails - This represents the sales order details. All the data is presented at a line item level
BillingSchedule - The amounts that are invoiced against the orders, also tracked at a line item level.
ProfessionalServicesDelivery - Delivery of "work" against professional services type activity, expressed in units of work (typically hours).
Expense - This represents the expense incurred on contract as contract cost and general cost of sales as other cost.
Reference information about the customer and products.
*Note that if the reference information (products/customers) are already known by Rev Rec (since you entered them earlier, sync'ed them into the system or entered them when you setup the Accounting Rules or elsewhere from the user interface) you do NOT need to provide them again.
An example transaction file with contract details is available here.
Transaction Files Field Descriptions
The following tables describe the fields and field names you can use to import
Order Details
| Field | Description |
|---|---|
| Customer ID | The identifier for the customer this order is being sold to. |
| Customer Name | A descriptive name for the customer |
| Order Number | The unique order number |
| Order Item Number | The unique line number for the item in this order |
| Product Code | A unique identifier for the product being sold (for example,the SKU) |
| Order Start Date | The date at which this overall order was placed. |
| Service Start Date | Optional:When a performance obligation for this line item/service begins |
| Service End Date | Optional:When a performance obligation for this line item/service ends. If not specified the system will use the term for the product that is sold |
| Quantlty | Number of items sold |
| List Price | List Unit Price of the line item |
| Unit Price | Unit Price of the line item |
| Sale Price | Optional:Quantity • Unit Price |
| Currency | Currency of the contract |
Billing Schedule
| Field | Description |
|---|---|
| Billing Date | Date when the invoice was sent to the customer |
| Customer ID | The unique customer ID |
| Invoice Number | A unique identifier for the invoice (not the line item) |
| Amount | The amount for the invoice line item |
| Currency | Currency of the customer |
Service Delivery
| Field | Description |
|---|---|
| Log Date | The date on which service is provided |
| Order Number | The unique order number |
| Order Item Number | Optional : The unique line number for the item in this order |
| Customer ID | The unique customer ID. Only used if Order Number and Order Item Number is not provided |
| Product Code | A unique identifier for the product for which consumption information is being uploaded (for example,thoe SKU). Only used if Order Number and Order Item number is not provided |
| Units Delivered | The amount of work (units) delivered under the arrangement |
Expense
| Field | Description |
|---|---|
| Reference No | Unique identifier for the expense |
| Product Code | Unique identifier for the product |
| Expense Code | A code used to identify a certain expense |
| Expense Date | Date on which expense is effective |
| Expense Amount | Total amount of the expense |
| Order number | Sales Order Number |
| Start Date | Start date of the expense. If selected as expense date then start date will default to expense date value |
| Term | Term in month for which the expense will be provided. If a term is provided, an end date is not required. |
| End Date | End date of the expense |
| Class | Class of the expense, an attribute for reporting purpose |
| Department | Department related to expense, an attribute for reporting purpose |
| Location | Location of the Expense, an attribute for reporting purpose |
REVLOCK also supports loading invoice information at the sales order item level if your invoicing method / solution supports it. If so you can use the following format instead:
Billing Schedule
| Field | Description |
|---|---|
| Field | Description |
| Billing Date | Date when the invoice was sent to the customer |
| Customer ID | The unique customer ID |
| Order Number | The unique order number |
| Order Item Number | The unique line number for the item in this order. |
| Invoice Number | A unique identifier for the invoice (not the line item) |
| Amount | The amount for the invoice line item |
| Currency | Currency of the customer |
Reference Information Files Field Descriptions
If you need to update reference information you can do using the following two worksheets:
Product
| Field | Description |
|---|---|
| Product Code | A unique identifier for the product being sold (for example,the SKU) |
| Product Name | A descriptive name for the product |
| Product Familv | Optional: An optional grouping of products that are similar. |
| Is Recurring | Optional: TRUE if the product is a subscription based. FALSE otherwise |
| Product Type | Optional: A grouping used in the PERCENT_NET SSP rule for products whose relative price is dependent on each other |
| List Price | List price per unit for the total term sold |
| Term | For recurring or subscription products the total term for which the product has been contracted (specified in months) |
Customer
| Field | Description |
|---|---|
| Customer ID | The unique customer ID |
| Customer Name | A descriptive name for the customer |
Note that all identifiers in Rev Rec can include any number of letters, digits ([0-9]), hyphens ("-"), underscores ("_"), colons (":"), and periods ("."). Other special characters such as /, \,? & are not currently supported.
Updated on: 22/06/2022
Thank you!