Linking Moneybird as a source

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

Learn more
PostHog Wizard hedgehog

Contents

Moneybird is an accounting platform popular in the Netherlands and Belgium. The Moneybird connector syncs your accounting data — contacts, invoices, bank transactions, and more — into the PostHog data warehouse.

Adding a data source

  1. Go to the sources tab of the data pipeline section in PostHog.
  2. Click + New source and then click Link next to Moneybird.
  3. Enter your Moneybird API token and Administration ID. To get these:
    • Create a personal API token at moneybird.com/user/applications/new. Select the scopes for the tables you want to sync: sales_invoices, documents, estimates, bank, time_entries, and settings.
    • Your Administration ID is the number after moneybird.com/ in the address bar when you open your administration.
  4. Click Next.
  5. Select the tables you want to sync, set the sync method and frequency, then click Import.

Once the syncs are complete, you can start using Moneybird data in PostHog.

Available tables

TableDescriptionSync method
contactsCustomers, suppliers, and other business relations, including archived contactsIncremental
sales_invoicesInvoices sent to customers for delivered products or servicesIncremental
estimatesEstimates (quotes) proposed to clientsFull refresh
external_sales_invoicesSales invoices created in other systems and imported into MoneybirdFull refresh
recurring_sales_invoicesTemplates for automatically recurring sales invoicesIncremental
purchase_invoicesInvoices received from suppliersIncremental
receiptsReceipts that prove the payment of expensesIncremental
general_journal_documentsManual bookkeeping entries for corrections or adjustmentsIncremental
general_documentsFinancial documents that are not invoices, receipts, or estimatesIncremental
financial_accountsBank accounts, credit cards, and other accounts that hold moneyFull refresh
financial_mutationsTransactions on financial accounts, such as bank transactionsIncremental
ledger_accountsCategories of bookkeeping: revenue, expenses, assets, and liabilitiesFull refresh
tax_ratesVAT rates that apply to products and servicesFull refresh
productsGoods and services for invoices and estimates, including deactivated productsFull refresh
projectsProjects that group time entries and financial dataFull refresh
time_entriesTime spent on work for contacts and projectsFull refresh
subscription_templatesTemplates that set products and prices for subscriptionsFull refresh
usersUsers of the administration, including inactive users and accountantsFull refresh
workflowsWorkflows for sending, reminding, and collecting invoices and estimatesFull refresh
custom_fieldsCustom fields added to sales invoices, contacts, and identitiesFull refresh

Incremental tables sync only new or updated records on each run. Full refresh tables reload all data on each sync.

Configuration

OptionDescription
API token
Type: password
Required: True
Administration ID
Type: text
Required: True

The number after moneybird.com/ in the address bar when you open the administration.

Supported tables

TableDescriptionSync methodIncremental fieldPrimary key
contacts

Customers, suppliers and other business relations in the Moneybird administration, including archived contacts.

Incremental, Full refreshupdated_at—
sales_invoices

Invoices sent to customers for delivered products or services, in every state.

Incremental, Full refreshupdated_at—
estimates

Estimates (quotes) that propose products or services to clients.

Full refresh——
external_sales_invoices

Sales invoices created in other systems and imported into Moneybird.

Full refresh——
recurring_sales_invoices

Templates for sales invoices that Moneybird creates at a recurring interval, both active and inactive, including the ones that belong to a subscription.

Incremental, Full refreshversion—
purchase_invoices

Invoices received from suppliers.

Incremental, Full refreshupdated_at—
receipts

Receipts that prove the payment of expenses.

Incremental, Full refreshupdated_at—
general_journal_documents

Manual bookkeeping entries that correct errors or make adjustments.

Incremental, Full refreshupdated_at—
general_documents

Financial documents that are not invoices, receipts, estimates or journal entries.

Incremental, Full refreshupdated_at—
financial_accounts

Active bank accounts, credit cards, payment services and other accounts that hold money. Moneybird does not return archived accounts.

Full refresh——
financial_mutations

Transactions on financial accounts, such as bank transactions, with how each one is booked.

Incremental, Full refreshversion—
ledger_accounts

The categories of the bookkeeping, such as revenue, expenses, assets and liabilities.

Full refresh——
tax_rates

VAT rates that apply to products and services.

Full refresh——
products

Goods and services that can be added to invoices and estimates, including deactivated products.

Full refresh——
projects

Projects that group time entries and financial data, both active and archived.

Full refresh——
time_entries

Time spent on work for contacts and projects, which can be billed to customers.

Full refresh——
subscription_templates

Templates that set the products and prices of subscriptions.

Full refresh——
users

Users of the administration, including inactive users and accountants.

Full refresh——
workflows

Workflows that set how invoices and estimates are sent, reminded and collected.

Full refresh——
custom_fields

Custom fields that add extra information to sales invoices, contacts and identities.

Full refresh——

Still have questions?

Was this page useful?