Concepts

ImportId

Every object in the model has an ImportId property. This is a string that is used to uniquely identify each item being imported. When importing data from an external system the ImportId can be populated with the object’s unique id from that system, or a new id can be generated for the purpose of importing.

To associate an id with an object that has already been imported into the system (for example, adding a work item to an existing matter), the format prefix_uniqueid should be used, e.g. matter_22635a10c993592cb52c083f346aa950.

Account

Note: Efimis will be provisioned with a default chart of accounts

PropertyDescriptionTypeExample
Namestring
Descriptionstring
JournalIdstring
ParentAccountIdstring
TypeAccountType
AccountRolesNot Supported YetIList<AccountRole>
AccountCategoryAccountCategory
AccountCodestring
BankNamestring
BankBSBstring
BankAccountNumberstring
TaxCodestring
CurrencyCurrency for this account. If not specified, the base currency is assumedstring?GBP , AUD
Balancedecimal200.38

AccountCategory

PropertyDescriptionValue
AssetAsset0
LiabilityLiability1
EquityEquity2
RevenueRevenue3
ExpenseExpenses4

AccountRole

PropertyDescriptionValue
UnallocatedCatch all account. If you can’t find an account put it in here0
UnbankedFundsUnbanked Funds1
AccountsReceivableAccounts Receivable2
DebtorsAdjustmentDebtors Adjustment3
AccountsPayableAccounts Payable4
CreditorsAdjustmentCreditors Adjustment5
SupplierPrepaymentsAdvance payments to supplier for future purchases6
SupplierCreditsSupplier issued non-cash credit notes, i.e. discounts taken7
DisbursementDisbursement Incurred8
DisbursementRecoveredDisbursement Recovered9
AnticipatedDisbursementAnticipated Disbursement Incurred10
AnticipatedDisbursementRecoveredAnticipated Disbursement Recovered11
ClientFundsClient advanced payments for future invoices12
CreditNotesFirm issued non-cash credits, i.e. vouchers or gift cards13
TaxCollectedTax Collected14
TaxPaidTax Paid15
CmaControlControlled Moneies control account, lives in the trust journal only16
StatDepositControlApplicable only to some juristictions, the control account for all monies held with the statutory body, lives in the trust journal only17
RetainedEarningsRetained Earnings18
CurrentEarningsCurrent Earnings19
HistoricalBalanceHistorical Balance20
FeesRevenueProfessional fees revenue recognised on invoices when finalised, inclusive of discount21
CostRecoveredCost recovery revenue recognised on invoices when finalised22
DiscountTakenDiscount taken from supplier when a discount is received23
RealisedFxGainCaptures gains and losses due to exchange rate difference between when debtor/credit is posted, and when they are paid24
UnrealisedFxGainCaptures gains and losses due to exchange rate difference between the reporting time, and posting time25
RoundingAdjustmentWhen working with tax, forex, rounding errors occur when numbers cannot be divided completely26
CreditNotesIssuedThis specifically does not include discount line items - they are considered a reduction of FeesRevenue27
FeesWrittenOffFees Written Off28
DisbursementsWrittenOffDisbursements Written Off29
CostRecoveryWrittenOffCost Recovery Written Off30
AnticipatedDisbWrittenOffAnticipated Disbursement Written Off31
OtherRevenueMiscellaneous revenue items on the invoice, for items like interest earned or credit card surcharge32
OtherRevenueWrittenOffOther Revenue and other GL revenue items invoiced being written off33
ProBonoFeesExpensesAccount to track fees on pro-bono matters34
ProBonoDisbursementsExpensesAccount to track disbursements on pro-bono matters35
ProBonoAnticipatedDisbursementsExpensesAccount to track anticipated disbursements on pro-bono matters36
ProBonoCostRecoveryExpensesAccount to track cost recovery disbursements on pro-bono matters37

AccountType

PropertyDescriptionValue
StandardStandard GL account with no special behaviour0
BankA GL account that mirrors a bank account and may participate in cashbook operations1

Address

PropertyDescriptionTypeExample
AttentionOfstring
AddressTypeAddressType
Streetstring
Localitystring
Suburbstring
Statestring
PostCodestring
Countrystring
NameOptional name to identify this address, e.g. Spouse Address, which gives more information about the address type.string
NotesOptional additional information on how this address should be used, e.g. only call after hours, or do not discuss confidential details, etc.string
Defaultbooltrue, false

AddressType

PropertyDescriptionValue
BillingBilling0
PostalPostal1
StreetStreet address2
OtherOther3

Association

PropertyDescriptionTypeExample
Typestring
EntityIdstring

BankAccountDetails

PropertyDescriptionTypeExample
RoutingCodestring
BranchCodestring
Numberstring
Namestring
BankNamestring
BranchNamestring

BillingBasis

All the different ways billing is done on matters

PropertyDescriptionValue
AdHocMatter has to be marked as billing for it to be included in the automated billing run0
PeriodicMatter will be billed periodically according to the firm default billing schedule1
ProBonoMatter will not be included in any billing, and marked as pro bono work2
NonBillableMatter will not be included in any billing, and marked as internal admin matter3

BillingGrade

PropertyDescriptionTypeExample
Namestring

BillingRate

This represents a rate definition on a Matter or Employee

