Power BI Connector for FreshBooks

Build 20.0.7587

ProfitLossReport

The Profit/Loss Report shows all the information involving both your Profits and Losses.

Columns

Name Type Description
ProfitsAmount Decimal Amount of total profits.
ProfitsCode String Three-letter currency code.
IncomesAmount Decimal Amount of total incomes.
IncomesCode String Three-letter currency code.
ExpensesAmount Decimal Amount of total expenses.
ExpensesCode String Three-letter currency code.
FromDate Date The beginning date of the report.
ToDate Date The ending date of the report.

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
StartDate String the starting date for the expense report query.
EndDate String Will only return invoices that were created before the given date.

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