How Does My Amalgam Account Work?
If you are new to Amalgam, here is what to expect before you start.
Integrations
Section titled “Integrations”Everything starts with an Amalgam account, which exists to create and manage Integrations: connections to the apps you use, such as your accounting system, bank, payroll, payment processor or CRM. Add one from the web app at app.amalgam.me, sign in to the other system when prompted, and it is connected. You can share integrations with teammates, or group them by client, so access is managed in one central place.
Reports
Section titled “Reports”Reports pull data from an integration and hand it to you as a table: a P&L, an AR aging, a bank transaction list, a payroll journal. Reports are read-only. They are the simplest way to use an integration, and in many cases they give you data that is not available as a download anywhere else. If a report you need is missing, let us know.
Resources
Section titled “Resources”Resources are the editable side. Invoices, bills, journal entries, customers, vendors and more can be downloaded, changed, and uploaded back to the source system, or created in bulk. Resources are the key to building automations on Amalgam.
Where You Use Them
Section titled “Where You Use Them”Your integrations, reports and resources are the same wherever you work:
- The web app: run reports and resources in the browser, manage integrations, and manage your team.
- Excel and Google Sheets: the Amalgam plugin brings reports and resources into any workbook, where your formulas turn them into automations. See installing the Excel plugin and the Google Sheets plugin.
- Claude and ChatGPT: connect your Amalgam account to your AI tool with the MCP connector and work with your data without leaving it.
- Routines: schedule a report to run on a timetable and email you the results. Available on some plans; ask us if you do not see it.
Create Automations
Section titled “Create Automations”With all of these pieces together, your spreadsheets can access and edit data in external apps without ever leaving your workbook. You can page through datasets and access information simply by changing tabs. You can link two apps together simply by linking cells with a formula.
Use formulas to control how data from one system integrates with another. Automate reporting, reconciliation, and work paper creation. Consolidate data from multiple systems with a single click.
Amalgam lets you complete entire workflows from a single place, whether that is a spreadsheet, the web app, or your AI tool.
Integrations form the basis of our system. Create them in your account to connect to the apps you use.
Reports pull data from your integrations and display it in a nice way. Use them to get instant access to whatever data you need.
Resources modify data. Use them to change app data without logging in and manually entering it yourself.