PropertyDescriptionTypeExample
Namestring
RateSetNamestring?
RateThe hourly ratedecimal200.38
MatterIdstring?
EmployeeIdstring?
Memostring
EffectiveFromDateTime?2025-01-12T00:00:00
EffectiveToDateTime?2025-01-12T00:00:00

CashbookAccount

Specifies a cashbook account that tracks a bank account

PropertyDescriptionTypeExample
JournalIdstring
AccountNameName used by the user to identify itstring
BookBalanceCashbook balance as at cutover timedecimal200.38
ReconciledBalanceReconciled cashbook balance as at cutover time. Usually written to the cashbook, alongside unreconciled receipts and payments to make the book balancedecimal200.38
BankRoutingCodeThe unique identifier used by the banking system at large to identify international transfer accounts IBAN/Swiftstring?
BankBranchCodeThe Branch code of the bankstring?
BankAccountNumberAccount number issued by the bankstring?
BankAccountNameAccount name known by the bankstring?
BankNameFinancial institution namestring?
BankBranchNameBranch namestring?
StatDepositBalanceStat Deposit Balance as at cutover time. Applicable to Australian firms onlydecimal?200.38

CashDetail

PropertyDescriptionTypeExample
AmountInNotesdecimal200.38
AmountInCoinsdecimal200.38

Client

PropertyDescriptionTypeExample
EntityIdstring
StateClientState
ClientNumberstring
CurrencyCurrency this client deals in (inherited from Entity)string
TaxCodeThe default tax code applicable to this clientstring
RateSetIdstring
OverrideRateSetIdstring
BillingContactIdBilling contact for invoices and financials to be sent tostring
BillingBasisMethod by which billing is done on this matterBillingBasis?
BillingChannelHow does the client like to receive invoices?ContactChannel
MarketingChannelWhich marketing channel did this client come throughstring
IntroducerIdThe employee who introduced this client to the firmstring
ReferrerIdDetails about the external source that referred this client to the firmReferrerDetails?
Notesstring
AutoGenerateStatementsWhether to automatically email the Statement of Account to the client based on the configured schedulebooltrue, false

ClientState

PropertyDescriptionValue
DraftIn the process of creating0
ActiveIdentity verified1
HeldNo work can be done for this client2
ClosingIn the process of being closed3
ClosedNo longer acting4

CmaAccount

PropertyDescriptionTypeExample
DisplayNameUser friendly account namestring
MatterIdThe matter this CMA or investment account belongs tostring
AccountTypeControlled Money, or InvestmentCmaAccountType
DescriptionAdditional info regarding this CMA or investment accountstring
StateCmaAccountState
CurrencyCurrency of this bank accountstring
Balancedecimal200.38
BankAccountBank account addressing detailsBankAccountDetails
MaturesOnDateTime?2025-01-12T00:00:00
DateOpenedDateTime?2025-01-12T00:00:00
InterestPayableFromInterest payable from this dateDateTime?2025-01-12T00:00:00
Durationint?
DurationUnitUnit of measurement for the durationCmaDurationUnit?
InterestPayablePeriodCmaInterestPayablePeriod?
InterestRateDecimal representation of the interest rate, e.g. 5% should be 0.05decimal?200.38
ExpiryActionCmaExpiryAction?
TaxFileNumberATO tax file numberstring
BeneficiariesFree form description of the beneficiariesstring
InitialInvestmentThe initial amount investeddecimal200.38
LastStatementSentOnKeeps track of when the last statement was sent, used for regulatory complianceDateTimeOffset?

CmaAccountState

PropertyDescriptionValue
OpenOpen0
ClosedClosed1

CmaAccountType

PropertyDescriptionValue
ControlledMoneyControlled Money0
InvestmentInvestment1

CmaDurationUnit

PropertyDescriptionValue
DaysDays0
WeeksWeeks2
MonthsMonths2
YearsYears3

CmaExpiryAction

PropertyDescriptionValue
TerminateTerminate0
ReinvestReinvest1

CmaInterestPayablePeriod

PropertyDescriptionValue
OnMaturityOnMaturity0
MonthlyMonthly1
YearlyYearly2

CmaPaymentMethodDetail

PropertyDescriptionTypeExample
TypeCmaPaymentMethodType
OwnerIdstring
CmaTransactionIdstring
PaymentMethodIdstring?
PaymentMethodTypePaymentMethodType?
GeneralDetailsstring?

CmaPaymentMethodType

PropertyDescriptionValue
Receipt0
Payment1

CmaTransaction

Within the context of a CMA account, a transaction

