Important: This reference is provided as a guide and may not reflect every field imported for your specific configuration. Certain import sections, such as User Defined Fields, Price Lists, and Discount matrices, may not be fully represented here. Additionally, as the integration is updated over time, this document may become out of date. If you notice any missing fields, inaccuracies, or discrepancies between this document and the data in your system, please raise this with our support team so that we can review and update this article accordingly.
Sales Ledgers
CRM Field (Friendly Name) | Exchequer Source | Description |
Account Code |
| Unique identifier to link the CRM customer record back to Exchequer |
Company Name |
| Displays the customer's company name in the CRM |
Address Line 1 |
| Stores the first line of the customer's billing address |
Address Line 2 |
| Stores the second line of the billing address |
Town |
| Stores the town/city of the billing address |
County |
| Stores the county/region of the billing address |
Country |
| Stores the country for the billing address |
Country Code |
| ISO country code for international address standardisation |
Address Line 5 |
| Additional address line available in newer Exchequer versions |
Postcode |
| Postal/zip code for the customer |
Telephone |
| Primary phone number for the customer |
Fax |
| Fax number for the customer |
| Email address for the customer account | |
Default Warehouse |
| Sets the default warehouse/location for this customer's orders |
Invoice To |
| Identifies which account invoices should be addressed to |
On Stop | Derived from | Flags accounts that are on hold to prevent new orders |
Closed | Derived from | Flags accounts that have been closed in Exchequer |
Balance |
| Current outstanding balance for the customer |
Currency Code |
| The currency symbol associated with the customer |
Credit Limit |
| Maximum credit allowed for this customer |
Overall Discount |
| The overall discount percentage applied to the customer |
Price List |
| The price band (A–H) assigned to the customer |
Compound Overall Discount | Hardcoded to | Priority flag ensuring this only applies when no other pricing overrides exist |
Tax Code |
| The default VAT code (E/Z/A/D) for the customer |
VAT Registration Code |
| Customer's VAT registration number for tax compliance |
Settlement Discount |
| Default settlement discount percentage |
Settlement Days |
| Number of days within which settlement discount applies |
Department Code |
| Default department code assigned to the customer |
Cost Centre Code |
| Default cost centre code assigned to the customer |
GL Code |
| The general ledger code associated with sales for this customer |
Purchase Ledger
CRM Field (Friendly Name) | Exchequer Source | Description |
Supplier Code |
| Unique identifier linking the CRM supplier record to Exchequer |
Company Name |
| Displays the supplier's company name |
Address Line 1 |
| Stores the first line of the supplier's address |
Address Line 2 |
| Stores the second line of the supplier's address |
Town |
| Stores the town/city of the supplier's address |
County |
| Stores the county/region of the supplier's address |
Country |
| Stores the country (mapped from the address postcode field in older versions) |
Postcode |
| Postal/zip code for the supplier |
Telephone |
| Primary phone number for the supplier |
Fax |
| Fax number for the supplier |
| Email address for the supplier account | |
Closed | Derived from | Flags suppliers that have been closed in Exchequer |
Balance |
| Current outstanding balance owed to the supplier |
Currency Code |
| Currency symbol associated with the supplier |
Product Items
CRM Field (Friendly Name) | Exchequer Source | Description |
Product Reference |
| Unique product identifier from the stock record |
Alternative Reference |
| Secondary/alternative product code |
Product Description |
| Primary description of the product |
Product Category |
| The parent group code, used as the product category |
Discount Matrix Code |
| Links product to discount matrix calculations |
Allow Overall Discount | Hardcoded to | Enables overall discount to be applied to this product |
Unit of Sale |
| Description of the unit the product is sold in |
Default Warehouse |
| Default stock location/warehouse for the product |
Bin Location |
| Specific bin location within the warehouse |
Cost Centre |
| Cost centre associated with this product |
Department |
| Department associated with this product |
Sell Price |
| Selling price converted to home currency |
Cost Price |
| Cost price for margin and profitability calculations |
Sell Price Decimals |
| Number of decimal places for sell prices |
Cost Price Decimals |
| Number of decimal places for cost prices |
Pack/Unit | Derived from stock converter | Unit description used for pricing calculations |
VAT Code |
| Default VAT code for the product |
Extended Description |
| Additional descriptive text for the product |
Barcode |
| Product barcode for scanning/identification |
Quantity Type | Derived from stock converter | Whether quantity is decimal or factor-based |
Quantity Factor | Derived from stock converter | Conversion factor for quantity calculations |
Quantity Decimals |
| Number of decimal places for quantities |
Allow Split | Derived (true if decimals > 0 or factor > 1) | Whether the product can be sold in partial quantities |
Stocked | Derived from | Whether the product is a physical stocked item |
Obsolete | Derived from | Flags discontinued products |
Purchase Currency | Derived from | Currency the product is purchased in |
Purchase Cost |
| Cost price in the supplier's currency |
Purchase Cost Decimals | Derived | Decimal places for the purchase cost |
Unit Weight |
| Product weight for shipping/Intrastat reporting |
Unit Weight Decimals | Hardcoded to | Decimal precision for weight |
Unit Weight Description | Hardcoded to | Weight unit label |
Product Categories
CRM Field (Friendly Name) | Exchequer Source | Desciption |
Category Code |
| Unique identifier for the product category |
Category Description |
| Human-readable name of the category |
Parent Category |
| Establishes the category hierarchy |
Invoices (Sales Invoices)
CRM Field (Friendly Name) | Exchequer Source | Description |
Account Code |
| Links invoice lines to the correct customer |
Quote Reference |
| Links the invoice back to the originating CRM quote |
Order Number |
| Links the invoice to the sales order |
Customer Reference |
| The customer's own purchase order reference |
Delivery Reference | Parsed from line descriptions (SDN prefix) | Tracks which delivery note relates to the invoice line |
Invoice Document |
| The unique Exchequer transaction reference for the invoice |
Invoice Line |
| Line number within the invoice |
Invoice Number |
| Invoice number displayed to users |
Product Reference |
| Links the line to a product in the CRM |
Product Description |
| Description of the product on this line |
GL Code |
| General ledger code for the invoice line |
Department Code |
| Department associated with the invoice line |
Order Quantity |
| Quantity ordered |
Quantity Type | Derived from stock converter | Whether quantity is decimal or factor-based |
Quantity Decimals |
| Decimal places for quantity display |
Quantity Factor | Derived from stock converter | Conversion factor for the quantity |
Delivered Quantity | Same as | Quantity delivered (set equal to order qty for invoices) |
Invoice Quantity | Same as | Quantity invoiced |
Unit Price |
| Net price per unit on the line |
Sell Price Decimals |
| Decimal places for selling prices |
Cost Price |
| Cost price for margin/profitability analysis |
Cost Decimals | Derived from stock converter | Decimal places for cost price |
Cost Value | Calculated from cost × qty | Total cost value for the line |
Warehouse Code |
| Warehouse the stock was dispatched from |
Currency Decimals | Hardcoded to | Decimal places for currency values |
Base Currency Decimals | Hardcoded to | Decimal places for base currency values |
Line Value (Net) |
| Net total value of the invoice line |
Line Value (Gross) | Net + | Gross total including VAT |
Base Value (Net) | Converted via | Net value in base/home currency |
Base Value (Gross) | Converted via | Gross value in base/home currency |
Invoice Date |
| Date the invoice was raised |
Order Date |
| Date the original order was placed |
Due Date |
| Payment due date |
Expire Date |
| Contract expiry date |
Contract |
| Service contract reference |
Ledger Account |
| The Exchequer account code on the transaction header |
Currency Code |
| Currency symbol for the invoice line |
Delivery Date |
| Date of delivery for the line |
Analysis Code 1 |
| Analysis code for reporting/categorisation |
Job Code |
| Links the line to a job costing record |
User Field 1 |
| Custom user-defined field from the transaction line |
User Field 2 |
| Custom user-defined field from the transaction line |
User Field 3 |
| Custom user-defined field from the transaction line |
User Field 4 |
| Custom user-defined field from the transaction line |
Extended Description |
| Additional descriptive text for the invoice line |
Sales Credits
CRM Field (Friendly Name) | Exchequer Source | Description |
GL Code |
| General ledger code for the credit line |
Department Code |
| Department associated with the credit line |
Credit Document |
| Unique Exchequer reference for the credit note |
Credit Line |
| Line number within the credit note |
Invoice Number |
| Links the credit to the original invoice |
Order Number |
| Customer's reference / your ref on the credit |
Product Reference |
| Links the line to a product in the CRM |
Product Description |
| Description of the credited product |
Warehouse Code |
| Warehouse the credit relates to |
Order Quantity |
| Quantity being credited |
Quantity Type | Derived from stock converter | Decimal or factor-based quantity |
Quantity Decimals |
| Decimal places for quantities |
Quantity Factor | Derived from stock converter | Conversion factor |
Delivered Quantity | Same as | Delivery quantity (mirrors order qty) |
Invoice Quantity | Same as | Invoiced quantity for the credit |
Unit Price |
| Net price per unit (negated for credit) |
Sell Price Decimals |
| Decimal places for selling prices |
Cost Price |
| Cost price for the credited line |
Cost Decimals | Derived from stock converter | Decimal places for cost |
Cost Value | Calculated from cost × qty | Total cost value of the credit line |
Line Value (Net) |
| Net value of the credit line |
Line Value (Gross) | Net + | Gross value including VAT |
Base Value (Net) | Converted via | Net value in home currency |
Base Value (Gross) | Converted via | Gross value in home currency |
Invoice Date |
| Date the credit was raised |
Due Date |
| Payment due date for the credit |
Expire Date |
| Contract expiry date |
Contract |
| Service contract reference |
Account Code |
| Links the credit to the correct customer |
Ledger Account |
| Exchequer account code on the header |
Currency Code |
| Currency symbol for the credit line |
Customer Reference |
| Customer's PO reference |
Quote Reference |
| Originating quote reference |
Delivery Date |
| Delivery date on the line |
Analysis Code 1 |
| Analysis code for reporting |
Job Code |
| Links the credit to a job costing record |
Extended Description |
| Additional text for the credit line |
Payments
CRM Field (Friendly Name) | Exchequer Source | Description |
Invoice Number |
| Identifies which invoice the payment status relates to |
Payment Due Date |
| The date by which payment is expected |
Paid Flag | Derived from | Indicates whether the invoice has been fully paid |
General Ledger
CRM Field (Friendly Name) | Exchequer Source | Description |
GL Code |
| Unique general ledger account code |
Description |
| Human-readable name of the GL account |
GL Type |
| Classifies the type of GL account |
Parent GL Code |
| Establishes hierarchy between GL accounts |
Obsolete |
| Flags inactive/obsolete GL accounts |
Departments
CRM Field (Friendly Name) | Exchequer Source | Description |
Department Code |
| Unique department identifier |
Description |
| Human-readable department name |
Obsolete |
| Flags inactive/obsolete departments |
Cost Centres
CRM Field (Friendly Name) | Exchequer Source | Description |
Cost Centre Code |
| Unique cost centre identifier |
Description |
| Human-readable cost centre name |
Obsolete |
| Flags inactive/obsolete cost centres |
Warehouses
CRM Field (Friendly Name) | Exchequer Source | Description |
Warehouse Code |
| Unique location/warehouse identifier |
Warehouse Name |
| Human-readable warehouse name |
A default "Not Set" warehouse is always created, and if locations are disabled in Exchequer a "Total Stock" entry is added instead. WarehouseImportItem.vb:46-107
Jobs (Job Costing)
CRM Field (Friendly Name) | Exchequer Source | Description |
Job Code |
| Unique job identifier |
Description |
| Human-readable job description |
Parent Job Code |
| Links to a parent job for hierarchy |
Alternative Code |
| Secondary/alternative job reference |
Contact |
| Contact person associated with the job |
Manager |
| Manager responsible for the job |
Completed |
| Whether the job has been completed |
Start Date |
| Planned or actual start date |
End Date |
| Planned or actual end date |
Revised End Date |
| Updated end date if the job has been rescheduled |
Job Type |
| Numeric job type classification |
Job Type Code |
| Code referencing the job type definition |
Charge Type |
| How the job is charged (e.g. fixed, time & materials) |
SOR Number |
| Links the job to a Sales Order |
Quoted Price |
| The quoted price for the job |
Quoted Currency |
| Currency for the quoted price |
QS Code |
| Quantity Surveyor / quote stage code |
Status |
| Current status of the job |
Customer Code |
| Links the job to a sales ledger customer |
Supplier Code |
| Links the job to a purchase ledger supplier |
User Defined Fields 1–10 |
| Custom user-defined fields for flexible data capture |
Division Contacts and Delivery Locations
When new divisions are created in the CRM from Exchequer, a contact record and a default delivery location are also imported.
Division Contacts
CRM Field (Friendly Name) | Exchequer Source | Description |
Title | Parsed from | Contact's title (Mr, Mrs, etc.) |
Forename | Parsed from | Contact's first name |
Surname | Parsed from | Contact's last name |
Salutation |
| Full name used for correspondence |
| Contact's email address | |
Role Code | From integration settings | Assigns the contact a role within the division |
Division Delivery Locations
CRM Field (Friendly Name) | Exchequer Source | Description |
Address Line 1 |
| First line of the delivery address |
Address Line 2 |
| Second line of the delivery address |
Town |
| Town/city of the delivery address |
County |
| County/region of the delivery address |
Address Line 5 |
| Additional address line |
Postcode |
| Postal/zip code for the delivery address |
Country |
| Country for the delivery address |