Getting your data

 Looking to free your Sage Accounting data? Good, you’ve come to the right place. ## Getting connected 1. Select **Connections** from the main menu 2. Click the **New** button 3. Select **Sage Accounting** 4. Give it a name (this is especially useful if you’re creating multiple Sage Accounting connections) 5. Authorise the connection by following the prompts to sign in to your Sage Accounting account 6. Done. Now watch as SyncHub begins retrieving your historical data. To connect multiple Sage Accounting accounts, simply follow the steps above for each one. Just make sure to check that your SyncHub plan allows for multiple API connections. ## Available endpoints SyncHub works by regularly querying each endpoint in the Sage Accounting API, checking for new and modified data. For each endpoint SyncHub produces a corresponding data table in your reporting tool. These are the endpoints currently available: - Address - Address region - Address type - Attachment - Bank account - Bank account type - Bank deposit - Bank opening balance - Bank reconciliation - Bank transfer - Chart of accounts - Chart of accounts template - Contact - Contact allocation - Contact opening balance - Contact payment - Contact person - Country - Currency - Journal - Ledger account - Ledger account opening balance - Ledger account type - Ledger entry - Other payment - Payment method - Product - Product sales price type - Product stock item - Purchase credit note - Purchase invoice - Sales credit note - Sales estimate - Sales invoice - Sales quote - Service - Service rate type - Stock movement - Tax rate - Transaction - Transaction type - Contact type - Contact allocation artefact - Contact payment allocated artefact - Contact person type - Journal line - Other payment line - Product sales price - Purchase credit note line - Purchase credit note payment allocation - Purchase invoice line - Purchase invoice payment allocation - Sales credit note line - Sales credit note payment allocation - Sales estimate profit line breakdown - Sales estimate line - Sales invoice line - Sales invoice payment allocation - Sales quote profit line breakdown - Sales quote line - Service sale rate - Tax rate percentage Need more data? No problem, please [let us know](https://www.synchub.io/contact) and we'll see if we can add it. Or if you're a data nerd like us, feel free to check out the Sage Accounting API documentation to see what’s available. ### What data does SyncHub take from Sage Accounting? SyncHub extracts the endpoints above from Sage Accounting, and stores it in your data warehouse. ### What data does SyncHub create or modify in Sage Accounting? Nothing. SyncHub is read-only and never sends data back to Sage Accounting. ## Building your reports SyncHub stores data in a relational database optimized for reporting. This means that reporting from your favourite reporting tool is as easy as using their standard _database connector_. We have detailed walkthroughs for the most popular reporting tools here: - [Power BI](/connectors/sageaccounting/knowledge-base/powerbi) - [Excel](/connectors/sageaccounting/knowledge-base/excel) - [Tableau](/connectors/sageaccounting/knowledge-base/tableau)