PropertyDescriptionTypeExample
AccountIdThe CMA account this transaction belongs tostring
DateWhen was the transaction entered in to the system.DateTime2025-01-12T00:00:00
OriginalDateWhen did the transaction take placeDateTime2025-01-12T00:00:00
RequestedOnApplicable for payments only, the day it was requestedDateTimeOffset?
OtherJournalIdThe journal id of the cash account money was transferred to/from, required when OtherAccountId is specifiedstring
OtherAccountIdThe cash account money was transferred to/from, mutually exclusive with OtherEntityIdstring
OtherAccountNameThe trust cash account’s namestring
OtherEntityIdThe entity money was sent to, or received from, mutually exclusive with OtherAccountIdstring
OtherEntityNameOther party’s sort namestring
ReceiptPaymentMethodDetailPayment method details for RECEIPTReceiptPaymentMethodDetail?
PaymentPaymentMethodDetailPayment method details for a PAYMENTPaymentPaymentMethodDetail?
PaymentMethodDetailDescription of the payment method used for reportingstring
IsDebitFalse means receipt, True means paymentbooltrue, false
IsInterestTrue means crediting interest, false means any other transactionsbooltrue, false
Reasonstring
Memostring
ReferenceReference number issued by the firmstring
AmountAmount in both base and foreign currencydecimal200.38
AuthorisedByAuthorised by employee idstring
StateCmaTransactionState
ReversesIdThe Id of the transaction that this transaction reversesstring
IsReversedIndicates if this is a reversed or a reversal transactionBoolean
ReversalIdIf this transaction has been reversed, the ReversalIdstring

CmaTransactionState

PropertyDescriptionValue
PaymentRequestedCMA payment requested0
PaymentApprovedCMA payment approved1
PaymentCancelledCMA payment cancelled2
PostedPosted3
ReversedReversed4

ContactChannel

PropertyDescriptionValue
Email0
Post1
SMS2
Phone3

CustomFieldDetails

Values for custom fields to be included in the migration

PropertyDescriptionTypeExample
NameName of the field to be importedstring
TypeType of the field being importedType?
ValueValue of the imported fieldstring

Disbursement

Matter expenses

PropertyDescriptionTypeExample
TypeDisbursementType
CodeCode used to classify this disbursement internal to the firm (e.g. scan, print)string
DateThe date the disbursement incurred, anticipated, or posting date in the case of cost recoveryDateTime2025-01-12T00:00:00
ReferenceFirm-issued reference numberstring
SupplierReferenceSupplier-issued reference numberstring
Descriptionstring
MatterIdThe matter this disbursement belongs tostring
SupplierIdThe supplier this disbursement is to be paid to. Only required for Anticipated and Incurred disbursementsstring
PurchaseIdApplicable to ADs, if linked to a purchase, the purchase id. Note it is not necessary for AD to link to a payment transaction if it is directly paid, as even directly paid disbursements have a purchase.string
BillingAmountAmount of the disbursement (ex tax), in matter currency.decimal?200.38
BillingAmountBaseAmount of the disbursement (ex tax), in firm currency. Leave null if matter currency is same as firm currency.decimal?200.38
BillingTaxCodeThe tax code to use to bill to the clientstring
BillingTaxTax of the disbursement as charged to the client, in matter currencydecimal200.38
BillingTaxBaseTax of the disbursement as charged to the client, in firm currency. Leave null if matter currency is same as firm currency.decimal?200.38
IsBilledWhether this disbursement has been billed to the client yetbooltrue, false
AmountAmount of the disbursement (ex tax), in supplier currency.decimal200.38
AmountBaseAmount of the disbursement (ex tax), in firm currency. Leave null if supplier currency is same as firm currency.decimal?200.38
TaxCodeTax code as specified by the supplierstring
TaxTax of the disbursement as charged by the supplier, in supplier currencydecimal200.38
TaxBaseTax of the disbursement as charged by the supplier, in firm currency. Leave null if supplier currency is same as firm currency.decimal?200.38
CurrencyCurrency the supplier deals instring
ClientBalanceAmountThe remaining amount that the law firm has left to bill the client for, in client and firm currency. Note as soon as it is included in a draft bill, this amount is reduced.decimal200.38
ClientBalanceTaxThe remaining tax that the law firm has left to bill the client for, in client and firm currency. Note as soon as it is included in a draft bill, this amount is reduced.decimal200.38
SupplierBalanceAmountHow much does the firm owe the supplier (ex tax) taking into consideration creditor balance, in supplier currency.decimal200.38
SupplierBalanceTaxHow much tax does the firm owe the supplier taking into consideration creditor balance, in supplier currencydecimal200.38
SupplierBalanceAmountBaseHow much does the firm owe the supplier (ex tax) taking into consideration creditor balance, in firm currency. Leave null if supplier currency is same as firm currency.decimal?200.38
SupplierBalanceTaxBaseHow much tax does the firm owe the supplier taking into consideration creditor balance, in firm currency. Leave null if supplier currency is same as firm currency.decimal?200.38
UTBMSExpenseCodeLEDES disbursement codestring
IsBillableWhether this disbursement will be billable or not (affects whether it will be added to an invoice or not) - default truebooltrue, false

DisbursementCode

Allow a fee work item to be associated with task type for pre-filling and reporting

PropertyDescriptionTypeExample
NameDisplay name of the disbursement codestring
CodeCode used by firm to identify this disbursment templatestring
DescriptionAs it will appear on invoices issued to the clientstring
TypeCost Recovery, Incurred, and AnticipatedDisbursementType
TaxCodeSupplier tax codeString?
BillableWhether or not the disbursement is billable by defaultbooltrue, false
UTBMSExpenseCodeLEDES disbursement code if applicableString?
RateApplicable for cost recovery only, in firm currencydecimal?200.38
SupplierIdIf specified, pre-fills the supplier when creating a disbursementString?
AmountApplicable only to incurred disbursements. Amount (ex tax) in supplier currency, whatever that may bedecimal?200.38
IncurredTypeType of Incurred Disbursement Code, not applicable to other types.IncurredType

