get_obligation
ChatGPTGet one tax obligation by its id or its code (e.g. M900-T2-2026), with the official figures of the return saved in Tributs: the result (to pay, to carry forward, to refund) and the breakdown by section and box (IGI forms 900 and 910, corporate tax 800 and 805 and its payment on account 810, withholdings 700, 710, 310 and 311). filing.state says whether those figures are a calculated draft (generated) or the return as filed (filed). For the IGI period in progress with no return yet, estimate gives the running estimate from the books; present it as an estimate. Withholding forms come as totals, without the list of payees. Use this instead of adding up invoices when asked what a tax form says.
get_payroll_summary
ChatGPTPayroll totals of a company, one row per month with payslips, newest first: how many payslips and people, gross and net pay, social security (CASS) of the workers and of the company, income tax withheld (IRPF for residents, IRNR for non-residents), total company cost, and whether the month's pay is marked as paid in Tributs (payment_status; pending only means nobody has marked it yet). Amounts cover posted payslips; drafts are only counted. employees and partners split the same figures between salaried staff and partners or directors paid without a salary. Without month_from it returns the last twelve months. Use this for personnel cost and its trend; use list_payslips for what each person was paid.
get_purchase_invoice
ChatGPTGet one purchase invoice or credit note by its id (e.g. FC-26-00012), with its lines (description, quantity, price, expense account, IGI rate).
get_sales_invoice
ChatGPTGet one sales invoice, credit note or till summary by its id (its legal number, e.g. FV-26-00012), with its lines (description, quantity, price, income account, IGI rate) and the IGI breakdown by rate.
list_accounts
ChatGPTList the chart of accounts of a company (PGC of Andorra): number, name, parent account, whether it is a group and its nature (asset, liability, equity, income or expense). Use it to turn an account number into its name, or to find the number to pass to list_journal_lines.
list_bank_accounts
ChatGPTList the bank accounts of a company with two balances each. ledger_balance is the balance in the books (what the balance sheet and the general ledger show for that account), as of today or of date. statement_balance is the balance the bank itself reported on its latest statement line, with statement_date; it is null when the bank feed carries no balance. The two differ while statement lines are still to be reconciled (unreconciled_count) or the statement is behind (last_transaction_date). Use this for how much money there is and where; use report_balance_sheet for the whole financial position and list_bank_transactions for the lines of one account.
list_bank_transactions
ChatGPTList the bank statement lines of a company: date, amount (positive is money in, negative is money out), description, counterparty and whether the line is reconciled with the books. Filter by date, reconciliation status or bank account. status=unreconciled gives what is still waiting to be matched. Results come ordered by last change, oldest first: pass sort=date_desc for the latest lines and min_amount to leave small ones out. For how many lines there are and what they add up to, pass include=totals with limit=1 (the totals come with the first page) instead of reading every page.
list_companies
ChatGPTList the companies this person can read in Tributs: id, legal name, trade name, their role in each one and whether it is active or suspended. Call it first: every other tool takes the company id returned here.
list_contacts
ChatGPTList the customers and suppliers of a company: legal and trade name, tax id (NRT/NIF), country, email, phone and whether each one is a customer, a supplier or both. role keeps only one side. The contact id is the contact_id that the invoice and ledger tools take. There is no search by name: page through the list to find a contact.
list_employees
ChatGPTList the people on a company's payroll: name, whether they are active or have left, start and end dates, contract type, job category, tax residence, and whether they are salaried staff or a partner or director paid without a salary. Filter by status (active or left) or kind. It carries no pay: use list_payslips with employee_id for what a person was paid. Identity documents, bank details and birth dates are not available through this connection.
list_journal_lines
ChatGPTList the general ledger lines of a company, one row per debit or credit, in EUR: posting date, account, contact and the document that posted the line. Filter by posting date, account number or prefix (705 covers all its sub-accounts), contact or document. Use it to explain a balance or to see how a document was posted. For totals per account or per heading use the report tools: they are far cheaper than adding up lines.
list_obligations
ChatGPTList the tax calendar of one company: each filing with its tax model (e.g. 900 for the IGI return), period, deadline and status (pending, generated, in_progress, filed, overdue or not_applicable). When a return is saved in Tributs, result gives its outcome (to_pay, to_carry_forward, to_refund, zero) and amount, so this answers how much a filing came to. Filter by year, status or deadline range. Use get_obligation for the figures box by box, and portfolio_obligations to see what is pending across every company at once.
list_payables
ChatGPTOne row per supplier the company owes money to, as of today: the open amount (outstanding_amount), how much of it is overdue, due within 30 days or later, how many documents are open, the oldest due date, and the advances paid and not yet applied to an invoice (unapplied_advance_amount); net_amount is what is really owed after those advances. Largest balance first; sort=oldest_due puts the oldest debt first and min_amount leaves small balances out. For the total owed to all suppliers pass include=totals with limit=1. Use this for what has to be paid and to whom; use list_purchase_invoices with status=unpaid and contact_id for the invoices behind one supplier's balance.
list_payslips
ChatGPTList the payslips of a company, one per person and month: who was paid, gross and net pay, the worker's social security (CASS), the income tax withheld with its rate (withholding_tax says whether it is IRPF or IRNR), the company's social security and total cost, whether it is posted and whether it is marked as paid in Tributs (pending only means nobody has marked it yet). Filter by months (month_from, month_to, as YYYY-MM), employee_id, status or kind. sort=period_desc puts the latest month first. For sums pass include=totals; for a month-by-month view without names use get_payroll_summary. A draft payslip can still change; only posted ones are in the books. These are personal data of the workers: show them only to the user who asked.
list_purchase_invoices
ChatGPTList the issued purchase invoices and credit notes of a company, with the supplier's own invoice number and date. Filter by issue date, payment status (paid, unpaid, overdue, cancelled), type or contact. Amounts are in EUR; tax_amount is the deductible IGI. Drafts and documents waiting in the scanner inbox are left out. Results come ordered by last change, oldest first: pass sort=total_desc for the largest documents or sort=issue_date_desc for the latest ones, and min_total to leave small ones out. For how many there are and what they add up to (e.g. how much is still to pay), pass include=totals with limit=1 (the totals come with the first page) instead of reading every page. Use get_purchase_invoice for the lines of one document.
list_receivables
ChatGPTOne row per customer with money outstanding, as of today: the open amount (outstanding_amount), how much of it is overdue, due within 30 days or later, how many documents are open, the oldest due date, and the advances received and not yet applied to an invoice (unapplied_advance_amount); net_amount is what the customer really owes after those advances. Largest balance first; sort=oldest_due puts the oldest debt first and min_amount leaves small balances out. For the total owed by all customers pass include=totals with limit=1. Use this for who owes money and how much; use list_sales_invoices with status=unpaid and contact_id for the invoices behind one customer's balance.
list_sales_invoices
ChatGPTList the issued sales documents of a company: invoices, credit notes and daily till summaries (cash_close). Filter by issue date, payment status (paid, unpaid, overdue, cancelled), type or contact. Amounts are in EUR, the currency of the books; a document in another currency also carries document_total. Drafts are left out. Results come ordered by last change, oldest first: pass sort=total_desc for the largest documents or sort=issue_date_desc for the latest ones, and min_total to leave small ones out. For how many there are and what they add up to (e.g. how much is unpaid), pass include=totals with limit=1 (the totals come with the first page) instead of reading every page. Use get_sales_invoice for the lines of one document.
portfolio_obligations
ChatGPTSummarise the tax calendar of every company this person can read, in one call: for each company, the filings that are overdue and the ones due within the next days_ahead days (30 by default), with tax model, period, deadline and status. A filing whose return is already calculated in Tributs carries result (outcome: to_pay, to_carry_forward, to_refund or zero, and amount in EUR), so this also answers how much each company has to pay; result is null until the return is calculated. Companies with nothing pending are only counted. Use it for questions about the whole portfolio (what is due this month, who is late); use list_obligations for the full calendar of one company. Overdue filings older than three years are left out; a negative days_left means the deadline has passed. A mandatory filing that was prepared (generated, in_progress) but not filed by its deadline is listed as overdue and keeps that status, so you can tell it only needs filing. A company that cannot be read is listed under failed with the reason, and one marked incomplete has more filings than this summary reads.
report_balance_sheet
ChatGPTBalance sheet of a company by official heading (PGC of Andorra), with the accounts behind each heading and the totals of assets and of equity and liabilities, in EUR. With no parameters it is the balance as of today; pass date for another day, and periodicity with periods to compare several dates. Heading labels are the official ones, in Catalan; code identifies each heading.
report_profit_and_loss
ChatGPTProfit and loss of a company by official heading (PGC of Andorra), with the accounts behind each heading and the result of the period, in EUR. With no parameters it covers the current year up to today. Pass date_from and date_to for a custom range, or periodicity and periods to compare natural periods (up to 12 months, quarters, half-years or years). Heading labels are the official ones, in Catalan; code identifies each heading.
report_trial_balance
ChatGPTTrial balance of a company: opening balance, debit, credit and closing balance of every account with movement, in EUR, plus the column totals. With no parameters it covers the current fiscal year up to today; pass date_from and date_to for another range. Use it for the balance of specific accounts (bank, customers, suppliers, tax accounts).