# Guide: Using FreshBooks with Databox

## How to connect FreshBooks to Databox

![freshbooks connect](/assets/guide-using-freshbooks-with-databox_1.f3ccb26efabbd00c949e773dbb8b2875f250610d759d8fe0e3d5b5ab6f4567c2.4783b0ec.gif)

To connect a FreshBooks Account in Databox, go to **Data Manager > + New connection.** Type **FreshBooks** in the search bar and click on the green **Connect**button. Next, click the green **Connect now** button.

This will open the  **Authorization** window, which is where you will be prompted to enter your FreshBooks login credentials and authorize the Databox app.

Each FreshBooks Account must be connected as a separate Data Source in Databox (1 Account = 1 Data Source). Learn more [here](/add-a-connection)

## What's the maximum amount of historical data initially available when you use a new FreshBooks Data Source Metric in Databox?

When you connect a new FreshBooks Data Source in Databox, 36 months worth of historical data is initially synced.

Certain Metrics may have more or less historical data available. For more information about the amount of historical data available for a specific Metric, please contact our Support Team at [help@databox.com](mailto:help@databox.com).

In order to start syncing data for a Metric, you can add it to your Metrics screen, use it in a Scorecard, set a Goal around it, create an Alert for it, or add it to a Databoard. Learn more [here](/data-sync-storage-security-in-databox).
The amount of historical data you're able to access in Databox is dependent on your Databox plan. Learn more [here](/choose-a-subscription-plan).

## What time zone does FreshBooks data sync in?

FreshBooks data is synced in the time zone set in the FreshBooks Account. For example, if your FreshBooks Account time zone is set as EST, your FreshBooks data will sync with Databox in EST.

## How often does FreshBooks data sync?

All FreshBooks Data Sources will sync every hour with Databox. Learn more [here](/data-sync-storage-security-in-databox).

## How to access pre-built FreshBooks Templates

![freshbooks template](/assets/guide-using-freshbooks-with-databox_2.5b2e85ef6346af710e99a79fa81cc21445f7c354e7245ce23378121a8ec4a0e5.4783b0ec.gif)

1. Navigate to **Databoards > Public Templates**
2. In the **Data Source** drop-down list, select **FreshBooks**
3. To view a preview of the Template populated with dummy data, click **Preview**
4. To pull the Template into your Account and re-populate it with your own FreshBooks data, click **Use Template**
5. Select the appropriate FreshBooks Data Source from the drop-down list to complete the process. The Databoard will be re-populated with data from the selected FreshBooks Account and can be found on the **Databoards** page.


Once the Databoard is available on the **Databoards** page, it is completely disconnected from the public Template. Therefore, you can further customize this Databoard to meet your specific needs using the [Designer](/overview-designer).

View a full list of FreshBooks Metrics available in Databox [here.](https://app.databox.com/metrics/library/FreshBooks/2959915)

## How to build a Databoard

1. Navigate to  **Databoards** > **+ New Databoard** > **Start Blank**
2. Click on the **Metric Library** icon on the left-hand side of the Designer.
3. Select the appropriate FreshBooks Account from the **Data Source** drop-down list in the **Metric Library.**
4. View the list of pre-built FreshBooks Datablocks in the **Metric Library**. Drag and drop your selected Datablock onto your Databoard.
5. If a pre-built Datablock isn't available for your use case, click on the **Visualization Types** icon under the **Metric Library**icon.
6. View the list of Visualizations available in Databox. Drag and drop your selected Visualization onto your Databoard.
7. Click on the Datablock on the Databoard to open the corresponding **Datablock Editor**on the right-hand side of the Designer.
8. In the **Metrics** drop-down, click  **Data Source** to select the appropriate Data Source. This will filter out metrics from the specific Data Source.
9. In the main **Metrics** drop-down, select the metric you'd like to display on the Datablock, using the Search bar if needed. This will update the Datablock, and it will populate with the corresponding data.
10. Complete steps 4-9 until your Databoard is complete.


## Metric Considerations

Databox extracts direct values from FreshBooks, however for the following metrics special conditions apply:

- Outstanding Invoices: Databox checks all invoices that have an outstanding object in the response, and that it is not empty. The Value has to be larger than 0 and the Paid Amount of the invoices has to be less than the Total Value. The Invoice Status (v3_status) must be one of the Paid, Draft, Auto-paid and Partial.
- Payments Collected: Databox only processes Return Payments because in the FreshBooks API response they are separated from other income.
- Total Payments Collected: Databox processes Income and Payments together. Values of Objects are also summed up.