DisbursementType

PropertyDescriptionValue
CostRecoveryRecovering office expenses0
AnticipatedAnticipated disbursement, no invoice from supplier, no payment to supplier, but want to create it for billing1
IncurredImmediately paid out of the bank already2

Division

This represents a division

PropertyDescriptionTypeExample
Namestring
OfficeJournalIdstring
TrustJournalIdstring

EmailDeliveryOption

PropertyDescriptionValue
ActingPersonThe acting person on the matter0
ResponsiblePersonThe responsible person on the matter1
ClientThe client2
BillingContactThe billing contact person on the matter3
SpecificEmailManunally specified email address4

Employee

PropertyDescriptionTypeExample
EntityIdstring
TeamIdThe team the employee belongs to. Teams are hierarchical - top level teams may map to practice groupsstring
JobTitleIdJob title as assigned by the law firm. This is distinct to job title identification shared between the client and the firm - they may be client/matter specificstring
BillingGradeIdBilling grade categorises employees for the purposes of setting up billing rates.string
EmployeeNumberFirm-issued identifier for this employeestring
NominalCostPerHourUsed for profitability analysis, in base currencydecimal200.38
Notesstring
EmailEmail address from the entity recordstring
StateEmployeeState

EmployeeState

PropertyDescriptionValue
ActiveHas access to the system0
InactiveDoes not have access to the system1
DraftIn the process of creating2

Entity

PropertyDescriptionTypeExample
EmployeeIdstring
SupplierIdstring
ClientIdstring
EntityTypeEntityType
StateEntityState
IsVerified(AML) Whether this entity has been verifiedbooltrue, false
VerifiedDate(AML) Date when the entity was verifiedDateTime?2025-01-12T00:00:00
CurrencyCurrency this entity deals in. If not specified, the base currency is assumedstring?GBP , AUD
Salutatione.g. ‘To whom it may concern’, ‘Dear Mr Smith’string
FirstNamestring
MiddleNamesstring
LastNamestring
Initialsstring
OrganisationNamestring
OrganisationNumberCompany identifier, e.g. ABNstring
OrganisationNumber2Secondary company identifier, e.g. ACNstring
OrganisationTypee.g. Joint Party, Company, Unlimited Liability Companystring
OrganisationContactThe point of contact of an organisation, e.g. Office Manager, The Owner, The Secretarystring
PreferredNameNickname which the person/company prefers to be identified by colloquially, e.g. Bob.string
Titlestring
EntityNumberUnique identifier for this entity issued by the firmstring
EmailPrimary email of this entity. Email is the most commonly used method of communication, so it gets its special place at this level.string
AddressesIList<Address>
NumbersPhone/Fax and other numbersIList<Number>
BankAccountBank accountBankAccountDetails
CanLoginCan this user log in when it is determined to be a user (i.e. even if this entity is a user, they may not be able to log in, e.g. an ex-employee).bool?true, false
RoleIdsIf this entity is determined to be a user, the role it will haveIList<string>?
GroupMembersIf this entity is a group, then this lists the EntityIds of the members of this groupIList<string>?
CustomFieldsNot Supported Yet A list of all the additional fields we do not support in standard migrationsIList<CustomFieldDetails>?
AssociationsIList<Association>

EntityState

PropertyDescriptionValue
UnverifiedIdentity not verified (e.g. AML)0
VerifiedIdentity verified1

EntityType

PropertyDescriptionValue
Individual0
Organisation1
Group2

GeneralDetail

PropertyDescriptionTypeExample
Detailsstring

HistoricalTransaction

Represents a historical general ledger or ledger transaction

PropertyDescriptionTypeExample
TypeFor office journals, specify Posting or Both to import journal entries and optionally ledger entries. For trust journals, this must be Ledger.HistoricalTransactionType
TransactionTypeTransactionType
JournalIdstring
JournalTypeSpecify the type of journal this transaction will be written intoJournalType
AccountIdRequired when Type is ‘Ledger’, specifies the Historical Balancing account to post the ledger entry against. For trust ledger entries, this must specify the bank account.string
ReferenceIdentifier used by the user to uniquely identify this transaction, e.g. journal referencestring
OtherPartyIdEntity id of the other party if there is an associated entitystring
OtherPartyNamestring
OtherPartyAddressTogether with name, uniquely identifies the other partystring
Reasonstring
DatePosting Date of the transactionDateTime2025-01-12T00:00:00
OriginalDateDateTime2025-01-12T00:00:00
EnteredOnCaptures the date that the transaction was recorded into the database. Used for trust compliance reporting, if null the Posting Date will be usedDateTimeOffset?
AmountWhen Type is Ledger, receipts are positive. Otherwise, it is the sum of Splits with positive amount (i.e. debits)decimal200.38
PaymentPaymentMethodWhen this transaction is a Payment, the payment detailsPaymentPaymentMethodDetail?
ReceiptPaymentMethodWhen this transaction is a Receipt, the receipt detailsReceiptPaymentMethodDetail?
Memostring?
IsReconciledIndicate if it has been reconciled. Applicable to cashbook entry only.booltrue, false
ClearanceDateOptionally specify when this receipt will be cleared. Applicable to cashbook entry only.DateTime?2025-01-12T00:00:00
SplitsIList<HistoricalTransactionSplit>

