FreshBooks
Get started with the FreshBooks connector!
Description
FreshBooks is a software company that provides cloud-based accounting software for small and medium-sized businesses.
Connector Details
| Name | Value |
|---|---|
| Platform | FreshBooks |
| Auth Type | OAuth |
| Direction | Read |
Supported Data
See the table below for the list of data you can read with the FreshBooks connector.
| Table Name | Fields |
|---|---|
| accounts | business |
| bills | amount, attachment, bill_number, bill_payments, created_at, currency_code, due_date, due_offset_days, id, issue_date, language, lines, outstanding, overall_category, overall_description, paid, status, tax_amount, total_amount, updated_at, vis_state |
| business_id | business_id |
| clients | accounting_systemid, allow_email_include_pdf, allow_late_fees, allow_late_notifications, bus_phone, company_industry, company_size, currency_code, direct_link_token, email, exceeds_client_limit, fax, fname, has_retainer, home_phone, id, language, last_activity, last_login, level, lname, mob_phone, note, notified, num_logins, organization, p_city, p_code, p_country, p_province, p_street, p_street2, pref_email, pref_gmail, retainer_id, role, s_city, s_code, s_country, s_province, s_street, s_street2, signup_date, statement_token, subdomain, updated, userid, username, uuid, vat_name, vat_number, vis_state |
| expenses | account_name, accountid, accounting_systemid, amount, background_jobid, bank_name, bill_matches, billable, categoryid, clientid, compounded_tax, converse_projectid, date, expenseid, ext_accountid, ext_invoiceid, ext_systemid, from_bulk_import, has_receipt, id, include_receipt, invoiceid, is_cogs, isduplicate, markup_percent, modern_projectid, notes, potential_bill_payment, profileid, projectid, staffid, status, taxAmount1, taxAmount2, taxName1, taxName2, taxPercent1, taxPercent2, transactionid, updated, vendor, version, vis_state |
| invoices | accountid, accounting_systemid, address, amount, auto_bill, autobill_status, basecampid, city, code, country, create_date, created_at, currency_code, current_organization, customerid, date_paid, deposit_amount, deposit_percetage, deposit_status, description, discount_description, discount_total, discount_value, display_status, dispute_status, due_date, due_offset_days, estimateid, ext_archive, fname, fulfillment_date, generation_data, gmail, id, invoice_number, invoiceid, language, last_order_status, lname, net_paid_amount, notes, organization, outstanding, paid, ownerid, parent, payment_details, payment_status, po_number, province, return_uri, sentid, show_attachments, status, street, street2, template, terms, updated, uuid, v3_status, vat_name, vat_number, version, vis_state |
| journal_entries | account, accounting_systemid, balance, credit, debit, description, detail_type, detailid, entry, id, name, sub_account, user_entered_date |
| projects | id, title, description, due_date, client_id, internal, budget, fixed_price, rate, billing_method, project_type, project_manager_id, active, complete, sample, created_at, updated_at, logged_duration, services, billed_amount, billed_status, retainer_id, expense_markup, service_estimate_type, group_id |
| vendors | account_number, city, country, created_at, currency_code, is_1099, language, note, outstanding_balance, overdue_balance, phone, postal_code, primary_contact_email, primary_contact_first_name, primary_contact_last_name, province, street, street2, tax_defaults, updated_at, vendor_name, vendorid, vis_state, website |
Updated 4 months ago