CData Excel Add-In for FreshBooks 2019 - Online Help
Questions / Feedback?

Expenses

CData Excel Add-In for FreshBooks 2019 - Build 19.0.7354

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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0