HistoricalTransactionSplit

This is part of a HistoricalTransaction

PropertyDescriptionTypeExample
AccountIdSpecify only if item is related to a GL code, and not a matter or supplierstring?
MatterIdSpecify only if item is related to a matter, mutually exclusive with AccountId and SupplierId.string?
SupplierIdSpecify only if item is related to a supplier, and not a matter or supplierstring?
InvoiceIdSpecify only if item is related to a client invoice, and must be supplied with MatterId.string?
LedgerTypeIf specified, this is a ledger entryLedgerType?
Memostring
AmountDebit positive,decimal200.38
Taxdecimal200.38
TaxCodestring
TaxTypeSpecifies the tax is input or output taxTaxAppliesTo

HistoricalTransactionType

PropertyDescriptionValue
PostingGeneral ledger posting with journal entries only0
LedgerLedger entries only on matter trust or office, or supplier1
BothGeneral ledger posting with associated ledger entries2

IncurredType

PropertyDescriptionValue
PurchaseReceived an invoice from the supplier0
PaymentWill be paid out of the bank immediately when created1

Invoice

Only outstanding invoices are supported

PropertyDescriptionTypeExample
MatterIdstring
MatterNumberstring
MatterTitlestring
ClientEntityIdSaves a lookup for many UI widgets that needs to open the entity card, like the billing widget. Consider doing this on the UI side?string
ActingPersonIdstring
ResponsiblePersonIdstring
ClientIdstring
InvoiceNumberstring
InvoiceDateDateTime2025-01-12T00:00:00
DueDateDateTime2025-01-12T00:00:00
SentDateThe date the invoice was sent to the customerDateTime?2025-01-12T00:00:00
CurrencyInvoice currency as shown to the recipient. If not specified, assumes base currency. Must be the same as matter currencystring
ExchangeRateExchange rate used to take base currency to transaction currency (i.e. Amount = ExchangeRate * AmountB or AmountB = Amount / ExchangeRate). It is used to calculate base value of fees line items, not disbursements, which is fixed to the exchange rate on creation.decimal200.38
ApprovedForReceiptAllow a trust-to-office transfer to take place automaticallybooltrue, false
TemplateIdThe invoice template applied, or null if using defaultstring
BillToEntityIdThe entity the invoice is addressed tostring
AttentionOf[Optional] Who to attention the invoice tostring
BillingAddressAddress of the entity to billstring
TitleDescription of the invoice, e.g. Fees and Disbursements for Januarystring
CommentsInternal notes on the invoicestring
RetainedAmountWhen queried, all non-released allotments against this invoice are summed. It may be freely changed until finalised, when a single allotment will be created/consolidated.decimal?200.38
TotalAmountThe total amount in matter currency (excluding tax)decimal200.38
TotalTaxThe total tax in matter currencydecimal200.38
TotalAmountBaseThe total amount in base currency if different (excluding tax)decimal?200.38
TotalTaxBaseThe total tax in base currency if differentdecimal?200.38
BalanceHow much left for client to pay (inclusive of tax)decimal200.38
BalanceBaseHow much left for client to pay in base currency if different (inclusive of tax)decimal200.38
ItemsIList<InvoiceItem>
AllocationsNot Supported Yet Not currently supportedIList<InvoiceAllocation>

InvoiceAllocation

Not currently supported

PropertyDescriptionTypeExample
DateDate the receipt was allocated or write off was datedDateTime2025-01-12T00:00:00
TransactionIdThe transaction id that caused this allocation, e.g. ReceiptPosted, InvoiceCreditedstring
TypeInvoiceAllocationType
ItemTypeInvoiceItemType
AccountIdstring
AmountThe amount allocated, exclusive of tax. Original invoice exchange ratedecimal200.38
TaxThe tax allocateddecimal200.38
TaxCodeNeed to populate this for cash-basis accountingstring

InvoiceAllocationType

PropertyDescriptionValue
CollectionRegular receipt0
WriteOffWrite-off, loss caused by client1
ClientPaymentWhen client makes a direct payment to third party, reducing invoice balance2
CreditNoteLoss caused by the firm3

InvoiceItem

PropertyDescriptionTypeExample
InvoiceIdstring
ParentInvoiceItemIdstring
TypeInvoiceItemType
DisbursementId(Only use if this item is a billed, unpaid anticipated disbursement) Supplier who billed this itemstring
DateThe date when the invoice item was originally actionedDateTime2025-01-12T00:00:00
TitleOne-liner describing what the line item isstring
DescriptionLengthy description of what the line item isstring
BillerIdEmployee who billed this line itemstring
UnitsNumber of unitsdecimal200.38
UnitPriceUnit price of each unit, in invoice currencydecimal200.38
OriginalAmountSplitThe original amount after this invoice was splitdecimal200.38
BillingUnitsOverridden billing units for the line item, for display purposesdecimal?200.38
BillingUnitPriceOverridden billing units price for the line item, for display purposes, in invoice currencydecimal?200.38
BillingAmountOverridden line total in invoice currency, overrides Amount, and may be specified when BillingUnits or BillingUnitPrice is not specifieddecimal?200.38
AmountLine total in invoice currency, unrounded, exclusive of tax. It must be equal to Units * UnitPricedecimal200.38
TaxTax in invoice currency, unrounded, based on BillingTotal if specified, or Units*UnitPrice. Usually calculated based on TaxCode and not to be specified as input.decimal200.38
TaxCodeThe tax code applicable to this itemstring
SortOrderThe order in which the invoice items should appear in the invoice reportint?

