Business Categorization
Now that you've connected your data sources with Hurdlr's Expense Tracking API, you're ready to start leveraging all of the Expense Tracking features that Hurdlr has to offer, including Business & Tax Categorization.
1. How it works
Through Hurdlr's Plaid or MX integration, your user's transactions are pulled into Hurdlr as soon as Plaid makes them available. All of those transactions are then run through Hurdlr's proprietary algorithms, which leverage the user's business type, accountant best practices, and the behavior of similar businesses within the Hurdlr API's 1.3M+ users. The expense transactions are then categorized in three primary ways:
a) Business Categories: Hurdlr uses categories specific to the user's business, which a non-accountant business owner can understand. For example, an Uber driver's expense might be categorized as "Car Wash".
b) Tax Categories: All expenses are also mapped to a tax category, which an accountant can easily understand. Transactions are also mapped to specific line items on the 1040 Schedule C, 1065, 1120S, and 1120.
c) Personal Categories: Hurdlr also assigns a personal category (e.g. "Pets", "Childcare") to each expense, to handle scenarios where a business owner might accidentally charge a personal expense to a business account.
2. Displaying the user's expenses and allowing them to make edits
You can easily allow your users to view their expenses and make quick edits to categories, including the ability to split across multiple categories (e.g. for an Amazon order), by rendering Hurdlr Embedded's Expense Dashboard.
3. Programmatically getting the user's expenses
If you are building your own user experience or want to perform programmatic processing on a user's expenses, you can retrieve those expenses from the Hurdlr API.
On each expense, you may find the following attributes to be of particular interest:
Field | Description | Format |
---|---|---|
id | Id of the expense record | Numeric |
type | Type of expense | Must be one of the following: "PENDING", "BUSINESS", "NOT_BUSINESS" |
date | Date that the expense was incurred | yyyy-MM-dd'T'HH:mm:ss.SSSZ |
amount | Total value of the expense | Numeric, with 2 decimal places |
categoryId | Id of the associated business expense category | Numeric |
personalCategoryId | Id of the associated personal expense category | Numeric |
confidence | Deduction confidence of the expense transaction | Must be one of the following: "LIKELY", "UNLIKELY", "QUESTIONABLE" |
vendorName | Name of the vendor that the expense was incurred with | Any string |
vendorId | Id of the associated vendor | Numeric |
businessId | Id of the business that this was assigned to; only populated if type == "BUSINESS | Numeric |
clientId | Id of the client that this was assigned to; optional, only populated if type == "BUSINESS | Numeric |
lastUpdatedDate | The last date/time that this record was modified | yyyy-MM-dd'T'HH:mm:ss.SSSZ |
Additionally, several attributes to help you or your user identify a bank transaction are listed below:
Field | Description | Format |
---|---|---|
apiInstitutionId | Id of the institution that the transaction originated from | Any string |
apiAccountName | Display name for the user's bank account | Any string |
apiAccountNo | Mask of the user's bank account, often the last 4 digits of the account number | 2-4 Alphanumeric characters |
plaidItemAccountId | Id of the bank account that this transaction originated from (within Hurdlr's API) | Numeric |
apiName | Name of the API that this transaction originated from | Will always be "PLAID", unless you are utilizing one of Hurdlr's other direct integrations |
apiExpenseId | Id of the transaction record in Plaid's API | Any string |
bankDescription | Transaction description (similar to what will show on the user's bank statement) | Any string |
4. Identifying a transaction's business categorization
On each expense transaction, you will see a categoryId
field, which maps to one of Hurdlr's business-specific expense categories. To pull a user's business expense categories, you can make the following GET call. Be sure to include that user's access_token in the headers.
curl \
--request GET \
--url https://sandbox.hurdlr.com/rest/v5/expenses/categories?lastUpdatedDate=1970-01-01 \
--header 'Authorization: Bearer ${access_token}' \
--header 'Content-Type: application/json' \
The response from GET /expenseCategories contains an array of the user's expense categories:
{
data: [
{
"id": 1,
"name": "Accounting / Tax",
"taxCategory": {
"id": 11,
"name": "LEGAL_AND_PROFESSIONAL_SERVICES",
"displayName": "Legal and Professional Services",
"form1040SchedCLineNumber": "17",
"form1040SchedCDisplayName": "Legal and Professional Services",
"form1065LineNumber": "20",
"form1065DisplayName": "Other deductions (attach statement)",
"form1120SSLineNumber": "19",
"form1120SDisplayName": "Other deductions (attach statement)",
"t2125LineNumber": "8860",
"t2125DisplayName": "Professional fees (includes legal and accounting fees)",
},
"hasChilds": false,
"parentCategoryId": 70,
"status": "ACTIVE",
"lastUpdatedDate": "2021-08-13T22:14:23.000Z"
}
],
"lastUpdatedDate": "2021-08-27T15:37:40.107Z"
}
On each business expense category, you may find the following attributes to be of particular interest:
Field | Description | Format |
---|---|---|
id | Id of the expense category record | Numeric |
name | Name of the business-specific expense category | Any string |
The name of each expense category is specific to the user's business type, which will make sense to a non-accountant business owner. For example, an Uber Driver will have an expense category of "Car Wash". Of course, the Hurdlr API also takes care of mapping that to the proper tax categories, without the user having to think about that.
5. Taking advantage of Hurdlr's learning abilities
Hurdlr's algorithms get smarter over time, automating more and more of your users' actions. Hurdlr's A.I. suggests expense rules for each specific user, which can be easily fetched:
curl \
--request GET \
--url https://sandbox.hurdlr.com/rest/v5/expenses/rules \
--header 'Authorization: Bearer ${access_token}' \
--header 'Content-Type: application/json' \
The response from GET /rules contains an array of the user's expense rules:
{
"data": [
{
"id": 1118497,
"transactionName": "Starbucks",
"matchType": "NON_EXACT_NAME",
"autoClassify": "BUSINESS",
"suggestedStatus": "PENDING",
"categoryId": "13325613",
"personalCategoryId": null,
"vendorId": 237792,
"businessId": 416080,
"lastUpdatedDate": "2021-08-31T22:39:18.000Z"
}
],
"lastUpdatedDate": "2021-10-07T17:45:42.424Z"
}
On each rule, you may find the following attributes to be of particular interest:
Field | Description | Format |
---|---|---|
id | Id of the rule record | Numeric |
transactionName | Name of the transaction to determine whether it matches the rule | Any string |
matchType | Type of matching algorithm applied | Must be one of the following: "EXACT_NAME", "NON_EXACT_NAME" |
autoClassify | Type of auto-classification | Must be one of the following: "OFF", "BUSINESS", "NOT_BUSINESS" |
suggestedStatus | Status of the A.I.-based rule suggestion | Must be one of the following: "PENDING", "ACCEPTED", "DECLINED", "DELETED" |
In order to accept a rule that Hurdlr's algorithms have suggested, simply update the suggestedStatus
to "ACCEPTED":
curl \
--request POST \
--url https://sandbox.hurdlr.com/rest/v5/expenses/rule \
--header 'Authorization: Bearer ${access_token}' \
--header 'Content-Type: application/json' \
--data '{
"rule": {
"id": 1118497,
"suggestedStatus": "ACCEPTED",
},
}'
Now, all of that user's new expense transactions that meet the suggested rule criteria will be automatically classified and accounted for in the user's tax estimates and tax reporting.
Updated about 2 months ago