Expenses
Expenses are used to track expenditures your business incurs.
Columns
| Name | Type | ReadOnly | Description |
| ExpenseId [KEY] | Integer | True |
A unique identifier for the expense, unique to business id. |
| AccountName | String | False |
The name of the related account, if applicable. |
| AccountId | Integer | False |
The identifier of the related account, if applicable. |
| AccountingSystemId | String | False |
The identifier of the system. |
| Amount | Decimal | False |
The amount of the expense. |
| BackgroundJobId | Integer | False |
The identifier of the related background job if applicable. |
| BankName | String | False |
The name of the bank the expense was imported from, if applicable. |
| CategoryId | Integer | False |
The identifier of the related expense category. |
| ClientId | Integer | False |
The Id of the related client, if applicable. |
| Code | String | False |
Three-letter currency code for expense. |
| CompoundedTax | Boolean | False |
Boolean indicated if the tax was a compound tax. |
| Date | Date | False |
Date of the expense. (YYYY-MM-DD) |
| ExtInvoiceId | Integer | False |
The identifier of the related contractor invoice if applicable. |
| ExtSystemId | Integer | False |
The identifier of the related contractor system if applicable. |
| HasReceipt | Boolean | False |
Boolean indicating if there is a receipt attached. |
| InvoiceId | Integer | False |
Identifier of the related invoice, if applicable. |
| IsDuplicate | Boolean | False |
Boolean indicating if this is a duplicated expense. |
| MarkupPercent | String | False |
Note of percent to mark the expense up. (String-decimal) |
| Notes | String | False |
Notes about the expense. |
| ProfileId | Integer | False |
Identifier of related profile, if applicable. |
| ProjectId | Integer | False |
Identifier of related project, if applicable. |
| StaffId | Integer | False |
Identifier of related staff member, if applicable. |
| Status | Integer | False |
Values from expense status table. |
| TaxAmount1 | Decimal | False |
The amount of the first tax. |
| TaxAmount2 | Decimal | False |
The amount of the second tax. |
| TaxName1 | String | False |
Name of first tax. |
| TaxName2 | String | False |
Name of second tax. |
| TaxPercent1 | Decimal | False |
The percent of the first tax. |
| TaxPercent2 | Decimal | False |
The percent of the second tax. |
| TransactionId | Integer | False |
Identifier of related transaction, if applicable. |
| Updated | Datetime | False |
Time the invoice was last updated. (YYYY-MM-DD HH:MM:SS) |
| Vendor | String | False |
Name of vendor. |
| VisState | Integer | False |
0 for active, 1 for deleted. |