InvoiceItemType

PropertyDescriptionValue
GroupHeaderGroup header th at includes other child items0
FeesPost to fees. If negative, it’s a discount1
CostRecoveryPost to cost recovery2
DisbursementPost to disbursement3
AnticipatedDisbursementPost to anticipated disbursement4
AccountPost to the specified account5
DiscountDiscount applied to the invoice6

JobTitle

PropertyDescriptionTypeExample
Namestring

Journal

This represents a journal

PropertyDescriptionTypeExample
Namestring
TypeJournalType
IsDefaultbooltrue, false
AccountsIList<Account>

JournalType

PropertyDescriptionValue
OfficeOffice journal
TrustTrust (Client) journal
OtherOther Journal, such as Controlled Money or Client Deposit if separate

LedgerBalance

Opening balances for a Matter or Supplier

PropertyDescriptionTypeExample
TypeLedgerOwnerType
OwnerIdThe Matter or Supplier ImportId that this balance belongs tostring
AccountIDThe Account Id that this balance belongs tostring
Balancedecimal200.38

LedgerOwnerType

PropertyDescriptionValue
MatterOfficeMatter Office Balance0
MatterTrustMatter Trust/Client Balance1
SupplierSupplier Balance2

LedgerType

PropertyDescriptionValue
Office0
Trust1
Supplier2
Other3

Matter

PropertyDescriptionTypeExample
StateMatterState
AclIdACL Identifier to control the access permissions to this matterstring
DivisionIdstring
ClientIdstring
OfficeLedgerIdThe one and only office ledger, where F is always in client currency if different to base currencystring
ResponsiblePersonIdstring
ActingPersonIdstring
AssistingPersonIdstring
IntroducerIdThe employee who introduced this matter to the firmstring
ReferrerIdDetails about the external source that referred this client to the firmReferrerDetails?
MatterTypeIdMatter typestring
MatterNumberUser facing unique identifier for the matterstring
TitleOne-line description of the matterstring
SortTitleShorter title used for display and sortingstring
DateOpenedThe date on which the matter was opened.DateTime?2025-01-12T00:00:00
DateClosedThe date on which the matter was closed.DateTime?2025-01-12T00:00:00
BillingContactIdstring
InvoiceEmailCCA comma separated list of emails to also send any invoices to.string
ExchangeRateIf the matter currency is different from the firm’s base currency, the exchange rate to convert firm currency to matter currency. If not specified, uses the spot rate from the data provider.decimal?200.38
RateSetIdSpecifies which set of rates to look up when entering work itemsstring
OverrideRateSetIdOverrides which set of rates to look up when entering work itemsstring
BillingBasisMethod by which billing is done on this matterBillingBasis?
MarkedForBillingFlag to indicate this matter is ready for billingbooltrue, false
ProtectedTrustAmountReserved Amount in Trust Account for special purposes.decimal200.38
AutoGenerateStatementsWhether to generate statements for the matter and send them to the client automatically.booltrue, false
FeeEstimateEstimated fee target for the matter. The firm needs to talk to the client if the fees are going to exceed this amount.decimal?200.38
DisbursementEstimateEstimated disbursement target for the matter. The firm needs to talk to the client if the disbursements are going to exceed this amount.decimal?200.38
LastTrustStatementIssuedWhen the last trust statement of the matter issued.DateTimeOffset?
LastCmaStatementIssuedWhen the last controlled money statement of the matter issued.DateTimeOffset?
LastInvStatementIssuedWhen the last investment statement of the matter issued.DateTimeOffset?
CreditNoteBalanceValue of non-cash credit note balance on the matter. A positive value means the client has a credit note balance.decimal200.38
OfficeFundsBalanceValue of cash credit funds balance on the matter’s office ledger. A positive value means the client has funds (i.e. the firm owes the client money).decimal200.38
TrustFundsBalanceValue of trust funds balance on the matter, by each bank account. A positive value means the client has funds (i.e. the firm owes the client money). Note: Adjust this amount to remove unreconciled receipts and payments if they are to be imported separately as itemised entries to avoid duplication.Map
PartiesA list of entities related to the matter and their relationship/roleIList<Party>
ClientRoleThe role that the client plays in the matter (e.g. Defendant, Plaintiff, Agency)string
DateArchivedDateTime?2025-01-12T00:00:00
DateDestroyedDateTime?2025-01-12T00:00:00
StorageLocationstring
ArchiveNumberstring
BoxNumberstring
ArchivedByIdstring
DestroyedByIdstring
CustomFieldsA list of all the additional fields we do not support in standard migrationsIList<CustomFieldDetails>?

MatterState

PropertyDescriptionValue
DraftIn the process of being opened, i.e. running through a todo list0
ActiveActive1
OnHoldOn Hold, no work to be done on it2
Closing3
Closed4

