KashFlow MCP by usefulapi

The KashFlow company: name, address, contact, VAT registration, currency, payment terms and business type. SOAP GetCompanyDetails.

無需輸入參數。

All customers (name, code, contact, email, phone, address, VAT number, payment terms, notes), paged here: the reply says total and next_offset. SOAP GetCustomers.

One customer by its KashFlow customer code (the short code shown in the customer list, e.g. ACME01). SOAP GetCustomer.

One customer by its numeric CustomerID (as returned in other replies). SOAP GetCustomerByID.

The customer whose e-mail address matches. SOAP GetCustomerByEmail.

What one customer owes: the total invoiced value and the outstanding balance. SOAP GetCustomerBalance.

WRITE: create a new customer. The code must be unique (KashFlow refuses a code that exists) and nothing existing is changed. Returns the new CustomerID. SOAP InsertCustomer.

All suppliers (name, code, contact, email, phone, address, VAT number, payment terms), paged here: the reply says total and next_offset. SOAP GetSuppliers.

One supplier by its KashFlow supplier code. SOAP GetSupplier.

WRITE: create a new supplier. The code must be unique (KashFlow refuses a code that exists) and nothing existing is changed. Returns the new SupplierID. SOAP InsertSupplier.

One sales invoice by its invoice number: customer, dates, lines (description, quantity, rate, VAT), net, VAT, amount paid and a link. SOAP GetInvoice.

Sales invoices dated within a range (inclusive; a bare end date means the end of that day), paged here. Dates are yyyy-mm-dd. SOAP GetInvoicesByDateRange.

All sales invoices of one customer, by numeric CustomerID (see kashflow_get_customer for the id), paged here. SOAP GetInvoicesForCustomer.

All sales invoices not yet paid in full, paged here. SOAP GetInvoices_Unpaid.

All sales invoices past their due date and not paid in full, paged here. SOAP GetInvoices_Overdue.

The most recently created sales invoices. SOAP GetInvoices_Recent.

The payments recorded against one sales invoice (date, amount, method, bank account, note), by invoice number. SOAP GetInvoicePayment.

Customer payments received within a date range (date, amount, invoice, method, bank account). KashFlow returns them a page at a time: set page_number 1, 2, ... until a page comes back empty. Dates are yyyy-mm-dd. SOAP GetInvoicePaymentsByDateRange.

The notes attached to one sales invoice, by its InvoiceDBID (the numeric id in invoice replies, not the invoice number). SOAP GetInvoiceNotes.

WRITE: add a note to a sales invoice, by its InvoiceDBID (the numeric id in invoice replies). Existing notes and the invoice are not changed. SOAP InsertInvoiceNote.

All sales quotes (same shape as invoices), paged here. SOAP GetQuotes.

One purchase (supplier invoice / receipt) by its receipt number: supplier, dates, lines, net, VAT, amount paid. SOAP GetReceipt.

The most recently created purchases (supplier invoices / receipts). SOAP GetReceipts_Recent.

All purchases (supplier invoices / receipts) of one supplier, by numeric SupplierID (see kashflow_get_supplier), paged here. SOAP GetReceiptsForSupplier.

The product catalogue (name, code, description, price, stock level), paged here. SOAP GetProducts.

The bank accounts (AccountID, name, nominal code). SOAP GetBankAccounts.

無需輸入參數。

The transactions of one bank account (date, money in/out, VAT, type, comment, customer/supplier), by AccountID from kashflow_list_bank_accounts, paged here. SOAP GetBankTransactions.

The balance of one bank account on a date (default today). SOAP GetBankBalance.

The chart of accounts: nominal codes with their names. SOAP GetNominalCodes.

The VAT rates set up in the account. SOAP GetVATRates.

無需輸入參數。

The projects defined in the account (id, name). SOAP GetProjects.

無需輸入參數。

The profit and loss report for a date range: turnover, cost of sales, gross profit, expenses and net profit, with the lines of each section. SOAP GetProfitAndLoss.

The balance sheet at a date (default today): fixed assets, current assets, current liabilities, capital and reserves with the lines of each. SOAP GetBalanceSheet.

The trial balance for a date range: every nominal code with debit, credit and balance. SOAP GetTrialBalance.

Who owes you money at a date (default today), aged into current, three periods and older, per customer. SOAP GetAgedDebtors.

Who you owe money to at a date (default today), aged into current, three periods and older, per supplier. SOAP GetAgedCreditors.

The VAT return figures (boxes 1 to 9) for a period, and whether it was submitted to HMRC. SOAP GetVATReport.

Key figures for a date range (income, expenses, profit and similar, as name/value pairs). SOAP GetKPIs.