Rillet

Rillet is a cloud general ledger and accounting platform for growing companies.

With Amalgam, you can two-way sync data into Excel and Google Sheets, or enable your AI tools to take direct actions without hand-holding.

Book a Demo

Spreadsheets

AI Chat

Routines

Reports

Category: Accounting
Connects By: API Key
Reports: 8
Website: rillet.com

What You Can Do With Rillet

In a Spreadsheet

Pull data into Excel or Google Sheets, and refresh it whenever you need current numbers.

See How It Works

In an AI Chat

Connect your AI tool to Amalgam, and it can run Rillet reports to answer your questions.

See Amalgam for AI

On a Schedule

Set a routine to fetch data on a schedule and deliver it to your shared drive, inbox, or directly into a document.

See Routines

How to Connect

Create a read-only API key in Rillet's organization settings and paste it into Amalgam. Each account you connect becomes its own connection in Amalgam, and you can add as many as you need.

Read the Connection Guide

Reports8

Pull any of these into a spreadsheet, a chat or a routine, for one Rillet account or every account you connect.

AP Aging DetailedBeta

Rillet AP Aging Detailed for one subsidiary: each open bill and vendor credit grouped by vendor, with Type, Reference #, Date, Due Date, Currency, aging buckets (Current, 1 - 30, 31 - 60, 61 - 90, 91+ Days) and Total. Ages as of today unless a date is given.

Options: Vendor, Subsidiary, As of date

AP Aging SummaryBeta

Rillet AP Aging Summary for one subsidiary: one row per vendor with net open balance in each aging bucket (Current, 1 - 30, 31 - 60, 61 - 90, 91+ Days) and Total, plus a grand total row. Ages as of today unless a date is given.

Options: Vendor, Subsidiary, As of date

AR Aging DetailedBeta

Rillet AR Aging Detailed for one subsidiary: each open invoice and credit memo grouped by customer, with Type, Reference #, Date, Due Date, Currency, aging buckets (Current, 1 - 30, 31 - 60, 61 - 90, 91+ Days) and Total. Ages as of today unless a date is given.

Options: Subsidiary, Customer, As of date, Page Size

AR Aging SummaryBeta

Rillet AR Aging Summary for one subsidiary: one row per customer with net open balance in each aging bucket (Current, 1 - 30, 31 - 60, 61 - 90, 91+ Days) and Total, plus a grand total row. Ages as of today unless a date is given.

Options: Subsidiary, Customer, As of date, Page Size

Balance SheetBeta

Rillet Balance Sheet at a single date: one row per account with Account Code, Account Name and a Balance column with its Currency, organized into sections and groups with totals.

Options: As of Date, Subsidiary, Breakdown by Subsidiaries

General LedgerBeta

Rillet General Ledger: one row per journal entry line in a date range, with account, subsidiary, date, description, transaction and journal entry IDs, related accounts, and debit, credit and net amounts in reporting, local and transaction currency. Defaults to the current calendar year.

Options: From Date, To Date, Account, Group by Accounts, Hide Headers, Hide Total

Income StatementBeta

Rillet Income Statement for a date range: one row per account with Account Code, Account Name and an Amount column with its Currency, organized into sections with totals, followed by summary rows such as Gross Profit.

Options: Start Date, End Date, Breakdown by, Custom Field, Period, Hide Currency Columns

Trial BalanceBeta

Rillet Trial Balance for a date range: one row per account with Account Code, Account Name, Beginning Balance, Debit Total, Credit Total, Debit FX Total, Credit FX Total and Ending Balance, each with a Currency column, plus a Totals row.

Options: Start Date, End Date, Hide Currency Column, Subsidiary