MatterType

Matter types

PropertyDescriptionTypeExample
Namestring
Descriptionstring

Number

PropertyDescriptionTypeExample
TypeNumberType
NameOptional name to identify this number, e.g. Spouse Work, which gives more information about the number type.string
NotesOptional additional information on how this contact should be used, e.g. only call after hours, or do not discuss confidential details, etc.string
ValueThe number itselfstring
Defaultbooltrue, false

NumberType

PropertyDescriptionValue
HomeHome0
MobileMobile1
WorkWork2
EmailEmail3
FaxFax4
OtherOther5

Party

The role that entities play on a matter (e.g. Solicitor, Guarantor, Director)

PropertyDescriptionTypeExample
RoleThe name of the role (e.g. Solicitor, Guarantor, Director).string
ReferenceReference to use for correspondence with this partystring
SubjectDescription of the matterstring
MemoInternal notes about the entitystring
EntityIdThe entity playing this role in the matterstring
TypeHow this entity is associated with the matter (e.g. Representative, Party)PartyType

PartyType

PropertyDescriptionValue
Representative0
Party1

PaymentChequeDetail

PropertyDescriptionTypeExample
PaidTostring
Numberstring
IssueDateDateTime?2025-01-12T00:00:00
Branchstring
Institutionstring

PaymentCreditCardDetail

PropertyDescriptionTypeExample
CardHolderstring
Typestring
Namestring

PaymentEFTDetail

PropertyDescriptionTypeExample
BankAccountBankAccountDetails
Referencestring
SequenceNumberstring
BankReferencestring
IncludeInABAbooltrue, false

PaymentMethodType

PropertyDescriptionValue
General0
Cheque1
EFT2
CreditCardCredit Card3
Cash4

PaymentPaymentMethodDetail

PropertyDescriptionTypeExample
PaymentMethodIdstring
GeneralGeneralDetail
ChequePaymentChequeDetail
CashCashDetail
EFTPaymentEFTDetail
CreditCardPaymentCreditCardDetail
TypePaymentMethodType

Purchase

Represents unpaid purchase order and supplier invoices

PropertyDescriptionTypeExample
JournalIdstring
PurchaseNumberThe identifying number issued by the firm, to allow supplier to refer to this purchase (this is auto-generated from the PurchaseSequenceId in the Journal)string
InvoiceNumberSupplier’s invoice number for this purchase, to allow the firm to refer to this purchase when communicating with the supplier.string
PaymentReferenceSupplier-issued payment reference number to include in a payment (e.g. EFT), so the recipient can identify it in their system.string
DateDate to use for posting to Journals and LedgersDateTime?2025-01-12T00:00:00
DueDateDate the purchase is dueDateTime?2025-01-12T00:00:00
OriginalDateAs shown on supplier invoiceDateTime?2025-01-12T00:00:00
SupplierIdThe supplier this purchase is made fromstring
CurrencyPurchase currency as received from the supplier. If not specified, assumes base currency. Must be the same as the supplier’s currencystring
ExchangeRateExchange rate used to take base currency to transaction currency (i.e. Amount = ExchangeRate * AmountB or AmountB = Amount / ExchangeRate)decimal200.38
SupplierCommentsComments sent to the supplier when the purchase is approved to help them fulfil this order.string
TotalAmountThe total amount in supplier currency (exclusive of tax)decimal200.38
TotalTaxThe total tax in supplier currencydecimal200.38
BalanceHow much left to pay the supplier (inclusive of tax)decimal200.38
TotalAmountBaseThe total amount in base currency if different (exclusive of tax)decimal?200.38
TotalTaxBaseThe total tax in base currency if differentdecimal?200.38
BalanceBaseHow much left to pay the supplier (inclusive of tax) in base currency if differentdecimal?200.38
DescriptionAdditional details about the supplier invoice. This will be added to the transaction description when postedstring
ItemsIList<PurchaseItem>

PurchaseItem

Every purchase, creditor or payment alike, has one or more item specifying how it is classified/allocated

PropertyDescriptionTypeExample
PurchaseIdstring
TypeWhat type of line item this is, e.g. disbursement, account, purchase, matter credits, matter fundsPurchaseItemType
DisbursementIdApplicable only if PurchaseItemType is Anticipated Disbursementstring
AccountIdThe general ledger account this line item posts to, required only for PurchaseItemType of Account, ignored in all other casesstring
ReferenceA user-friendly unique identifier for this line itemstring
TitleOne-liner describing what the line item isstring
DescriptionLengthy description of what the line item isstring
AmountAmount in supplier currency, exclusive of taxdecimal200.38
TaxTax in supplier currencydecimal200.38
AmountBaseAmount in firm currency, exclusive of tax. Only required if supplier currency is different from firm currencydecimal?200.38
TaxBaseTax in firm currency. Only required if supplier currency is different from firm currencydecimal200.38
TaxCodeThe supply tax code applicable to this itemstring

PurchaseItemType

PropertyDescriptionValue
AccountIf it is related to a general ledger account code only, and not a disbursement0
DisbursementIf it is related to a disbursement; ensure MatterId is specified, This will result in a new Incurred Disbursement being created1
AnticipatedDisbursementIf it is related to a anticipated disbursement; ensure DisbursementId is specified2

