{"repo":"fivetran/dbt_xero","free":true,"listed":false,"github":"https://github.com/fivetran/dbt_xero","clone":"git clone https://github.com/fivetran/dbt_xero.git","description":"Data models for Fivetran's Xero connector built using dbt.","language":null,"stars":12,"topics":["xero","fivetran","dbt","dbt-packages","fivetran-finance-reporting"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"Xero dbt Package This dbt package transforms data from Fivetran's Xero connector into analytics-ready tables. Resources - Number of materialized models¹: 42 - Connector documentation - Xero connector documentation - Xero ERD - dbt package documentation - GitHub repository - dbt Docs - DAG - Changelog - dbt Core™ supported versions - =1.3.0, Note: Currently, our dbt models for Xero have limited support for multi-currency accounting, particularly for handling unrealized currency gains and losses and bank revaluations, as they require historical or current exchange rate data that is not available in the Xero connector to fully calculate. Output schema Final output tables are generated in the following target schema: Final output tables By default, this package materializes the following final tables: Table Description :---- :---- xero general ledger Tracks every journal line item with debits, credits, and account classifications to provide a complete transaction history for building financial statements and analyzing account activity. Example Analytics Questions: What is the total net amount by account class (asset, liability, equity, revenue, expense) for a given period? Which accounts have the highest transaction volumes or largest balance changes? How do journal entries by source type (invoice, payment, manual) contribute to overall financial activity? xero profit and loss report Summarizes monthly profit and loss by account with net amounts to track revenue, expenses, and pr","default_branch":null,"files":null,"tree":[],"storefront":"/r/fivetran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fivetran/dbt_xero/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}