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

ProfitDetails

CData Excel Add-In for FreshBooks 2019 - Build 19.0.7354

Returns profit & loss details. It is assumed that the currency_code is the same as the base currency code for the system. Invoice amounts in other currencies will be converted.

Columns

Name Type Description
Income Decimal Income earned, two decimal places.
Expenses Decimal Total expenses, two decimal places.
Profit Decimal Net profit, two decimal places.
CurrencyCode String Three-letter currency code.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
DateFrom Datetime Starting date filter.
DateTo Datetime Ending date filter.

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