ReceiptChequeDetail

PropertyDescriptionTypeExample
Numberstring
Drawerstring
Branchstring
Institutionstring
IssuedOnDateDateTime?2025-01-12T00:00:00
ClearsOnDateDateTime?2025-01-12T00:00:00
Memostring

ReceiptCreditCardDetail

PropertyDescriptionTypeExample
CardHolderNamestring
Typestring

ReceiptEFTDetail

PropertyDescriptionTypeExample
Referencestring

ReceiptPaymentMethodDetail

PropertyDescriptionTypeExample
PaymentMethodIdstring
GeneralGeneralDetail
ChequeReceiptChequeDetail
CashCashDetail
EFTReceiptEFTDetail
CreditCardReceiptCreditCardDetail
TypePaymentMethodType

ReferrerDetails

Details about the external referrer

PropertyDescriptionTypeExample
NameThe name of the referrer for reporting purposes. If EntityId is specified, then the entity’s sort name will be used instead.string?
EntityIdOptional if ReferrerName is specified.string?
SourceOptional description of the referrer source, such as Walk-in, Google, Facebook, Directory/Contact.string?

Supplier

PropertyDescriptionTypeExample
EntityIdstring
StateSupplierState
SupplierNumberstring
BillingContactIdBilling contact for purchase orders and billing enquiries to be sent tostring
DefaultPaymentTermNumber of days from supplier invoice date the supplier invoice will fall due by default.int?
RecogniseTaxOnPaymentSpecifies that purchases to this supplier posts to AccountRole.TaxSuspense rather than AccountRole.TaxPaid.booltrue, false
TaxCodeThe tax code applicable to this supplierstring
DebitNotesBalancesNot Supported Yet Amount of supplier non-cash credits available, in supplier currency by journalDictionary<string, decimal>
DebitFundsBalancesNot Supported Yet Amount of supplier pre-payment available, in supplier currency by journalDictionary<string, decimal>
Notesstring

SupplierState

PropertyDescriptionValue
DraftIn the process of creating0
ActiveNormal Supplier1
HeldNo work can be done with this supplier2
ClosingIn the process of being closed3
ClosedNo longer transacting with4

TaskType

PropertyDescriptionTypeExample
NameDescriptive title to help user choose the correct task type to usestring
CodeShort identifier of this task type used only in reportsstring
ItemisedWhen true, and chosen for a work item, pre-select it as an itemised feebooltrue, false
BillableWhen true, and chosen for a work item, pre-selects the work item as non-billablebooltrue, false
NarrationPre-populate the narration on work itemstring
DescriptionDetailed explanation of this task type, what it is, when it should be usedstring
ShortcutKey sequence to trigger text expansion to select this task typestring
UTBMSTaskCodestring
UTBMSActivityCodestring

TaxAppliesTo

PropertyDescriptionValue
NoneTax is not applicable0
SalesSales (will go to Tax Collected account)1
PurchasesPurchase (will go to Tax Paid account)2

Team

PropertyDescriptionTypeExample
Namestring

TransactionType

PropertyDescriptionValue
GeneralGeneral ledger transaction posting0
ReceiptReceipt1
PaymentPayment2

WorkItem

PropertyDescriptionTypeExample
TitleTitle as it will appear by default on invoicestring
ItemTypeTimed, Itemised, or LeaveWorkItemType
FileNoteFile note taken against this work itemstring
TaskTypeIdType of work referencestring
EmployeeIdEmployee who did the work, aka Fee Earnerstring
EmployeeTeamIdTeam to attribute this time entry to, defaults to fee-earner’s team at the time of entrystring
MatterIdThe matter the work is for, can be null if work item is in draftstring
BillingStageIdIf this work item is related to a billing stagestring
InvoiceIdIf this work item is included on an invoice, the invoice idstring
EntryDateWhen was the work doneDateTimeOffset
DurationTicksDuration of work done in ticks (100 nanoseconds), only applicable for Timed work itemslong?
UnitsNumber of units. For timed work items (if not specified), this is derived from DurationTicks and the minutes per unit setting. For itemised work items, this is specified directly.decimal?200.38
RateRate per unit (Itemised) or hours (Timed) in client currency. This is exclusive of tax.decimal?200.38
TotalFxAmount to provide a base currency for standardised management reportingdecimal?200.38
TaxCodeThe tax code applicable to this itemstring
TaxTax amount based on the Total if specified, or Units * Rate (Itemised). Usually calculated based on TaxCode and not to be specified as input.decimal?200.38
StateWorkItemState
WorkItemParts[Internal] Breakdown of this work item into multiple partsList<WorkItemPart>?

WorkItemPart

PropertyDescriptionTypeExample
Unitsdecimal?200.38
DurationTickslong?
Narrationstring
SumToParentbooltrue, false

WorkItemState

PropertyDescriptionValue
PendingIncomplete0
FinalisedReady for billing1
DraftedIncluded on a draft or pending invoice2
BilledMade its way to a finalised invoice3
WrittenOffProfessional service in nature, but the firm absorbs the cost4
NonBillableAdministrative or non-professional service in nature, such as internal training5

WorkItemType

PropertyDescriptionValue
TimedFeeTimed Fee0
ItemisedFeeItemised Fee1
LeaveLeave2